mybatis调存储过程时返回值null
就简单的一个存储过程
BEGIN
#SELECT COUNT(*) scount FROM test_user t WHERE t.user_sex=sex;
SELECT user_name userName FROM test_user t WHERE t.user_sex=sex;
END
然后在Mybatis Mapper配置文件中
<!--存储过程 输入参数用Map -->
<select id="queryCountBySexWithProcedure" statementType="CALLABLE" parameterType="java.util.Map" resultType="java.util.HashMap">
{
CALL queryCountBySexWithProcedure(
#{sex,jdbcType=VARCHAR,mode=IN},
#{userName,jdbcType=VARCHAR,mode=OUT}
)
}
</select>
然后userName值null,这是为什么呢?在mapper.xml文件会做映射处理,而在存储过程中下方标红的属性 user_name并不会自动映射到userName 值中,所以调用userName值一定返回null。
BEGIN
#SELECT COUNT(*) scount FROM test_user t WHERE t.user_sex=sex;
SELECT user_name userName FROM test_user t WHERE t.user_sex=sex;
END
那怎么处理这样问题呢?那就是加上INTO 关键字
BEGIN
#SELECT COUNT(*) scount FROM test_user t WHERE t.user_sex=sex;
SELECT user_name INTO userName FROM test_user t WHERE t.user_sex=sex;
END