mybatisplus 调用mysql存储过程

存储过程create procedure getUserName(IN userId int,OUT userName varchar(32))beginselect IFNULL(name,'dalao') into userName from user where id=userId;end;Mapper接口@Repositorypublic interface UserMapper exte

大佬腿好粗

2647人浏览 · 2022-04-21 08:59:41

大佬腿好粗 · 2022-04-21 08:59:41 发布

存储过程

create procedure getUserName(IN userId int,OUT userName varchar(32))
begin
	select IFNULL(name,'dalao') into userName from user where id=userId;
end;

Mapper接口

@Repository
public interface UserMapper extends BaseMapper<UserEntity> {

    void getUserName(Map map);

}

mapper配置文件

<select id="getUserName" statementType="CALLABLE">
        CALL getUserName(#{userId,mode=IN,jdbcType=VARCHAR},#{userName,mode=OUT,jdbcType=VARCHAR})
    </select>

调用

 @Test
    public void getUserName(){

        Map<String, String> map = new HashMap<>();
        map.put("userId","1");
        userMapper.getUserName(map);
        System.out.println(map);

    }