实现MyBatis批量查询

Service

        public List<DeviceBean> getDeviceList(Map<String, Object> parameter);

ServiceImpl

	@Override
	public Map<String, DeviceBean> getDeviceCollectStateIdByBean(Map<String, Object> parameter) {
		logger.info("DeviceServiceImpl{}==>getDeviceCollectStateIdByBean()");
		return deviceDao.getDeviceCollectStateIdByBean(parameter);
	}

Dao

        public List<DeviceBean> getDeviceList(Map<String, Object> parameter);

DaoImpl

	@Override
	public List<DeviceBean> getDeviceList(Map<String, Object> parameter) {
		logger.info("DeviceDaoImpl{}==>getDeviceList()");
		return getWriteSession().selectList(sqlId("getDeviceList"),parameter);
	}

Mapper


	<select id="getDeviceList"   resultType="com.yjkj.zzx.system.bean.DeviceBean" parameterType="map" >
		select 
			d.id as id, d.group_id as groupId,d.farm_id as farmId, d.house_id as houseId, d.code
		from t_device d
		 WHERE  d.del_flag = '0' and d.code in 
		    <foreach item="item" index="index" collection="codelist" open="(" separator="," close=")">  
		      #{item}  
		    </foreach>
	</select>

测试打印结果

    List<String> codeList =new ArrayList<String>();
    codeList.add("b827ebee9322");
    codeList.add("111");
    codeList.add("1111");
    Map<String,Object> paramap=new HashMap<String,Object>();
    paramap.put("codelist", codeList);
    List<DeviceBean> res11 = deviceService.getDeviceList(paramap);
    System.out.println(res11);





  • 0
    点赞
  • 10
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值