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 vote287 views1 answer
How to get date in android studio
Java
0 vote349 views1 answer
How does plus works in Java
Java
3 votes355 views1 answer
Spigot broadcast message
Java
2 votes381 views3 answers
Java main
Java
0 vote384 views1 answer
How to create space between element in vbox in javafx
Java
1 vote350 views1 answer
Android how to determine if the edit text focus changes
Java
63 votes343 views3 answers
Java hello word
Java
0 vote364 views2 answers
What does put extra do?
Java
4 votes358 views1 answer
Junit 5 assert exception message
Java
0 vote303 views1 answer
Android ancestral navigation
Java