1.简介
此次博客主要记录搭建Springboot框架及代码规范
需求: 成功与数据库交互
整合 Mybatis-plus
1.项目结构
项目需要引入Maven依赖,在 pom.xml中配置好
文件配置如下
- application.yml 写入数据库配置
server:
port: 8080 服务启动端口号
spring:
datasource:
url: jdbc:mysql://fitmgr-mysql:3306/java?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8
Mysql数据库端口号为3306 数据库名称为java
username: root
password: root 配置用户名和密码
driver-class-name: com.mysql.jdbc.Driver
type: com.zaxxer.hikari.HikariDataSource
typeAliasesPackage: com.example.demo.entity
mapper目录—UserMapper.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.example.demo.Mapper.UserMapper">
</mapper>
写入mapper文件所在位置
2. 各个包作用
- controller 路由层,写入交互路径
- entity 数据库表结构 写入数据库表字段
- mapper 工具接口
- request 封装请求实体类
- service
-impl 实际业务代码
原始接口--抽象接口继承Isevice
3.代码
UserService 抽象接口
public interface UserService extends IService<User> {
User getid(String uid);
User create_user(UserCreate userCreate);
}
UserMapper–工具
@Component
public interface UserMapper extends BaseMapper<User> {
}
User–数据库表结构
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
public class User implements Serializable {
private static final long serialVersionUID = 1L;
@TableId(value = "uid", type = IdType.INPUT)
private String uid;
private String name;
private String status;
}
UserCreate–实体类
@Data
public class UserCreate {
private String uid;
private String name;
private String status;
}
UserController–控制层
@Data
@RestController
public class UserController {
@Autowired
private UserServiceImpl ll;
@GetMapping("/findid/{uid}")
public User getID(@PathVariable String uid) {
return ll.getid(uid);
}
@PostMapping("/create")
public User create(@RequestBody UserCreate userCreate) {
return ll.create_user(userCreate);
}
}
UserServiceimpl–业务层
@Data
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
public User getid(String uid) {
User user = getById(uid);
return user;
}
public User create_user(UserCreate userCreate) {
User user = new User();
user.setUid(userCreate.getUid());
user.setName(userCreate.getName());
user.setStatus(userCreate.getStatus());
this.save(user);
return user;
}
}
启动类加入
@MapperScan(value = "com.example.demo.Mapper") mapper注入
服务就通了