mybatis调用存储过程返回多个值

调用存储过程，返回多个参数值：mapper.javapublic String querySourceInfo(Map<String, Object> map);mapper.xml<select id="querySourceInfo" statementType="CAL...

cihongmo6452

703人浏览 · 2015-10-22 18:11:00

cihongmo6452 · 2015-10-22 18:11:00 发布

调用存储过程，返回多个参数值：

mapper.java
public String querySourceInfo(Map<String, Object> map);

mapper.xml
<select id="querySourceInfo" statementType="CALLABLE" >
      {call lookfor_history_main(
       #{tableName, mode=IN},
           #{colName, mode=IN},
           #{oid, mode=IN},
           #{var_result_value, jdbcType=VARCHAR ,mode=OUT},
       #{var_result_value2, jdbcType=VARCHAR ,mode=OUT}
       )}
</select>

service:       返回的参数值在传递进入的map中
mapper.querySourceInfo(map);
Object obj = map.get("var_result_value");
Object obj2 = map.get("var_result_value2");