Hi all,
I'm new to Java/JDBC. I'm using JSP and i'm using
Resin 1.2 for JSP. Ok Now.. i have following doubts
regarding JDBC / JSP:
1. Suppose i have executed a query and got the results
in result set rs. Then which of the following is the
best method to browse through the records fetched:
Result rs = st.executeQuery("select *....");
Method 1:
---------
while (rs.next())
{
// get the records, do some operations
}
Method 2:
--------
ResultSetMetaData rsMeta = rs.getMetaData();
int numCols = rsMeta.getColumnCount();
for (int i=0; i<numCols; i++) {
// get the records
}
Which one of the above two methods is good in terms of
fastness, performance ?
2. I have a question regarding persistance of DB
connection between the JSP to Servlet calls? I mean in
a JSP i have a database handle returned from a
connection class bean. And can i pass this connection
handle to other program (either JSP, Servlet)??
Whether this handle is persistant from that other
program? Shall i be able to query the same db from the
second program?
Pardon me for the ignorance.
Thanks in advance,
kindly help,
Venu
__________________________________________________
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
