SpringBoot学习之通过xml文件方式整合MyBatis

新建实体类User

package org.hx.springboot_mybatis_demo27.model;

public class User {
    private Integer id;
    private String name;
    private String passwd;

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", passwd='" + passwd + '\'' +
                '}';
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPasswd() {
        return passwd;
    }

    public void setPasswd(String passwd) {
        this.passwd = passwd;
    }
}

新建UserMapper2类

package org.hx.springboot_mybatis_demo27.mapper;

import org.apache.ibatis.annotations.*;
import org.hx.springboot_mybatis_demo27.model.User;

import java.util.List;


public interface UserMapper2 {

    User getUserById(Integer id);

    List<User> getAllUsers();


    Integer addUser(User user);

    Integer deleteById(Integer id);

    Integer updateById(String name, Integer id);
}

在UserMapper2类同一目录下新建UserMapper2.xml文件

<?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.hx.springboot_mybatis_demo27.mapper.UserMapper2">
    <resultMap id="UserMap" type="org.hx.springboot_mybatis_demo27.model.User">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="passwd" column="passwd"/>
    </resultMap>
    <select id="getUserById" resultMap="UserMap">
        select * from t1 where id=#{id};
    </select>
    <select id="getAllUsers" resultMap="UserMap">
        select * from t1 ;
    </select>
    <insert id="addUser" parameterType="org.hx.springboot_mybatis_demo27.model.User" useGeneratedKeys="true" keyProperty="id">
        insert into t1 (name,passwd) values (#{name},#{passwd});
    </insert>
    <delete id="deleteById">
        delete from t1 where id=#{id};
    </delete>
    <update id="updateById">
        update t1 set name =#{name} where id=#{id};
    </update>
</mapper>

在测试类中加入代码

@Autowired
    UserMapper2 userMapper2;
    @Test
    void test2(){
        User user=userMapper2.getUserById(113);
        System.out.println(user);
    }
    @Test
    void test3(){
        List<User> user = userMapper2.getAllUsers();
        System.out.println(user);
        User u = new User();
        u.setName("hhh");
        u.setPasswd("123456");
        userMapper2.addUser(u);
        System.out.println(u.getId());
        userMapper2.deleteById(114);
        userMapper2.updateById("韩星",112);
    }

最后配置pom.xml，使其能扫描到xml文件

<build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
            </resource>
        </resources>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

application.properties文件配置与上一篇文章中的配置相同