天天看點

mybatis調用oracle過程,MyBatis調用Oracle的存儲過程

Mapper.xml檔案:

---------------------------------

{call rm.pg_hn_rm_for_ank.getUserInfo(?, ?, ?, ?)}

Mapper.java

------------------

Map getClassificationOfUser(Map map);

Service.java

--------------------------------

public void initReportData(ReportExample reportExample, LoginInfoBean loginInfoBean) {

if (reportExample.getReportId() != null && reportExample.getReportId().intValue() == 10026) {

Map map = new HashMap();

map.put("in_query_value", reportExample.getAccessNumber());

map.put("in_query_type", new Integer(1));

map.put("out_code", null);

map.put("out_msg", null);

Map retVal = reportMapper.getClassificationOfUser(map);

logger.debug(retVal);

}

}