（我是初学者）使用java获取sql存储过程中out参数的值

sql语句：分页查询

procedure：curpage 当前页数，pagesize 每页条数，total 总条数，totalpage 总页数

DELIMITER $

CREATE PROCEDURE pro_pageSchool(IN curpage INT,IN pagesize INT,OUT total INT,OUT totalpage INT)
BEGIN
SELECT COUNT(*) INTO total FROM t_school;
IF total%pagesize=0 THEN SET totalpage:=total/pagesize;
ELSE SET totalpage:=total/pagesize+1;
END IF;
SELECT * FROM t_school;
END$

 

java：

cs=con.prepareCall("CALL pro_pageSchool(?,?,?,?)");

//设置in参数
cs.setInt(1, curPage);
cs.setInt(2, pageSize);

cs.registerOutParameter(3, Type.INT);
cs.registerOutParameter(4, Type.INT);

//获取out参数的值
total=cs.getInt(3);
totalPage=cs.getInt(4);

//结果集
rs=cs.executeQuery();