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

11 votes142 views2 answers
Calculate age from localdate java
Java
0 vote136 views1 answer
Java supress unchecked
Java
0 vote121 views1 answer
How to encrypt password in properties file in spring boot
Java
1 vote103 views1 answer
How to filter data in java
Java
23 votes104 views6 answers
String to char
Java
0 vote111 views1 answer
Index 1 out of bound for length 1 java
Java
0 vote109 views1 answer
Bukkit e.getCurrentItem() bytes?
Java
0 vote199 views1 answer
Java list of a class has a string that is equal to
Java
0 vote104 views1 answer
Why we use return method
Java
5 votes97 views2 answers
Get columns number sql
Java