Connection con;
PreparedStatement pstmt;
String sql = "INSERT INTO appraisalreport VALUES (?,?,?,?,?,?,?,?,?,?,?,?);";
try{
Class.forName(DRIVER);
con = DriverManager.getConnection(DB_URL, UNAME, PWD);
pstmt = con.prepareStatement(sql);
pstmt.setInt(1, new Integer(tfsn.getText()));
pstmt.setString(2, tfdate.getText());
pstmt.setString(3, tfap.getText());
pstmt.setString(4, jTextField1.getText());
pstmt.setInt(5, new Integer(jpunc.getText()));
pstmt.setInt(6, new Integer(jattend.getText()));
pstmt.setInt(7, new Integer(jteam.getText()));
pstmt.setInt(8, new Integer(jsocial.getText()));
pstmt.setInt(9, new Integer(jsmart.getText()));
pstmt.setInt(10, new Integer(jtask.getText()));
pstmt.setInt(11, new Integer(jtotal.getText()));
pstmt.setString(12, jTextField9.getText());
int n = pstmt.executeUpdate();
if(n > 0){
javax.swing.JOptionPane.showMessageDialog(rootPane, "Appraisal successful !");
}else{
javax.swing.JOptionPane.showMessageDialog(rootPane, "Appraisal failed !");
}
pstmt.close();
con.close();
}catch(ClassNotFoundException e){
System.out.println("Driver not registered");
}catch(SQLException se){
se.printStackTrace();
}