数据库
CREATE OR REPLACE PACKAGE MyTest AS
Type T_CURSOR IS REF CURSOR;
PROCEDURE zhbtest(v_employeeno in varchar2 ,Re_CURSOR OUT T_CURSOR);
END MyTest;CREATE OR REPLACE PACKAGE BODY MyTest
IS
PROCEDURE zhbtest(v_employeeno in varchar2,Re_CURSOR OUT T_CURSOR)
IS
BEGIN
open V_CURSOR for select * from OA_COMM_MAIN;
END;
END;
java程序
public class Protest {
private static Connection conn = null;
private static oracle.jdbc.OracleCallableStatement call = null;
private static ResultSet rs = null;
private static String url = "jdbc:oracle:thin:@192.168.100.145:1521:kdc";
private static String name = "liuyi";
private static int cout = 0; public static void main(String[] args){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url,"kdcerp2","123");
call = (oracle.jdbc.OracleCallableStatement)conn.prepareCall("{call mytest.zhbtest(?,?)}");
call.setString(1, "4050608006");
call.registerOutParameter(2,oracle.jdbc.OracleTypes.CURSOR);
call.execute();
rs = call.getCursor(2);
while(rs.next()){
System.out.println(rs.getString(1));
cout++;
}
System.out.println(cout);
}catch(java.lang.ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e){
System.out.println(e.toString());
}
}
}
CREATE OR REPLACE PACKAGE MyTest AS
Type T_CURSOR IS REF CURSOR;
PROCEDURE zhbtest(v_employeeno in varchar2 ,Re_CURSOR OUT T_CURSOR);
END MyTest;CREATE OR REPLACE PACKAGE BODY MyTest
IS
PROCEDURE zhbtest(v_employeeno in varchar2,Re_CURSOR OUT T_CURSOR)
IS
BEGIN
open V_CURSOR for select * from OA_COMM_MAIN;
END;
END;
java程序
public class Protest {
private static Connection conn = null;
private static oracle.jdbc.OracleCallableStatement call = null;
private static ResultSet rs = null;
private static String url = "jdbc:oracle:thin:@192.168.100.145:1521:kdc";
private static String name = "liuyi";
private static int cout = 0; public static void main(String[] args){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url,"kdcerp2","123");
call = (oracle.jdbc.OracleCallableStatement)conn.prepareCall("{call mytest.zhbtest(?,?)}");
call.setString(1, "4050608006");
call.registerOutParameter(2,oracle.jdbc.OracleTypes.CURSOR);
call.execute();
rs = call.getCursor(2);
while(rs.next()){
System.out.println(rs.getString(1));
cout++;
}
System.out.println(cout);
}catch(java.lang.ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e){
System.out.println(e.toString());
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货