java中的代码 try{ CallableStatement pc = conn.prepareCall("{call user_pro(?,?,?)}"); pc.registerOutParameter(1, Types.INTEGER); pc.setInt(2, 2); pc.setInt(3, 4); pc.execute(); System.out.println(pc.getInt(1)); ResultSet rs = pc.getResultSet(); while(rs.next()) { System.out.print(rs.getInt(1)+"-"); System.out.print(rs.getString(2)+"-"); System.out.println(rs.getString(3)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } 存储过程 DELIMITER $ CREATE DEFINER=`root`@`localhost` PROCEDURE `user_pro`(out num int,in b_num int,in s_num int) BEGIN select count(*) into num from user_t; select * from user_t limit b_num,s_num; END