PLSQL数据库Mybatis学习Day02

https://www.yuque.com/docs/share/fe42dbdb-7d33-4ea9-9021-48bfcb67411b?# 《数据库》

目录

3.3.6、接口绑定方案

3.3.6.1、实现方式

3.3.6.2、测试有参查询

3.3.6.3、测试接口下实现CRUD

3.3.6.4、测试接口下实现动态Sql

3.3.6.5、单表查询时字段名与属性名不一致

3.3.6.6、多表查询时字段名与属性名不一致(一对一|多对一)

3.3.6.7、多表查询时字段名与属性名不一致(一对多)

3.3.6.8、接口注解开发

---

3.3.6、接口绑定方案

以下实现接口时默认已经以javabean规范创建了与表对应的实体类

接口的命名与映射文件一致 （表名Mapper.java | 表名Mapper.xml)

实体类命名与对应表名一致 （表名.java)

Dept类

public class Dept {
    private int id;
    private String name;
    private String loc;

    public Dept() {
    }

    public Dept(int id, String name, String loc) {
        this.id = id;
        this.name = name;
        this.loc = loc;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getLoc() {
        return loc;
    }

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

    @Override
    public String toString() {
        return "Dept{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", loc='" + loc + '\'' +
                '}';
    }
}

Emp类

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

    //属性: javabean : 员工对象所在的部门信息
    private Dept pddDept;

    public Emp() {
    }

    public Emp(int empno, String ename, double sal, String job, double comm, int mgr, Date hiredate, int deptno) {
        this.empno = empno;
        this.ename = ename;
        this.sal = sal;
        this.job = job;
        this.comm = comm;
        this.mgr = mgr;
        this.hiredate = hiredate;
        this.deptno = deptno;
    }

    public Dept getPddDept() {
        return pddDept;
    }

    public void setPddDept(Dept pddDept) {
        this.pddDept = pddDept;
    }
    public int getEmpno() {
        return empno;
    }

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

    public String getEname() {
        return ename;
    }

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

    public double getSal() {
        return sal;
    }

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

    public String getJob() {
        return job;
    }

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

    public double getComm() {
        return comm;
    }

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

    public int getMgr() {
        return mgr;
    }

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

    public Date getHiredate() {
        return hiredate;
    }

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

    public int getDeptno() {
        return deptno;
    }

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

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

3.3.6.1、实现方式

1）同名接口

/*
    接口绑定方案下的接口 :
 */
public interface DeptMapper {
    // 查询所有的部门信息
    public List queryAll();
}

2)同名sql映射文件

    
    
        select * from dept
    

3）mybatis添加项

4）接口测试类