SpringBoot整合Mybatis和Mybatis-Plus

1、SpringBoot整合Mybatis

1.加依赖

<!--        1.mybatis整个Spring Boot的依赖-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
<!--        2.mysql的驱动依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.23</version>
        </dependency>

2.配置

server:
  port: 8088

#配置数据库
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/frame_db?useUnicode=true&characterEncoding=utf-8&useSSL=false
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
  #配置别名
  type-aliases-package: com.gcxy.entity
  #下划线转驼峰的配置
  configuration:
    map-underscore-to-camel-case: true
  #mapper.xml的地址
  #mapper-locations: classpath:mapper/*.xml

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@MapperScan("com.gcxy.mapper")//配置mapper接口的扫描路径
@SpringBootApplication
public class Application {
    public static void main(String[] args) {
        SpringApplication.run(Application.class, args);
    }
}

3.启动

public interface CourseMapper {
    //查询所有课程
    @Select("select * from course")
    List<Course> selectAll();
}

2、SpringBoot整合Mybatis-Plus

https://baomidou.com/

1.加依赖

<!--        1.mybatis-plus整个Spring Boot的依赖-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>
        <!--        2.mysql的驱动依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.23</version>
        </dependency>

2.配置

server:
  port: 8088

#配置数据库
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/frame_db?useUnicode=true&characterEncoding=utf-8&useSSL=false
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver
mybatis-plus:
  #配置别名
  type-aliases-package: com.gcxy.domain
  configuration:
    #下划线转驼峰的配置
    map-underscore-to-camel-case: true
    #控制台打印日志
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@MapperScan("com.gcxy.mapper")
@SpringBootApplication
public class Application {
    public static void main(String[] args) {
        SpringApplication.run(Application.class, args);
    }
}

3.启动

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.gcxy.domain.Course;
public interface CourseMapper extends BaseMapper<Course> {

}