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 vote147 views3 answers
Get selected item spinner
Java
1 vote119 views1 answer
Java check if two list are the same
Java
1 vote146 views1 answer
Why can we implement multiple interfaces in java
Java
0 vote168 views1 answer
How to find the angle of 2 coordinates java
Java
89 votes221 views5 answers
Java foreach
Java
16 votes157 views2 answers
Log4j
Java
0 vote146 views1 answer
How to not allow a user to enter a mark greater than 100 or below 0 in java
Java
0 vote157 views2 answers
Java fill two dimensional array stream
Java
0 vote153 views1 answer
Android dynamically create layer-list with item and shape site:stackoverflow.com
Java
1 vote149 views1 answer
Java fields
Java