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 vote183 views1 answer
Who is James Gosling
Java
0 vote181 views1 answer
Java unused import statement
Java
0 vote179 views1 answer
How to clear a stringbuffer in java
Java
0 vote174 views1 answer
Intergers are appearing as string in Json
Java
51 votes214 views6 answers
Java array print
Java
1 vote170 views1 answer
Java sort arraylist of arraylist
Java
2 votes169 views2 answers
Install java with brew
Java
1 vote213 views1 answer
Comparable
Java
0 vote187 views1 answer
Java binary addition
Java
11 votes170 views6 answers
Print statement in java
Java