예제 #1
0
  @Override
  public List<CertType> findMH(String s, Object o) {
    // TODO Auto-generated method stub
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    List<CertType> certTypeList = new ArrayList<CertType>();
    String sql = "select * from tab_certtype where " + s + " like '%" + o + "%'";
    try {
      conn = DBUtils.getconnection();
      pstmt = conn.prepareStatement(sql);
      //	pstmt.setObject(1, "'%" + o + "%'");
      rs = pstmt.executeQuery();
      while (rs.next()) {
        CertType ct = new CertType();
        ct.setID(rs.getInt("ID"));
        ct.setContent(rs.getString("content"));
        certTypeList.add(ct);
      }

    } catch (SQLException e) {
      // TODO Auto-generated catch block
      System.out.println("findMH error!");
    } finally {
      //		    DBUtils.closeConnection(conn);
      DBUtils.closeStatement(rs, pstmt);
    }
    return certTypeList;
  }
예제 #2
0
  // ���ң���ȷ���� + ģ�����
  @Override
  public CertType findJQ(String s, Object o) {
    CertType ct = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;

    String sql = "select * from tab_certtype where " + s + "=?";
    try {
      pstmt = conn.prepareStatement(sql);
      pstmt.setObject(1, o);
      rs = pstmt.executeQuery();
      if (rs.next()) {
        ct = new CertType();
        ct.setID(rs.getInt("ID"));
        ct.setContent(rs.getString("content"));
      }

    } catch (SQLException e) {
      // TODO Auto-generated catch block
      System.out.println("findJQ error!");
    } finally {
      DBUtils.closeStatement(rs, pstmt);
      //	DBUtils.closeConnection(conn);
    }
    return ct;
  }
예제 #3
0
 public User findUser(User u) {
   User user = null;
   Connection conn = null;
   try {
     conn = DBUtils.getconnection();
     UserDaoImpl udi = new UserDaoImpl(conn);
     DBUtils.beginTransaction(conn);
     user = udi.findUser(u);
     DBUtils.commit(conn);
   } catch (Exception e) {
     DBUtils.rollBack(conn);
     System.out.println("findUser in UserServince error!");
   } finally {
     DBUtils.closeConnection(conn);
   }
   return user;
 }
예제 #4
0
 public int updateUser(User one) throws Exception {
   Connection conn = null;
   int res = 0;
   try {
     conn = DBUtils.getconnection();
     UserDaoImpl userDaoImpl = new UserDaoImpl(conn);
     DBUtils.beginTransaction(conn);
     res = userDaoImpl.updateUser(one);
     DBUtils.commit(conn);
   } catch (SQLException e) {
     DBUtils.rollBack(conn);
     System.out.println("updateUser error!");
   } finally {
     DBUtils.closeConnection(conn);
   }
   return res;
 }
예제 #5
0
 /**
  * 获取指定页用户信息列表,通过分页SQL语句实现
  *
  * @param pageSize ,每页显示信息条数
  * @param rowNum ,需要获取的页数
  * @param one ,需要获取的页数
  * @return 用户信息列表,List[User],若无满足条件则列表为空
  * @throws SQLException
  */
 public List<User> getUserList(int pageSize, int rowNum, User one) {
   Connection conn = null;
   List<User> res = null;
   try {
     conn = DBUtils.getconnection();
     UserDao userDao = new UserDaoImpl(conn);
     DBUtils.beginTransaction(conn);
     res = userDao.getUserList(pageSize, rowNum, one);
     DBUtils.commit(conn);
   } catch (Exception e) {
     DBUtils.rollBack(conn);
     System.out.println("getUserList error!");
   } finally {
     DBUtils.closeConnection(conn);
   }
   return res;
 }
예제 #6
0
 public User login(String username, String password) {
   User u = null;
   Connection conn = null;
   int i = 0;
   try {
     conn = DBUtils.getconnection();
     UserDaoImpl udi = new UserDaoImpl(conn);
     DBUtils.beginTransaction(conn);
     u = udi.login(username, password);
     DBUtils.commit(conn);
   } catch (Exception e) {
     DBUtils.rollBack(conn);
     System.out.println("save error!");
   } finally {
     DBUtils.closeConnection(conn);
   }
   return u;
 }
예제 #7
0
 public boolean deleteUsers(int[] userIdList) throws Exception {
   boolean s = false;
   Connection conn = null;
   int i = 0;
   try {
     conn = DBUtils.getconnection();
     UserDaoImpl udi = new UserDaoImpl(conn);
     DBUtils.beginTransaction(conn);
     s = udi.deleteUsers(userIdList);
     DBUtils.commit(conn);
   } catch (Exception e) {
     DBUtils.rollBack(conn);
     System.out.println("deleteUsers error!");
   } finally {
     DBUtils.closeConnection(conn);
   }
   return s;
 }
예제 #8
0
 public boolean save(User u) {
   boolean s = false;
   Connection conn = null;
   int i = 0;
   try {
     conn = DBUtils.getconnection();
     UserDaoImpl udi = new UserDaoImpl(conn);
     DBUtils.beginTransaction(conn);
     s = udi.save(u);
     DBUtils.commit(conn);
   } catch (Exception e) {
     DBUtils.rollBack(conn);
     System.out.println("save error!");
   } finally {
     DBUtils.closeConnection(conn);
   }
   return s;
 }
예제 #9
0
  /**
   * 获取用户列表最大页数
   *
   * @param pageSize ,每页显示信息条数
   * @return 列表最大页数
   * @throws Exception
   * @throws SQLException
   */
  public int getUserListPageCount(int pageSize, User one) throws Exception {
    Connection conn = null;
    int res = 0;
    try {
      conn = DBUtils.getconnection();
      UserDaoImpl userDao = new UserDaoImpl(conn);
      DBUtils.beginTransaction(conn);
      res = userDao.getUserListPageCount(pageSize, one);
      DBUtils.commit(conn);
    } catch (SQLException e) {
      DBUtils.rollBack(conn);
      System.out.println("getUserListPageCount error!");
    } finally {
      DBUtils.closeConnection(conn);
    }

    return res;
  }
예제 #10
0
  /**
   * 根据省份标识获取所有城市信息列表
   *
   * @param proID
   * @return
   * @throws SQLException
   */
  public List<City> getCityListByProID(String proID) {
    Connection conn = null;
    List<City> res = null;
    try {
      conn = DBUtils.getConnection();
      CityDao cityDao = new CityDaoImpl(conn);
      DBUtils.beginTransaction(conn);
      res = cityDao.getCityListByProID(proID);
      DBUtils.commit(conn);
    } catch (SQLException e) {
      DBUtils.rollback(conn);
      throw new ServiceException("查询错误", e);
    } finally {
      DBUtils.closeConnection(conn);
    }

    return res;
  }
예제 #11
0
  public List<CertType> getCertType() throws SQLException {
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    List<CertType> certTypeList = new ArrayList<CertType>();

    try {
      pstmt = conn.prepareStatement("select * from tab_certtype");
      rs = pstmt.executeQuery();
      while (rs.next()) {
        CertType ct = new CertType();
        ct.setID(rs.getInt("ID"));
        ct.setContent(rs.getString("content"));
        certTypeList.add(ct);
      }

    } finally {
      //			rs.close();
      //			pstmt.close();

      //		    DBUtils.closeConnection(conn);
      DBUtils.closeStatement(rs, pstmt);
    }
    return certTypeList;
  }