在spring boot中对两个不同的表应用分页并合并结果

// 引入Spring Data JPA分页插件
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;

// 自定义实体类和对应的Repository接口
@Entity
@Table(name = "table1")
public class Table1 {
    // 实体类字段和对应的数据库列
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    // 其他字段...

    // Getters and setters...
}

public interface Table1Repository extends JpaRepository<Table1, Long> {
}

@Entity
@Table(name = "table2")
public class Table2 {
    // 实体类字段和对应的数据库列
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    // 其他字段...

    // Getters and setters...
}

public interface Table2Repository extends JpaRepository<Table2, Long> {
}

// 编写Service层代码
@Service
public class TableService {
    @Autowired
    private Table1Repository table1Repository;

    @Autowired
    private Table2Repository table2Repository;

    public List<Object> getMergedData(int pageNumber, int pageSize) {
        // 创建分页请求对象
        Pageable pageable = PageRequest.of(pageNumber, pageSize);

        // 分别查询两个表的数据
        Page<Table1> table1Page = table1Repository.findAll(pageable);
        Page<Table2> table2Page = table2Repository.findAll(pageable);

        // 合并两个表的数据
        List<Object> mergedData = new ArrayList<>();
        mergedData.addAll(table1Page.getContent());
        mergedData.addAll(table2Page.getContent());

        return mergedData;
    }
}