1、POM依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.0</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.1.5.RELEASE</version>
</dependency>
2、测试用数据库表结构
mysql数据库为test,数据库表为teacher,创建表语句如下:
create table teacher(
tec_id varchar(16) not null primary key,
tec_name varchar(16) not null,
tec_age tinyint unsigned,
tec_desc varchar(128)
);
往数据库插入一条数据
3、springboot maven 项目目录结构
4、配置到application.properties,添加MySQL数据库连接
#数据库连接:注意要加上时区 spring.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8 spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=com.mysql.jdbc.Driver #配置mapper.xml文件存放路径 mybatis.mapper-locations=classpath:mapper/*.xml
5、在创建的mybatis目录(目录名可任意命名)下,新建MyBatis 数据库 Configuration 文件
package com.rctech.testmybatis.mybatis; //import com.github.pagehelper.PageHelper; import org.springframework.boot.context.properties.ConfigurationProperties; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springfra