SpringBoot整合ORM框架

SpringBoot整合ORM框架的记录。

SpringBoot整合Mybatis（注解版本）

准备数据库环境

准备test数据库下的user表。

导入依赖

• pom.xml

<!--Mybatis-->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.2</version>
</dependency>

<!--MySQL-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.30</version>
</dependency>

<!--Lombok-->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <optional>true</optional>
</dependency>

配置文件

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8&&characterEncoding=utf8
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver

创建实体类和Mapper文件

• 实体类User

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
     int id;
     String username;
     String password;
}

• Mapper

@Mapper
public interface UserMapper {

    @Select("select * from user where username = #{username}")
    User selectUserByName(String username);
}

编写测试代码

• Test文件

@SpringBootTest
class MybatisTestApplicationTests {

    @Resource
    UserMapper mapper;
    
    @Test
    void teatMain(){
        User user = mapper.selectUserByName("admin");
        System.out.println(user);
    }
}

运行结果

整合成功

SpringBoot整合MybatisPlus

数据库环境

准备test数据库下的user表。

创建项目

导入依赖

• pom.xml

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.30</version>
</dependency>

<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <optional>true</optional>
</dependency>

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.5.2</version>
</dependency>

配置文件

• application.yml

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
    username: root
    password: 123456
mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

主启动类添加Scan注解

@SpringBootApplication
@MapperScan("com.example.mapper")
public class MybatisPlusTestApplication {

    public static void main(String[] args) {
        SpringApplication.run(MybatisPlusTestApplication.class, args);
    }

}

创建实体类和Mapper文件

• User

@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {

    int id;
    String username;
    String password;

}

• Mapper

@Mapper
public interface UserMapper extends BaseMapper<User> {

}

编写测试运行代码

@SpringBootTest
class MybatisPlusTestApplicationTests {

    @Resource
    UserMapper mapper;

    @Test
    void contextLoads() {
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.eq("username","admin");
        User user = mapper.selectOne(wrapper);
        System.out.println(user);
    }

}

测试结果