基础Mybatis框架的数据库增删改查

1.数据库表结构

2.jar包导入

3.配置文件mybatis-config

4.Model封装类

public class Emp {
    private Integer eid;
    private String ename;
    private String esex;
    private Integer eage;
    private Float esalary;

    public Emp() {
    }

    public Emp(Integer eid) {
        this.eid = eid;
    }

    public Emp(Integer eid, String ename, String esex, Integer eage, Float esalary) {
        this.eid = eid;
        this.ename = ename;
        this.esex = esex;
        this.eage = eage;
        this.esalary = esalary;
    }

    public Emp(String ename, String esex, Integer eage, Float esalary) {
        this.ename = ename;
        this.esex = esex;
        this.eage = eage;
        this.esalary = esalary;
    }

    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 getEsex() {
        return esex;
    }

    public void setEsex(String esex) {
        this.esex = esex;
    }

    public Integer getEage() {
        return eage;
    }

    public void setEage(Integer eage) {
        this.eage = eage;
    }

    public Float getEsalary() {
        return esalary;
    }

    public void setEsalary(Float esalary) {
        this.esalary = esalary;
    }

    @Override
    public String toString() {
        return "Emp{" +
                "eid=" + eid +
                ", ename='" + ename + ''' +
                ", esex='" + esex + ''' +
                ", eage=" + eage +
                ", esalary=" + esalary +
                '}';
    }
}

5.Emp crud sql代码配置文件







    
    
      select * from emp;
    

    
    
        insert into emp values(null,'jfp158','1',12,12000);
    

    
    
        update emp set ename="wzj139" where eid=14;