Question

我有一个问题,我想做的是得到当前的日期和一张桌子上的专栏。这是我目前为止的代码:

s = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rset = s.executeQuery("select getdate() as date, tglpengiriman from orders");
java.sql.Date date = rset.getDate("date");
java.sql.Date tglkirim = rset.getDate("tglpengiriman");

And throwing exception "no current row in ResultSet" in line 3 of my code above. What s wrong with my code? Missunderstanding usage of ResultSet, maybe?

谢谢你的回答...

EDIT: answered. Please see post from @Christopher below. Thanks

Answer 1

您需要在调用任何结果Set. get* 方法前先拨打结果Set. ext 。请查看对帐单、结果Set 等的文档。还要确定在最后一个街区中关闭您的所有资源。

Answer 2

You need to call rset.next() before getting the data from the result set. It is also wise to check that rset.next() returned true.

Answer 3

切换结果组的数据像这样

while (resultSet.next()) {
java.sql.Date date = rset.getDate("date");
java.sql.Date tglkirim = rset.getDate("tglpengiriman"); 
}

因为结果集的初始位置总是在第一个记录之前, 也就是在第一个记录开始的时候, 此结果Set. next () 将结果设置为指向第一个记录。

友情链接