Same query working in MySQL, and not in Java Client

Question

This query retrieves the correct value when run in MySQL workbench.

select person_id from person where person_name='John Adam';

But when I run it from by Java code, it gives the exception at the line in which executeQuery() is called.

SQLState: 42S22
Error Code: 1054
Message: Unknown column 'John Adam' in 'where clause'

My code is:

String inputname= JOptionPane.showInputDialog ( "Enter person's name:" ); 
String query= "select person_id from person where person_name= "+ inputname;

try {
    stmt=con.createStatement();
    ResultSet rs = stmt.executeQuery(query); // EXCEPTION AT THIS LINE
    while (rs.next()){
    rid= rs.getInt("person_id");
    } // .....

What do you think can be the reason for this?

juergen d · Accepted Answer · 2014-04-28 12:25:58Z

4

You need to put quotes around your input

String query= "select person_id from person " + 
              "where person_name= '"+ inputname + "'";

Or better use Prepared Statements to let the escaping do the program for you automatically.

answered Apr 28, 2014 at 12:25

juergen d

205k40 gold badges305 silver badges377 bronze badges

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

Comments

Sadikhasan · Accepted Answer · 2014-04-28 12:25:45Z

1

Try with single quotes

String query= "select person_id" + 
               "from person where person_name= '"+ inputname+"'";

answered Apr 28, 2014 at 12:25

Sadikhasan

18.6k23 gold badges85 silver badges126 bronze badges

Collectives™ on Stack Overflow

Same query working in MySQL, and not in Java Client

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related