springboot接入mybatis管理数据库

springboot接入mybatis管理数据库

• 1.创建springboot项目(使用开发工具类似IDEA新建Springboot项目)

• 2.pom依赖引入

  
  
  mysql
  mysql-connector-java
  ${mysql.version}
  
  
  
  org.mybatis.spring.boot
  mybatis-spring-boot-starter
  ${mybatis.version}
  

• 3.配置文件(application.yml)

  数据库配置

  spring:
  datasource:
  # 驱动
  driver-class-name: com.mysql.cj.jdbc.Driver
  # url
  url: jdbc:mysql://xxx:3306/second_kill?characterEncoding=utf-8&useSSL=false
  # 用户名
  username: xxx
  # 密码
  password: xxx
  dbcp2:
  # 验证查询
  validation-query: select 1 from dual

  MyBatis

  mybatis:
  # 包别名配置
  type-aliases-package: com.kinson.springboot.domain
  # mapper xml位置配置
  mapper-locations: classpath:/secondKill/*.xml
  # 控制台打印sql(https://www.cnblogs.com/kingsonfu/p/9245731.html)
  configuration:
  log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

• 4.启动类加MapperScan注解

  @SpringBootApplication
  // 多个以逗号分隔
  @MapperScan({"com.kinson.springboot.mapper", "xxx"})
  public class SecondKillProSpringboot {

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

• 5.新加数据库表映射类

  public class User {

  private Integer id;

  private String userName;

  public Integer getId() {
  return id;
  }

  public void setId(Integer id) {
  this.id = id;
  }

  public String getUserName() {
  return userName;
  }

  public void setUserName(String userName) {
  this.userName = userName;
  }
  }

• 6.新增对应的Mapper类

  public interface UserMapper {

  /**
  * 查询所有用户
  *
  * @return
  */
  List selectUserList();
  }

• 7.新增对应Mapper的映射xml文件

  select * from user

• 8.之后就可以使用mapper在service注入使用了

Github源码：springboot-mybatis