ssm调用mysql存储过程

DELIMITER //

CREATE PROCEDURE GetUserById(IN userId INT, OUT userName VARCHAR(255))
BEGIN
    SELECT name INTO userName FROM users WHERE id = userId;
END //

DELIMITER ;

<mapper namespace="com.example.mapper.UserMapper">
    <select id="getUserById" statementType="CALLABLE">
        {call GetUserById(#{userId, mode=IN, jdbcType=INTEGER}, #{userName, mode=OUT, jdbcType=VARCHAR})}
    </select>
</mapper>

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class Main {
    public static void main(String[] args) {
        // 假设已经通过某种方式获取了SqlSessionFactory实例
        SqlSessionFactory sqlSessionFactory = ...;

        try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
            UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
            Map<String, Object> params = new HashMap<>();
            params.put("userId", 1);

            userMapper.getUserById(params);

            String userName = (String) params.get("userName");
            System.out.println("User Name: " + userName);
        }
    }
}

GRANT EXECUTE ON PROCEDURE GetUserById TO 'your_user'@'your_host';