Mybatis增删改查

入门案例

1. 导入pom.xml中的依赖

<!--mybatis依赖包-->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.2.0</version>
</dependency>

<!--jdbc依赖包-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>
<!--lombok-->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <optional>true</optional>
</dependency>

2. 在src/main/resources文件夹下创建mybatis-config.xml文件

<?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>

    <!--环境配置标签-->
    <environments default="development">

        <!--编辑开发环境-->
        <environment id="development">
        	<!--表示使用JDBC的事务控制-->
            <transactionManager type="JDBC"/>
            <!--使用JDBC连接池-->
            <dataSource type="POOLED">
            	<!--8版本的驱动有cj包，8以下的没有cj-->
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <!--数据库连接信息-->
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/jt?serverTimezone=GMT%2B8&amp;useUnicode=true&amp;characterEncoding=utf8&amp;autoReconnect=true&amp;allowMultiQueries=true"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
	
</configuration>

3. 创建com.jt.pojo.UserMapper接口

package com.jt.mapper;

import com.jt.pojo.User;

import java.util.List;

public interface UserMapper {

    List<User> findAll();

	List<User> findUserListByLike(Map map);

    User findById(Integer id);

    int addUser(User user);

    void deleteUser(Integer id);

    void updateUser(User user);
}

4. 在src/main/resources/mappers/下创建UserMapper.xml映射文件
   注意：
   namespace的值一定要与接口的全限定名一致
   不论具体的返回值是List<User>还是User,resultType的值只需写pojo包下对应的类就可以了

<?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是mybaits映射文件的唯一标识,与接口对应-->
<mapper namespace="com.jt.mapper.UserMapper">
    <!--id 表示接口方法
        resultType 返回值结果类型
    -->
    <select id="findAll" resultType="com.jt.pojo.User">
        select *
        from demo_user
    </select>

    <select id="findById" resultType="com.jt.pojo.User">
        select *
        from demo_user
        where id = #{id}
    </select>
    
 <!--<select id="findUserListByLike" resultType="com.jt.pojo.User">
        select * from demo_user where name like "%"#{name}"%"
    </select>-->
    <select id="findUserListByLike" resultType="com.jt.pojo.User">
        select * from demo_user where name like #{name}
    </select>

	<!-- keyProperty="id" useGeneratedKeys="true" -->
	<!-- 设置是否使用JDBC的getGenereatedKeys方法获取主键并赋值到keyProperty设置的领域模型属性中 -->
    <insert id="addUser" parameterType="com.jt.pojo.User" keyProperty="id" useGeneratedKeys="true">
        insert into demo_user (id, name, age, sex)
        values (#{id}, #{name}, #{age}, #{sex})
    </insert>

    <delete id="deleteUser">
        delete
        from demo_user
        where id = #{id}
    </delete>

    <update id="updateUser" parameterType="com.jt.pojo.User">
        update demo_user
        set name=#{name},
            age=#{age},
            sex=#{sex}
        where id = #{id}
    </update>
</mapper>

4. 建UserMapper.xml与接口UserMapper的关联关系，在第2步中的mybatis-config.xml配置文件中的底行</configuration>的上面，</environments>的下面添加如下内容

    <!--Mybatis加载Mapper映射文件-->
    <mappers>
        <mapper resource="mappers/UserMapper.xml"/>
    </mappers>

5. 测试

package com.jt;

import com.jt.mapper.UserMapper;
import com.jt.pojo.User;
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 java.io.IOException;
import java.io.InputStream;
import java.util.List;

/**
 * 本类用于测试Mybatis数据库
 *
 * @author SJXQ
 * @version 2021/12/3 16:25
 */
public class TestMybatis {

    private static SqlSessionFactory sqlSessionFactory;

    public static void main(String[] args) {
        try {
            test1();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    private static void test1() throws IOException {
        // 指定资源文件名称，本例中该文件存放在src/main/resources/下面
        String resource = "mybatis-config.xml";
        // 获得该资源文件的输入流
        InputStream in = Resources.getResourceAsStream(resource);
        // 通过工具得到sqlSessionFactory
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(in);
        //获得Session
        SqlSession sqlSession = sqlSessionFactory.openSession();
        // 通过Session获得对应接口的实现对象
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

        // 测试查询所有
        userMapper.findAll().forEach(System.out::println);
        
		// 测试模糊查询
		Map map = new HashMap();
        //map.put("name","君");
        map.put("name","%君%");
        userMapper.findUserListByLike(map).forEach(System.out::println);

        // 测试增加功能
        User user = new User(100, "Vitor", 18, "男");
        System.out.println(user);
        int i = userMapper.addUser(user);
        System.out.println("添加行数" + i);
        sqlSession.commit();

        // 测试根据id查询
        User byIdUser = userMapper.findById(100);
        System.out.println("get user by id:" + byIdUser);

        // 更新
        byIdUser.setName("白雪");
        byIdUser.setAge(20);
        byIdUser.setSex("女");
        int updateRows = userMapper.updateUser(byIdUser);
        System.out.println("更新行数：" + updateRows);
        sqlSession.commit();

        //验证更新是否生效
        System.out.println("更新后的数据：" + userMapper.findById(100));

        //测试删除用户
        int deleteRows = userMapper.deleteUser(100);
        sqlSession.commit();
        System.out.println("测试用户已删除");
        sqlSession.close();
    }
}