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