Spring boot Mybatis-plus自定義分頁插件關聯多表查詢

自定義個資料類型，用于解析兩表聯合查詢傳回的資料。

entity

@Data
public class UserCompany implements Serializable {

    private static final long serialVersionUID = 1L;
    private int userId;
    private String userName;
    private String fullName;

}
           

接口位址

Controller

@RequestMapping("/selectCompanyNameById")
    public IPage<UserCompany> selectCompanyNameById(@RequestParam("current") int current, @RequestParam("size") int size, @RequestParam("userName") String userName){
        return userService.selectCompanyNameById(current,size,userName);
    }
           

根據 user表和entity表 兩表關聯查詢出來的字段合并 并傳回

調用 Mybatis-plus 分頁插件基礎接口

Mapper

@Repository
public interface UserMapper extends BaseMapper<User> {
    @Select("select entity.full_name,user.user_id,user.user_name from user inner join entity on user.company = entity.entity_id")
    IPage<UserCompany> selectCompanyNameById(IPage<UserCompany> page , QueryWrapper<UserCompany> wrapper);
}
           

方法接口

services

public interface UserService extends IService<User> {

    IPage<UserCompany> selectCompanyNameById(int current, int size , String userName);
}
           

接口實作類

serviceImpl

@Override
    public IPage<UserCompany> selectCompanyNameById(int current, int size , String userName){
        Page<UserCompany> page = new Page<>(current,size);
        QueryWrapper<UserCompany> wrapper = new QueryWrapper<>();
        IPage<UserCompany> userIPage = userMapper.selectCompanyNameById(page , wrapper);
        return userIPage;
    }