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.