JDBC调用oracle分页存储过程（2）

jdbc调用代码：引入oracle jar包，junit包

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import oracle.jdbc.OracleTypes;
import org.junit.Test;

public class Test1 {

	@Test
	public void test1() throws SQLException {
		Connection conn = null;
		ResultSet rs = null;
		CallableStatement cstmt = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection(
					"jdbc:oracle:thin:@localhost:1521:TEST", "test",
					"test");
			cstmt = conn.prepareCall("{call page.p_pagintion(?,?,?,?,?,?)}");
			cstmt.setString(1, "select t.* from t_user t");
			cstmt.setInt(2, 3);
			cstmt.setInt(3, 1);
			cstmt.registerOutParameter(4, OracleTypes.NUMBER);
			cstmt.registerOutParameter(5, OracleTypes.NUMBER);
			cstmt.registerOutParameter(6, OracleTypes.CURSOR);
			cstmt.executeQuery();
			System.out.println("共" + cstmt.getObject(4) + "页");
			System.out.println("共" + cstmt.getObject(5) + "条");
			rs = (ResultSet) cstmt.getObject(6);
			while (rs.next()) {
				System.out.println(rs.getString("id") + " -- "
						+ rs.getString("name") + " -- " + rs.getString("age"));
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			rs.close();
			cstmt.close();
			conn.close();
		}
	}
}