Java sql query with parameters

   statement =con.prepareStatement("SELECT * from employee WHERE  userID = :userId");
   statement.setString(userId, userID);
   ResultSet rs = statement.executeQuery();
// Or, you can use ? in place of named value - :userId..

   statement =con.prepareStatement("SELECT * from employee WHERE  userID = ?");
   statement.setString(1, userID);

Source: stackoverflow.com

Similar codes

2 votes154 views1 answer
Password encryption and decryption in java
Java
0 vote202 views1 answer
Cypher query having multiple values
Java
2 votes162 views3 answers
Convert java to kotlin online editor
Java
1 vote167 views1 answer
Void get method using collections
Java
4 votes214 views2 answers
Generate 5 digit random string in java
Java
0 vote154 views1 answer
Positive numbers in array
Java
6 votes155 views5 answers
SharedPreferences
Java
0 vote159 views2 answers
How to create a console in java gui
Java
0 vote177 views1 answer
FirebaseCrashlyticsPlugin.java uses or overrides a deprecated API.
Java
35 votes164 views2 answers
Remoce last character froma java string
Java