SELECT
tu.user_id userId,
tu.user_name userName,
tu.user_accout userAccount,
tu.user_passwd userPassword,
tu.is_domain isDomain,
IFNULL(tu.user_phone,'--') userPhone,
IFNULL(tu.call_phone ,'--') callPhone,
IFNULL(tu.email,'--') email,
IFNULL(tu.note,'--') note,
tu.create_time createTime,
IFNULL(tu.last_login_ip,'--') lastLoginIp,
ttr.role_name roleName,
ttr.role_id roleId,
ttr.role_code roleCode
FROM
t_user tu
Mybatis查询字段为空处理
最新推荐文章于 2024-07-30 15:35:55 发布