MySQL SQL Syntax error on GUI

Question

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.

It is the standard , "You got an MySQL error in your syntax, check for..." — Radu Maftei
– Radu Maftei, Commented Jan 8, 2017 at 11:35
Possible duplicate of How to use prepared statement for select query in Java? — hotzst
– hotzst, Commented Jan 8, 2017 at 11:36

SpringLearner · Accepted Answer · 2017-01-08 11:38:43Z

1

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()

edited Jan 8, 2017 at 11:38

answered Jan 8, 2017 at 11:36

SpringLearner

13.9k20 gold badges82 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Radu Maftei Over a year ago

This was it, I'll put it as an answer soon.

Collectives™ on Stack Overflow

MySQL SQL Syntax error on GUI

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related