Search code examples
javamysqlconnector

MySQL SQL Syntax error on GUI


Hello I want to put 2 values to 2 columns in my table. I get those values from txtField and textField_1 (which are 2 textboxes on an GUI).

The problem is that whenever I push the button to register those values I get an syntax error on my mysql.

String query = "INSERT INTO Registration (Username , Password ) VALUES (? ,?)";
                java.sql.PreparedStatement pst = connection.prepareStatement(query);
                pst.setString(1,textField.getText());
                pst.setString(2,textField_1.getText());
                int rs = pst.executeUpdate(query);

If I put static values instead of ?, is working.


Solution

  • String query = "INSERT INTO Registration (Username , Password ) VALUES (? ,?)";
                    java.sql.PreparedStatement pst = connection.prepareStatement(query);
                    pst.setString(1,textField.getText());
                    pst.setString(2,textField_1.getText());
                    int rs = pst.executeUpdate();
    

    use executeUpdate()