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

5 votes264 views2 answers
How to import java.util
Java
0 vote264 views1 answer
If en java avec un point d'interrogation
Java
0 vote274 views1 answer
Creating jdbc connection in java using service name oracle
Java
0 vote277 views5 answers
Comment in Java
Java
2 votes283 views2 answers
Convert integer array to string array
Java
4 votes284 views2 answers
Remove action bar android studio
Java
1 vote260 views1 answer
Java how to center window
Java
4 votes318 views2 answers
Append to file in java
Java
0 vote275 views1 answer
Open a new activity on click of a button
Java
-2 votes257 views2 answers
How to find a string in a sentence in java
Java