spring mybatis 调用存储过程

xiaoxiao2021-02-27  238

~controler层:

在xxx方法里:

 HashMap<String, Object> map = new HashMap<String, Object>();  map.put("argHotelGroupId", hotelGroupId);  map.put("argHotelId", hotelId);  map.put("argHotelCode", hotelCode);      systemService.upRoom(map);

~service层:

@Transactional(readOnly = false) public void upRoom(HashMap<String, Object> map){ userDao.upImportRoom(map); }

~Dao层:

public void upImportRoom(HashMap<String, Object> map);

~mapper.xml:

<select id="upImportRoom" parameterMap="upRoomMap" statementType="CALLABLE"> {call migrate_db.up_import_room_no_wyn_setup_pms(               ?,?,?       ) }  </select>      <parameterMap type="java.util.Map" id="upRoomMap">         <parameter property="argHotelGroupId" mode="IN" jdbcType="INTEGER"/>         <parameter property="argHotelId" mode="IN" jdbcType="INTEGER"/>       <parameter property="argHotelCode" mode="IN" jdbcType="VARCHAR"/>           </parameterMap> 

转载请注明原文地址: https://www.6miu.com/read-8955.html

最新回复(0)