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

23 votes148 views6 answers
String to char
Java
1 vote160 views1 answer
Reading Large Files in Java
Java
16 votes162 views5 answers
Java reverse array
Java
0 vote181 views4 answers
UpperCase
Java
0 vote147 views3 answers
Transcoder converter for python to java
Java
0 vote164 views3 answers
D/NetworkSecurityConfig: No Network Security Config specified, using platform default
Java
1 vote161 views2 answers
How to uninstall java openjdk in linux
Java
11 votes162 views1 answer
Exception in thread "main" java.lang.indexoutofboundsexception: index 1 out of bounds for length 1
Java
2 votes179 views1 answer
Java chararray to int
Java
11 votes159 views1 answer
Age in java
Java