Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/employee", "root", "");
- PreparedStatement pt = connect.prepareStatement("INSERT INTO employee (firstname,lastname,deptcode,phoneno,hiredate,job) values(?,?,?,?,?,?)");
- // pt.setString(1, empnoTField.getText());
- pt.setString(1, fnameTField.getText());
- pt.setString(2, lnameTField.getText());
- pt.setString(3, deptCodeCombo.getSelectedItem().toString());
- pt.setString(4, phoneTField.getText());
- //pt.setString(6, monthCombo.getSelectedItem().toString() + "/" + dayCombo.getSelectedItem().toString() + "/" + yearCombo.getSelectedItem().toString());
- pt.setString(5, hiredate.getText());
- pt.setString(6, jobTField.getText());
- pt.executeUpdate();
- connect.close();
- JOptionPane.showMessageDialog(this, "New Employee Save!","Confirmation",JOptionPane.INFORMATION_MESSAGE);
- //empnoTField.setText(null);
- fnameTField.setText(null);
- lnameTField.setText(null);
- deptCodeCombo.setSelectedIndex(0);
- phoneTField.setText(null);
- //monthCombo.setSelectedIndex(0);
- //dayCombo.setSelectedIndex(0);
- //yearCombo.setSelectedIndex(0);
- hiredate.setText(null);
- jobTField.setText(null);
- // NewRecord.setVisible(false);
- displayTable();
- }
- catch(SQLException sqe){
- System.out.println("SQl error: " + sqe.toString());
- }
- catch(ClassNotFoundException cnf){
- System.out.println("Class not found error: " + cnf.toString());
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement