package com.hxzkappboot.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.hxzkappboot.pojo.TbUser;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
public interface UserDao extends BaseMapper<TbUser> {
|
@Select("select u.*,c.id as companyid from tb_user u LEFT JOIN tb_company c ON u.company=c.companyname where username = #{username} and password = #{password}")
|
public TbUser findUser(TbUser user);
|
|
@Select("select * from tb_user where cid != 'null' and cid != ''")
|
public List<TbUser> findUserCid( );
|
}
|
