You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
查看后端代码,发现执行获取所有用户的sql语句如下
SELECT
hr.id, hr.name, hr.phone, hr.telephone, hr.address, hr.enabled, hr.username, hr.userface, hr.remark, hr.employee_id, hr.work_date, r.id as rid, r.name as rname, r.namezh as rnamezh
FROM hr left join hr_role hrr on hr.id = hrr.hrid left join role r on hrr.rid = r.id
WHERE hr.id != #{id,jdbcType=INTEGER} AND hr.employee_id is NULL
AND hr.name LIKE concat('%',#{name,jdbcType=VARCHAR},'%')
查看后端代码,发现执行获取所有用户的sql语句如下
SELECT
hr.id, hr.name, hr.phone, hr.telephone, hr.address, hr.enabled, hr.username, hr.userface, hr.remark, hr.employee_id, hr.work_date, r.id as rid, r.name as rname, r.namezh as rnamezh
FROM hr left join hr_role hrr on hr.id = hrr.hrid left join role r on hrr.rid = r.id
WHERE hr.id != #{id,jdbcType=INTEGER} AND hr.employee_id is NULL
AND hr.name LIKE concat('%',#{name,jdbcType=VARCHAR},'%')
发现要求employee_id要为空,但是在hr实体类的employee_id是int类型,前端发送请求时并没有给emplyee_id赋值,导致后端执行sql语句时employee_id的值为0,而获取所有用户的sql语句的employee_id要求为空
解决办法
修改后端hr实体类employee_id的变量类型为Integer,修改get,set方法的变量类型
修改前端addHr变量的employee_id变量值置为空
The text was updated successfully, but these errors were encountered: