java调用分页存储过程

package com.jlwang.db;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class FenYe {

	/**
	 * @param args
	 */
	public static void main(String[] args) 
	{
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");

			Connection connection = DriverManager.getConnection(
					"jdbc:oracle:thin:@localhost:1521:ORCL", "*****",
					"******");

			if (null == connection) {
				return;
			}

				CallableStatement cs = connection
						.prepareCall("{call FENYE(?,?,?,?,?,?)}");

				cs.setString(1, "emp");
				cs.setInt(2, 3);
				
				//显示的当前
				cs.setInt(3, 1);
				
				cs.registerOutParameter(4, oracle.jdbc.OracleTypes.INTEGER);
				cs.registerOutParameter(5, oracle.jdbc.OracleTypes.INTEGER);
				cs.registerOutParameter(6, oracle.jdbc.OracleTypes.CURSOR);
				
				cs.execute();
				
				System.out.println(cs.getInt(4));
				System.out.println(cs.getInt(5));
				
				ResultSet rSet = (ResultSet)cs.getObject(6);
				
				while (rSet.next()) 
				{
					
					System.out.println(rSet.getString("ename")+":"+rSet.getFloat("sal"));
					
				}
//				String nameString = cs.getString(2);
//				float salFloat = cs.getFloat(3);
//				String jobString = cs.getString(4);
//				
//				System.out.println("name is :"+nameString+"，薪水："+salFloat+",职位："+jobString);

				


		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally
		{
		}

	}

}