Using value from a JTextBox in SELECT query in mysql

Question

I have a textbox. When the user enters the name in the textbox I want the details fetched from the table

String getTxt = text.getText();
ResultSet rs=st.executeQuery("SELECT * FROM authors_4 WHERE self_authors="+getTxt);

On executing this i'm getting exception

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server

What is the solution to this. Need help

Reimeus · Accepted Answer · 2013-03-28 15:05:38Z

3

You're missing single quotes:

st.executeQuery("SELECT * FROM authors_4 WHERE self_authors='" + getTxt + "'");

Better use a PreparedStatement to protect against SQL Injection attacks.

edited Mar 28, 2013 at 15:05

answered Mar 28, 2013 at 14:54

Reimeus

160k16 gold badges225 silver badges282 bronze badges

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

1 Comment

Shahzaib Over a year ago

You are using ' "+getTxt+" ' ` ", shouldnt it be ' "+getTxt+" ' "

Collectives™ on Stack Overflow

Using value from a JTextBox in SELECT query in mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related