如何在Hibernate中使用外键？

I'm new to Hibernate. This is my problem. I can do this:

我是Hibernate的新手。这是我的问题。我可以做这个:

package = session.createQuery("from Package").list();
session.getTransaction().commit();

But what I really want is this in SQL:

但我真正想要的是SQL:

select * from package,product where product.nome='television' and package.idProduct = product.id

How do I do that?

我怎么做?

These are my POJOs:

这些是我的POJO:

public class Package implements java.io.Serializable {

  private PackageId id;
  private User user;
  private Product product;
  private int quant;
  private char mode;
  private String unit;
  private String description;

public class PackageId implements java.io.Serializable {

  private int id;
  private int idProduct;

public class Product  implements java.io.Serializable {

  private int id;
  private String name;
  private Set packages = new HashSet(0);

These POJOs were generated by Netbeans.

这些POJO由Netbeans生成。

Is this configuration right?

这个配置对吗?

http://pastebin.com/gBUdKke0

1 个解决方案

#1

You're already working with HQL. With HQL you can select multiple objects not just one or just a set of object fields.

你已经在使用HQL了。使用HQL,您可以选择多个对象,而不仅仅是一个对象字段。

select product, package 
from Product product
join product.packages package
where product.name = 'television'

See HQL reference for select for examples.

有关示例,请参阅HQL参考。

1 个解决方案

#1

更多相关文章

随机推荐