Exemplo n.º 1
0
 public int updUser(UserEntity user) {
   Connection conn = null;
   try {
     conn = JDBCUtils.getConn();
     String isql =
         "update user set kind=?,shortTitle=?,specialService=?,author=?,origin=?,"
             + "companyAddress=?,officeCompany=?,companyNumber=?,servicesType=?,respectiveIndustries=?,companyLeader=?,title=?where id = ? ";
     PreparedStatement pstmt = conn.prepareStatement(isql);
     pstmt.setString(1, user.getKind());
     pstmt.setString(2, user.getShortTitle());
     pstmt.setString(3, user.getSpecialService());
     pstmt.setDouble(4, user.getAuthor());
     pstmt.setString(5, user.getOrigin());
     pstmt.setString(6, user.getCompanyAddress());
     pstmt.setString(7, user.getOfficeCompany());
     pstmt.setInt(8, user.getCompanyNumber());
     pstmt.setString(19, user.getServicesType());
     pstmt.setString(10, user.getRespectiveIndustries());
     pstmt.setString(11, user.getCompanyLeader());
     pstmt.setString(12, user.getTitle());
     pstmt.setString(13, user.getId());
     return pstmt.executeUpdate();
   } catch (JDBCUTilsException e) {
     e.printStackTrace();
   } catch (SQLException e) {
     e.printStackTrace();
   } finally {
     try {
       JDBCUtils.close(conn);
     } catch (SQLException e) {
       e.printStackTrace();
     }
   }
   return 0;
 }
Exemplo n.º 2
0
 public int addUser(UserEntity user) throws SQLException {
   Connection conn = null;
   try {
     // check 唯一性
     conn = JDBCUtils.getConn();
     String isql =
         "insert into user (id,username,password,kind,shortTitle,specialService,author,origin,"
             + "companyAddress,officeCompany,companyNumber,servicesType,respectiveIndustries,companyLeader,title,createdate) "
             + " values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
     PreparedStatement pstmt = conn.prepareStatement(isql);
     pstmt.setString(1, user.getId());
     pstmt.setString(2, user.getUsername());
     pstmt.setString(3, user.getPassword());
     pstmt.setString(4, user.getKind());
     pstmt.setString(5, user.getShortTitle());
     pstmt.setString(6, user.getSpecialService());
     pstmt.setDouble(7, user.getAuthor());
     pstmt.setString(8, user.getOrigin());
     pstmt.setString(9, user.getCompanyAddress());
     pstmt.setString(10, user.getOfficeCompany());
     pstmt.setInt(11, user.getCompanyNumber());
     pstmt.setString(12, user.getServicesType());
     pstmt.setString(13, user.getRespectiveIndustries());
     pstmt.setString(14, user.getCompanyLeader());
     pstmt.setString(15, user.getTitle());
     pstmt.setDate(16, new Date(System.currentTimeMillis()));
     return pstmt.executeUpdate();
   } finally {
     try {
       JDBCUtils.close(conn);
     } catch (SQLException e) {
       e.printStackTrace();
     }
   }
 }
Exemplo n.º 3
0
 private UserEntity getEntity(ResultSet rs) throws SQLException {
   UserEntity user = new UserEntity();
   user.setId(rs.getString("id"));
   user.setUsername(rs.getString("username"));
   user.setPassword(rs.getString("password"));
   user.setKind(rs.getString("kind"));
   user.setShortTitle(rs.getString("shortTitle"));
   user.setSpecialService(rs.getString("specialService"));
   user.setAuthor(rs.getDouble("Author"));
   user.setOrigin(rs.getString("origin"));
   user.setCompanyAddress(rs.getString("companyAddress"));
   user.setOfficeCompany(rs.getString("officeCompany"));
   user.setCompanyNumber(rs.getInt("companyNumber"));
   user.setServicesType(rs.getString("servicesType"));
   user.setRespectiveIndustries(rs.getString("respectiveIndustries"));
   user.setCompanyLeader(rs.getString("companyLeader"));
   user.setTitle(rs.getString("title"));
   return user;
 }