4_MyBatis传统DAO模式开发-2_sqlSession传递参数的三种方式

电玩女神 2023-09-27 13:17 99阅读 0赞

1 单个基础数据类型作为参数

2 多个基础数据类型的map 集合作为参数

3 引用类型作为参数

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="EmpMapper2">
 *  
 *  <select id="findByEmpno" resultType="emp" parameterType="int">
 *  select \* from emp where empno = \#\{empno\}
 *  </select>
 *  
 *  
 *  <select id="findEmpByDeptnoAndSal" resultType="emp" parameterType="map">
 *  select \* from emp where deptno = \#\{deptno\} and sal >= \#\{sal\}
 *  </select>
 *  
 *  
 *  
 *  <select id="findEmpByDeptnoAndSal2" resultType="emp" parameterType="emp">
 *  select \* from emp where deptno = \#\{deptno\} and sal >= \#\{sal\}
 *  </select>
 *  </mapper>
 *

测试代码

*  package com.msb.test;
 *  
 *  import com.msb.pojo.Emp;
 *  import org.apache.ibatis.io.Resources;
 *  import org.apache.ibatis.session.SqlSession;
 *  import org.apache.ibatis.session.SqlSessionFactory;
 *  import org.apache.ibatis.session.SqlSessionFactoryBuilder;
 *  import org.junit.After;
 *  import org.junit.Before;
 *  import org.junit.Test;
 *  
 *  import java.io.IOException;
 *  import java.io.InputStream;
 *  import java.util.HashMap;
 *  import java.util.List;
 *  import java.util.Map;
 *  import java.util.Set;
 *  
 *  /\*\*
 *  \* @Author: Ma HaiYang
 *  \* @Description: MircoMessage:Mark\_7001
 *  \*/
 *  public class Test3 \{
 *  
 *  private SqlSession sqlSession;
 *  @Before
 *  public void init()\{
 *  SqlSessionFactoryBuilder ssfb =new SqlSessionFactoryBuilder();
 *  InputStream resourceAsStream = null;
 *  try \{
 *  resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
 *  \} catch (IOException e) \{
 *  e.printStackTrace();
 *  \}
 *  SqlSessionFactory factory=ssfb.build(resourceAsStream) ;
 *  sqlSession=factory.openSession();
 *  \}
 *  
 *  @Test
 *  public void testSingleArg()\{
 *  // 测试单个基本数据类型作为参数
 *  Emp emp = sqlSession.selectOne("findByEmpno", 7499);
 *  System.out.println(emp);
 *  \}
 *  
 *  @Test
 *  public void testMapArg()\{
 *  // 测试Map集合作为参数
 *  Map<String,Object> args=new HashMap<>();
 *  args.put("deptno", 20);
 *  args.put("sal", 3000.0);
 *  List<Emp> emps = sqlSession.selectList("findEmpByDeptnoAndSal", args);
 *  emps.forEach(System.out::println);
 *  \}
 *  
 *  @Test
 *  public void testEmpArg()\{
 *  // 测试Map集合作为参数
 *  Emp arg =new Emp();
 *  arg.setDeptno(10);
 *  arg.setSal(2000.0);
 *  List<Emp> emps = sqlSession.selectList("findEmpByDeptnoAndSal2", arg);
 *  emps.forEach(System.out::println);
 *  \}
 *  
 *  
 *  @After
 *  public void release()\{
 *  // 关闭SQLSession
 *  sqlSession.close();
 *  \}
 *  
 *  \}