myBatis 3 与 2 的调用方式区别 较大
drop PROCEDURE if EXISTS chartIndexs;
CREATE PROCEDURE chartIndexs(in beginTime timestamp, in intervalTime INTEGER, in showCount INTEGER)。。。。。。
xml配置:
<select id="procXXX" statementType="CALLABLE" resultType="java.lang.String" parameterType="com.Query">
{call proc_lsvs_chart_Indexs(
#{addr, jdbcType=VARCHAR, mode=IN},
#{storageTimeStart, jdbcType=TIMESTAMP, mode=IN},
#{intervalTime, jdbcType=INTEGER, mode=IN},
#{showCount, jdbcType=INTEGER, mode=IN},
#{indexStrs, jdbcType=VARCHAR, mode=OUT}
)}
</select>
java调用:
dao.procXXX(query);
System.out.println("返回值:"+query.indexStrs);