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

1.数据库表结构

2.jar包导入

3.配置文件mybatis-config

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

    <!--配置多个环境的标签 default默认使用的环境-->
    <environments default="development">

        <!--配置一个环境的标签-->
        <environment id="development">
            <!--事物管理器-->
            <transactionManager type="JDBC"/>
            <!--数据源-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/empmanager"/>
                <property name="username" value="###"/>
                <property name="password" value="###"/>
            </dataSource>
        </environment>

    </environments>

    <!--提供映射文件路径 Emp.xml中写对Emp的sql语句-->
    <mappers>
        <mapper resource="com/hbu/jfp/mybatis/model/Emp.xml"></mapper>
    </mappers>


</configuration>

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代码配置文件

<?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="org.mybatis.example.model.Emp">

    <!--查询-->
    <select id="selectEmp" resultType="com.hbu.jfp.mybatis.model.Emp">
      select * from emp;
    </select>

    <!--插入-->
    <insert id="insertEmp">
        insert into emp values(null,'jfp158','1',12,12000);
    </insert>

    <!--修改-->
    <update id="updateEmp">
        update emp set ename="wzj139" where eid=14;
    </update>

    <!--查询-->
    <select id="selectEmpById" resultType="com.hbu.jfp.mybatis.model.Emp">
      select * from emp where eid=14;
    </select>

    <!--删除-->
    <delete id="deleteEmpById">
        delete from emp where eid=14;
    </delete>
</mapper>

6.测试类 Test1.java

public class Test1 {
    public static void main(String[] args) throws IOException {

        String resource = "com/hbu/jfp/mybatis/resource/mybatis-config.xml";//mybatis-config.xml文件存放路径
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
//        System.out.println(sqlSession);


        //查询多个
        //org.mybatis.example.model.Emp.selectEmp  在Emp.xml文件中表示哪个namespace下的命名空间的哪个查询方法
        List<Emp> list = sqlSession.selectList("org.mybatis.example.model.Emp.selectEmp");
        for (Emp emp : list) {
            System.out.println(emp);
        }
        System.out.println("------------------------------------------------------------");

        //插入
        //org.mybatis.example.model.Emp.insertEmp在Emp.xml文件中表示哪个namespace下的命名空间的哪个查询方法
        int insert = sqlSession.insert("org.mybatis.example.model.Emp.insertEmp");
        sqlSession.commit();
        System.out.println(insert);
        System.out.println("------------------------------------------------------------");

        //更新
        //org.mybatis.example.model.Emp.updateEmp在Emp.xml文件中表示哪个namespace下的命名空间的哪个查询方法
        int update = sqlSession.update("org.mybatis.example.model.Emp.updateEmp");
        sqlSession.commit();
        System.out.println(update);
        System.out.println("------------------------------------------------------------");

        //根据id
        Emp emp = sqlSession.selectOne("org.mybatis.example.model.Emp.selectEmpById");
        System.out.println(emp);
        System.out.println("------------------------------------------------------------");

        //根据id
        int delete = sqlSession.delete("org.mybatis.example.model.Emp.deleteEmpById");
        sqlSession.commit();
        System.out.println(delete);

        sqlSession.close();

    }
}