6_代理模式下开发各种功能-1_多种参数传递问题

亦凉 2023-09-27 15:02 44阅读 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);
    }

![c3788abddcb6334844f47ff685511f62.gif][]

![a0076693952592152442278c4ea1468d.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>

![47a2d5beeacd879ee3e5cd88ffd27f89.gif][]

![844db6876073e8ec695bb4a9b3e2ddc9.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();
        }
    }

![3d6d70247a3d8715bafc172852028912.gif][]

![c0f448b9c67a671768930764ebbd81e7.gif][]

[c3788abddcb6334844f47ff685511f62.gif]: https://img-blog.csdnimg.cn/img_convert/c3788abddcb6334844f47ff685511f62.gif
[a0076693952592152442278c4ea1468d.gif]: https://img-blog.csdnimg.cn/img_convert/a0076693952592152442278c4ea1468d.gif
[47a2d5beeacd879ee3e5cd88ffd27f89.gif]: https://img-blog.csdnimg.cn/img_convert/47a2d5beeacd879ee3e5cd88ffd27f89.gif
[844db6876073e8ec695bb4a9b3e2ddc9.gif]: https://img-blog.csdnimg.cn/img_convert/844db6876073e8ec695bb4a9b3e2ddc9.gif
[3d6d70247a3d8715bafc172852028912.gif]: https://img-blog.csdnimg.cn/img_convert/3d6d70247a3d8715bafc172852028912.gif
[c0f448b9c67a671768930764ebbd81e7.gif]: https://img-blog.csdnimg.cn/img_convert/c0f448b9c67a671768930764ebbd81e7.gif