点击用户管理后报500错误码,怎么解决?

Question

报错信息的关键信息:

2023-12-19T17:04:41.730+08:00 ERROR 21624 --- [CRM] [nio-8080-exec-4] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.springframework.jdbc.BadSqlGrammarException: 

报错信息的截图:

点击用户管理的跳转的代码:

package com.bdqn.controller;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.bdqn.pojo.Role;
import com.bdqn.pojo.User;
import com.bdqn.service.RoleService;
import com.bdqn.service.UserService;
import jakarta.annotation.Resource;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.List;

/**
 * UserController
 *
 * @author 刘家旺
 * @since 2023-12-18
 */
@Controller
@RequestMapping("/user")
public class UserController {

    @Resource
    private UserService userService;

    @Resource
    private RoleService roleService;

    @GetMapping("/list")
    public String list(Model model, String usrName, @RequestParam(required = false, defaultValue = "0") Long roleId, @RequestParam(required = false, defaultValue = "1") int pageIndex) {
        // 创建Page对象，设置当前页和每页数量
        Page<User> page = new Page<>(pageIndex, 5);
        // 调用服务层方法，获取分页的用户列表
        List<User> userPager = userService.findUsers(usrName, roleId, page);
        // 将用户列表数据添加到Model对象中
        model.addAttribute("userPager", userPager);
        model.addAttribute("usrName", usrName);
        List<Role> roles = roleService.findAllRoles();
        model.addAttribute("roles", roles);
        // 返回用户列表页面的视图名称
        return "user/list";
    }

}

点击用户管理后报500错误码,怎么解决?

Answer 1

报错显示查询角色表sys_role，没有rights字段，请检查确认下表结构