环境与 BaseMapper

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-plus-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-plus.version>3.5.9</mybatis-plus.version>
15
        <mysql.version>8.3.0</mysql.version>
16
    </properties>
17

18
    <dependencies>
19
        <dependency>
20
            <groupId>com.baomidou</groupId>
21
            <artifactId>mybatis-plus</artifactId>
22
            <version>${mybatis-plus.version}</version>
23
        </dependency>
24
        <dependency>
25
            <groupId>com.baomidou</groupId>
26
            <artifactId>mybatis-plus-jsqlparser</artifactId>
27
            <version>${mybatis-plus.version}</version>
28
        </dependency>
29
        <dependency>
30
            <groupId>com.mysql</groupId>
31
            <artifactId>mysql-connector-j</artifactId>
32
            <version>${mysql.version}</version>
33
        </dependency>
34
        <dependency>
35
            <groupId>com.zaxxer</groupId>
36
            <artifactId>HikariCP</artifactId>
37
            <version>5.1.0</version>
38
        </dependency>
39
    </dependencies>
40

41
    <build>
42
        <plugins>
43
            <plugin>
44
                <groupId>org.codehaus.mojo</groupId>
45
                <artifactId>exec-maven-plugin</artifactId>
46
                <version>3.5.0</version>
47
            </plugin>
48
        </plugins>
49
    </build>
50
</project>

1
package demo.mp;
2

3
import com.baomidou.mybatisplus.annotation.IdType;
4
import com.baomidou.mybatisplus.annotation.TableField;
5
import com.baomidou.mybatisplus.annotation.TableId;
6
import com.baomidou.mybatisplus.annotation.TableName;
7

8
import java.time.LocalDateTime;
9

10
@TableName("user")
11
public class User {
12

13
    @TableId(type = IdType.AUTO)
14
    private Long id;
15

16
    @TableField("user_name")
17
    private String userName;
18

19
    private String email;
20
    private Integer status;
21

22
    @TableField("created_at")
23
    private LocalDateTime createdAt;
24

25
    public User() {}
26

27
    public User(String userName, String email, int status) {
28
        this.userName = userName;
29
        this.email = email;
30
        this.status = status;
31
    }
32

33
    public Long getId() { return id; }
34
    public void setId(Long id) { this.id = id; }
35
    public String getUserName() { return userName; }
36
    public void setUserName(String userName) { this.userName = userName; }
37
    public String getEmail() { return email; }
38
    public void setEmail(String email) { this.email = email; }
39
    public Integer getStatus() { return status; }
40
    public void setStatus(Integer status) { this.status = status; }
41
    public LocalDateTime getCreatedAt() { return createdAt; }
42
    public void setCreatedAt(LocalDateTime createdAt) { this.createdAt = createdAt; }
43

44
    @Override
45
    public String toString() {
46
        return "User{id=" + id + ", userName='" + userName + "', email='" + email
47
                + "', status=" + status + ", createdAt=" + createdAt + "}";
48
    }
49
}

1
package demo.mp;
2

3
import com.baomidou.mybatisplus.annotation.DbType;
4
import com.baomidou.mybatisplus.core.MybatisConfiguration;
5
import com.baomidou.mybatisplus.core.MybatisSqlSessionFactoryBuilder;
6
import com.baomidou.mybatisplus.core.config.GlobalConfig;
7
import com.baomidou.mybatisplus.core.toolkit.GlobalConfigUtils;
8
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
9
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
10
import com.zaxxer.hikari.HikariConfig;
11
import com.zaxxer.hikari.HikariDataSource;
12
import org.apache.ibatis.mapping.Environment;
13
import org.apache.ibatis.session.SqlSessionFactory;
14
import org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory;
15

16
import javax.sql.DataSource;
17

18
public final class Mp {
19

20
    private Mp() {}
21

22
    public static SqlSessionFactory factory() {
23
        HikariConfig cfg = new HikariConfig();
24
        cfg.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/jdbc_lab?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai");
25
        cfg.setUsername("root");
26
        cfg.setPassword("root");
27
        cfg.setMaximumPoolSize(5);
28
        DataSource ds = new HikariDataSource(cfg);
29

30
        MybatisConfiguration configuration = new MybatisConfiguration();
31
        configuration.setMapUnderscoreToCamelCase(true);
32
        GlobalConfigUtils.setGlobalConfig(configuration, new GlobalConfig());
33
        configuration.addMapper(UserMapper.class);
34
        configuration.setEnvironment(new Environment("dev", new JdbcTransactionFactory(), ds));
35

36
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
37
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
38
        configuration.addInterceptor(interceptor);
39

40
        return new MybatisSqlSessionFactoryBuilder().build(configuration);
41
    }
42
}