hros icon indicating copy to clipboard operation
hros copied to clipboard

添加用户后在界面不显示

Open AgnoyZ opened this issue 10 months ago • 2 comments

查看后端代码,发现执行获取所有用户的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变量值置为空

AgnoyZ avatar Apr 11 '24 07:04 AgnoyZ