public boolean insertFamilyDetails(String personnelID, FamilyDetails fd) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + FAMILY + " VALUES(?,?,?,?,?,?,?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setString(1, personnelID); ps.setShort(2, fd.getRelationID()); ps.setNString(3, fd.getPerName()); if (fd.getPerBirth() == null) { ps.setNull(4, java.sql.Types.DATE); } else { ps.setDate(4, fd.getPerBirth()); } ps.setNString(5, fd.getPerJob()); ps.setNString(6, fd.getPerAdd()); ps.setString(7, fd.getPerPhone()); if (ps.executeUpdate() < 1) { check = false; } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }
/** * Add recruitment request to permanent store. * * @param toAdd request to be added * @return id of added request or -1 if unsuccessful */ public int addRecruitmentRequest(RecruitmentRequestBean toAdd) { String insertStatement = "insert into recruitmentrequests (requestdep, requestdate, jobtitle, contracttype, yearsofexperience, jobdescription, status) values (?,?,?,?,?,?,?);"; try { PreparedStatement statement = connection.prepareStatement(insertStatement, Statement.RETURN_GENERATED_KEYS); statement.setNString(1, toAdd.getRequestDepartment()); statement.setDate(2, new java.sql.Date(toAdd.getRequestDate().getTime())); statement.setNString(3, toAdd.getJobTitle()); statement.setNString(4, toAdd.getContractType()); statement.setInt(5, toAdd.getYearsOfExperience()); statement.setNString(6, toAdd.getJobDescription()); statement.setNString(7, "active"); statement.executeUpdate(); ResultSet rs = statement.getGeneratedKeys(); if (rs.first()) { return rs.getInt(1); } } catch (SQLException e) { e.printStackTrace(); } return -1; }
public boolean insertHealthStatus(String personnelID, HealthStatus hs) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + HEALTH_STATUS + " VALUES(?,?,?,?,?,?,?,?,?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setString(1, personnelID); if (hs.getHealDate() == null) { ps.setNull(2, java.sql.Types.DATE); } else { ps.setDate(2, hs.getHealDate()); } ps.setNString(3, hs.getHospital()); ps.setShort(4, hs.getHeight()); ps.setShort(5, hs.getWeight()); ps.setString(6, hs.getSight()); ps.setShort(7, hs.getBloodID()); ps.setShort(8, hs.getHealthStatusID()); ps.setNString(9, hs.getNote()); if (ps.executeUpdate() < 1) { check = false; } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }
public boolean insertCompanyDetails(CompanyDetails com) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + COMPANY_INFO + " VALUES(?,?,?,?,?,?,?,?,?,?,?,?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setNString(1, com.getTenCtyVN()); ps.setString(2, com.getTenCtyEN()); ps.setString(3, com.getTenVietTat()); ps.setNString(4, com.getTenGiamDoc()); ps.setString(5, com.getSoDienThoai()); ps.setString(6, com.getSoFax()); ps.setString(7, com.getSoTaiKhoan()); ps.setNString(8, com.getDiaChiVN()); ps.setNString(9, com.getDiaChiEN()); ps.setString(10, com.getMaSoThue()); if (com.getNgayDangKy() == null) { ps.setNull(11, java.sql.Types.DATE); } else { ps.setDate(11, com.getNgayDangKy()); } ps.setBytes(12, com.getLogo()); if (ps.executeUpdate() < 1) { check = false; } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }
public boolean insertDocumentDetails(String personnelID, DocumentsDetails doc) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + DOC_INFO + " VALUES(?,?,?,?,?,?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setString(1, personnelID); ps.setNString(2, doc.getName()); if (doc.getSaveDate() == null) { ps.setNull(3, java.sql.Types.DATE); } else { ps.setDate(3, doc.getSaveDate()); } ps.setBytes(4, doc.getFile()); ps.setString(5, doc.getExtension()); ps.setShort(6, doc.getKindID()); if (ps.executeUpdate() < 1) { check = false; } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }
public boolean updateContractList(Contract con) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + getCONTRACT_CB() + " VALUES(?,?,?,?,?,?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setNString(1, con.getName()); ps.setShort(2, con.getMonth()); if (con.isBHXH()) { ps.setBoolean(3, con.isBHXH()); ps.setFloat(4, con.getPercent()); } else { ps.setBoolean(3, con.isBHXH()); ps.setNull(4, java.sql.Types.FLOAT); } ps.setBytes(5, con.getTemplate()); ps.setString(6, con.getExtension()); if (ps.executeUpdate() < 1) { check = false; } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }
public boolean insertSkillInfo(String personnelID, Skill sk) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + SKILL_INFO + " VALUES(?,?,?,?,?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setString(1, personnelID); ps.setShort(2, sk.getNameID()); ps.setShort(3, sk.getClassificationID()); ps.setNString(4, sk.getNote()); if (sk.getEffectiveDate() == null) { ps.setNull(5, java.sql.Types.DATE); } else { ps.setDate(5, sk.getEffectiveDate()); } if (ps.executeUpdate() < 1) { check = false; } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }
public void setNString(int idx, String string) throws SQLException { try { addMementoEntry("setNString", new Class[] {String.class}, idx, string); wrapped.setNString(idx, string); } catch (SQLException e) { throw new UcanaccessSQLException(e); } }
public void setNString(int parameterIndex, String value) throws SQLException { String methodCall = "setNString(" + parameterIndex + ", " + value + ")"; argTraceSet(parameterIndex, "(String)", value); try { realPreparedStatement.setNString(parameterIndex, value); } catch (SQLException s) { reportException(methodCall, s); throw s; } reportReturn(methodCall); }
@POST @Path("/products") @Consumes(MediaType.APPLICATION_JSON) @Produces(MediaType.TEXT_PLAIN) public String postProduct(String str) throws SQLException { JsonParser parser = Json.createParser(new StringReader(str)); Map<String, String> productMap = new LinkedHashMap<String, String>(); String key = ""; String val = ""; while (parser.hasNext()) { JsonParser.Event event = parser.next(); switch (event) { case KEY_NAME: key = parser.getString(); break; case VALUE_STRING: val = parser.getString(); productMap.put(key, val); break; case VALUE_NUMBER: val = parser.getString(); productMap.put(key, val); break; default: break; } } if (conn == null) { return "Not connected"; } else { String query = "INSERT INTO products (name,decription,quantity) VALUES (?,?,?)"; PreparedStatement pstmt = conn.prepareStatement(query); pstmt.setNString(1, productMap.get("product_id")); pstmt.setNString(2, productMap.get("name")); pstmt.setNString(3, productMap.get("description")); pstmt.setNString(4, productMap.get("quantity")); return "row has been inserted into the database"; } }
/** * Add event request to persistent store * * @param toAdd event to add * @return id of added event, or -1 if unsuccessful */ public int addEventRequest(EventRequestBean toAdd) { String insertStatement = "insert into eventrequests " + "(clientid, type, name, fromdate, todate, budget," + " status, details_photo_video, details_music," + " details_poster, details_decoration, details_network," + " details_food_beverages, details_waiter, feedback_budget)" + " values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);"; try { PreparedStatement statement = connection.prepareStatement(insertStatement, Statement.RETURN_GENERATED_KEYS); statement.setInt(1, toAdd.getClientId()); statement.setNString(2, toAdd.getType()); statement.setNString(3, toAdd.getName()); statement.setDate(4, new java.sql.Date(toAdd.getFrom().getTime())); statement.setDate(5, new java.sql.Date(toAdd.getTo().getTime())); statement.setNString(6, toAdd.getBudget()); statement.setNString(7, toAdd.getStatus()); Map<String, String> preferences = toAdd.getPreferences(); statement.setNString(8, preferences.get("details_photo_video")); statement.setNString(9, preferences.get("details_music")); statement.setNString(10, preferences.get("details_poster")); statement.setNString(11, preferences.get("details_decoration")); statement.setNString(12, preferences.get("details_network")); statement.setNString(13, preferences.get("details_food_beverages")); statement.setNString(14, preferences.get("details_waiter")); statement.setNString(15, preferences.get("feedback_budget")); statement.executeUpdate(); ResultSet rs = statement.getGeneratedKeys(); if (!rs.next()) { return -1; } return (int) rs.getLong(1); } catch (SQLException e) { e.printStackTrace(); } return -1; }
/** * PUT method for updating or creating an instance of ProductResource * * @param content representation for the resource * @return an HTTP response with content of the updated or created resource. */ @PUT @Path("{id}") @Consumes(MediaType.APPLICATION_JSON) public String putProduct(@PathParam("id") int id, String str) throws SQLException { JsonParser parser = Json.createParser(new StringReader(str)); Map<String, String> productMap = new LinkedHashMap<String, String>(); String key = ""; String val = ""; while (parser.hasNext()) { JsonParser.Event event = parser.next(); switch (event) { case KEY_NAME: key = parser.getString(); break; case VALUE_STRING: val = parser.getString(); productMap.put(key, val); break; case VALUE_NUMBER: val = parser.getString(); productMap.put(key, val); break; default: break; } } if (conn == null) { return "Not connected"; } else { String query = "UPDATE products SET name = ?, SET decription = ?, SET quantity = ? WHERE id = ? "; PreparedStatement pstmt = conn.prepareStatement(query); pstmt.setInt(4, id); pstmt.setNString(1, productMap.get("name")); pstmt.setNString(2, productMap.get("description")); pstmt.setNString(3, productMap.get("quantity")); return "row has been updated into the database"; } }
/** * Add client record to persistent store. * * @param toAdd client to add * @return id of added client, or -1 if an error occurred */ public int addClient(ClientBean toAdd) { String insertStatement = "insert into clients (firstname, lastname, email, phonenumber) values (?,?,?,?);"; try { PreparedStatement statement = connection.prepareStatement(insertStatement, Statement.RETURN_GENERATED_KEYS); statement.setNString(1, toAdd.getFirstName()); statement.setNString(2, toAdd.getLastName()); statement.setNString(3, toAdd.getEmail()); statement.setNString(4, toAdd.getPhone()); statement.executeUpdate(); ResultSet generatedKeys = statement.getGeneratedKeys(); if (generatedKeys.first()) { return generatedKeys.getInt(1); } } catch (SQLException e) { e.printStackTrace(); } return -1; }
public void insertNewData(CommonDataBean bean) throws Exception { Connection conn = null; PreparedStatement pstmt = null; try { // prepare sql script StringBuffer sql = new StringBuffer(); sql.append( "insert into digital_converage (serialno, id, lang_id, title, subtitle, description, author, linkA, ") .append( " linkB, linkC, imgPathA, imgPathB, imgPathC, breadcrumbA, breadcrumbB, breadcrumbC, ") .append( " filePathA, filePathB, filePathC, createDate, top, enabled, isDelete, displayOrder, content_short, content_long ) ") .append(" values (?,?,?,?,?, ?,?,?,?,?, ?,?,?,?,?, ?,?,?,?,now(), ?,?,?,1,?,?) "); conn = DriverManager.getConnection("proxool.digital"); pstmt = conn.prepareStatement(sql.toString()); pstmt.setNull(1, java.sql.Types.INTEGER); pstmt.setInt(2, bean.getId()); pstmt.setInt(3, bean.getLang_id()); pstmt.setNString(4, bean.getTitle()); pstmt.setString(5, bean.getSubtitle()); pstmt.setString(6, bean.getDescription()); pstmt.setString(7, bean.getAuthor()); pstmt.setString(8, bean.getLinkA()); pstmt.setString(9, bean.getLinkB()); pstmt.setString(10, bean.getLinkC()); pstmt.setString(11, bean.getImageApath()); pstmt.setString(12, bean.getImageBpath()); pstmt.setString(13, bean.getImageCpath()); pstmt.setInt(14, bean.getBreadcrumbA()); pstmt.setInt(15, bean.getBreadcrumbB()); pstmt.setInt(16, bean.getBreadcrumbC()); pstmt.setString(17, bean.getFileApath()); pstmt.setString(18, bean.getFileBpath()); pstmt.setString(19, bean.getFileCpath()); // pstmt.setNull(20, java.sql.Types.DATE);//default is now() pstmt.setBoolean(20, bean.getTop() == 1 ? true : false); pstmt.setBoolean(21, bean.getEnabled() == 1 ? true : false); pstmt.setBoolean(22, false); pstmt.setString(23, bean.getContent_short()); pstmt.setString(24, bean.getContent_long()); pstmt.execute(); } catch (Exception e) { e.printStackTrace(); } finally { pstmt.close(); conn.close(); } }
public boolean addEventFeedback(int eventId, String budgetFeedback) { String updateStatement = "update eventrequests set feedback_budget=? where id=?;"; try { PreparedStatement statement = connection.prepareStatement(updateStatement); statement.setNString(1, budgetFeedback); statement.setInt(2, eventId); statement.executeUpdate(); return true; } catch (SQLException e) { e.printStackTrace(); } return false; }
public boolean insertExperience(String personnelID, Experience exp) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + EXPERIENCE_INFO + " VALUES(?,?,?,?,?,?,?,?,?,?,?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setString(1, personnelID); ps.setNString(2, exp.getCompName()); ps.setNString(3, exp.getPos()); ps.setNString(4, exp.getJob()); if (exp.getStartDate() == null) { ps.setNull(5, java.sql.Types.DATE); } else { ps.setDate(5, exp.getStartDate()); } if (exp.getEndDate() == null) { ps.setNull(6, java.sql.Types.DATE); } else { ps.setDate(6, exp.getEndDate()); } ps.setNString(7, exp.getReason()); ps.setNString(8, exp.getReferName()); ps.setString(9, exp.getReferPhone()); ps.setString(10, exp.getReferEmail()); ps.setNString(11, exp.getReferPos()); if (ps.executeUpdate() < 1) { check = false; } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }
public void addUser(String username, String password, String position) { String hash = Util.SHA256(password); String prepared = "insert into users (username, password, position) values (?,?,?);"; PreparedStatement statement = null; try { statement = connection.prepareStatement(prepared); statement.setNString(1, username); statement.setString(2, hash); statement.setString(3, position); statement.executeUpdate(); Log.i("Added user " + username + " : " + position); } catch (SQLException e) { e.printStackTrace(); } }
public boolean updateListTable(String value, String listName) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + listName + " VALUES(?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setNString(1, value); if (ps.executeUpdate() < 1) { check = false; } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }
public boolean updateOfficeList(Office o) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + getOFFICE_CB() + " VALUES(?,?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setNString(1, o.getOfficeName()); ps.setString(2, o.getOfficeNum()); if (ps.executeUpdate() < 1) { check = false; } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }
public boolean insertEducationInfo(String personnelID, Education edu) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + EDUCATION + " VALUES(?,?,?,?,?,?,?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setString(1, personnelID); ps.setShort(2, edu.getKindID()); ps.setShort(3, edu.getGraduationID()); ps.setNString(4, edu.getCourseName()); ps.setNString(5, edu.getSchoolName()); ps.setShort(6, edu.getFromYear()); ps.setShort(7, edu.getToYear()); if (ps.executeUpdate() < 1) { check = false; } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }
@Override public void setNString(int parameterIndex, String x) throws SQLException { stmt.setNString(parameterIndex, x); logValue(parameterIndex, x == null ? null : '\'' + x.replace("'", "''") + '\''); }
public boolean updatePersonnelDetails(PersonnelDetails pd) { boolean check = false; PreparedStatement ps = null; if (dbc.connect()) { try { String sqlQuery = "update " + PERSONNEL_INFO + " set " + "HoDem = ? ," + "Ten = ? ," + " Nickname = ?,\n" + " MaTrangThai = ?,\n" + " MaLoaiNV = ?,\n" + " MaLoaiHopDong = ?,\n" + " MaChucVu = ?,\n" + " MaPhongBan = ?,\n" + " NgayVao = ?,\n" + " NgayBatDau = ?,\n" + " GioiTinh = ?,\n" + " SDT = ?,\n" + " EmailCty = ?,\n" + " NgayKTthuViec = ?,\n" + " HinhAnh = ?,\n" + " NgaySinh = ?,\n" + " NguyenQuan = ?,\n" + " ThuongTru = ?,\n" + " MaDanToc = ?,\n" + " MaTonGiao = ?,\n" + " MaQuocGia = ?,\n" + " EmailRieng = ?,\n" + " KetHon = ?,\n" + " TrinhDoVH = ?,\n" + " DiaChi = ?,\n" + " SoCMT = ?,\n" + " NgayCap = ?,\n" + " MaTinh = ?,\n" + " SoTK = ?,\n" + " MaNH = ?,\n" + " NoiCap = ?,\n" + " MaSoThue = ?\n" + "where MaNV = ?"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setNString(1, pd.getlName()); ps.setNString(2, pd.getfName()); ps.setNString(3, pd.getNickName()); ps.setShort(4, pd.getStatusID()); ps.setShort(5, pd.getKindID()); ps.setShort(6, pd.getContractID()); ps.setShort(7, pd.getPosID()); ps.setShort(8, pd.getOfficeID()); if (pd.getEnterDate() == null) { ps.setNull(9, java.sql.Types.DATE); } else { ps.setDate(9, pd.getEnterDate()); } if (pd.getStartDate() == null) { ps.setNull(10, java.sql.Types.DATE); } else { ps.setDate(10, pd.getStartDate()); } ps.setBoolean(11, pd.isSex()); ps.setString(12, pd.getPhoneNum()); ps.setString(13, pd.getCompEmail()); if (pd.getEndTraining() == null) { ps.setNull(14, java.sql.Types.DATE); } else { ps.setDate(14, pd.getEndTraining()); } ps.setBytes(15, pd.getPic()); if (pd.getBirth() == null) { ps.setNull(16, java.sql.Types.DATE); } else { ps.setDate(16, pd.getBirth()); } ps.setNString(17, pd.getPlaceOB()); ps.setNString(18, pd.getRecentAdd()); ps.setShort(19, pd.getFolkID()); ps.setShort(20, pd.getReligionID()); ps.setShort(21, pd.getNationID()); ps.setString(22, pd.getPersonalEmail()); ps.setBoolean(23, pd.isMariage()); ps.setString(24, pd.getEducation()); ps.setNString(25, pd.getAdd()); ps.setString(26, pd.getIDNum()); if (pd.getIDDay() == null) { ps.setNull(27, java.sql.Types.DATE); } else { ps.setDate(27, pd.getIDDay()); } ps.setShort(28, pd.getRegionID()); ps.setString(29, pd.getBankCode()); ps.setShort(30, pd.getBankID()); ps.setNString(31, pd.getIDPlace()); ps.setString(32, pd.getTaxCode()); ps.setString(33, pd.getPersonnelID()); if (ps.executeUpdate() > 0) { check = true; } dbc.close(ps); } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } finally { dbc.close(ps); } } return check; }
private void testClob(int length) throws Exception { Random r = new Random(length); char[] data = new char[length]; // Unicode problem: // The UCS code values 0xd800-0xdfff (UTF-16 surrogates) // as well as 0xfffe and 0xffff (UCS non-characters) // should not appear in conforming UTF-8 streams. // (String.getBytes("UTF-8") only returns 1 byte for 0xd800-0xdfff) for (int i = 0; i < length; i++) { char c; do { c = (char) r.nextInt(); } while (c >= 0xd800 && c <= 0xdfff); data[i] = c; } Clob c = conn.createClob(); Writer out = c.setCharacterStream(1); out.write(data, 0, data.length); out.close(); stat.execute("delete from test"); PreparedStatement prep = conn.prepareStatement("insert into test values(?, ?)"); prep.setInt(1, 1); prep.setClob(2, c); prep.execute(); c = conn.createClob(); c.setString(1, new String(data)); prep.setInt(1, 2); prep.setClob(2, c); prep.execute(); prep.setInt(1, 3); prep.setCharacterStream(2, new StringReader(new String(data))); prep.execute(); prep.setInt(1, 4); prep.setCharacterStream(2, new StringReader(new String(data)), -1); prep.execute(); NClob nc; nc = conn.createNClob(); nc.setString(1, new String(data)); prep.setInt(1, 5); prep.setNClob(2, nc); prep.execute(); prep.setInt(1, 5); prep.setNClob(2, new StringReader(new String(data))); prep.execute(); prep.setInt(1, 6); prep.setNClob(2, new StringReader(new String(data)), -1); prep.execute(); prep.setInt(1, 7); prep.setNString(2, new String(data)); prep.execute(); ResultSet rs; rs = stat.executeQuery("select * from test"); rs.next(); Clob c2 = rs.getClob(2); assertEquals(length, c2.length()); String s = c.getSubString(1, length); String s2 = c2.getSubString(1, length); while (rs.next()) { c2 = rs.getClob(2); assertEquals(length, c2.length()); s2 = c2.getSubString(1, length); assertEquals(s, s2); } }
public void setNString(int parameterIndex, String value) throws SQLException { delegate.setNString(parameterIndex, value); }
// public static void main(String[] args) { // PersonnelDAO p = new PersonnelDAO(); // p.getPersonnelDetails("NV0001"); //////// //// String a = p.getPersonnelInfo("TenPhongBan", "tblPhongBan", "MaPhongBan", (short) 1); //// System.out.println(a); ////// ArrayList h = p.getList("MaMQH", "tblGiaDinh"); ////// for (int i = 0; i < h.size(); i++) { ////// System.out.println(h.get(i)); ////// } ////////// p.getFamilyDetails("NV0001"); ////////// p.getHealthStatus("NV0001"); ////////// p.getEducation("NV0001"); ////////// p.getSkill("NV0001"); ////////// p.getExperience("NV0001"); ////////// p.getDocumentsDetails("NV0001"); ////////// p.getRowPersonnelListTable(); //////// ArrayList<PersonnelBasic> a = p.getRowPersonnelListTable(); //////// for (int i = 0; i < a.size(); i++) { //////// System.out.println(a.get(i).getName()); //////// System.out.println(a.get(i).getBirth()); //////// System.out.println(a.get(i).getOffice()); // } // } public boolean insertPersonnelDetails(PersonnelDetails pd) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + PERSONNEL_INFO + " VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setString(1, pd.getPersonnelID()); ps.setNString(2, pd.getlName()); ps.setNString(3, pd.getfName()); ps.setNString(4, pd.getNickName()); ps.setShort(5, pd.getStatusID()); ps.setShort(6, pd.getKindID()); ps.setShort(7, pd.getContractID()); ps.setShort(8, pd.getPosID()); ps.setShort(9, pd.getOfficeID()); if (pd.getEnterDate() == null) { ps.setNull(10, java.sql.Types.DATE); } else { ps.setDate(10, pd.getEnterDate()); } if (pd.getStartDate() == null) { ps.setNull(11, java.sql.Types.DATE); } else { ps.setDate(11, pd.getStartDate()); } ps.setBoolean(12, pd.isSex()); ps.setString(13, pd.getPhoneNum()); ps.setString(14, pd.getCompEmail()); if (pd.getEndTraining() == null) { ps.setNull(15, java.sql.Types.DATE); } else { ps.setDate(15, pd.getEndTraining()); } ps.setBytes(16, pd.getPic()); if (pd.getBirth() == null) { ps.setNull(17, java.sql.Types.DATE); } else { ps.setDate(17, pd.getBirth()); } ps.setNString(18, pd.getPlaceOB()); ps.setNString(19, pd.getRecentAdd()); ps.setShort(20, pd.getFolkID()); ps.setShort(21, pd.getReligionID()); ps.setShort(22, pd.getNationID()); ps.setString(23, pd.getPersonalEmail()); ps.setBoolean(24, pd.isMariage()); ps.setString(25, pd.getEducation()); ps.setNString(26, pd.getAdd()); ps.setString(27, pd.getIDNum()); if (pd.getIDDay() == null) { ps.setNull(28, java.sql.Types.DATE); } else { ps.setDate(28, pd.getIDDay()); } ps.setShort(29, pd.getRegionID()); ps.setString(30, pd.getBankCode()); ps.setShort(31, pd.getBankID()); ps.setNString(32, pd.getIDPlace()); ps.setString(33, pd.getTaxCode()); if (ps.executeUpdate() < 1) { check = false; } dbc.close(ps); } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }