基于maven构建接口式开发Mybatis增删改查案例

文件分布图

---

 1.pom文件

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>sm.ning</groupId>
    <artifactId>mybatis_maven</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>
    <dependencies>
        <!--1.单元测试-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.9</version>
        </dependency>
        <!--2.mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>6.0.6</version>
        </dependency>

        <!--3.mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.7</version>
        </dependency>
        <!--lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.8</version>
        </dependency>
    </dependencies>

</project>

---

2.Mybatis的全局配置文件

<?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">
<!--Mybatis的全局配置文件-->
<configuration>
    <environments default="develop"><!--默认环境-->
        <environment id="develop"><!--可配置多个环境-->
            <transactionManager type="JDBC"></transactionManager><!--事务管理方式-->
            <dataSource type="POOLED"><!--使用连接池-->
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/db20?useUnicode=true&amp;serverTimezone=Asia/Shanghai&amp;character=utf-8"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>

    <!--给定mapper配置文件路径-->
    <mappers>
        <mapper resource="EmpDao.xml"/>
    </mappers>
    
</configuration>

---

3.测试类

package sm.ning.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 org.junit.Test;
import sm.ning.dao.EmpDao;
import sm.ning.entity.Emp;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

/**
 * @outher ningzp
 * @date 2022-03-15
 */
public class Mycrud {
    private static SqlSession session=null;
    static {
        //1.读取Mybatis的全局配置文件
        InputStream config = null;
        try {
            config = Resources.getResourceAsStream("mybatis.xml");
            //2.基于配置信息获取一个会话工厂
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(config);
            //3.通过会话工厂产生一个会话
            session=factory.openSession(true);/*默认是false,表示手动提交事务,true则是自动提交事务*/
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    @Test //通过ID查询单条数据
    public void queryByIdTest(){
        EmpDao empDao = session.getMapper(EmpDao.class);
        Emp emp = empDao.queryById(1);
        System.out.println(emp);/*Emp(id=1, name=张三, deptId=1)*/
    }

    @Test //查询指定行数据
    public void queryAllByLimitTest(){
        EmpDao empDao = session.getMapper(EmpDao.class);
        List<Emp> emps = empDao.queryAllByLimit(1, 3);
        for (Emp emp : emps) {
            System.out.println(emp);
            /*Emp(id=2, name=李四, deptId=2)
            Emp(id=3, name=老王, deptId=3)
            Emp(id=4, name=赵六, deptId=4)*/
        }
    }
    @Test //通过实体作为筛选条件查询
    public void queryAllTest(){
        EmpDao empDao = session.getMapper(EmpDao.class);
        Emp emp = new Emp();
        emp.setId(5);
        emp.setName("刘能");
        emp.setDeptId(4);
        List<Emp> emps = empDao.queryAll(emp);
        for (Emp emp1 : emps) {
            System.out.println(emp1);
        }
    }
    @Test //新增数据
    public void insertTest(){
        EmpDao empDao = session.getMapper(EmpDao.class);
        Emp emp = new Emp();
        emp.setId(5);
        emp.setName("刘能");
        emp.setDeptId(4);
        empDao.insert(emp);
    }
    @Test //修改数据
    public void updateTest(){
        EmpDao empDao = session.getMapper(EmpDao.class);
        Emp emp = new Emp();
        emp.setId(5);
        emp.setName("刘能");
        emp.setDeptId(4);
        empDao.update(emp);
    }
    @Test //通过主键删除数据
    public void deleteByIdTest(){
        EmpDao empDao = session.getMapper(EmpDao.class);
        empDao.deleteById(1);
    }

}

---

4.实体类

package sm.ning.entity;

import lombok.Data;

import java.io.Serializable;

@Data
public class Emp implements Serializable {
    private static final long serialVersionUID = 352597308109318457L;
    
    private Integer id;
    
    private String name;
    
    private Integer deptId;




}

---

5.持久化接口

package sm.ning.dao;

import sm.ning.entity.Emp;
import org.apache.ibatis.annotations.Param;
import java.util.List;

public interface EmpDao {

    /**
     * 通过ID查询单条数据
     *
     * @param id 主键
     * @return 实例对象
     */
    Emp queryById(Integer id);

    /**
     * 查询指定行数据
     *
     * @param offset 查询起始位置
     * @param limit 查询条数
     * @return 对象列表
     */
    List<Emp> queryAllByLimit(@Param("offset") int offset, @Param("limit") int limit);


    /**
     * 通过实体作为筛选条件查询
     *
     * @param emp 实例对象
     * @return 对象列表
     */
    List<Emp> queryAll(Emp emp);

    /**
     * 新增数据
     *
     * @param emp 实例对象
     * @return 影响行数
     */
    int insert(Emp emp);

    /**
     * 修改数据
     *
     * @param emp 实例对象
     * @return 影响行数
     */
    int update(Emp emp);

    /**
     * 通过主键删除数据
     *
     * @param id 主键
     * @return 影响行数
     */
    int deleteById(Integer id);

}

---

6.映射文件

<?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="sm.ning.dao.EmpDao">

    <resultMap id="BaseResultMap" type="sm.ning.entity.Emp">
        <!--@Table emp-->
        <result property="id" column="id" jdbcType="INTEGER"/>
        <result property="name" column="name" jdbcType="VARCHAR"/>
        <result property="deptId" column="dept_id" jdbcType="INTEGER"/>
    </resultMap>

    <!--查询单个-->
    <select id="queryById" resultMap="BaseResultMap">
        select
          id, name, dept_id
        from db20.emp
        where id = #{id}
    </select>

    <!--查询指定行数据-->
    <select id="queryAllByLimit" resultMap="BaseResultMap">
        select
          id, name, dept_id
        from db20.emp
        limit #{offset}, #{limit}
    </select>

    <!--通过实体作为筛选条件查询-->
    <select id="queryAll" resultMap="BaseResultMap">
        select
          id, name, dept_id
        from db20.emp
        <where>
            <if test="id != null">
                and id = #{id}
            </if>
            <if test="name != null and name != ''">
                and name = #{name}
            </if>
            <if test="deptId != null">
                and dept_id = #{deptId}
            </if>
        </where>
    </select>

    <!--新增所有列-->
    <insert id="insert" keyProperty="id" useGeneratedKeys="true">
        insert into db20.emp(name, dept_id)
        values (#{name}, #{deptId})
    </insert>

    <!--通过主键修改数据-->
    <update id="update">
        update db20.emp
        <set>
            <if test="name != null and name != ''">
                name = #{name},
            </if>
            <if test="deptId != null">
                dept_id = #{deptId},
            </if>
        </set>
        where id = #{id}
    </update>

    <!--通过主键删除-->
    <delete id="deleteById">
        delete from db20.emp where id = #{id}
    </delete>

</mapper>