1.Oracle的包头
--【包头】
create or replace package A_package1 is
--在此处输入程序包声明(类型,异常错误,方法等)
type classCursor is ref cursor;
--定义存储过程使用游标
procedure findClassInfoById(v_worktype in varchar2,v_classinfo out classCursor);
end A_package1;
2.Oracle的包体
--【包体】
create or replace package body A_package1 is
procedure findClassInfoById(v_classid in varchar2,v_classinfo out classCursor) as
begin
--根据指定的部门编号查询多个员工信息赋值给输出型变量的游标
open v_classinfo for select * from classinfo where worktype=v_worktype;
end findClassInfoById;
end A_package1;
3.JDBC调用Oracle包的Java代码
package cn.itcast.packages;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.