Mybatis的课程总结

 1.mybatis

Mybatis主要是对代码进行少写，分别加入核心配置文件和mapper映射文件，

核心配置文件主要是为了连接数据库，mapper映射文件是为了编写sql语句

 1.如何配置mybatis

①先创建一个moudle

 ②然后配置jar包

 ③然后进行mybatis的分层

 bean包：主要是进行一些实体类

dao包：主要是进行构建接口和编写sql语句

test包：主要是进行sql语句的测试

 ④在bean包中创建实体类

Emp：

public class Emp {
    private Integer eid;
    private String ename;
    private String job;
    private double sal;
    private String phone;
    private String address;
    //一对一关系的定义:把外键的did 定义为相关联的 对象
    private Dept dept;

    public Integer getEid() {
        return eid;
    }

    public void setEid(Integer eid) {
        this.eid = eid;
    }

    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 double getSal() {
        return sal;
    }

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

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public Dept getDept() {
        return dept;
    }

    public void setDept(Dept dept) {
        this.dept = dept;
    }

    @Override
    public String toString() {
        return "Emp{" +
                "eid=" + eid +
                ", ename='" + ename + '\'' +
                ", job='" + job + '\'' +
                ", sal=" + sal +
                ", phone='" + phone + '\'' +
                ", address='" + address + '\'' +
                ", dept=" + dept +
                '}';
    }
}

 ⑤在dao包中创建mapper映射文件和接口

EmpDao接口：

public interface EmpDao {
    
}

EmpDao.xml 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">
<!--namespace：把配置文件和接口进行映射-->
<mapper namespace="com.qi.dao.EmpDao">
    <!--定义手动映射关系:数据库中字段 和 类的属性 的映射-->
</mapper>

⑥src中创建核心配置文件和jdbc.properties

 

 mybatis.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3