private void chooseActionPerformed(java.awt.event.ActionEvent evt) {

         JTextField id = new JTextField(20);
         JTextField name = new JTextField(40);
         JTextField year = new JTextField(5);
         JTextField branch = new JTextField(5);
         JTextField faculty = new JTextField(30);



      JPanel myPanel = new JPanel();
      myPanel.add(new JLabel("ID:"));
      myPanel.add(id);
      myPanel.add(Box.createVerticalStrut(15)); // a spacer

      myPanel.add(new JLabel("Name:"));
      myPanel.add(name);
      myPanel.add(Box.createVerticalStrut(15));

      myPanel.add(new JLabel("Year:"));
      myPanel.add(year);
      myPanel.add(Box.createVerticalStrut(15));

      myPanel.add(new JLabel("Branch:"));
      myPanel.add(branch);
      myPanel.add(Box.createVerticalStrut(15));

      myPanel.add(new JLabel("Faculty"));
      myPanel.add(faculty);
      myPanel.add(Box.createVerticalStrut(15));

      int result = JOptionPane.showConfirmDialog(null, myPanel,
               "Enter Course details", JOptionPane.OK_CANCEL_OPTION);
      if (result == JOptionPane.OK_OPTION) {
        String cid = id.getText();
        String cname = name.getText();
        String cyear = year.getText();
        String cbranch = branch.getText();
        String cfaculty = faculty.getText();

         try{
                Class.forName("java.sql.Driver");
                Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "root", "lego");
                Statement st = con.createStatement();
                PreparedStatement pst = con.prepareStatement("insert into db.courses values(?,?,?,?,?);");
                pst.setString(1, cid);
                pst.setString(2, cname);
                pst.setString(3, cyear);
                pst.setString(4,cbranch);
                pst.setString(5, cfaculty);
                pst.executeUpdate();

                st.close();
                con.close();
            } catch(Exception e){
                System.out.println(e);
            }

      }



        try {
            Class.forName("java.sql.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "root", "lego");
            Statement st = con.createStatement();

            String sql = "select cid, cname, year, branch, faculty from db.courses;";
            ResultSet rs = st.executeQuery(sql);

            table.setModel(DbUtils.resultSetToTableModel(rs));

        } catch (Exception e){
            System.out.println(e);
        }
    }