hi
i have trying to acess some attributes using the
jdbc connection in servlet.Based on the result set value i want to retrieve the value of some other attributes in another table .and print all the attributes from both queries in 1 table .Please tell me how to do this .i am able to get the attributes from one table but not able to connect to another result set it is giving me errors.the code is
stmt=con.createStatement();
String que="select L.registerno,L.bldgno,L.aptno from Lease L where L.leasestart='"+d1+"'" ;
rs=stmt.executeQuery(que);
while(rs.next())
{
int regno=rs.getInt(1);
int blno=rs.getInt(2);
int apno=rs.getInt(3);
pw.println("<tr>");
pw.println("<td>");
pw.println(regno);
pw.println("</td>");
pw.println("<td>");
pw.println(blno);
pw.println("</td>");
pw.println("<td>");
pw.println(apno);
pw.println("</td>");
pw.println("</tr>");
stmt1=con.createStatement();
String que1="select PT.pname,PT.contactinfo from ProspectiveTenant PT where PT.registerno="+regno;
rs1=stmt1.executeQuery(que1);
String pnam=rs1.getString(1);
int cfo=rs1.getInt(2);
pw.println(pnam);
pw.println(cfo);
Here i am getting the value of regno but i dont know how to implement the second result set .please tell me how to do that
Thanks in advance
Lakshmi