| | |
| | | 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 org.springframework.web.bind.annotation.*; |
| | | |
| | | import javax.annotation.Resource; |
| | | |
| | | import java.io.*; |
| | | |
| | | |
| | |
| | | |
| | | @Resource |
| | | private TestService testService; |
| | | |
| | | /** |
| | | * name 姓名 |
| | | * email 郵箱 |
| | |
| | | */ |
| | | @ApiOperation(value = "测试插入", notes = "测试插入") |
| | | @RequestMapping(value = "/saveTest", method = RequestMethod.POST) |
| | | public ResultMessage save() { |
| | | public ResultMessage save() { |
| | | |
| | | Test test=new Test(); |
| | | Test test = new Test(); |
| | | test.setEmail("test@qq.com"); |
| | | test.setName("name"); |
| | | test.setMobile("13965898745"); |
| | |
| | | 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") |
| | | @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); |
| | | log.info("page is:" + page + " size is:" + size); |
| | | //根据条件分页查询 |
| | | Page<Test> userPage = testService.selectByPage(null, page, size); |
| | | //封装分页返回对象 |
| | | PageResult<Test> pageResult = new PageResult<>( |
| | | userPage.getTotal(), userPage.getPages(),userPage.getRecords() |
| | | userPage.getTotal(), userPage.getPages(), userPage.getRecords() |
| | | ); |
| | | //返回数据 |
| | | return ResultMessage.ok(pageResult); |
| | | return ResultMessage.ok(pageResult); |
| | | } |
| | | |
| | | |
| | |
| | | @ApiOperation(value = "redis測試", notes = "redis測試") |
| | | @RequestMapping(value = "redis", method = RequestMethod.GET) |
| | | public ResultMessage testRedis() { |
| | | RedisUtil.set("redistest","test"); |
| | | RedisUtil.set("redistest", "test"); |
| | | return ResultMessage.ok(RedisUtil.get("redistest")); |
| | | |
| | | } |
| | |
| | | */ |
| | | @ApiOperation(value = "事務測試", notes = "事務測試") |
| | | @RequestMapping(value = "saveTest", method = RequestMethod.GET) |
| | | public ResultMessage saveTest() throws Exception{ |
| | | 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","test111111111111111"); |
| | | kafkaTemplate.send("test_topic", "{'mac': 'p5dnd1234567','DataTime':1623058244104,'e1':10,'e2':20,'ver':2}"); |
| | | } |
| | | |
| | | @GetMapping("testToken") |
| | | public void testToken(){ |
| | | public void testToken() { |
| | | String decoded = TokenEncryptUtils.decoded("5b53480d4e570b54565f555775"); |
| | | String decoded2 = TokenEncryptUtils.decoded("584f560a49510f5453515453"); |
| | | System.out.println(decoded); |
| | |
| | | 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){ |
| | | while ((line = fis.readLine()) != null) { |
| | | //获取code |
| | | StringBuilder str = new StringBuilder(line); |
| | | String code = str.substring(31, 37); |
| | |
| | | int i = 0; |
| | | StringBuilder buffered = new StringBuilder(); |
| | | for (char aChar : chars) { |
| | | if(aChar=='\'') |
| | | i ++; |
| | | if(i==1){ |
| | | if (aChar == '\'') |
| | | i++; |
| | | if (i == 1) { |
| | | buffered.append(aChar); |
| | | } |
| | | } |
| | |
| | | int j = 0; |
| | | StringBuilder buffered2 = new StringBuilder(); |
| | | for (char c : chars1) { |
| | | if(j==6){ |
| | | if (j == 6) { |
| | | buffered2.append(c); |
| | | } |
| | | if(c==',') |
| | | if (c == ',') |
| | | j++; |
| | | } |
| | | StringBuilder parentCode = buffered2.deleteCharAt(buffered2.length() - 1); |
| | | //写入 |
| | | writer.write("INSERT INTO `sys_area` VALUES ("+code+","+name+","+parentCode+");"); |
| | | writer.write("INSERT INTO `sys_area` VALUES (" + code + "," + name + "," + parentCode + ");"); |
| | | writer.newLine(); |
| | | } |
| | | |