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

1 vote128 views1 answer
Breadth first search BST java
Java
3 votes233 views3 answers
Spring mvc
Java Spring
2 votes134 views2 answers
Check whether a double is not a number in java
Java
6 votes128 views3 answers
Java get current year
Java
0 vote138 views1 answer
How to count an replace substring string in java
Java
4 votes250 views1 answer
Spring load config value in variable
Java Spring
0 vote138 views1 answer
Spring valid request body custom message
Java
0 vote120 views1 answer
Spring aop xml definition
Java
-1 vote141 views2 answers
Running Sum of 1d Array
Java
7 votes135 views1 answer
Java string stringbuilder remove trailing comma
Java