Information regarding ResultSet !
Hi every one!
Can anyone tell me what kind of output does a ResultSet object hold?And can we store this in any other object?
Also as i know the output of an sql query will be stored in ResultSet object.And we use rs.next() to move through these select records.
But my doubt is.,
while(rs.next())
{
String dis = rs.getString(3);
out.println("<tr>");
out.println("<td>");
out.println(rs.getInt(1));
out.println("</td>");
out.println("<td>");
out.println(rs.getString(2));
out.println("</td>");
out.println("<td>");
out.println("<a href=http://localhost:8080/servlets-examples/detail?name=dis>");
out.println(rs.getString(3));
out.println("</a>");
out.println("</td>");
out.println("<td>");
out.println("<a href=http://localhost:8080/servlets-examples/addetail>");
out.println(rs.getString(4));
out.println("</a>");
out.println("</td>");
out.println("</tr>");
is it correct to use String dis =rs.getString(3) and then further down use rs.getInt(1)?
Also is it that we can use rs.setXXX() only once per field?Plz giude me!
