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 vote304 views1 answer
Getarguments().getstring updates android
Java
-2 votes824 views2 answers
How to use beacon power in minecraft in java edition
Java
1 vote347 views1 answer
Java get temp dir
Java
0 vote398 views1 answer
How to write a perfect shuffle method in java
Java
0 vote347 views1 answer
Reader from string java
Java
1 vote329 views4 answers
How to compare strings without capital letters in java easy
Java
0 vote350 views1 answer
Java string regexp replace
Java
0 vote346 views1 answer
Factorial method library in java
Java
0 vote338 views1 answer
How to set to nothing a ComboBox in java
Java
0 vote345 views1 answer
Java print class type
Java