在实体的 TableName中写构建视图的子查询,并赋予一个别名:
@TableName("(select * from msg) msg_view")
@Data
public class MsgView {
private Integer id;
private Integer fromUser;
private Integer toUser;
private String content;
private Date sendTime;
private Date receiveTime;
private Object msgStatus;
private Integer fromRemoved;
private Integer toRemoved;
}
然后再使用lambdaQuery的地方就可以像操作正常表一样进行操作了。