mybatis多种参数类型的五种解决方案

落日映苍穹つ 2023-07-08 02:43 9阅读 0赞

项目架构  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70]  
案例代码  
StudentDao

public interface StudentDao
    {
     //  多条件查询学生
        Student  selectOne2( Integer id,  String name);
    }

StudentDao.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.stone.mybatis.mapper.StudentDao">
    
    	
    	<select id="selectOne2" resultType="com.stone.mybatis.model.Student">
    		select * from student where id>#{id} and  name=#{name}
    	</select>
    </mapper>

测试

public class StudentTest
    {
    
        StudentDao mapper = null;
        Reader reader = null;
        SqlSessionFactory sessionFactory = null;
    
        //  在每一次单元测试之前执行 （得到操作数据库对象）
        @Before
        public void bef() throws IOException
        {
            //  1.  加载mybatis配置文件
            String resource = "mybatis-config.xml";
            reader = Resources.getResourceAsReader(resource);
            //  2.获取sqlsessionfactory
            sessionFactory = new SqlSessionFactoryBuilder().build(reader);
    
        }
    
        //    在每一次测试方法执行之后 （关闭操作数据库需要释放的资源）
        @After
        public void aft()
        {
            if (reader != null)
            {
                try
                {
                    reader.close();
                }
                catch (IOException e)
                {
                    e.printStackTrace();
                }
            }
    
    
        }
      //    多条件查询
        @Test
        public void test6()
        {
            SqlSession sqlSession = sessionFactory.openSession();
            mapper = sqlSession.getMapper(StudentDao.class);
            Student student = mapper.selectOne2(2, "xw");
            System.out.println(student);
        }
    
    }

运行结果  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 1]

**解决方案**  
根据错误提示，mybatis在多参数匹配时找不到参数，并且提示可用参数为\[arg1, arg0, param1, param2\]

解决方案一 ：将mapper中的参数替换为arg0 ，arg1…  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 2]

解决方案二： 将mapper中的参数替换为param1，param2…  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 3]

方案三：使用@Param注解指定传入参数  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 4]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 5]

方案四：利用pojo封装对象，传入参数为pojo属性名  
pojo

package com.stone.mybatis.model;
    
    
    public class Student
    {
        private Integer id; //  学生学号
        private String name; //  学生姓名
        private Integer age; //  学生年龄
        private String  sex; //  学生性别
    
        public Student()
        {
        }
    
        public Student(Integer id, String name, Integer age, String sex)
        {
            this.id = id;
            this.name = name;
            this.age = age;
            this.sex = sex;
        }
    
        public Integer getId()
        {
            return id;
        }
    
        public void setId(Integer id)
        {
            this.id = id;
        }
    
        public String getName()
        {
            return name;
        }
    
        public void setName(String name)
        {
            this.name = name;
        }
    
        public Integer getAge()
        {
            return age;
        }
    
        public void setAge(Integer age)
        {
            this.age = age;
        }
    
        public String getSex()
        {
            return sex;
        }
    
        public void setSex(String sex)
        {
            this.sex = sex;
        }
    
        @Override
        public String toString()
        {
            return "Student{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    ", age=" + age +
                    ", sex='" + sex + '\'' +
                    '}';
        }
    }

mapper接口  
![在这里插入图片描述][20200224180026548.png]  
mapper xml  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 6]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 7]

方案五：传入map集合，添加map的key就是参数名  
mapper接口![在这里插入图片描述][20200224180610468.png]  
mapper xml  
![在这里插入图片描述][20200224180701604.png]  
测试代码  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 8]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200224173925403.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/2020022417422039.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200224174556778.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200224174704990.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200224174833528.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200224174943218.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx,size_16,color_FFFFFF,t_70
[20200224180026548.png]: https://img-blog.csdnimg.cn/20200224180026548.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20200224180136339.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20200224180227387.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx,size_16,color_FFFFFF,t_70
[20200224180610468.png]: https://img-blog.csdnimg.cn/20200224180610468.png
[20200224180701604.png]: https://img-blog.csdnimg.cn/20200224180701604.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20200224180829884.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODkyMDkx,size_16,color_FFFFFF,t_70