三、mybatis使用map作为ParameterType传参多表查询参数

• • • 1.数据库连接配置文件：jdbc.properties
    • 2.mybatis核心配置文件：mybatis-config.xml
    • 3.javabean数据库表类Dept 、Emp
    • 4.main类（map传参实例）MyBatisTest01
    • 4.main类（map传参多表查询实例）MyBatisTest02
    • 5.sql语句 sqlMapper.xml

jdbc.properties

#在类的根路径src下新建jdbc.properties数据库的配置文件，单独配置一个资源文件/属性文件，然后在核心配置文件mybatis-config.xml中引入
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/wkcto
username=root
password=admin123

mybatis-config.xml

Dept

package com.wkcto.mybatis.beans;

public class Dept {
    private String deptno;
    private String dname;
    private String loc;

    public String getDeptno() {
        return deptno;
    }

    public void setDeptno(String deptno) {
        this.deptno = deptno;
    }

    public String getDname() {
        return dname;
    }

    public void setDname(String dname) {
        this.dname = dname;
    }

    public String getLoc() {
        return loc;
    }

    public void setLoc(String loc) {
        this.loc = loc;
    }

    @Override
    public String toString() {
        return "Dept{" +
                "deptno='" + deptno + ''' +
                ", dname='" + dname + ''' +
                ", loc='" + loc + ''' +
                '}';
    }
}

emp

package com.wkcto.mybatis.beans;

public class Emp {
    private String empno;
    private String ename;
    private String job;
    private String mgr;
    private String hiredate;
    private String sal;
    private String comm;
    private String deptno;

    public String getEmpno() {
        return empno;
    }

    public void setEmpno(String empno) {
        this.empno = empno;
    }

    public String getEname() {
        return ename;
    }

    public void setEname(String ename) {
        this.ename = ename;
    }

    public String getJob() {
        return job;
    }

    public void setJob(String job) {
        this.job = job;
    }

    public String getMgr() {
        return mgr;
    }

    public void setMgr(String mgr) {
        this.mgr = mgr;
    }

    public String getHiredate() {
        return hiredate;
    }

    public void setHiredate(String hiredate) {
        this.hiredate = hiredate;
    }

    public String getSal() {
        return sal;
    }

    public void setSal(String sal) {
        this.sal = sal;
    }

    public String getComm() {
        return comm;
    }

    public void setComm(String comm) {
        this.comm = comm;
    }

    public String getDeptno() {
        return deptno;
    }

    public void setDeptno(String deptno) {
        this.deptno = deptno;
    }

    @Override
    public String toString() {
        return "Emp{" +
                "empno='" + empno + ''' +
                ", ename='" + ename + ''' +
                ", job='" + job + ''' +
                ", mgr='" + mgr + ''' +
                ", hiredate='" + hiredate + ''' +
                ", sal='" + sal + ''' +
                ", comm='" + comm + ''' +
                ", deptno='" + deptno + ''' +
                '}';
    }
}

MyBatisTest01

package com.wkcto.mybatis.test;

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 java.util.HashMap;
import java.util.Map;

public class MyBatisTest01 {
    public static void main(String[] args) {
        SqlSession sqlSession = null;
        try {
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
            sqlSession = factory.openSession();
            //insert
            
            Map studentMap = new HashMap<>();
            studentMap.put("xuehao","666");
            studentMap.put("xingming","fafa");
            studentMap.put("shengri","2032-1-1");
            int count = sqlSession.insert("save", studentMap);
            System.out.println(count);
            sqlSession.commit();
        }catch (Exception e){
            if (sqlSession != null){
                sqlSession.rollback();
            }
            e.printStackTrace();
        }finally {
            if (sqlSession!=null){
                sqlSession.close();
            }
        }
    }
}

package com.wkcto.mybatis.test;

import com.wkcto.mybatis.beans.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 java.io.IOException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


public class MyBatisTest02 {
    public static void main(String[] args) {
        SqlSession sqlSession = null;
        try {
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
            sqlSession = factory.openSession();
            
            Map empMap = new HashMap<>();
            empMap.put("dname","SALES");
            empMap.put("job","MANAGER");
            List empList = sqlSession.selectList("mutSel", empMap);
            for (Emp e : empList){
                System.out.println(e.toString());
            }
            sqlSession.commit();
        } catch (IOException e) {
            if (sqlSession!=null){
                sqlSession.rollback();
            }
            e.printStackTrace();
        }finally {
            if (sqlSession!=null){
                sqlSession.close();
            }
        }
    }
}

sqlMapper.xml

    
    
        insert into tbl_student
            (id,name,birth)
        value
            (#{xuehao},#{xingming},#{shengri})
    
    
    
    
        select e.*
        from emp e
        join dept d
        on e.deptno = d.deptno
        where d.dname = #{dname}  and e.job=#{job}