hibernate 语句转 mybatis
老师们 下面这个方法是hibernate的,我想用mybatis实现mapper因该返回什么类型呀
hibernate
public List<Object[]> insitutionDistributeSearch(String deptId,
String begin, String end, String order) {
// TODO Auto-generated method stub
String procedure = "{Call INSITUTIONDISTRIBUTESEARCH("+deptId+",'"+begin+"','"+end+"',"+order+")}";
return getSession().createSQLQuery(procedure).list();
}
mybatis
public List<Map<String ,Object>> fineHomePir(@Param("deptName")String deptName,@Param("begin")String begin,@Param("end")String end,@Param("type")String type);
mapper
<select id="fineHomePir" resultType="java.util.LinkeHashMap" statementType="CALLABLE">
{Call TUNNELCIRCLESCALE("${deptName}",'${begin}','${end}',"${type}")}
<!-- SELECT SUM(BASIC) BASIC,SUM(INPUTSTRENGTHEN) INPUTSTRENGTH,SUM(OUTPUTSTRENGTHEN) OUTPUTSTRENGTH,SUM(GG) OGAOGAN
FROM DAISY_REPORT_SEGMENTCONSUMPTION_NEW
WHERE TUNNEL_NAME = '${deptName}'
AND RECORD_DATE BETWEEN '${begin}' AND '${end}' -->
</select>