Controller
Map mapSCB = smsService.findBus(detail);
RecordVo recordVo = new RecordVo();
if (mapSCB != null) {
try {
recordVo.setbId((int) mapSCB.get("bID"));
recordVo.setcId((int) mapSCB.get("cID"));
recordVo.setsId((int) mapSCB.get("sID"));
} catch (Exception e) {
logger.error("业务表中sId,cId,bID,转化到order表,Object转Integer:", e);
}
service
public Map findBus(String detail){
Map map=inserRecordMapper.findBus(detail);
return map;
}
xml写法
<select id="findBus" parameterType="String" resultType="map">
SELECT b.ID as bID,b.SP_ID as sID,b.CP_ID as cID FROM business_info b where b.CP_CODE=#{detail};
</select>