package com.moral.api.controller; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.moral.api.entity.Test; import com.moral.api.service.TestService; import com.moral.api.util.CacheUtils; import com.moral.constant.ResultMessage; import com.moral.redis.RedisUtil; import com.moral.util.PageResult; import com.moral.util.TokenEncryptUtils; import com.moral.util.TokenUtils; import io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.kafka.core.KafkaTemplate; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.io.*; @Slf4j @Api(tags = {"大屏"}) @RestController @RequestMapping("/api") public class TestController { @Resource private KafkaTemplate kafkaTemplate; @Resource private TestService testService; /** * name 姓名 * email 郵箱 * mobile 手機號 */ @ApiOperation(value = "测试插入", notes = "测试插入") @RequestMapping(value = "/saveTest", method = RequestMethod.POST) public ResultMessage save() { Test test = new Test(); test.setEmail("test@qq.com"); test.setName("name"); test.setMobile("13965898745"); testService.save(test); return ResultMessage.ok(); } /** * page 當前頁 * size 每頁大小 */ @ApiOperation(value = "分頁", notes = "分頁") @ApiImplicitParams({ @ApiImplicitParam(name = "page", value = "當前頁數", required = true, paramType = "path", dataType = "Int"), @ApiImplicitParam(name = "size", value = "每頁大小", required = true, paramType = "path", dataType = "Int") }) @RequestMapping(value = "search/{page}/{size}", method = RequestMethod.GET) public ResultMessage findBypage(@PathVariable("page") Integer page, @PathVariable("size") Integer size) { log.info("page is:" + page + " size is:" + size); //根据条件分页查询 Page userPage = testService.selectByPage(null, page, size); //封装分页返回对象 PageResult pageResult = new PageResult<>( userPage.getTotal(), userPage.getPages(), userPage.getRecords() ); //返回数据 return ResultMessage.ok(pageResult); } /** * redis測試 */ @ApiOperation(value = "redis測試", notes = "redis測試") @RequestMapping(value = "redis", method = RequestMethod.GET) public ResultMessage testRedis() { RedisUtil.set("redistest", "test"); return ResultMessage.ok(RedisUtil.get("redistest")); } /** * 事務 */ @ApiOperation(value = "事務測試", notes = "事務測試") @RequestMapping(value = "saveTest", method = RequestMethod.GET) public ResultMessage saveTest() throws Exception { testService.saveTest(); return ResultMessage.ok(); } /** * kafka測試 */ @ApiOperation(value = "kafka測試", notes = "kafka測試") @ApiImplicitParams({ @ApiImplicitParam(name = "token", value = "token", required = true, paramType = "header", dataType = "String") }) @RequestMapping(value = "kafkaTest", method = RequestMethod.GET) public void kafkaTest() { kafkaTemplate.send("test_topic", "{'mac': 'p5dnd1234567','DataTime':1623058244104,'e1':10,'e2':20,'ver':2}"); } @GetMapping("testToken") public void testToken() { String decoded = TokenEncryptUtils.decoded("5b53480d4e570b54565f555775"); String decoded2 = TokenEncryptUtils.decoded("584f560a49510f5453515453"); System.out.println(decoded); System.out.println(decoded2); } public static void main(String[] args) throws IOException { String path = "C:\\Users\\cdl\\Desktop\\province.txt"; BufferedReader fis = new BufferedReader(new FileReader(path)); BufferedWriter writer = new BufferedWriter(new FileWriter("C:\\Users\\cdl\\Desktop\\provin1ce.txt")); String line = ""; while ((line = fis.readLine()) != null) { //获取code StringBuilder str = new StringBuilder(line); String code = str.substring(31, 37); //获取名称 char[] chars = line.toCharArray(); int i = 0; StringBuilder buffered = new StringBuilder(); for (char aChar : chars) { if (aChar == '\'') i++; if (i == 1) { buffered.append(aChar); } } buffered.append('\''); String name = buffered.toString(); //获取父级code line.trim(); char[] chars1 = line.toCharArray(); int j = 0; StringBuilder buffered2 = new StringBuilder(); for (char c : chars1) { if (j == 6) { buffered2.append(c); } if (c == ',') j++; } StringBuilder parentCode = buffered2.deleteCharAt(buffered2.length() - 1); //写入 writer.write("INSERT INTO `sys_area` VALUES (" + code + "," + name + "," + parentCode + ");"); writer.newLine(); } writer.close(); fis.close(); } }