1. 快速搭建 Spring Boot 项目
通过 Spring Initializr(https://start.spring.io/)快速生成项目,勾选以下依赖:
- Spring Web(Web 开发)
- MyBatis-Plus(简化数据库操作)
- MySQL Driver(MySQL 驱动)
- Lombok(简化实体类代码)
2. 核心代码实现
(1)数据库配置(application.yml)
yaml
spring:
datasource:
url: jdbc:mysql://localhost:3306/uniapp_demo?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
mybatis-plus:
mapper-locations: classpath:mapper/*.xml
type-aliases-package: com.example.demo.entity
configuration:
map-underscore-to-camel-case: true # 下划线转驼峰
server:
port: 8080 # 后端端口
(2)实体类(User.java)
java
运行
package com.example.demo.entity;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import java.time.LocalDateTime;
@Data // Lombok注解,自动生成get/set/toString
@TableName("user") // 对应数据库表名
public class User {
@TableId(type = IdType.AUTO) // 主键自增
private Long id;
private String username; // 用户名
private String password; // 密码(实际项目需加密)
private String phone; // 手机号
private LocalDateTime createTime; // 创建时间
}
(3)Mapper 层(UserMapper.java)
java
运行
package com.example.demo.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.entity.User;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface UserMapper extends BaseMapper<User> {
// 继承BaseMapper后,无需编写基础CRUD代码
}
(4)Service 层(UserService.java)
java
运行
package com.example.demo.service;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.demo.entity.User;
import com.example.demo.mapper.UserMapper;
import org.springframework.stereotype.Service;
@Service
public class UserService extends ServiceImpl<UserMapper, User> {
// 基础CRUD已继承,可自定义业务方法
public User getUserByUsername(String username) {
return lambdaQuery().eq(User::getUsername, username).one();
}
}
(5)Controller 层(UserController.java)
java
运行
package com.example.demo.controller;
import com.example.demo.entity.User;
import com.example.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.List;
@RestController
@RequestMapping("/api/user")
@CrossOrigin // 解决跨域问题(生产环境建议配置全局跨域)
public class UserController {
@Autowired
private UserService userService;
// 新增用户
@PostMapping("/add")
public boolean addUser(@RequestBody User user) {
return userService.save(user);
}
// 根据用户名查询用户
@GetMapping("/getByUsername")
public User getUserByUsername(@RequestParam String username) {
return userService.getUserByUsername(username);
}
// 查询所有用户
@GetMapping("/list")
public List<User> getUserList() {
return userService.list();
}
}
