SpringBoot 整合Mybatis操作数据库

程序员继芳技术 2022年11月15日

0 收藏 730 点赞 4,963 浏览 1226 个字

1.引入依赖：

 <dependency>
     <groupId>org.mybatis.spring.boot</groupId>
     <artifactId>mybatis-spring-boot-starter</artifactId>
     <version>2.0.0</version>
 </dependency>
 <dependency>
     <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
 </dependency>
 <dependency>
     <groupId>com.alibaba</groupId>
     <artifactId>druid</artifactId>
     <version>1.1.10</version>
 </dependency>

2.application.properties

#DB Configation
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/springboot?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
# JPAConfiguration
spring.jpa.database=mysql
spring.jpa.show-sql=true
spring.jpa.generate-ddl=truespring.freemarker.suffix=.ftl

或application.yml

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/springboot?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
    username: root
    password: root
  jpa:
    database: mysql
    show-sql: true
    generate-ddl: true
  freemarker:
    suffix: .ftl

3.在SpringBoot上增加启动类

@SpringBootApplication
@MapperScan(basePackages = "com.feiyu.user.dao")
public class JpaApplication {   public static void main(String[] args) {
      SpringApplication.run(JpaApplication.class, args);
   }}

即可正常使用