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 vote189 views1 answer
Take string until /
Java
0 vote187 views1 answer
Conexion a mysql java
Java
11 votes172 views2 answers
Converting temperature from fahrenheit to celsius
Java
2 votes178 views1 answer
Enum set in java
Java
0 vote194 views1 answer
Java icon to image
Java
0 vote230 views1 answer
How to know what a valid name for a variable is in java
Java
-2 votes192 views1 answer
App.js:2119 Uncaught TypeError: Vue.component is not a function
Java
0 vote182 views1 answer
Access denied finding property "camera.aux.packagelist"
Java
1 vote205 views1 answer
Selection Structure and Conditions
Java
0 vote146 views1 answer
How to get server port in java
Java