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 vote112 views1 answer
Java find if element of list in present in another list
Java
3 votes98 views1 answer
Java .trim()
Java
0 vote135 views1 answer
How to create a node in Java
Java
1 vote124 views1 answer
Creating file in specific location in java application
Java
0 vote127 views1 answer
How to insert a 0 in an array java
Java
0 vote119 views1 answer
Java map sorted by key
Java
0 vote150 views1 answer
How to find the logged-in user in Spring Boot?
Java Spring
0 vote123 views1 answer
Simple text formatter as in textbook
Java
0 vote144 views1 answer
Action bar message spigot 1.8
Java
4 votes123 views2 answers
With uses in python
Java