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
{
}
}
}
java调用分页存储过程
最新推荐文章于 2021-02-25 13:03:39 发布