well i need to fire 10-12(or even more may be in hundreds) queries which is better way
to code
1)
Connection con = getConnection
Statement stat = con.createStatement();
ResultSet rs = stat.executeQuery("sql");
ResultSet rs1 = stat.executeQuery("sql");
ResultSet rs2 = stat.executeQuery("sql");
........................
.......................
so on
or
2)
Connection con = getConnection
Statement stat = con.createStatement();
ResultSet rs = stat.executeQuery("sql");
rs.close();
rs = stat.executeQuery("sql");
rs.close();
rs = stat.executeQuery("sql");
........................
.......................
or
3)
Connection con = getConnection
Statement stat = con.createStatement();
ResultSet rs = stat.executeQuery("sql");
rs.close();
stat.close();
stat = con.createStatement();
rs = stat.executeQuery("sql");
stat.close();
stat = con.createStatement();
rs = stat.executeQuery("sql");
........................
.......................
or
4)
Connection con = getConnection
Statement stat = con.createStatement();
ResultSet rs = stat.executeQuery("sql");
rs.close();
stat.close();
con.close();
Connection con = getConnection
stat = con.createStatement();
rs = stat.executeQuery("sql");
rs.close();
stat.close();
con.close();
Connection con = getConnection
stat = con.createStatement();
rs = stat.executeQuery("sql");
........................
.......................
or suggest some other better way
thanx Shashi
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
