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 vote171 views2 answers
Programming scares me
Java
0 vote135 views1 answer
Arraylistof objects
Java
0 vote250 views1 answer
System.out.printf("%"+(n)+"s \n")
Java
1 vote124 views1 answer
Javafx detect collision
Java
4 votes122 views1 answer
Spring load config value in variable
Java
4 votes154 views1 answer
Type variable java
Java
0 vote142 views1 answer
How to disable the auto-configuration?
Java
0 vote135 views1 answer
How to get stack trace of a function in java
Java
0 vote139 views1 answer
Multiple string java
Java
0 vote127 views1 answer
Boucle for avec un tableau java
Java