Java--SpringBoot-41-Mybatis-9-调用存储过程

dropPROCEDUREinsert_user;
CREATEPROCEDUREinsert_user(INidINTEGER,INuserNameVARCHAR(20),INpassWordVARCHAR(20),INrealNameVARCHAR(20))
BEGININSERTINTOuser (id,userName,passWord,realName) VALUES (id,userName,passWord,realName);
SETid=LAST_INSERT_ID();
END#调用下确认没问题callinsert_user(100,"存储过程","密码","存过");

packagecom.xing.mapper;
importcom.xing.entity.UserEntity;
importorg.apache.ibatis.annotations.*;
importorg.springframework.stereotype.Repository;
importjava.util.List;
/*** 面向接口*/@RepositorypublicinterfaceUserMapper {
/*** 存储过程 插入用户* @param user user*/voidinsertUserCG(UserEntityuser);
}

<?xmlversion="1.0"encoding="UTF-8"?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.xing.mapper.UserMapper"><resultMapid="BaseResultMap"type="com.xing.entity.UserEntity"autoMapping="false"><resultcolumn="id"jdbcType="INTEGER"property="id"/><resultcolumn="userName"jdbcType="VARCHAR"property="userName"/><resultcolumn="passWord"jdbcType="VARCHAR"property="passWord"/><resultcolumn="realName"jdbcType="VARCHAR"property="realName"/></resultMap><selectid="getOne"resultType="com.xing.entity.UserEntity">select*fromuserwhereid=#{id}
</select><insertid="insertUserCG"parameterType="com.xing.entity.UserEntity"statementType="CALLABLE">        {
callinsert_user(
#{id,mode=IN,jdbcType=INTEGER},#{userName,mode=IN},#{passWord,mode=IN},#{realName,mode=IN}
            )
        }
</insert></mapper>

/*** 新增* @param user user* @return ok*/@PostMapping("/insertCG")
publicStringinsertUserCG(@RequestBodyUserEntityuser){ 
‍userMapper.insertUserCD(user);‍‍return"ok";
}

/***  试试select标签* @param user*/voidinsertUserCD2(UserEntityuser);

<selectid="insertUserCD2"parameterType="com.xing.entity.UserEntity"statementType="CALLABLE">   {
callinsert_user(
#{id,mode=IN,jdbcType=INTEGER},#{userName,mode=IN},#{passWord,mode=IN},#{realName,mode=IN}
      )
   }
</select>