package jdbcDay03;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestScroll {
public static void main(String[] args) {
Connection conn=null;
Statement stmt=null;
try {
String sql="select * from mytemp";
conn=ConnectionUtils.openConnection();
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, //可滚动的,不可保存的
ResultSet.CONCUR_READ_ONLY); //并发只读
ResultSet rs=stmt.executeQuery(sql);
if(rs.first())
System.out.println("1 "+rs.getString("user_id"));
if(rs.next())
System.out.println("2 "+rs.getString("user_id"));
rs.absolute(99);
System.out.println("99 "+rs.getString("user_id"));
rs.relative(-20); //相对于99减去10条
System.out.println("79 "+rs.getString("user_id"));
// rs.beforeFirst(); //结果集合已经耗尽
rs.previous(); //前一条
// rs.afterLast();
System.out.println("78 "+rs.getString("user_id"));
if(rs.last())
System.out.println("99 "+rs.getString("user_id"));
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
jdbc中可滚动数据定位方法
最新推荐文章于 2021-03-11 01:16:15 发布