如何使用hibernate标准编写连接查询

// 定义实体类
@Entity
@Table(name = "orders")
public class Order {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    
    // 其他属性和关联关系
    
    // getter和setter方法
}

@Entity
@Table(name = "items")
public class Item {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    
    // 其他属性和关联关系
    
    // getter和setter方法
}

// 配置Hibernate
@Configuration
public class HibernateConfig {
    @Bean
    public LocalSessionFactoryBean sessionFactory() {
        LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();
        sessionFactory.setDataSource(dataSource());
        sessionFactory.setPackagesToScan("com.example.model");
        sessionFactory.setHibernateProperties(hibernateProperties());
        return sessionFactory;
    }
    
    // 其他配置
    
    @Bean
    public DataSource dataSource() {
        // 配置数据源
    }
    
    @Bean
    public Properties hibernateProperties() {
        // 配置Hibernate属性
    }
}

// 创建连接查询
@Repository
public class OrderRepository {
    @Autowired
    private SessionFactory sessionFactory;
    
    public List<Order> getOrdersWithItems() {
        try (Session session = sessionFactory.openSession()) {
            String hql = "SELECT o FROM Order o JOIN FETCH o.items";
            Query<Order> query = session.createQuery(hql, Order.class);
            return query.getResultList();
        }
    }
}