ansaurus

Question

jsp coding problem

Answer 1

+3 A:

You need to call ResultSet#next() to move the cursor to the next row, otherwise you cannot access any data from the row. If you expect multiple rows, do this in a while loop:

while (rset1.next()) {
    System.out.println(" name -> " + rset1.getString(2));
}

Or if you expect only one row, then do this in an if statement:

if (rset1.next()) {
    System.out.println(" name -> " + rset1.getString(2));
}

`ResultSet` is never, **never**, `null`. If there is no data then `ResultSet#next()` will simply return `false`. Or if something fails during obtaining the data, then just a `SQLException` will be thrown. Also see the **Returns:** entry of the [Statement#executeQuery() javadoc](http://java.sun.com/javase/6/docs/api/java/sql/PreparedStatement.html#executeQuery%28%29)

BalusC 2010-07-07 18:58:34

you are right...becaz of a quick galnace on the javadoc i got confused "never null" with "null"

Pangea 2010-07-07 19:09:14

Answer 3

A:

You should explicitly list the columns you are requesting rather than using a wildcard. There's no guarantee as to the order of columns in your result set otherwise. Consider what would happen if somebody added a column in the middle of the table (and yes, this does happen).

TMN 2010-07-07 19:25:56

ansaurus

tags:

views:

answers:

jsp coding problem

See also:

See also:

related questions