引入依赖

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <modelVersion>4.0.0</modelVersion>
  5.     <parent>
  6.         <groupId>org.springframework.boot</groupId>
  7.         <artifactId>spring-boot-starter-parent</artifactId>
  8.         <version>2.3.0.RELEASE</version>
  9.     </parent>
  11.     <groupId>com.example.start</groupId>
  12.     <artifactId>spring-demo</artifactId>
  13.     <version>0.0.1-SNAPSHOT</version>
  14.     <name>spring-demo</name>
  15.     <description>Demo project for Spring Boot</description>
  17.     <properties>
  18.         <java.version>1.8</java.version>
  20.     </properties>
  22.     <dependencies>
  24.         <dependency>
  25.             <groupId>org.springframework.boot</groupId>
  26.             <artifactId>spring-boot-starter</artifactId>
  27.         </dependency>
  30.         <dependency>
  31.             <groupId>org.springframework.boot</groupId>
  32.             <artifactId>spring-boot-starter-web</artifactId>
  33.         </dependency>
  35.         <dependency>
  36.             <groupId>org.aspectj</groupId>
  37.             <artifactId>aspectjweaver</artifactId>
  38.         </dependency>
  40.         <dependency>
  41.             <groupId>mysql</groupId>
  42.             <artifactId>mysql-connector-java</artifactId>
  43.         </dependency>
  45.         <dependency>
  46.             <groupId>org.projectlombok</groupId>
  47.             <artifactId>lombok</artifactId>
  48.         </dependency>
  50.         <dependency>
  51.             <groupId>org.mybatis.spring.boot</groupId>
  52.             <artifactId>mybatis-spring-boot-starter</artifactId>
  53.             <version>2.1.1</version>
  54.         </dependency>
  56.         <!--<dependency>-->
  57.             <!--<groupId>com.alibaba</groupId>-->
  58.             <!--<artifactId>druid</artifactId>-->
  59.             <!--<version>1.1.6</version>-->
  60.         <!--</dependency>-->
  62.         <dependency>
  63.             <groupId>com.alibaba</groupId>
  64.             <artifactId>druid-spring-boot-starter</artifactId>
  65.             <version>1.1.17</version>
  66.         </dependency>
  68.         <dependency>
  69.             <groupId>org.springframework.boot</groupId>
  70.             <artifactId>spring-boot-starter-test</artifactId>
  71.         </dependency>
  73.         <dependency>
  74.             <groupId>com.alibaba</groupId>
  75.             <artifactId>dubbo</artifactId>
  76.             <version>2.6.5</version>
  77.         </dependency>
  79.     </dependencies>
  81.     <build>
  82.         <plugins>
  83.             <plugin>
  84.                 <groupId>org.springframework.boot</groupId>
  85.                 <artifactId>spring-boot-maven-plugin</artifactId>
  86.             </plugin>
  88.             <plugin>
  89.                 <groupId>org.mybatis.generator</groupId>
  90.                 <artifactId>mybatis-generator-maven-plugin</artifactId>
  91.                 <version>1.3.7</version>
  92.                 <configuration>
  93.                     <configurationFile>src/main/resources/mybatis/generator/generatorConfig.xml</configurationFile>
  94.                 </configuration>
  95.             </plugin>
  97.         </plugins>
  98.     </build>
  100. </project>

application.properties

  1. spring.application.name=spring-demo
  2. spring.datasource.url=jdbc:mysql://127.0.0.1:3306/spring_demo?useUnicode=true&characterEncoding=utf-8
  3. spring.datasource.username=root
  4. spring.datasource.password=Xiele
  6. mybatis.mapper-locations=classpath:mybatis/generator/sqlmap/*.xml
  7. mybatis.type-aliases-package=com.example.start.springdemo.mybatis

启动与验证

直接启动后执行查询, 未使用Controller。

  1. @MapperScan("com.example.start.springdemo.mybatis.generator")
  2. @SpringBootApplication
  3. public class MyBatisBootStrap {
  5.     private SpringUserDao springUserDao;
  7.     @Autowired
  8.     public MyBatisBootStrap(SpringUserDao springUserDao) {
  9.         this.springUserDao = springUserDao;
  10.     }
  12.     @Bean
  13.     CommandLineRunner sampleCommandLineRunner() {
  14.         return args -> {
  15.             SpringUserDO user = springUserDao.selectByPrimaryKey(1L);
  16.             System.out.println("mapper query -> " + user);
  17.         };
  18.     }
  20.     public static void main(String[] args) {
  22.         SpringApplication.run(MyBatisBootStrap.class, args);
  24.     }
  25. }