基于SpringBoot与MyBatis实现简单的CURD操作
- 一.必要配置
- 二.CRUD操作
- 前端代码
- 控制层代码
- 服务层代码
- 持久层代码
一.必要配置 ① 创建XX_DB数据库并创建数据表user_tb,定义userName与password字段
②Idea创建Spring Initializr工程,导入所需依赖
③导入Druid连接池,在resources文件下创建application.yaml文件来配置数据源
I.Maven中导入连接池依赖
com.alibaba druid-spring-boot-starter1.1.17
II.Maven中导入mysql驱动依赖
mysql mysql-connector-java
III.Maven中导入第三方类库hutool依赖(生成验证码需要)
cn.hutool hutool-all5.8.1
VI.yaml文件中进行数据源的配置
spring:
datasource:
url: jdbc:mysql://localhost:3306/XX_DB
username: root
password: 123456
driver-class-name: com.mysql.jdbc.Driver
④文件结构
二.CURD操作 2.1 添加操作 浏览器输入用户名和密码,数据将保存到mysql数据库中
1. 前端代码:index.html
CRUD首页
addUser-Test
getUser-Test
deleteUser-Test
updateUser-Test
文件上传-Test
验证码-Test
2 控制层代码:UserController
package com.allin.controller;
import com.allin.pojo.User;
import com.allin.service.IService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import java.io.File;
import java.io.IOException;
@RestController
public class UserController {
@Autowired
private IService iService;
@PostMapping("/addUser")
public User addUser(User user){
iService.addUser(user);
return user;
}
@PostMapping("/getUser")
public User getUser(String userName){
User user = iService.getUser(userName);
return user;
}
@DeleteMapping("/deleteUser")
public String deleteUser(String userName){
iService.deleteUser(userName);
return userName;
}
@PutMapping("/updateUser")
public User UserName(User user){
User user1 = iService.updateUser(user);
return user;
}
@PostMapping("/upload")
public String upload(@RequestParam("headerImg")MultipartFile headerImg) throws IOException {
if(!headerImg.isEmpty()){
//保存到文件服务器,OSS服务器
String originalFilename = headerImg.getOriginalFilename();
headerImg.transferTo(new File("D:\2022learn\CRUDTest\src\main\resources\images\"+originalFilename));
}
return "success";
}
@GetMapping("/verify")
public void Verify(HttpServletResponse response) throws IOException {
//定义图形验证码的长、宽、验证码字符数、干扰线宽度
ShearCaptcha captcha = CaptchaUtil.createShearCaptcha(400, 100, 4, 4);
//图形验证码写出,可以写出到文件,也可以写出到流
//captcha.write("D:/shear.png");
captcha.write(response.getOutputStream());
//验证图形验证码的有效性,返回boolean值
captcha.verify("1234");
}
}
3 服务层代码:IService、UserService IService.java
package com.allin.service;
import com.allin.pojo.User;
public interface IService {
public void addUser(User user);
public User getUser(String userName);
public void deleteUser(String userName);
public User updateUser(User user);
}
package com.allin.service;
import com.allin.pojo.User;
public interface IService {
public void addUser(User user);
public User getUser(String userName);
public void deleteUser(String userName);
public User updateUser(User user);
}
UserService.java
package com.allin.service.Impl;
import com.allin.mapper.AddUserMapper;
import com.allin.mapper.DeleteUserMapper;
import com.allin.mapper.GetUserMapper;
import com.allin.mapper.UpdateUserMapper;
import com.allin.pojo.User;
import com.allin.service.IService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class UserService implements IService {
@Autowired
AddUserMapper addUserMapper;
@Autowired
GetUserMapper getUserMapper;
@Autowired
DeleteUserMapper deleteUserMapper;
@Autowired
UpdateUserMapper updateUserMapper;
@Override
public void addUser(User user) {
addUserMapper.insert(user);
}
@Override
public User getUser(String userName) {
return getUserMapper.get(userName);
}
@Override
public void deleteUser(String userName) {
deleteUserMapper.delete(userName);
}
@Override
public User updateUser(User user) {
updateUserMapper.update(user);
return getUserMapper.get(user.getUserName());
}
}
4 持久层代码 AddUserMapper
@Mapper
public interface AddUserMapper {
@Insert("insert into user values (#{userName},#{password})")
@Options(useGeneratedKeys = true,keyProperty = "id")
public void insert(User user);
}
DeleteUserMapper
@Mapper
public interface DeleteUserMapper {
@Delete("delete from user where userName = #{userName}")
public void delete(String userName);
}
GetUserMapper
@Mapper
public interface GetUserMapper {
@Select("select * from user where userName = #{userName}")
public User get(String userName);
}
UpdateUserMapper
@Mapper
public interface UpdateUserMapper {
@Update("update user set password = #{password} where userName = #{userName} ")
public void update(User user);
}



