Hi Friends,
Here is piece of my
servlet from first query I got userID and now I don't know how can I pass "userID" to the second query?
Many thanks for your help,
Elahe
PrepStmt =con.prepareStatement("select userID from user where name =" +name);
while (rs.next()) {
C_BugList xobj=new C_BugList();
xobj.setUserID(rs.getInt("userID"));
}
stmt.close();
//Create a Statement Object
stmt = con.createStatement();
//Second query
PrepStmt =con.prepareStatement("update bug set values (?) where bugNumber="+bugNumber);
PrepStmt.setInt(4,userID);