How in JDBC to create a search query for identical text in a database where the text is passed from a variable of type String

Question

How to check the identity of a value in the h2 database with the value of a variable of type String ?

 r=stat.executeQuery("SELECT * FROM USER WHERE LOGIN ='data'");

Instead of the text data, a variable of the String type should be passed:

r=stat.executeQuery("SELECT * FROM USER WHERE LOGIN =login");

Use PreparedStatement also failed.

Accepted Answer · 2016-01-23T13:13:58

Just like this:

 String str = "Alex"; r = stat.executeQuery("SELECT * FROM USER WHERE LOGIN = '" + str + "';");

dirkgntly

3,697 4 gold marks 13 silver marks 32 bronze marks

String s = "qwer"; r = stat.executeQuery ("SELECT * FROM USER WHERE LOGIN = '" + s + "';"); while (r.next ()) {System.out.print (r.getString ("Login")); } - George
does not display any results even though there is an entry in the database with such a login; - George
@ Georgy, let's get the code, then it will be easier vladislavkhripkov@mail.ru - dirkgntly

|

1 answer 1