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 vote282 views1 answer
Java compile
Java
1 vote226 views1 answer
Split by new line java
Java
8 votes255 views1 answer
Org.mockito.exceptions.misusing.WrongTypeOfReturnValue
Java
26 votes232 views4 answers
Loop list java
Java
1 vote231 views1 answer
How to display an integer in a textfield in java
Java
0 vote247 views1 answer
Java compareto jdei stackoverflow
Java
0 vote243 views1 answer
Convert arraylist to csv file java
Java
1 vote228 views1 answer
Java 8 filter first
Java
1 vote227 views1 answer
How to make an invisiblke button in swing
Java
0 vote234 views1 answer
C:\elastic stack\elasticsearch-7.15.1-windows-x86_64\elasticsearch-7.15.1\bin>java -version java version "1.8.0_311" Java(TM) SE Runtime Environment (build 1.8.0_311-b11) Java HotSpot(TM) Client VM (build 25.311-b11, mixed mode, sharing)
Java