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

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>