com.base4j.mvc.sys.mapper.SysUserDetailsMapper Maven / Gradle / Ivy
package com.base4j.mvc.sys.mapper;
import com.base4j.mvc.auth.SecurityUser;
import com.base4j.mvc.sys.entity.SysUser;
import com.base4j.mybatis.base.mapper.BaseMapper;
import com.base4j.mybatis.config.mybatis.annotations.AutoMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@AutoMapper
public interface SysUserDetailsMapper extends BaseMapper {
@Select("SELECT SSU.ID,SSU.NAME, SSU.SYS_ORG_ID as sysOrgId, SSU.SYS_DEPT_ID as sysDeptId,SSA.`PASSWORD` as password" +
" FROM SEED_SYS_ACCOUNT SSA INNER JOIN SEED_SYS_USER SSU ON SSA.SYS_USER_ID = SSU.ID" +
" WHERE USERNAME=#{username}")
SysUser selectByUsername(@Param("username") String username);
}