1_多种参数传递问题

Myth丶恋晨 2023-09-27 15:51 114阅读 0赞

1单个基本数据类型

2多个基本数据类型

3单个引用数据类型

4map集合数据类型

5多个引用数据类型

接口

package com.msb.mapper;
    import com.msb.pojo.Emp;
    import org.apache.ibatis.annotations.Param;
    import java.util.List;
    import java.util.Map;
    /**
     * @Author: Ma HaiYang
     * @Description: MircoMessage:Mark_7001
     */
    public interface EmpMapper {
        /**
         * 该方法用于查询全部的员工信息
         * @return 全部员工信息封装的Emp对象的List集合
         */
        List<Emp> findAll();
        /**
         * 根据员工编号查询单个员工信息的方法
         * @param empno 员工编号
         * @return 如果找到了返回Emp对象,找不到返回null
         */
        Emp findByEmpno(int empno);
        /**
         * 根据员工编号和薪资下限去查询员工信息
         * @param empno 员工编号
         * @param sal 薪资下限
         * @return 多个Emp对象的List集合
         */
        List<Emp> findByDeptnoAndSal(@Param("deptno") int deptno,@Param("sal") double sal);
        List<Emp> findByDeptnoAndSal2(Map<String,Object> map);
        List<Emp> findByDeptnoAndSal3(Emp emp);
        List<Emp> findByDeptnoAndSal4(@Param("empa") Emp empa,@Param("empb") Emp empb);
    }

![da8659a2de69e6578e555d7e0f30a309.gif][]

![3fd1bcb68fcd06d11b633c69f0bba3f4.gif][]

mapper映射文件

<?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.msb.mapper.EmpMapper">
        
        
        <select id="findAll" resultType="emp" >
            select * from emp
        </select>
        
        <select id="findByEmpno" resultType="emp" >
            select * from emp where empno =#{empno}
        </select>
        
        <select id="findByDeptnoAndSal" resultType="emp">
            
            
            
        </select>
        
        <select id="findByDeptnoAndSal2" resultType="emp" parameterType="map" >
            
            
             select * from emp where deptno =#{deptno} and sal >= #{sal}
        </select>
        
        <select id="findByDeptnoAndSal3" resultType="emp" parameterType="emp" >
            select * from emp where deptno =#{deptno} and sal >= #{sal}
        </select>
        
        <select id="findByDeptnoAndSal4" resultType="emp"  >
            
             select * from emp where deptno =#{param1.deptno} and sal >= #{param2.sal}
             
        </select>
    </mapper>

![cf5921bda75390ee159c686b575eaa61.gif][]

![a1a23363698d31b0cbf87d2293882a31.gif][]

测试 代码

package com.msb.testDemo;
    import com.msb.mapper.EmpMapper;
    import com.msb.pojo.Emp;
    import com.msb.util.SqlSessionUtil;
    import org.apache.ibatis.session.SqlSession;
    import java.util.List;
    public class Test1 {
        public static void main(String[] args) {
            SqlSession sqlSession = SqlSessionUtil.getSqlSession(true);
            /*
            * 帮助我们生成一个接口下的实现类对象的
            *
            * */
            EmpMapper mapper = sqlSession.getMapper(EmpMapper.class);
            List<Emp> emps = mapper.getAllEmp();
            for(Emp emp:emps) {
                System.out.println(emp);
            }
            // 1单个基本数据类型作为方法参数
            Emp emp = mapper.getByEmpno(7902);
            System.out.println(emp);
            // 2多个基本数据类型作为方法参数
            List<Emp> emps2 = mapper.getByDeptnoAndSal(10, 1500);
            for(Emp em:emps2) {
                System.out.println(em);
            }
            // 3单个引用类型作为方法参数
            Emp condition=new Emp();
            condition.setDeptno(10);
            condition.setSal(1500.0);
            List<Emp> emps3 = mapper.getByDeptnoAndSal2(condition);
            for(Emp em:emps3) {
                System.out.println(em);
            }
            // 4多个引用类型作为方法参数
            Emp condition1=new Emp();
            condition1.setDeptno(10);
            Emp condition2=new Emp();
            condition2.setSal(1500.0);
            List<Emp> emps4 = mapper.getByDeptnoAndSal3(condition1,condition2);
            for(Emp em:emps4) {
                System.out.println(em);
            }
            sqlSession.close();
        }
    }

![210115a95db9f733317374154294fd5b.gif][]

![4e19b4206113922b9ac11e16356a5c29.gif][]

[da8659a2de69e6578e555d7e0f30a309.gif]: https://img-blog.csdnimg.cn/img_convert/da8659a2de69e6578e555d7e0f30a309.gif
[3fd1bcb68fcd06d11b633c69f0bba3f4.gif]: https://img-blog.csdnimg.cn/img_convert/3fd1bcb68fcd06d11b633c69f0bba3f4.gif
[cf5921bda75390ee159c686b575eaa61.gif]: https://img-blog.csdnimg.cn/img_convert/cf5921bda75390ee159c686b575eaa61.gif
[a1a23363698d31b0cbf87d2293882a31.gif]: https://img-blog.csdnimg.cn/img_convert/a1a23363698d31b0cbf87d2293882a31.gif
[210115a95db9f733317374154294fd5b.gif]: https://img-blog.csdnimg.cn/img_convert/210115a95db9f733317374154294fd5b.gif
[4e19b4206113922b9ac11e16356a5c29.gif]: https://img-blog.csdnimg.cn/img_convert/4e19b4206113922b9ac11e16356a5c29.gif