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 vote197 views1 answer
Null check in line java
Java
-1 vote196 views1 answer
How to run java in eclipse
Java
1 vote185 views2 answers
Scanner_Java
Java
0 vote195 views2 answers
Round to the next multiple of 5
Java
0 vote205 views1 answer
Java opengl get fps
Java
0 vote223 views1 answer
How to check my java heap space size
Java
3 votes194 views1 answer
What are parameters in java
Java
0 vote193 views2 answers
Java indexof all occurrences
Java
3 votes223 views2 answers
File to image javafx
Java
4 votes199 views3 answers
Array find max in java
Java