Suppose I have a table called "user" with just a

Question

Suppose I have a table called "user" with just a

single row(record), which has just two columns namely "name" and "password".
So does anyone know how can I get the data in the second column using java.sql.ResultSet ?

ResultSet rs = stmnt.executeQuery("select * from user");
rs.next();
name = rs.getString("name");

The above code gives me the value in the first column in the first record. But now how can I get the value in the 2nd column in the first record ?

0

13.12.2021

6 ответов

38 просмотров

mito Автор вопроса

Mihai
https://docs.oracle.com/javase/tutorial/jdbc/basic...

Thanks Mihai 👍

0

13.12.2021

Dmytro Buryak

Not sure whether you've already fixed, but following general understanding of jdbc result sets may be helpful. ResultSet works as a data container, and as an iterator (or "cursor") at the same time. So when you're fetching data from result set with ".getString", you should think of it like "I'm reading columns of the row that ResultSet is currently point at". When you're done fetching all the rows you need, you should point cursor at next row by calling "rs.next()". Yes, it's very confusing design, but this is old and very widely used interface, so we have to live with it))

0

13.12.2021

mito Автор вопроса

Dmytro Buryak
Not sure whether you've already fixed, but followi...

When you're done fetching all the "row" you need, you should point cursor at next row by calling "rs.next()". Do you mean column here instead of row in the first phrase ?

0

13.12.2021

Dmytro Buryak

mito
When you're done fetching all the "row" you need, ...

Yes, I meant columns, you're right)) you fetch column values, then call "next", and now the same result set object points to next row

0

14.12.2021

mito Автор вопроса

Dmytro Buryak
Yes, I meant columns, you're right)) you fetch col...

thanks :)

0

14.12.2021