环境与 Mapper 配置

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

7
    <groupId>com.blog.demo</groupId>
8
    <artifactId>mybatis-user-lab</artifactId>
9
    <version>1.0.0</version>
10

11
    <properties>
12
        <maven.compiler.release>17</maven.compiler.release>
13
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
14
        <mybatis.version>3.5.16</mybatis.version>
15
        <mysql.version>8.3.0</mysql.version>
16
    </properties>
17

18
    <dependencies>
19
        <dependency>
20
            <groupId>org.mybatis</groupId>
21
            <artifactId>mybatis</artifactId>
22
            <version>${mybatis.version}</version>
23
        </dependency>
24
        <dependency>
25
            <groupId>com.mysql</groupId>
26
            <artifactId>mysql-connector-j</artifactId>
27
            <version>${mysql.version}</version>
28
        </dependency>
29
    </dependencies>
30

31
    <build>
32
        <plugins>
33
            <plugin>
34
                <groupId>org.codehaus.mojo</groupId>
35
                <artifactId>exec-maven-plugin</artifactId>
36
                <version>3.5.0</version>
37
            </plugin>
38
        </plugins>
39
    </build>
40
</project>

1
<?xml version="1.0" encoding="UTF-8" ?>
2
<!DOCTYPE configuration
3
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
4
        "https://mybatis.org/dtd/mybatis-3-config.dtd">
5
<configuration>
6
    <settings>
7
        <setting name="mapUnderscoreToCamelCase" value="true"/>
8
        <setting name="logImpl" value="STDOUT_LOGGING"/>
9
    </settings>
10

11
    <environments default="dev">
12
        <environment id="dev">
13
            <transactionManager type="JDBC"/>
14
            <dataSource type="POOLED">
15
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
16
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/jdbc_lab?useSSL=false&amp;allowPublicKeyRetrieval=true&amp;serverTimezone=Asia/Shanghai"/>
17
                <property name="username" value="root"/>
18
                <property name="password" value="root"/>
19
            </dataSource>
20
        </environment>
21
    </environments>
22

23
    <mappers>
24
        <mapper resource="mapper/UserMapper.xml"/>
25
    </mappers>
26
</configuration>

1
package demo.mybatis;
2

3
import java.time.LocalDateTime;
4

5
public class User {
6
    private Long id;
7
    private String userName;
8
    private String email;
9
    private int status;
10
    private LocalDateTime createdAt;
11

12
    public User() {}
13

14
    public User(String userName, String email, int status) {
15
        this.userName = userName;
16
        this.email = email;
17
        this.status = status;
18
    }
19

20
    public Long getId() { return id; }
21
    public void setId(Long id) { this.id = id; }
22
    public String getUserName() { return userName; }
23
    public void setUserName(String userName) { this.userName = userName; }
24
    public String getEmail() { return email; }
25
    public void setEmail(String email) { this.email = email; }
26
    public int getStatus() { return status; }
27
    public void setStatus(int status) { this.status = status; }
28
    public LocalDateTime getCreatedAt() { return createdAt; }
29
    public void setCreatedAt(LocalDateTime createdAt) { this.createdAt = createdAt; }
30

31
    @Override
32
    public String toString() {
33
        return "User{id=" + id + ", userName='" + userName + "', email='" + email
34
                + "', status=" + status + ", createdAt=" + createdAt + "}";
35
    }
36
}

1
<?xml version="1.0" encoding="UTF-8" ?>
2
<!DOCTYPE mapper
3
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
4
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
5
<mapper namespace="demo.mybatis.UserMapper">
6

7
    <resultMap id="UserMap" type="demo.mybatis.User">
8
        <id property="id" column="id"/>
9
        <result property="userName" column="user_name"/>
10
        <result property="email" column="email"/>
11
        <result property="status" column="status"/>
12
        <result property="createdAt" column="created_at"/>
13
    </resultMap>
14

15
    <insert id="insert" useGeneratedKeys="true" keyProperty="id">
16
        INSERT INTO user (user_name, email, status)
17
        VALUES (#{userName}, #{email}, #{status})
18
    </insert>
19

20
    <select id="selectById" resultMap="UserMap">
21
        SELECT id, user_name, email, status, created_at
22
        FROM user WHERE id = #{id}
23
    </select>
24

25
    <update id="updateEmail">
26
        UPDATE user SET email = #{email} WHERE id = #{id}
27
    </update>
28

29
    <delete id="deleteById">
30
        DELETE FROM user WHERE id = #{id}
31
    </delete>
32

33
    <select id="selectByStatus" resultMap="UserMap">
34
        SELECT id, user_name, email, status, created_at
35
        FROM user WHERE status = #{status} ORDER BY id
36
    </select>
37
</mapper>