t.ry_idnum(为身份证号字段)
(case when #{isAble} = '0' then t.ry_idnum ①
when #{isAble} = '1' then (
(case when length(t.ry_idnum)>0 then substr(t.ry_idnum,0,3) || '**********' || substr(t.ry_idnum,16) ②
③else t.ry_idnum end))
end) as RYIDNUM
注: ①:判断有权限,身份证号全部展示;
②判断数据库中身份证号字段是否有值,有值进行加密处理(加密前展示3后展示3中间*);
③身份证号字段无值则不处理。