Advertisement
Guest User

action

a guest
Oct 3rd, 2018
406
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.18 KB | None | 0 0
  1. @Override
  2. public void actionPerformed(ActionEvent e) {
  3.  
  4. if (e.getSource() == btnSave) {
  5.  
  6. try {
  7. int gTT = Integer.parseInt(txtTT.getText());
  8. int gTR = Integer.parseInt(txtTR.getText());
  9. String gName = txtName.getText();
  10. int gPhone = Integer.parseInt(txtPhone.getText());
  11. String gLab = cboLab.getSelectedItem().toString();
  12.  
  13. String gRB = "";
  14. if (rbDJTMK.isSelected()) {
  15. gRB = rbDJTMK.getActionCommand();
  16. } else if (rbDJPA.isSelected()) {
  17. gRB = rbDJPA.getActionCommand();
  18. }
  19.  
  20. JOptionPane.showMessageDialog(null, "Time taken : " + gTT + "\nTime returned : " + gTR
  21. + "\nLecturer name : " + gName + "\nPhone number : " + gPhone
  22. + "\nLaboratory : " + gLab + "\nDepartment : " + gRB);
  23.  
  24. Class.forName("com.mysql.jdbc.Driver");
  25. conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/semester4", "root", "");
  26. stmt = conn.createStatement();
  27. stmt.executeUpdate("insert into laboratory values(" + gTT + "," + gTR + ",'" + gName + "'," + gPhone + ",'" + gLab + "','" + gRB + "')");
  28.  
  29. } catch (Exception exc) {
  30. System.err.println("Got an exception! ");
  31. System.err.println(exc.getMessage());
  32. }
  33.  
  34. }
  35.  
  36. else if (e.getSource() == btnDisplay) {
  37.  
  38. try {
  39.  
  40. JOptionPane.showMessageDialog(null, "Load data from database ...");
  41.  
  42.  
  43. ResultSet rs = stmt.executeQuery("select * from laboratory");
  44. while (rs.next());
  45.  
  46. int gdTT = rs.getInt("TIME_TAKEN");
  47. int gdTR = rs.getInt("TIME_RETURNED");
  48. String gdName = rs.getString("LECTURER_NAME");
  49. int gdPhone = rs.getInt("PHONE_NUMBER");
  50. String gdLab = rs.getString("LABORATORY");
  51. String gdDep = rs.getString("DEPARTMENT");
  52.  
  53. DefaultTableModel model = new DefaultTableModel();
  54. JTable table = new JTable(model);
  55. JScrollPane scrollPane = new JScrollPane();
  56.  
  57. model.addRow(new Object [] {gdTT, gdTR, gdName, gdPhone, gdLab, gdDep});
  58. table.setModel(model);
  59. scrollPane = new JScrollPane(table);
  60. scrollPane.setBounds(130,120,400,150);
  61. add(scrollPane);
  62.  
  63. } catch (Exception exc2) {
  64. exc2.printStackTrace();
  65. }
  66. }
  67.  
  68. else if (e.getSource() == btnClose) {
  69. int close = JOptionPane.showConfirmDialog(null, "Do you want to close this program ?", "Exit", JOptionPane.YES_NO_OPTION);
  70. if (close == JOptionPane.YES_OPTION) {
  71. System.exit(0);
  72. } else if (close == JOptionPane.NO_OPTION) {
  73. setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
  74. }
  75. }
  76.  
  77. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement