1.环境准备 1.1 服务端 安装数据库 准备数据 # 创建测试表 create table tb1 (id int(10),name varchar(25)); create table tb2 (id int(10),name varchar(25)); # 测试数据 insert into tb1 values (1,"zs"); insert into tb2 values (1,"张三"); # 测试存储 #返回多个cursor类型 create or replace procedure test_two_cursor(rs1 out curosr,rs2 out cursor) begin open rs1 for select * from tb1; open rs2 for select * from tb2; end; #返回不同类型 create or replace procedure test_two_out(rs1 out int(10),rs2 out varchar(25)) begin select id,name into rs1,rs2 from tb1; end; #returning create or replace procedure test_two_return() returning int(10),varchar(10) begin define rs1 int(10)