mybatis 接口传多参数的三种方式

kingforce

第一种方式:直接多参数

@Delete("delete from ABROAD_AGENT_BILL where CHANNEL_ID=#{channelID} and ABROAD_AGENT_ID=#{abroadAgent} and BUSINESSTYPE=#{businessType} and day between to_date(#{startTime},'yyyy-mm-dd hh24:mi:ss') and to_date(#{endTime},'yyyy-mm-dd hh24:mi:ss')")
public void deleteData(@Param("channelID") String channelID, @Param("abroadAgent") String abroadAgent,
@Param("businessType") String businessType, @Param("startTime") String startTime,
@Param("endTime") String endTime);

第二种方式:多参数封装成对象

@Insert("insert into BANDWIDTH_PRELOAD(CHANNEL_ID,DAY,TIME_NUM,COUNT,FILESIZE) values(#{channelID},to_date(#{day},'yyyy-mm-dd'),#{timeNum},#{count},#{fileSize})")
public void addData(PreloadData data);

第三种方式:多参数封装成map

public List<PreloadData> getDatas(Map<String, Object> params);
Map<String, Object> params = new HashMap<String, Object>();
params.put("day", day);
preloadMapper.deleteData(params);