-- [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};