This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Journey To Enterprise Agility and have Daryl Kulak & Hong Li on-line!
See this thread for details.
Win a copy of The Journey To Enterprise Agility this week in the Agile and Other Processes forum! And see the welcome thread for 20% off.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Junilu Lacar
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Ganesh Patekar
  • Tim Moores
  • Pete Letkeman
  • Stephan van Hulst
Bartenders:
  • Carey Brown
  • Tim Holloway
  • Joe Ess

urgent  RSS feed

 
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 3244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Lakshmi
what is the actual Exception you are getting? If the code you posted is the code you are running you'll get an error if there is no resultset returned from your second query.
You could just do a JOIN on the two tables and get the records in one trip:
Something like this:
String que="select PT.pname,PT.contactinfo, L.registerno,L.bldgno,L.aptno from Lease L INNER JOIN ProspectiveTenant PT ON L.registerno = PT.registerno where L.leasestart='"+d1+"'" ;
hope that helps
Also, this is more of a JDBC question.
[ April 19, 2002: Message edited by: Dave Vick ]
 
"The Hood"
Sheriff
Posts: 8521
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I will move it to JDBC.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!