为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