Set variable in static query

Question

I have a static query as Select * from Emp where Empid in (?) and I have that value of (?). I am not able to place that value. Please guide me. Let me know, I f anything else is required.

Hi Mureinik, there is nothing to share the code. i have fetch the data from DB as well as from JSP. and unable to set that value. please suggest me, how can I do that ? And, thanks for correcting the question. — Archit Mathur
– Archit Mathur, Commented Feb 14, 2014 at 13:10
is it because the method is static and the variable you want to set is not static, so in the method it is not available (due to static/non static fields? or are you trying to set it and at the DB level the variable is null? — Mark Giaconia
– Mark Giaconia, Commented Feb 14, 2014 at 13:11

ashokramcse · Accepted Answer · 2014-02-14 13:14:40Z

1

Try this java code:

public boolean yourMethod(String yuorValue) {
    String sql = "select * from user where fieldName = ?";
    PreparedStatement stmt = connection.prepareStatement(sql);
    stmt.setString(1, yuorValue);//fieldvalue(1), Your passing value 
    ResultSet rs = stmt.executeQuery();
    return rs.next(); 
 }

edited Feb 14, 2014 at 13:14

ashokramcse

2,8612 gold badges24 silver badges42 bronze badges

answered Feb 14, 2014 at 13:12

Sathiyaraj

3433 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Set variable in static query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related