Skip to content

(使用sqlserver数据库)用户管理查询出错 #1140

Closed
@qingjing0606

Description

@qingjing0606
版本号:2.1.4
问题描述:sys_user表identity字段为sqlserver的关键字,用户管理查询时出错
截图&代码:

image

SysUser.java 文件需做处理
/**
* 身份(0 普通成员 1 上级)
*/
@Excel(name="(1普通成员 2上级)",width = 15)
// fix keyword 'identity' in sqlserver begin
@TableField("[identity]")
// fix keyword 'identity' in sqlserver end
private Integer identity;

友情提示: 未按格式要求发帖,会直接删掉。

Activity

yunpyy

yunpyy commented on Apr 29, 2020

@yunpyy

版本号:2.1.4

SysUserMapper.xml文件中多处del_flag后是双引号,导致sqlServer执行sql报错。

<update id="revertLogicDeleted"> UPDATE sys_user SET del_flag = "0", update_by = #{entity.updateBy}, update_time = #{entity.updateTime} WHERE del_flag = "1" AND id IN (${userIds}) </update>

zhangdaiscott

zhangdaiscott commented on Apr 29, 2020

@zhangdaiscott
Member

已经改了,下个版本发布

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @zhangdaiscott@yunpyy@qingjing0606

        Issue actions

          (使用sqlserver数据库)用户管理查询出错 · Issue #1140 · jeecgboot/JeecgBoot