mapper:
<select id="test" statementType="CALLABLE" resultMap="OneMap,TwoMap,ThreeMap" >
EXEC USP_BQC_MOBILE
</select>
<resultMap type="map" id="OneMap">
</resultMap>
<resultMap type="map" id="TwoMap">
</resultMap>
<resultMap type="map" id="ThreeMap">
</resultMap>
dao:
/**
*
* @return
*/
List<List<?>> test();
controller:
@RequestMapping("list")
@ResponseBody
public BenqResult list(HttpServletRequest request){
List<List<?>> test = dao.test();
return BenqResult.success(test);
}
数据:
{"msg":"success","count":0,"code":0,"data":[
[{"ret_flag":"S","ret_msg":""}],[{"FORM_NAME":"零用金报销单","EMP_NAME":"","ACTIVE":"N","DEPT_CODE":"","FORM_NO":123456,"LOGIN_NAME":"wngk"}],
[{项目=1, 费用类别=null, 摘要=宿舍补助, 币别=RMB, 报销金额=800, 归属部门=EGH59, 归属产品=000 -全线产品, 归属期间=2008/11, 详细说明=宿舍补助}]
]}
dao层和mapper会显示红色,先不用管,直接运行项目访问接口即可,这种有个缺陷,如果存储过程不确定有多少的结果集,这种的只能使用jdbc去调用,方便以后业务扩展