How to pass query as parameter? 0 Answer(s) 3 years ago
Posted in : JSP-Servlet
Hi Friends,
I have a real tough time in finding the solution of a problem. I am here to find a real solution of my problem. Please help me solve this problem. My Problem is:
I have 3 query.. String qry1="select id from table1"; String qry2="select name from table2"; String qry3="select age from table13";
string q=Insert into emp values(?,?,?); int update=prep.executeUpdate(q); prep.setString(1,qry1); prep.setString(2,qry2); prep.setString(3,qry3); prep.executeUpdate();
In this, i am not able to pass the value of qry1,qry2,qry3...