SpringBoot体验Mybatis、MybatisPlus、TKMybatis

Mybatis

Mybatis搭建与使用

1. pom文件中的依赖

<!-- mybatis 依赖 -->
<dependency>
  <groupId>org.mybatis.spring.boot</groupId>
  <artifactId>mybatis-spring-boot-starter</artifactId>
  <version>2.2.2</version>
</dependency>
<!-- mysql 驱动 -->
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <scope>runtime</scope>
</dependency>

<!-- 数据池 -->
<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid</artifactId>
  <version>1.2.1</version>
</dependency>

2. 修改配置文件

这里使用 yml 格式的配置文件

# 数据库连接配置
spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    password: qwer1234
    url: jdbc:mysql://localhost:3306/project_manager?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
 
# mybatis 配置
mybatis:
  type-aliases-package: mybatis.pojo
  mapper-locations: classpath:/mapper/*.xml

3. 定义Java 对象

@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
   
    private Integer id;

    private String name;

    private String password;

    private String others;
}

4. 定义mapper接口

@Mapper
public interface UserMapper {
   

    public List<User> selectAllUsers();

    public List<User> selectLimit(Map<String, Object> map);

    public void insertUser(User user);

    public void updateUser(User user);

    public void deleteUser(User user);

    public User selectUserById(Integer id);

    public User selectUserByName(String name);

}

5. 在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="mybatis.mapper.UserMapper">
    <select id="selectAllUsers" resultType="mybatis.pojo.User">
        select *
        from pm_user;
    </select>

    <select id="selectLimit" parameterType="map" resultType="mybatis.pojo.User">
        select *
        from pm_user limit #{startIndex}, #{pageSize};
    </select>

    <select id