HeatingPaymentsInvoker/conf/sqlroot/com/yinjie/heating/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};


-- [storeLogin]
SELECT
 *
FROM $table$
WHERE loginAccount = #{loginName} AND loginPass = #{password};

-- [loginCompany]
SELECT
 *
FROM $table$
WHERE appId = #{loginName} AND loginPass = #{password};