package com.example.lxw.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.example.lxw.pojo.User_inf;
|
import com.example.lxw.pojo.vo.UserInfo;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Component;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author lxw
|
* @create 2021-04-13 16:32
|
*/
|
@Mapper
|
public interface User_InfMapper extends BaseMapper<User_inf> {
|
/**
|
* 返回所有的用户
|
* @return
|
*/
|
public List<User_inf> searchByBaojiUsr();
|
|
/**
|
* 返回所有的用户
|
* @return
|
*/
|
|
public List<UserInfo> searchByBaojiUsr2();
|
|
@Select("SELECT tb_user_inf.*,tb_user_battgroup_baojigroup_usr.baoji_group_id from tb_user_inf LEFT JOIN tb_user_battgroup_baojigroup_usr ON tb_user_inf.uId=tb_user_battgroup_baojigroup_usr.uId order by tb_user_inf.uid")
|
public List<Map<String,Object>> searchByBaojiUsr3();
|
|
}
|
