springboot整合其他技术栈（redis缓存，mongodb，exsyexcel，Mybatis-plus）

package com.yy.controller; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.date.DateUtil; import cn.hutool.core.date.Quarter; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yy.dao.TestUserDao; import com.yy.enums.ResponseEnum; import com.yy.pojo.TestUser; import com.yy.service.Impl.TestUserServiceImpl; import com.yy.service.TestUserService; import com.yy.utils.R; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.dao.DuplicateKeyException; import org.springframework.util.StreamUtils; import org.springframework.util.StringUtils; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.*; /** * @author young * @date 2022/8/26 9:36 * @description: */ @Slf4j @RestController @RequestMapping("/mysql") public class TestUserController { private static final DateFormat dataFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); @Autowired private TestUserServiceImpl testUserService; @Autowired private TestUserDao Mapper; /* 自主测试 */ @GetMapping("/test/{id}") public R<Boolean> test(@PathVariable Integer id){ return R.ok(testUserService.tests(id)); } /** * 增加一个test用户 * * @param testUser * @return */ @PostMapping("/addOne") public R<Boolean> addUser(TestUser testUser) { boolean save = testUserService.save(testUser); return R.ok(save); } /** * 批量添加test用户 * * @param * @return */ @PostMapping("/addMore") public R<Boolean> addBatch() { List<TestUser> list = new ArrayList<>(); TestUser user1 = new TestUser("黎治跃", true, "韩家墩五号", new Date()); TestUser user2 = new TestUser("李帅", false, "李家墩号", new Date()); TestUser user3 = new TestUser("刘超琪", false, "刘家墩五号", new Date()); TestUser user4 = new TestUser("刘亮", true, "刘家墩号", new Date()); list.add(user1); list.add(user2); list.add(user3); list.add(user4); boolean b = testUserService.saveBatch(list); return R.ok(b); } /** * 通过删除一个用户 * * @param id * @return */ @DeleteMapping("/deleteOne/{id}") public R<Boolean> removeUser(@PathVariable Integer id) { boolean remove = testUserService.removeById(id); return R.ok(remove); } /** * 批量删除指定id的数据 * * @param * @return */ @DeleteMapping("/deleteMore/{ids}") public R<Boolean> deleteBatch(@PathVariable("ids") Integer... ids) { List<Integer> list = Arrays.asList(ids); boolean batch = testUserService.removeBatchByIds(list); return R.ok(batch); } /** * 更新指定id的信息 * * @param id * @return */ @PostMapping("/updateOne/{id}") public R<Boolean> updateOne(@RequestParam Integer id) { TestUser user = new TestUser(id); user.setName("张三").setSex(false).setAddress("北京朝阳路5号").setCreateTime(new Date()); boolean b = testUserService.updateById(user); return R.ok(b); } /** * 查找指定id信息 * * @param id * @return */ @GetMapping("/getOne/{id}") public R<TestUser> selectOne(@PathVariable Integer id) { TestUser user = testUserService.getById(id); return R.ok(user); } /** * 返回所有数据 * * @return */ @GetMapping("/getAll") public R<List<TestUser>> getAll() { return R.ok(testUserService.list()); } /** * 查找多条消息 * * @param ids * @return */ @GetMapping("/getMore/{ids}") public R<List<TestUser>> selectMore(@PathVariable Integer... ids) { List<TestUser> testUsers = testUserService.listByIds(Arrays.asList(ids)); return R.ok(testUsers); } /** * 查询name中包含inName，sex为inSex的信息，并只返回id，name，sex * * @param inName 输入的name * @param inSex 输入的sex * @return */ @GetMapping("/likeSelect/{num}/{sex}") public R<List<TestUser>> likeSelect(@PathVariable("num") Integer inName, @PathVariable("sex") Boolean inSex) { QueryWrapper<TestUser> wrapper = new QueryWrapper<>(); wrapper.select("id", "name", "sex").like("name", inName).in("sex", inSex); List<TestUser> list = testUserService.list(wrapper); return R.ok(list); } /** * 返回地址中包含的数字并且输入id大于一定数或者createTime为空的数据 * * @param inId 指定id * @param address 地址包含的数 * @return */ @GetMapping("getLike/{id}/{num}") public R<List<TestUser>> getLike(@PathVariable("id") Integer inId, @PathVariable("num") Integer address) { QueryWrapper<TestUser> wrapper = new QueryWrapper<>(); wrapper.like("address", address).and(wq -> wq.isNull("createTime").or().ge("id", inId)); return R.ok(testUserService.list(wrapper)); } /** * 多条件匹配 * * @param objName 输入指定的名字 * @param sex 输入指定的性别 * @return */ @GetMapping("/AllEq/{name}/{sex}") public R<List<TestUser>> allEq(@PathVariable("name") Object objName, @PathVariable("sex") Boolean sex) { QueryWrapper<TestUser> wrapper = new QueryWrapper<>(); Map<String, Object> map = new HashMap<>(); map.put("name", objName); map.put("sex", sex); wrapper.allEq(map); return R.ok(testUserService.list(wrapper)); } /** * 把查询条件按map形式展现出来 * * @param mName 输入指定的名字 * @param mSex 输入指定的性别 * @return */ @GetMapping("/map/{name}/{sex}") public R<List<Map<String, Object>>> map(@PathVariable("name") Object mName, @PathVariable("sex") Boolean mSex) { QueryWrapper<TestUser> wrapper = new QueryWrapper<>(); wrapper.like("name", mName).in("sex", mSex); System.out.println("maps测试如下：" + "\n"); List<Map<String, Object>> maps = testUserService.listMaps(wrapper); maps.forEach(System.out::println); return R.ok(maps); } /** * objs测试 * @param name * @param address * @return 符合条件的id集合 */ @GetMapping("/objs/{name}/{address}") public R<List<Object>> objs(@PathVariable("name") Object name, @PathVariable("address") Object address) { QueryWrapper<TestUser> wrapper = new QueryWrapper<>(); wrapper.like("name", name).like("address", address); System.out.println("objs测试如下：" + "\n"); List<Object> objects = testUserService.listObjs(wrapper); objects.forEach(System.out::println); return R.ok(objects); } /** * lambda测试 * * @param sex 指定性别 * @param address 指定地址 * @return */ @GetMapping("/lambda/{sex}/{address}") public R<List<TestUser>> lambdaTest(@PathVariable Boolean sex, @PathVariable Object address) { Lambd