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

0 vote211 views1 answer
Url encode not working spring boot oauth2
Java
0 vote188 views1 answer
Function name in java
Java
3 votes209 views1 answer
How to converet negative byte value to postive int value in java
Java
0 vote193 views1 answer
String to int error
Java
0 vote192 views1 answer
Exception in thread "main" java.lang.numberformatexception: for input string: ""
Java
0 vote210 views1 answer
Get host from request object java
Java
7 votes199 views3 answers
Convert Integer arraylist to array java
Java
3 votes208 views2 answers
Java hashmap time complexity
Java
0 vote196 views1 answer
How to set opacity of background android
Java
0 vote231 views1 answer
How to print all package in java
Java