Springboot+Mybatis+Clickhouse+jsp 搭建单体应用项目(三)(添加增删改查)
- 2020 年 8 月 4 日
- 筆記
- ClickHouse
一、添加增加接口


1 @ApiResponses(value = { 2 @ApiResponse(code = 200, message = "接口返回成功状态"), 3 @ApiResponse(code = 500, message = "接口返回未知错误,请联系开发人员调试") 4 }) 5 @ApiOperation(value = "新增数据", notes = "访问此接口,返回hello语句,测试接口") 6 @PostMapping(value = "/insertSelective") 7 public void insertSelective(@RequestBody UserInfo userInfo) { 8 userInfoService.insertSelective(userInfo); 9 }
View Code
二、修改接口


1 @ApiResponses(value = { 2 @ApiResponse(code = 200, message = "接口返回成功状态"), 3 @ApiResponse(code = 500, message = "接口返回未知错误,请联系开发人员调试") 4 }) 5 @ApiOperation(value = "修改数据", notes = "访问此接口,返回hello语句,测试接口") 6 @PostMapping(value = "/updateByPrimaryKeySelective") 7 public void updateByPrimaryKeySelective(@RequestBody UserInfo userInfo) { 8 userInfoService.updateByPrimaryKeySelective(userInfo); 9 }
View Code
三、查询接口


1 @ApiResponses(value = { 2 @ApiResponse(code = 200, message = "接口返回成功状态"), 3 @ApiResponse(code = 500, message = "接口返回未知错误,请联系开发人员调试") 4 }) 5 @ApiOperation(value = "按条件查询", notes = "访问此接口,返回hello语句,测试接口") 6 @PostMapping(value = "/selectByStudentSelective") 7 public List<UserInfo> selectByStudentSelective(@RequestBody UserInfo userInfo) throws ServletException, IOException { 8 9 return userInfoService.selectByStudentSelective(userInfo); 10 }
View Code
四、删除数据


1 @ApiResponses(value = { 2 @ApiResponse(code = 200, message = "接口返回成功状态"), 3 @ApiResponse(code = 500, message = "接口返回未知错误,请联系开发人员调试") 4 }) 5 @ApiOperation(value = "删除数据", notes = "访问此接口,返回hello语句,测试接口") 6 @PostMapping(value = "/removeUser") 7 public int removeUser(@RequestBody UserInfo userInfo) { 8 return userInfoService.removeUser(userInfo); 9 }
View Code
五、注意
其中,删除和修改的语法跟mysql和oracle略有不同,请注意
六、源码
//gitee.com/liuyangfirst/springboot-clickhouse.git