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();
}
}
}
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;
}