在spring-boot应用程序中模拟DB视图

@Entity
@Table(name = "db_view")
@Immutable // 声明实体类为只读，不可修改
public class DBViewEntity {
    @Id
    private Long id;

    private String name;

    // 其他属性...

    // 构造函数、Getter和Setter方法...
}

public interface DBViewRepository extends JpaRepository<DBViewEntity, Long> {
    @Query(value = "SELECT id, name FROM table1 JOIN table2 ON table1.id = table2.id", nativeQuery = true)
    List<DBViewEntity> getDBView();
}

@Service
public class DBViewService {
    private final DBViewRepository dbViewRepository;

    public DBViewService(DBViewRepository dbViewRepository) {
        this.dbViewRepository = dbViewRepository;
    }

    public List<DBViewEntity> getDBViewData() {
        return dbViewRepository.getDBView();
    }
}