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

﹏ヽ暗。殇╰゛Y 2023-09-30 18:02 1阅读 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);  
\}

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>

测试 代码

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();  
\}  
\}