dySdDesigner/conf/sqlroot/com/sdtool/business/dao/LoginDao.dql

-- [login]
SELECT
  id, loginName, userName,
  companyId, deptId, userType,
  email, phonenumber, sex,
  avatar, status, delFlag,
  remark, postIds
FROM $table$
WHERE loginName = #{loginName} AND password = #{password};

-- [mallLogin]
SELECT *
FROM $table$
WHERE (loginName = #{loginName} or loginAccount = #{loginName}) AND password = #{password};