private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
Human hm =new Human();
if(jTextField1.getText() == "\0" ){
JOptionPane.showMessageDialog(rootPane,"Chưa thêm phần Tên ");
}
else{
try {
ConnectionDTB cdtb = null;
try {
cdtb = new ConnectionDTB();
} catch (SQLException ex) {
Logger.getLogger(Them1.class.getName()).log(Level. SEVERE, null, ex);
}
ResultSet rs = cdtb.retrieveData("select svcode from listSV");
if(!rs.next()){
try {
hm.setName(jTextField2.getText());
if(jRadioButton1.isSelected()){
hm.setChucvu(jRadioButton1.getText());
}
else{
if(jRadioButton2.isSelected()){
hm.setChucvu(jRadioButton2.getText());
}
else
if(jRadioButton3.isSelected()){
hm.setChucvu(jRadioButton3.getText());
}
}
hm.setFather(jTextField7.getText());
hm.setMother(jTextField14.getText());
hm.setSkh(jTextField4.getText());
hm.setBplace(jTextField5.getText());
hm.setLocation(jTextField3.getText());
hm.setSex(String.valueOf(jComboBox2.getSelectedIte m()));
hm.setKhuyettat(jTextField6.getText());
hm.setMjob(jTextField13.getText());
hm.setFjob(jTextField8.getText());
hm.setMwork(jTextField12.getText());
hm.setFwork(jTextField9.getText());
hm.setNote(jTextArea1.getText());
hm.setLop(String.valueOf(jComboBox1.getSelectedIte m()));
hm.setSvcode(Integer.parseInt(jTextField1.getText( )));
hm.setSdtm(Integer.parseInt(jTextField11.getText() ));
hm.setSdtc(Integer.parseInt(jTextField10.getText() ));
DateFormat dateFormat = new SimpleDateFormat("dd/mm/yyyy");
Date date;
date = dateFormat.parse(jTextField18.getText());
hm.setBday(date);
if(jRadioButton1.isSelected()){
date = dateFormat.parse(jTextField15.getText());
hm.setDchucvu1(date);
}
else{
if(jRadioButton2.isSelected()){
date = dateFormat.parse(jTextField15.getText());
hm.setDchucvu1(date);
date = dateFormat.parse(jTextField16.getText());
hm.setDchucvu2(date);
}
else
if(jRadioButton3.isSelected()){
date = dateFormat.parse(jTextField15.getText());
hm.setDchucvu1(date);
date = dateFormat.parse(jTextField16.getText());
hm.setDchucvu2(date);
date = dateFormat.parse(jTextField17.getText());
hm.setDchucvu3(date);
}
}
String sqlCommand = "insert into listSV (myname,chucvu,father,mother,skh,bplace,sex,locati on,khuyettat,mjob,fjob,mwork,fwork,note,lop,svcode ,sdtm,sdtc,bday,dchucvu1,dchucvu2,dchucvu3) "
+ "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?, ?)";
java.sql.PreparedStatement ps1 = cdtb.excutePre(sqlCommand);
ps1.setString(1, hm.getName());
ps1.setString(2, hm.getChucvu());
ps1.setString(3, hm.getFather());
ps1.setString(4, hm.getMother());
ps1.setString(5, hm.getSkh());
ps1.setString(6, hm.getBplace());
ps1.setString(7, hm.getSex());
ps1.setString(8, hm.getLocation());
ps1.setString(9, hm.getKhuyettat());
ps1.setString(10, hm.getMjob());
ps1.setString(11, hm.getFjob());
ps1.setString(12, hm.getMwork());
ps1.setString(13, hm.getFwork());
ps1.setString(14, hm.getNote());
ps1.setString(15, hm.getLop());
ps1.setInt(16, hm.getSvcode());
ps1.setInt(17, hm.getSdtm());
ps1.setInt(18, hm.getSdtc());
java.sql.Date sqlDate = new java.sql.Date(hm.getBday().getTime());
ps1.setDate(19,sqlDate);
sqlDate = new java.sql.Date(hm.getDchucvu1().getTime());
ps1.setDate(20, sqlDate);
sqlDate = new java.sql.Date(hm.getDchucvu2().getTime());
ps1.setDate(21, sqlDate);
sqlDate = new java.sql.Date(hm.getDchucvu3().getTime());
ps1.setDate(22, sqlDate);
try {
ps1.execute();
} catch (SQLException ex) {
Logger.getLogger(Them1.class.getName()).log(Level. SEVERE, null, ex);
}
} catch (ParseException ex) {
Logger.getLogger(Them1.class.getName()).log(Level. SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(Them1.class.getName()).log(Level. SEVERE, null, ex);
}
JOptionPane.showMessageDialog(rootPane,"Đã thêm ");
}
else{
try {
while(rs.next()){
if(Integer.parseInt(jTextField1.getText()) == rs.getInt("svcode")){
JOptionPane.showMessageDialog(rootPane,"Mã Sinh viên đã tồn tại");
break;
}
if(rs.isLast()){
Object[] values = hm.toObject();
int[] indexes = new int[]{1};
hm.setName(jTextField2.getText());
if(jRadioButton1.isSelected()){
hm.setChucvu(jRadioButton1.getText());
}
else{
if(jRadioButton2.isSelected()){
hm.setChucvu(jRadioButton2.getText());
}
else
if(jRadioButton3.isSelected()){
hm.setChucvu(jRadioButton3.getText());
}
}
hm.setFather(jTextField7.getText());
hm.setMother(jTextField14.getText());
hm.setSkh(jTextField4.getText());
hm.setBplace(jTextField5.getText());
hm.setLocation(jTextField3.getText());
hm.setSex(String.valueOf(jComboBox2.getSelectedIte m()));
hm.setKhuyettat(jTextField6.getText());
hm.setMjob(jTextField13.getText());
hm.setFjob(jTextField8.getText());
hm.setMwork(jTextField12.getText());
hm.setFwork(jTextField9.getText());
hm.setNote(jTextArea1.getText());
hm.setLop(String.valueOf(jComboBox1.getSelectedIte m()));
hm.setSvcode(Integer.parseInt(jTextField1.getText( )));
hm.setSdtm(Integer.parseInt(jTextField11.getText() ));
hm.setSdtc(Integer.parseInt(jTextField10.getText() ));
DateFormat dateFormat = new SimpleDateFormat("dd/mm/yyyy");
Date date;
date = dateFormat.parse(jTextField18.getText());
hm.setBday(date);
if(jRadioButton1.isSelected()){
date = dateFormat.parse(jTextField15.getText());
hm.setDchucvu1(date);
}
else{
if(jRadioButton2.isSelected()){
date = dateFormat.parse(jTextField15.getText());
hm.setDchucvu1(date);
date = dateFormat.parse(jTextField16.getText());
hm.setDchucvu2(date);
}
else
if(jRadioButton3.isSelected()){
date = dateFormat.parse(jTextField15.getText());
hm.setDchucvu1(date);
date = dateFormat.parse(jTextField16.getText());
hm.setDchucvu2(date);
date = dateFormat.parse(jTextField17.getText());
hm.setDchucvu3(date);
}
}
String sqlCommand = "insert into listSV (myname,chucvu,father,mother,skh,bplace,sex,locati on,khuyettat,mjob,fjob,mwork,fwork,note,lop,svcode ,sdtm,sdtc,bday,dchucvu1,dchucvu2,dchucvu3) "
+ "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?, ?)";
PreparedStatement ps1 = (PreparedStatement) cdtb.excutePre(sqlCommand);
ps1.setString(1, hm.getName());
ps1.setString(2, hm.getChucvu());
ps1.setString(3, hm.getFather());
ps1.setString(4, hm.getMother());
ps1.setString(5, hm.getSkh());
ps1.setString(6, hm.getBplace());
ps1.setString(7, hm.getSex());
ps1.setString(8, hm.getLocation());
ps1.setString(9, hm.getKhuyettat());
ps1.setString(10, hm.getMjob());
ps1.setString(11, hm.getFjob());
ps1.setString(12, hm.getMwork());
ps1.setString(13, hm.getFwork());
ps1.setString(14, hm.getNote());
ps1.setString(15, hm.getLop());
ps1.setInt(16, hm.getSvcode());
ps1.setInt(17, hm.getSdtm());
ps1.setInt(18, hm.getSdtc());
java.sql.Date sqlDate = new java.sql.Date(hm.getBday().getTime());
ps1.setDate(19,sqlDate);
sqlDate = new java.sql.Date(hm.getDchucvu1().getTime());
ps1.setDate(20, sqlDate);
sqlDate = new java.sql.Date(hm.getDchucvu2().getTime());
ps1.setDate(21, sqlDate);
sqlDate = new java.sql.Date(hm.getDchucvu3().getTime());
ps1.setDate(22, sqlDate);
ps1.execute();
}
}
} catch (SQLException ex) {
Logger.getLogger(Them1.class.getName()).log(Level. SEVERE, null, ex);
} catch (ParseException ex) {
Logger.getLogger(Them1.class.getName()).log(Level. SEVERE, null, ex);
}
}

} catch (SQLException ex) {
Logger.getLogger(Them1.class.getName()).log(Level. SEVERE, null, ex);
}

}
}
Em không hiểu lỗi xảy ra ở đâu.
Kể cả để giá trị ô trúng là null hay không làm gì ấn vào nút này vẫn không ra bảng cần "chưa thêm phần tên" mà khi thêm hết vào rồi vẫn không cho vào MySQL được
Bài tập này thứ 6 phải nộp mà bị vấp chỗ này mãi không ra được
Mong mọi người giúp đỡ