plsql分页
时间:2022-03-10 17:13
- create or replace procedure sp_pro7(spBookId in number,spbookName in varchar2,sppublishHouse in varchar2) is
- insert into book values(spBookId,spbookName,sppublishHouse);
- //调用一个无返回值的过程
- public class Test2{
- //1.加载驱动
- //2.得到连接
- CallableStatement cs = ct.prepareCall("{call sp_pro7(?,?,?)}");
- cs.setInt(1,10);
- cs.setString(3,"人民出版社");
- cs.execute();
- e.printStackTrace();
- //6.关闭各个打开的资源
- ct.close();
- }
- --有输入和输出的存储过程
- (spno in number, spName out varchar2) is
- select ename into spName from emp where empno=spno;
- import java.sql.*;
- public static void main(String[] args){
- try{
- Class.forName("oracle.jdbc.driver.OracleDriver");
- Connection ct = DriverManager.getConnection("jdbc:oracle:thin@127.0.0.1:1521:MYORA1","scott","m123");
- //3.创建CallableStatement
- //4.给?赋值
- cs.setString(2,"笑傲江湖");
- //创建CallableStatement
- cs.setInt(1,7788);
- cs.registerOutParameter(2,oracle.jdbc.OracleTypes.VARCHAR);
- //5.执行
- //取出返回值,要注意?的顺序
- System.out.println("7788的名字"+name);
- e.printStackTrace();
- //6.关闭各个打开的资源
- ct.close();
- }
- --有输入和输出的存储过程
- (spno in number, spName out varchar2,spSal out number,spJob out varchar2) is
- select ename,sal,job into spName,spSal,spJob from emp where empno=spno;