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

4 votes359 views1 answer
Java remove while iterating
Java
1 vote331 views2 answers
Java first day of week
Java
0 vote328 views1 answer
Log10 in java
Java
0 vote352 views1 answer
Java stack using linked list
Java
3 votes323 views1 answer
Java console write
Java
-1 vote434 views1 answer
Annotation spring notnull
Java Spring
0 vote357 views1 answer
Priority scheduling in java
Java
0 vote342 views1 answer
Connect 3 game android studio not working play agin
Java
23 votes319 views2 answers
Check last character of string java
Java
0 vote352 views1 answer
Java insert char in string at index
Java