可滚动的结果集

 

package JDBC;

import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Time;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Calendar;
/** *//**
 * 
 * @author oakertree
 *
 */
public class TestScroll {
    public static void main(String[] args) {
        Connection con = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
//            new com.mysql.jdbc.Driver();
            con = DriverManager.getConnection("jdbc:mysql://localhost:3307/test", "root", "admini");
            stmt = con.createStatement(
                    ResultSet.TYPE_SCROLL_INSENSITIVE,
                    ResultSet.CONCUR_READ_ONLY);
            rs = stmt.executeQuery("SELECT * FROM time");
            rs.next();
            System.out.println(rs.getDate(1));
            System.out.println(rs.getTime(2));
            System.out.println(rs.getTimestamp(3));
            System.out.println("*******************************");
            
            rs.last();
            System.out.println(rs.getDate(1));
            System.out.println(rs.getTime(2));
            System.out.println(rs.getTimestamp(3));
            System.out.println("*******************************");
            
            System.out.println(rs.last());
            System.out.println("*******************************");
            
            System.out.println(rs.isAfterLast());
            System.out.println("*******************************");
            
            System.out.println(rs.isBeforeFirst());
            System.out.println("*******************************");
            
            System.out.println(rs.getRow());
            System.out.println("*******************************");
            
            rs.previous();
            System.out.println(rs.getDate(1));
            System.out.println(rs.getTime(2));
            System.out.println(rs.getTimestamp(3));
            System.out.println("*******************************");
            
            rs.absolute(rs.getRow() - 2);
            System.out.println(rs.getDate(1));
            System.out.println(rs.getTime(2));
            System.out.println(rs.getTimestamp(3));
            System.out.println("*******************************");
            
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                try {
                    if(rs != null) {
                        rs.close();
                        rs = null;
                    }
                    if(stmt != null) {
                        stmt.close();
                        stmt = null;
                    }
                    if(con != null) {
                        con.close();
                        con = null;
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
    }
}
/**//*
+----------+----------+------+-----+---------+-------+
| Field    | Type     | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| date     | date     | YES  |     | NULL    |       |
| time     | time     | YES  |     | NULL    |       |
| datetime | datetime | YES  |     | NULL    |       |
+----------+----------+------+-----+---------+-------+
 */