mybatis(第一天) springboot 集成mybatis mysql数据库

新建一个 maven  项目  JDK 为1.8  

pom.xml 文件 如下

<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.test</groupId> <artifactId>spring-boot-mybatis-druid</artifactId> <version>1.0-SNAPSHOT</version> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.1.1.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <project.finalName>spring-boot-mybatis-druid</project.finalName> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <!--依赖包版本--> <spring-boot.version>2.1.1.RELEASE</spring-boot.version> <mybatis.version>2.1.1</mybatis.version> <mysql.version>5.1.28</mysql.version> <druid.version>1.1.10</druid.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>${mybatis.version}</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>${mysql.version}</version> <scope>runtime</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>${druid.version}</version> </dependency> </dependencies> <build> <finalName>${project.finalName}</finalName> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <version>${spring-boot.version}</version> <executions> <execution> <goals> <goal>repackage</goal> </goals> </execution> </executions> </plugin> </plugins> <!--避免打包时失误 扫描不到 防止遗漏--> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.xml</include> </includes> </resource> <resource> <directory>src/main/resources</directory> </resource> </resources> </build> </project>

 application.properties 里 有关 mybatis的 简单配置

#数据库链接 spring.datasource.url=jdbc:mysql:///test01?useUnicode=true&characterEncoding=utf-8 #数据库账号 spring.datasource.username=root #数据库密码 spring.datasource.password=root #数据库驱动 spring.datasource.type=com.alibaba.druid.pool.DruidDataSource #mapper.xml 文件所在目录 mybatis.mapper-locations=classpath:mapper/*.xml

boot 启动类

package com.test; import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication //mybatis扫描mapper接口 @MapperScan(basePackages = "com.test.mapper") public class Application { public static void main(String[] args) { SpringApplication.run(Application.class,args); } }