ORACLE分页

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ScrollTest {

	/**
	 * @param args
	 * @throws SQLException
	 */
	public static void main(String[] args) throws SQLException {
		scroll();
	}

	static void scroll() throws SQLException {
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;

		conn = JdbcUtils.getConnection();
		st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
				ResultSet.CONCUR_READ_ONLY);
		rs = st.executeQuery("SELECT pid,name,birthday,money FROM person");
		rs.absolute(50);
		int i = 0;
		while (rs.next() && i < 10) {
			i++;
			System.out.println(rs.getInt("pid") + "\t" + rs.getString("name")
					+ "\t" + rs.getDate("birthday") + "\t"
					+ rs.getFloat("money"));
		}
		JdbcUtils.free(rs, st, conn);
	}

}