DaniWeb IT Discussion Community - Inserting Data into Access Database

Hello I need help I have created a application that pulls data from and is supposed to update and insert data into an access database. I have been successful in pulling data from it using first, last, previous and next buttons.

However, I can't get my insert button to work. Here is the code I have for that button. I can't figure out what is wrong in the code. Can some one please help?

This is the connection code.

 

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

    connection = DriverManager.getConnection("jdbc:odbc:Miller");

    stmt = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);

    sqlQuery = "select Cust_ID, Name, Phone, Class_Level, Course_ID, Status, Pay_Terms from customers";

    rs = stmt.executeQuery(sqlQuery);

This is the code for the insert button:

 

class insertButtonHandler implements ActionListener

  {

      public void actionPerformed(ActionEvent e) 

      {

          try

             {

              if (inserting == false) { // clear text boxes

                  numF.setText("");

                  custF.setText("");

                  phneF.setText("");

                  levelF.setText("");

                  courseF.setText("");

                  statF.setText("");

                  termsF.setText("");

                  insertButton.setText("Save");

                  inserting = true;

              }

                  else 

                  { // finalize the insert

                rs.moveToInsertRow();

                int custNo = Integer.parseInt(numF.getText());

                rs.updateInt(1, custNo);

                rs.updateString(2, custF.getText());

                rs.updateString(3, phneF.getText());

                rs.updateString(4, levelF.getText());

                rs.updateString(5, courseF.getText());

                rs.updateString(6, statF.getText());

                rs.updateString(7, termsF.getText());

                rs.insertRow();

                insertButton.setText("Insert");

                inserting = false;

            }

            } 

                catch (Exception ex)

                {

                   JOptionPane.showMessageDialog(null, "Nothing inserted",

                           "Event Handler Message",  

                            JOptionPane.INFORMATION_MESSAGE);

    

       }

    }

  }

I get no errors at compilation. Everything else works, but nothing is inserted and it goes right to the catch and the event handler message comes up.