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 vote377 views1 answer
Design a class ‘complex ‘with data members for real and imaginary part. provide default and parameterized constructors. write a program to perform arithmetic operations of two complex numbers.
Java
0 vote234 views2 answers
Sets
Java
0 vote217 views1 answer
BottomNavigationView only icon
Java
0 vote222 views2 answers
How to get string value in java in android
Java
2 votes217 views1 answer
How to change a string array in integer array
Java
0 vote237 views1 answer
More parameters java sql @PathVariable
Java
2 votes238 views2 answers
Restart java windows
Java
0 vote207 views1 answer
'tools:replace="android:appComponentFactory"' to <application> element at AndroidManifest.xml:6:5-34:19 to override.
Java
0 vote215 views1 answer
Java.lang.NoClassDefFoundError: net/sf/cb2xml/def/IItem
Java
11 votes166 views2 answers
Java binary tree height method
Java