public int add_user(JobUserBean bean) { int id = 0; Connection con = null; PreparedStatement psptem = null; ResultSet rs = null; try { con = SxitConnPool2.getConnection(); String strsql = "insert into hr_user(USERNAME,PASSWORD,USERFLAG,CREATEDATETIME,ipaddress) values(?,?,?,?,?) "; psptem = con.prepareStatement(strsql, Statement.RETURN_GENERATED_KEYS); psptem.setString(1, bean.getUsername()); psptem.setString(2, bean.getPassword()); psptem.setString(3, bean.getUserflag()); psptem.setString(4, bean.getCreatedatetime()); psptem.setString(5, bean.getIpaddress()); int ii = psptem.executeUpdate(); if (ii > 0) { rs = psptem.getGeneratedKeys(); if (rs.next()) { id = rs.getInt(1); } } if (psptem != null) psptem.close(); } catch (Exception e) { e.printStackTrace(); } finally { SxitConnPool2.closeConnection(con); } return id; }