使用JPA创建和查询表-如何返回多行？

String sql = "SELECT * FROM table_name";
Query query = entityManager.createNativeQuery(sql);
List<Object[]> resultList = query.getResultList();

for (Object[] row : resultList) {
    // 处理每一行数据
}

String jpql = "SELECT NEW com.example.dto.EntityDto(e.id, e.name) FROM Entity e";
TypedQuery<EntityDto> query = entityManager.createQuery(jpql, EntityDto.class);
List<EntityDto> resultList = query.getResultList();

for (EntityDto dto : resultList) {
    // 处理每一行数据
}

public interface EntityProjection {
    Long getId();
    String getName();
}

String jpql = "SELECT e.id AS id, e.name AS name FROM Entity e";
TypedQuery<EntityProjection> query = entityManager.createQuery(jpql, EntityProjection.class);
List<EntityProjection> resultList = query.getResultList();

for (EntityProjection projection : resultList) {
    // 处理每一行数据
}