spring mybatis 调用存储过程

来源:互联网 发布:成交量指标公式源码 编辑:程序博客网 时间:2024/05/21 22:35

~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> 

原创粉丝点击