MyBatis传入多个参数，通过多个变量接收多个参数(Springboot+mybatis Plus+mysql)

最新推荐文章于 2025-10-24 09:25:36 发布

原创最新推荐文章于 2025-10-24 09:25:36 发布 · 4.6k 阅读

1 ·

CC 4.0 BY-SA版权

springboot 同时被 3 个专栏收录

17 篇文章

订阅专栏

java开发

13 篇文章

订阅专栏

idea

10 篇文章

订阅专栏

本文详细介绍了在MyBatis框架中如何实现多参数的传递与接收，通过具体实例展示了service层、serviceImpl层、Dao层及XML配置文件的编写方法，为开发者提供了实用的代码示例。

MyBatis传入多个参数，通过多个变量接收多个参数
1.目录结构如图
在这里插入图片描述
2.service层的编写

public interface NiotCollectorService extends IService<NiotCollectorEntity> {
    NiotCollectorEntity findByCollectorNumAndItemType(String collectorNum, String itemType);
}

serviceImpl

@Service
public class NiotCollectorServiceimpl extends ServiceImpl<NiotCollectorDao, NiotCollectorEntity> implements NiotCollectorService {

    @Autowired
    private NiotCollectorDao niotCollectorDao;

    @Override
    public NiotCollectorEntity findByCollectorNumAndItemType(String collectorNum, String itemType) {
       NiotCollectorEntity collectorEntity = niotCollectorDao.findByCollectorNumAndItemType(collectorNum,itemType);
        return collectorEntity;
    }
}

3.Dao层的编写

@Mapper
public interface NiotCollectorDao extends BaseMapper<NiotCollectorEntity> {
    NiotCollectorEntity findByCollectorNumAndItemType(String collectorNum, String itemType);
}

4.XML文件的编写

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.northmeter.app.niotcollector.dao.NiotCollectorDao">
	<select id="findByCollectorNumAndItemType" parameterType="String"
			resultType="com.northmeter.app.niotcollector.entity.NiotCollectorEntity">
		select * from niot_collector where collector_num = #{arg0} and item_type = #{arg1}
	</select>
</mapper>