jdbc处理可以滚动的结果集

来源：互联网发布：判断推理知乎编辑：程序博客网时间：2024/04/30 05:34

this code cannot run successful at sqlite3, SQLite only supports TYPE_FORWARD_ONLY cursors.

package com.zhanghao.local;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class localtest {    public static void main(String[] args) throws Exception {        String DRIVER = "org.sqlite.JDBC";        String URL = "jdbc:sqlite:D:\\Java_projects\\data.db";        Class.forName(DRIVER);        Connection conn = DriverManager.getConnection(URL);        Statement statement = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);        ResultSet resultSet = statement.executeQuery("select * from user order by name");        resultSet.next();        System.out.println(resultSet.getString(1));        resultSet.last();        System.out.println(resultSet.getString(1));        System.out.println(resultSet.isLast());        System.out.println(resultSet.isAfterLast());        System.out.println(resultSet.getRow());        resultSet.previous();        System.out.println(resultSet.getString(1));        resultSet.absolute(6);        System.out.println(resultSet.getString(1));        resultSet.close();        statement.close();        conn.close();    }}

0 0