第一次使用Java搭项目，Spring boot＋MyBatis-Plus＋MySQL

新增项目

注意添加Type需要选择Maven，Java对应的版本要选择正确

直接下一步

打开项目结构如图

pom.xml添加依赖mybatis-plus，mysql，lombok，druid

com.baomidoumybatis-plus-boot-starter3.3.1com.alibabadruid1.1.22mysqlmysql-connector-java8.0.33org.projectlomboklombok

完整文件内容

4.0.0

org.springframework.bootspring-boot-starter-parent2.7.12com.exampledemo0.0.1-SNAPSHOTdemoDemo project for Spring Boot

1.8org.springframework.bootspring-boot-starterorg.springframework.bootspring-boot-starter-testtestorg.springframework.bootspring-boot-starter-webcom.baomidoumybatis-plus-boot-starter3.3.1com.alibabadruid1.1.22mysqlmysql-connector-java8.0.11org.projectlomboklombok

org.springframework.bootspring-boot-maven-plugin

添加完成后更新

修改application文件

server: port: 8088 spring: devtools: restart: enabled: true #??????? additional-paths: src/main/java #???? exclude: WEB-INF freemarker: cache: false #?????????????? datasource: # ????? url: jdbc:mysql://数据库地址:3306/连接库名?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8 # ??????? # driver-class-name: com.mysql.cj.jdbc.Driver # ????? username: 账号 # ??? password: 密码

开始编写接口

entity目录下添加文件User.java

entity编写数据库表映射

package com.example.demo.entity; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; @Data @TableName("auth_user") public class User { private Long id; private String username; private String email; private String password; }

mapper目录下添加文件UserMapper.java

mapper对应表编写数据库操作的

package com.example.demo.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.example.demo.entity.User; public interface UserMapper extends BaseMapper { }

Controller目录下添加文件UserController.java

可能是写接口的或者写逻辑的

package com.example.demo.Controller; import com.example.demo.entity.User; import com.example.demo.mapper.UserMapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; @RestController @RequestMapping("/test") public class HomeController { @Autowired private UserMapper userMapper; @PostMapping("/user") public Map user(@RequestBody Map param){ Map map = new HashMap(); List users = userMapper.selectList(null); map.put("data",users); return map; } //详情接口 @GetMapping("/user/") public Map userDetail(@PathVariable("id") Long id){ // 校验id是否合法 if (id 查询用户详情 User user = userMapper.selectById(id); // 封装结果并返回 return Result.succeed(user); } }

添加通用的响应

package com.example.demo.config; import java.util.HashMap; import java.util.Map; public class Result { public static Map succeed(Object data) { Map map = new HashMap (); map.put("code", 200); map.put("msg", "success"); map.put("data", data); return map; } public static Map fail(int code, String msg) { Map map = new HashMap(); map.put("code", code); map.put("msg", msg); return map; } }

修改运行文件，添加@MapperScan(“com.example.demo.mapper”)

点击运行后出现如下页面运行成功

用postman调接口试试

现在可以开心的撸代码了