方法1 add方法：新增已录
@PostMapping("/add") public Result add(@RequestBody News news) { newsService.save(news); return Result.success(); }
方法2 修改用户信息 /update已录
@PutMapping("/update") public Result update(@RequestBody News news) { newsService.updateById(news); return Result.success(); }
方法3 删除信息 /delete/{id} 已录
@DeleteMapping("/delete/{id}") public Result delete(@PathVariable Integer id) { newsService.removeById(id); return Result.success(); }
方法4 批量删除用户信息，查询全部用户信息 /delete/batch ，查询全部selectAll
@DeleteMapping("/delete/batch") public Result batchDelete(@RequestBody List<Integer> ids) { newsService.removeBatchByIds(ids); return Result.success(); }
方法5 查询全部信息 / selectAll
@GetMapping("/selectAll") public Result selectAll() { List<News> userList = newsService.list(new QueryWrapper<News>().orderByDesc("id")); return Result.success(userList); }
方法6根据ID查询信息 /selectById/{id}
方法6多条件模糊查询信息 ,/selectByPage
接口模板
package zero.file.videoProject.controller; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import zero.file.videoProject.bean.News; import zero.file.videoProject.bean.Result; import zero.file.videoProject.service.NewsService; import java.util.List; @CrossOrigin @RestController @RequestMapping("/news") public class NewsController { @Autowired NewsService newsService; // 新增信息 @PostMapping("/add") public Result add(@RequestBody News news) { newsService.save(news); return Result.success(); } // 修改用户信息 @PutMapping("/update") public Result update(@RequestBody News news) { newsService.updateById(news); return Result.success(); } /** * 删除信息 */ @DeleteMapping("/delete/{id}") public Result delete(@PathVariable Integer id) { newsService.removeById(id); return Result.success(); } @DeleteMapping("/delete/batch") public Result batchDelete(@RequestBody List<Integer> ids) { newsService.removeBatchByIds(ids); return Result.success(); } /** * 查询全部信息 */ @GetMapping("/selectAll") public Result selectAll() { List<News> userList = newsService.list(new QueryWrapper<News>().orderByDesc("id")); return Result.success(userList); } // 根据ID查询信息 @GetMapping("/selectById/{id}") public Result selectById(@PathVariable Integer id) { News news = newsService.getById(id); return Result.success(news); } @GetMapping("/selectByPage") public Result selectByPage(@RequestParam Integer pageNum, @RequestParam Integer pageSize, @RequestParam String title) { QueryWrapper<News> queryWrapper = new QueryWrapper<News>().orderByDesc("id"); // 默认倒序，让最新的数据在最上面 queryWrapper.like(StrUtil.isNotBlank(title), "title", title); Page<News> page = newsService.page(new Page<>(pageNum, pageSize), queryWrapper); return Result.success(page); } }
page和QueryWrapper编写
使用前先要添加依赖
第一步添加依赖
<dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.5.3.2</version> </dependency>
视频资源:16. SpringBoot+Vue管理系统实现增删改查
【带小白做毕设】16. SpringBoot+Vue管理系统实现增删改查_哔哩哔哩_bilibili
第二步 加注解使用 @TableName("sys_user")表名称,两个，id放到了
@TableId(type= IdType.AUTO)
mybatisplus在做分页查询的时候要添加一个插件：
要添加一个MybatisConfig
package zero.file.videoProject.config; import com.baomidou.mybatisplus.annotation.DbType; import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor; import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor; import org.mybatis.spring.annotation.MapperScan; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; @Configuration @MapperScan("zero.file.videoProject.mappers") public class MybatisPlusConfig { /** * 添加分页插件 */ @Bean public MybatisPlusInterceptor mybatisPlusInterceptor() { MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor(); interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));//如果配置多个插件,切记分页最后添加 return interceptor; } }
第三步 添加依赖
<dependency> <groupId>cn.hutool</groupId> <artifactId>hutool-all</artifactId> <version>5.8.18</version> </dependency>
