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, fnameTField.getText());
        pt.setString(2, lnameTField.getText());
        pt.setString(3, deptCodeCombo.getSelectedItem().toString());
        pt.setString(4, phoneTField.getText());
        pt.setString(5, hiredate.getText());
        pt.setString(6, jobTField.getText());

        pt.executeUpdate();
        connect.close();
        JOptionPane.showMessageDialog(this, "New Employee Save!","Confirmation",JOptionPane.INFORMATION_MESSAGE);



	fnameTField.setText(null);
        lnameTField.setText(null);
        deptCodeCombo.setSelectedIndex(0);
	phoneTField.setText(null);

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