springboot + vue3 ,想要实现分页加条件查询,post请求,前端的参数传不到后端,改用get请求可以

为post请求时,后端service层和controller层代码如下

//service层
@Override
public Page<User> getAllusersByPage(String username, Integer current, Integer size) {
    QueryWrapper<User> queryWrapper = new QueryWrapper<>();
    queryWrapper.like("username",username);
    Long count = userDao.selectCount(queryWrapper);
    return userDao.selectPage(new Page<>(current,size,count),queryWrapper);
}

//controller层
@RestController
@CrossOrigin(origins = {"*"})
@RequestMapping("/user")
public class UserController {

    @Autowired
    private UserService userService;

    @RequestMapping(value = "/userList")
    public JsonResponsePojo userList(@RequestParam(defaultValue = "") String username,
                                     @RequestParam(defaultValue = "1") Integer current,
                                     @RequestParam(defaultValue = "5") Integer size){

        return new JsonResponsePojo("200","成功",userService.getAllusersByPage(username,current,size));
    }
}

前端代码

var _this = this;
this.axios({
	method: "post",
	url: "http://localhost:8087/user/userList",
	data: {
		username: _this.searchForm.username,
		current: _this.currentPage,
		size: _this.pageSize
	},
	headers:{
		'Access-Control-Allow-Origin': '*',
		Authorization:token
	}

页面无法进行切换页码和查询操作,控制台sql语句执行如下,一直执行的是如下的SQL语句

==>  Preparing: SELECT id,username,password,realname,address,roleid,isdelete FROM user WHERE isdelete=0 AND (username LIKE ?) LIMIT ?
==> Parameters: %%(String), 5(Long)
<==    Columns: id, username, password, realname, address, roleid, isdelete
<==        Row: 1, guest, 123, abc, 合肥, 2, 0
<==        Row: 2, user, 123, xxx, 南京, 2, 0
<==        Row: 3, admin, 123, ADMIN, 芜湖, 1, 0
<==        Row: 4, 777, 777, xxx, 北京, 0, 0
<==        Row: 10, xiaomu, 1223, sada, 上海, 2, 0
<==      Total: 5

为get请求时,后端代码不变,前端改成get请求,操作正常执行

this.axios({
	method: "get",
	url: "http://localhost:8087/user/userList",
	params: {
		username: _this.searchForm.username,
		current: _this.currentPage,
		size: _this.pageSize
		},
	headers:{
		'Access-Control-Allow-Origin': '*',
		Authorization:token
	}
==>  Preparing: SELECT id,username,password,realname,address,roleid,isdelete FROM user WHERE isdelete=0 AND (username LIKE ?) LIMIT ?
==> Parameters: %in%(String), 5(Long)
<==    Columns: id, username, password, realname, address, roleid, isdelete
<==        Row: 3, admin, 123, ADMIN, 芜湖, 1, 0
<==        Row: 12, xioamin, 123, jarxxxk, 北京, 2, 0
<==        Row: 18, admin2, 123, 121, 洛阳, 1, 0
<==        Row: 310378502, admin02, qwe, xiaomu, 上海, 1, 0
<==        Row: 310378503, admin02, 456, xiatian, 苏州, 2, 0
<==      Total: 5

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值