之前学了一点,现在要做,差不多完全忘记了,做完在这里做下总结。
springboot要集成mybatis和swagger的话,先不要着急,胡乱复制粘贴代码。要集成这两个,建议先集成swagger。
大致的项目结构:
tips:controller、config、service等这些类都要在启动类的同级或下级文件夹中。
一、新建一个springboot项目(过程省略)
二、集成swagger
- 导入依赖(可能有多余的)
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jdbc</artifactId>
</dependency>
<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>2.1.4</version>
</dependency>
<!--swagger-->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger2</artifactId>
<exclusions>
<exclusion>
<groupId>io.swagger</groupId>
<artifactId>swagger-annotations</artifactId>
</exclusion>
<exclusion>
<groupId>io.swagger</groupId>
<artifactId>swagger-models</artifactId>
</exclusion>
</exclusions>
<version>2.9.2</version>
</dependency>
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger-ui</artifactId>
<version>2.9.2</version>
<!--<scope>provided</scope>-->
</dependency>
<dependency>
<groupId>io.swagger</groupId>
<artifactId>swagger-annotations</artifactId>
<version>1.5.21</version>
</dependency>
<dependency>
<groupId>io.swagger</groupId>
<artifactId>swagger-models</artifactId>
<version>1.5.21</version>
</dependency>
<!-- 6.分布式数据库 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!--数据库连接驱动-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.21</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-tomcat</artifactId>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
- 添加swagger的配置文件SwaggerConfig.java
@Configuration
@EnableSwagger2
public class SwaggerConfig {
@Bean
public Docket customDocket(){
return new Docket(DocumentationType.SWAGGER_2)
.apiInfo(apiInfo())
.select()
.apis(RequestHandlerSelectors.basePackage("controller的路径")) //扫描controller层的包
.build();
}
private ApiInfo apiInfo(){
return new ApiInfoBuilder()
.title("springboot集成mybatis&swagger的demo") //文档说明
.version("1.0")
.build();
}
}
- 编写controller(这里写的是对一个简单的person表进行增删改查,写了这个可以把实体类,后面的service层、dao层补充好)
@RestController
@Api("对person的增删改查")
public class PersonController {
@Autowired
PersonService personService;
// 查询(暂未考虑用户重名情况)
@GetMapping("/findOne")
@ApiOperation(value = "通过人名查找信息")
@ApiImplicitParam(name = "name",value = "用户姓名",required = true,dataType = "String")
public List<Person> findOne(String name){
return personService.findOne(name);
}
//保存功能
@ApiOperation(value = "保存用户信息")
@PostMapping("save")
@ApiImplicitParams({
@ApiImplicitParam(name = "name",value = "用户姓名",required = true,dataType = "String"),
@ApiImplicitParam(name = "age",value = "用户年龄",required = false),
@ApiImplicitParam(name = "gender",value = "用户性别",required = false)
})
public int save(String name, Integer age, Integer gender){
Person p=new Person(name,age,gender);
return personService.save(p);
}
// 删
@ApiOperation(value = "删除某人的信息")
@DeleteMapping("delete")
@ApiImplicitParam(name = "name",value = "用户姓名",required = true,dataType = "String")
public int delete(String name){
return personService.delete(name);
}
// 改
@ApiOperation(value = "修改信息")
@PutMapping("update")
@ApiImplicitParams({
@ApiImplicitParam(name = "name",value = "用户姓名",required = true),
@ApiImplicitParam(name = "age",value = "用户年龄",required = false),
@ApiImplicitParam(name = "gender",value = "用户性别",required = false)
})
public int update(String name, Integer age, Integer gender) {
Person p = new Person(name, age, gender);
return personService.update(p);
}
}
- 写完这些启动项目可以发现会报错,这是因为到了mapper,没法到数据库,因此把数据库方面补起来。(开始整合mybatis)
以上参考:
版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/u012431703/article/details/93856842
三、集成mybatis
- 添加驱动,在application.yml中添加配置
#swagger
swagger:
enabled: true
server:
port: 8080
spring:
#jdbc
datasource:
username: root
password: root
url: jdbc:mysql://localhost:3306/work?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
driver-class-name: com.mysql.cj.jdbc.Driver
- 添加mybatis配置文件mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 延迟加载和驼峰式编写规范支持 -->
<settings>
<setting name="lazyLoadingEnabled" value="true"/>
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
</configuration>
- 补充完善application.yml中的配置
#mybatis整合配置
mybatis:
config-location: classpath:mybatis/mybatis-config.xml
mapper-locations: classpath:mybatis/mappers/*.xml
- 在启动类上添加扫描mapper接口的注解
@MapperScan("mapper接口的路径")
tips:mapper接口要添加@mapper注解,另@mapper和@Repository的区别在下面这篇文章:
版权声明:本文为CSDN博主「昆仑山下一头驴」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/weixin_44607885/article/details/102554773