准备工作
1、准备如下一个数据表
CREATE TABLE `student` ( `id` varchar(32) NOT NULL, `gender` varchar(32) DEFAULT NULL, `age` int(12) DEFAULT NULL, `nick_name` varchar(32) DEFAULT NULL, `name` varchar(32) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2、插入几条测试数据
整合步骤
工程的完整包结构如图所示
1、导入maven依赖
org.springframework.boot spring-boot-starter-parent 2.1.1.RELEASE UTF-8 UTF-8 1.8 8.0.11 3.7 1.2.47 3.3.0 3.3.0 1.1.14 1.18.0 2.0.0 2.9.2 1.9.6 org.apache.commons commons-lang3 3.4 org.springframework.boot spring-boot-starter-web mysql mysql-connector-java ${mysql-connector-java.version} com.alibaba fastjson ${fastjson.version} com.alibaba druid-spring-boot-starter ${druid.version} org.mybatis.spring.boot mybatis-spring-boot-starter 2.1.1 com.baomidou mybatis-plus-boot-starter ${mybatis-plus-boot-starter.version} com.baomidou mybatis-plus-generator ${mybatis-plus-generator.version} org.projectlombok lombok ${lombok.version} io.springfox springfox-swagger2 ${swagger.version} io.springfox springfox-swagger-ui ${swagger.version} com.github.xiaoymin swagger-bootstrap-ui ${swagger-bootstrap-ui.version}
2、配置文件 application.yml
server:
port: 8083
logging:
config: classpath:logback-spring.xml #日志
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://IP:3306/school?autoReconnect=true&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false
username: root
password: root
druid:
max-active: 100
initial-size: 10
max-wait: 60000
min-idle: 5
#设置单个文件最大上传大小
servlet:
multipart:
max-file-size: 20MB
mybatis-plus:
mapper-locations: classpath*:mapper/*.xml
global-config:
db-column-underline: true #开启驼峰转换
db-config:
id-type: uuid
field-strategy: not_null
refresh: true
configuration:
map-underscore-to-camel-case: true
#log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #打印sql语句便于调试3、为了方便后面调试接口，增加一个swagger的配置
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import springfox.documentation.builders.ApiInfoBuilder;
import springfox.documentation.builders.PathSelectors;
import springfox.documentation.builders.RequestHandlerSelectors;
import springfox.documentation.service.ApiInfo;
import springfox.documentation.spi.DocumentationType;
import springfox.documentation.spring.web.plugins.Docket;
import springfox.documentation.swagger2.annotations.EnableSwagger2;
/**
* swagger文档，项目启动后，浏览器访问:http://localhost:8083/swagger-ui.html
*/
@Configuration
@EnableSwagger2
public class ApiSwagger2 {
@Bean
public Docket createRestBmbsApi() {
return new Docket(DocumentationType.SWAGGER_2)
.groupName("users")
.apiInfo(apiInfo())
.select()
.apis(RequestHandlerSelectors.basePackage("com.congge.controller"))
.paths(PathSelectors.any())
.build();
}
private ApiInfo apiInfo() {
return new ApiInfoBuilder()
.title("后端相关API")
.version("1.0")
.build();
}
}4、实体类
import com.baomidou.mybatisplus.annotation.TableField;
import lombok.Data;
@Data
public class Student {
@TableField("id")
private String id;
@TableField("name")
private String name;
@TableField("gender")
private String gender;
@TableField("age")
private int age;
@TableField("nick_name")
private String nickName;
}5、dao接口，里面添加一个查询所有数据的方法
import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.congge.entity.Student; import org.apache.ibatis.annotations.Mapper; import java.util.List; @Mapper public interface StudentMapper extends BaseMapper{ List queryAll(); }
6、mybatis层，写sql的文件
7、业务实现类
在本次的业务实现中，同时可以使用mybatis的方式以及mybatis-plus的方式进行，具体使用的时候结合自身的需求进行选择；
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.congge.dao.StudentMapper;
import com.congge.entity.Student;
import com.congge.service.StudentService;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.List;
@Service
public class StudentServiceImpl implements StudentService {
@Resource
private StudentMapper studentMapper;
@Override
public List queryAllStudent() {
QueryWrapper queryWrapper = new QueryWrapper();
List students = studentMapper.selectList(queryWrapper);
return students;
//return studentMapper.queryAll();
}
@Override
public List getByName(String name) {
QueryWrapper queryWrapper = new QueryWrapper();
queryWrapper.like("name",name);
return studentMapper.selectList(queryWrapper);
}
public Student getById(String id) {
QueryWrapper queryWrapper = new QueryWrapper();
queryWrapper.like("id",id);
return studentMapper.selectOne(queryWrapper);
}
} 8、添加一个测试接口
@RestController
public class StudentController {
@Autowired
private StudentService studentService;
@GetMapping("/getAll")
public List getAll(){
return studentService.queryAllStudent();
}
@GetMapping("/getByName")
public List getByName(@RequestParam String name){
return studentService.getByName(name);
}
@GetMapping("/getById")
public Student getById(@RequestParam String id){
return studentService.getById(id);
}
} 9、启动类
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class App {
public static void main(String[] args) {
SpringApplication.run(App.class,args);
}
}接下来，将工程运行起来做一下测试吧
10、启动之后，打开swagger界面
不妨随机测试两个接口吧，测试下获取所有学生的数据接口
