- 选择File->new->Project
- 创建Group包名,Atrifact项目名
- 添加需要的jar包配置
- 在com.xj.demo包下分别创建config、controller、mapper、model、service包名，注意包名创建后，最好不要修改否则会有奇怪问题
- 编辑application.properties文件，添加MySql、Mybatis参数配置
#基本配置 spring.datasource.url=jdbc:mysql://127.0.0.1:3306/business?useUnicode=true&characterEncoding=utf-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC spring.datasource.username=root spring.datasource.password=root spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver #使用mysql spring.jpa.database = mysql #是否显示sql语句 spring.jpa.show-sql=true #mybatis配置 mybatis.config-location=classpath:mybatis-config.xml // 配置文件位置 mybatis.typeAliasesPackage=com.xj.demo.model mybatis.mapper-locations=classpath:mapper/*.xml
- 在resources文件下，创建文件夹mapper,并创建User_infoMapper.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xj.demo.mapper.User_infoMapper">
<!---查询列表-->
<select id="selectList" resultType="User_info">
select * from User_info
</select>
<!-- 增加 -->
<insert id="addUser" parameterType="com.xj.demo.model.User_info">
INSERT INTO user_info
(id,uname,create_time)
VALUES
(#{id},#{uname},#{create_time})
</insert>
<!-- 修改 -->
<update id="editUser" parameterType="com.xj.demo.model.User_info" >
update user_info set uname=#{uname},create_time=#{create_time}
where id=#{id}
</update>
<!-- 删除 -->
<delete id="delUser" parameterType="java.lang.String" >
delete from user_info
where id=#{id}
</delete>
</mapper>
- config、controller、mapper、model、service包下代码如下
Swagger3Config 接口swagger类，需要在pom.xml文件中，添加引用
<!-- swagger3.0 --> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-boot-starter</artifactId> <version>3.0.0</version> </dependency>
package com.xj.demo.config; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.Contact; 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; @Configuration public class Swagger3Config { @Bean public Docket createRestApi() { return new Docket(DocumentationType.OAS_30) .apiInfo(apiInfo()) .select() .apis(RequestHandlerSelectors.withMethodAnnotation(ApiOperation.class)) .paths(PathSelectors.any()) .build(); } private ApiInfo apiInfo() { return new ApiInfoBuilder() .title("Swagger3接口文档") .description("更多请咨询服务开发者Ray。") .version("1.0") .build(); } }
model类
package com.xj.demo.model; import java.util.Date; public class User_info { private String id; private String uname; private Date create_time; public String getId() { return id; } public void setId(String id) { this.id = id; } public String getName() { return uname; } public void setName(String name) { this.uname = name; } public Date getCreate_time() { return create_time; } public void setCreate_time(Date name) { this.create_time = name; } }
User_infoMapper接口类
package com.xj.demo.mapper; import com.xj.demo.model.User_info; import org.apache.ibatis.annotations.Mapper; import java.util.List; @Mapper public interface User_infoMapper { // 查询列表 public List<User_info> selectList(); //添加 public int addUser(User_info user); //修改 public int editUser(User_info user); //删除 public int delUser(String id); }
User_infoService类
package com.xj.demo.service; import com.xj.demo.mapper.User_infoMapper; import com.xj.demo.model.User_info; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service public class User_infoService implements User_infoMapper { @Autowired private User_infoMapper uMapper; @Override public List<User_info> selectList() { return uMapper.selectList(); } @Override public int addUser(User_info user) { return uMapper.addUser(user); } @Override public int editUser(User_info user) { return uMapper.editUser(user); } @Override public int delUser(String id) { return uMapper.delUser(id); } }
controller类
package com.xj.demo.controller; import com.xj.demo.model.User_info; import com.xj.demo.service.User_infoService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import springfox.documentation.oas.annotations.EnableOpenApi; import java.util.Date; import java.util.List; import java.util.UUID; @Api(tags = "用户信息管理") @RestController @RequestMapping("/user") public class User_infoController { @Autowired private User_infoService userService; @ApiOperation("测试接口") @GetMapping("/hello") public String hello() { return "hello"; } @ApiOperation("增加用户") @PostMapping("/addUser") public int addUser( @RequestBody User_info user){ user.setCreate_time(new Date()); user.setId(UUID.randomUUID().toString()); return userService.addUser(user); } @ApiOperation("删除用户") @PostMapping("/delUser") public int delUser( @RequestBody String id){ return userService.delUser(id); } @ApiOperation("修改用户") @PostMapping("/editUser") public int editUser( @RequestBody User_info user){ user.setCreate_time(new Date()); return userService.editUser(user); } @ApiOperation("查询列表") @GetMapping("/selectList") public List<User_info> selectList() { return userService.selectList(); } }
DemoApplication 类
package com.xj.demo; import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import springfox.documentation.oas.annotations.EnableOpenApi; @EnableOpenApi //swagger3.0 @SpringBootApplication @MapperScan("com.xj.demo.mapper") public class DemoApplication { public static void main(String[] args) { SpringApplication.run(DemoApplication.class, args); } }
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 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.3.3.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.xj</groupId> <artifactId>demo</artifactId> <version>0.0.1-SNAPSHOT</version> <name>demo</name> <description>Demo project for Spring Boot</description> <properties> <java.version>1.8</java.version> <kotlin.version>1.4.0</kotlin.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>2.1.3</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-test</artifactId> <scope>test</scope> <exclusions> <exclusion> <groupId>org.junit.vintage</groupId> <artifactId>junit-vintage-engine</artifactId> </exclusion> </exclusions> </dependency> <!-- swagger3.0 --> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-boot-starter</artifactId> <version>3.0.0</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <version>2.2.8.RELEASE</version> </plugin> <plugin> <groupId>org.jetbrains.kotlin</groupId> <artifactId>kotlin-maven-plugin</artifactId> <version>${kotlin.version}</version> <executions> <execution> <id>compile</id> <phase>compile</phase> <goals> <goal>compile</goal> </goals> </execution> <execution> <id>test-compile</id> <phase>test-compile</phase> <goals> <goal>test-compile</goal> </goals> </execution> </executions> <configuration> <jvmTarget>1.8</jvmTarget> </configuration> </plugin> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <executions> <execution> <id>compile</id> <phase>compile</phase> <goals> <goal>compile</goal> </goals> </execution> <execution> <id>testCompile</id> <phase>test-compile</phase> <goals> <goal>testCompile</goal> </goals> </execution> </executions> </plugin> </plugins> </build> </project>
最后在url输入http://localhost:8080/swagger-ui/index.html，查看效果
使用PostMan测试接口，效果：
源码下载：https://download.csdn.net/download/haojuntu/12717787