BootDemo
SpringBoot Demo是一个集成了SpringBoot+MyBatis的Demo工程，以书籍数据管理为例提供了书籍的增删改查的Restfull格式的API接口。
开发环境
IDEA 2019.3 MySQL 8.0.19 Tomcat 9 Maven 3.6
目录结构
├── src #
│ └── main #
│ ├── java #
│ │ └── com #
│ │ └── dzq #
│ │ └── bootdemo #
│ │ ├── Application.java # 程序入口
│ │ ├── SwaggerConfig.java # Swagger配置
│ │ ├── controller #
│ │ │ └── BookAPIController.java # 书籍增删改查API
│ │ ├── dao #
│ │ │ ├── BookMapper.java # 书籍Mapper接口
│ │ ├── pojo #
│ │ │ └── Books.java # 书籍数据模型
│ │ ├── service #
│ │ │ ├── BookService.java # 书籍Service接口
│ │ │ └── BookServiceImpl.java # 书籍Service实现
│ │ └── vo #
│ │ └── ResponseBody.java # 返回对象
│ └── resources #
│ └── application.yaml # SpringBoot配置文件
├── BootDemo.iml #
├── LICENSE #
├── README.md #
├── pom.xml # 数据库
CREATE DATABASE `ssmbuild`;
USE `ssmbuild`;
create table books
(
id int auto_increment comment '书id'
primary key,
name varchar(100) not null comment '书名',
num int not null comment '数量',
detail varchar(200) not null comment '描述'
)
charset=utf8;
INSERT INTO ssmbuild.books (id, name, num, detail) VALUES (1, 'Java', 1, '从入门到放弃');
INSERT INTO ssmbuild.books (id, name, num, detail) VALUES (2, 'MySQL', 10, '从删库到跑路');
INSERT INTO ssmbuild.books (id, name, num, detail) VALUES (3, 'Linux', 5, '从进门到进牢');
INSERT INTO ssmbuild.books (id, name, num, detail) VALUES (4, '安慰我', 100, '大声道撒');
INSERT INTO ssmbuild.books (id, name, num, detail) VALUES (5, 'MySQL', 10, '从删库到跑路');
INSERT INTO ssmbuild.books (id, name, num, detail) VALUES (6, 'Linux', 5, '从进门到进牢');
INSERT INTO ssmbuild.books (id, name, num, detail) VALUES (7, 'Java', 1, '从入门到放弃');
INSERT INTO ssmbuild.books (id, name, num, detail) VALUES (8, 'MySQL', 10, '从删库到跑路');
INSERT INTO ssmbuild.books (id, name, num, detail) VALUES (9, 'Linux', 5, '从进门到进牢');
INSERT INTO ssmbuild.books (id, name, num, detail) VALUES (10, '阿斯顿撒', 1, '实时');Maven项目
pom依赖
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.2.5.RELEASE</version>
</parent>
<dependencies>
<!-- Spring Boot -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--数据库驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.19</version>
</dependency>
<!-- 数据库连接池 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/tk.mybatis/mapper-spring-boot-starter -->
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>2.0.3</version>
</dependency>
<!-- JSON-->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.5</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-annotations</artifactId>
<version>2.9.5</version>
</dependency>
<!-- lombok -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
<scope>provided</scope>
</dependency>
<!-- Swagger-->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger2</artifactId>
<version>2.9.2</version>
</dependency>
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger-ui</artifactId>
<version>2.9.2</version>
</dependency>
</dependencies>Maven资源过滤设置
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>Spring Boot 配置文件
logging:
level:
root: info
com.dzq.bootdemo: debug
spring:
datasource:
type: com.mysql.cj.jdbc.MysqlConnectionPoolDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
username: root
password: 12345678
mybatis:
mapper-locations: classpath:com/dzq/bootdemo/dao/*.xml
type-aliases-package: com.dzq.bootdemo.pojo提供的接口
POST /book 添加书籍
PUT /book 更新书籍
GET /book/{id} 查询指定ID的书籍
DELETE /book/{id} 删除书籍
GET /book/list 查询所有书籍
GET /book/search/{name} 查询包含指定名称书籍