Mybatis调用存储过程

1：实体类为USER

public class User {     
	private Integer id;
	private String name;
	private String sex;
	private Integer age;
	}

2:在mysql数据库中建t_user表

CREATE TABLE `t_user` (
   `id` int(10) NOT NULL,
   `name` varchar(50) NOT NULL,
   `sex` varchar(6) NOT NULL,
   `age` int(10) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8

3：无参数的存储过程，求记录总条数（没有out参数），要加DELIMITER

DROP PROCEDURE IF EXISTS pGetTotal;
DELIMITER//
CREATE PROCEDURE pGetTotal()
BEGIN
    SELECT COUNT(id) FROM t_user;
END;
//

3-1：java代码调用存储过程

//求总数，方法有返回值
@Test
public void getTotal(){
    Integer total = userServiceImple.getTotal();
    System.out.println