Breaking News: Grepper is joining You.com. Read the official announcement!

java sql query with parameters

DevPedrada answered on October 6, 2021 Popularity 8/10 Helpfulness 4/10

answer java sql query with parameters

java sql query with parameters

Comment

   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);

Popularity 8/10 Helpfulness 4/10 Language java

Source: stackoverflow.com

Tags: java parameters sql

Link to this answer
Share Copy Link