Eclipse+JBoss+EJB3实现Entity Bean的一对多映射

2009-12-1     作者:   编辑:崔晓帆        点击进入论坛
关键词:Eclipse  JBoss  EJB3  Entit

  EJB3的一对多映射使用@OneToMany来设置,如果是双向的一对多映射,在many方需要使用@ManyToOne设置。在本书中给出两个表,其他一个表t_customers在上一篇文章中已给出了,另一个表的结构如图1所示。

t_orders表

  图1 t_orders表

  t_customers和t_orders表是一对多关系,一个Customer可能有多个Order,而一个Order只能有一个Customer。

  在Customer类中需要定义一个集合类型的属性,用来保存多个Order对象,Customer类的代码如下:

  1. package entity;
  2. import java.util.Collection;
  3. import javax.persistence.CascadeType;
  4. import javax.persistence.Entity;
  5. import javax.persistence.FetchType;
  6. import javax.persistence.GeneratedValue;
  7. import javax.persistence.GenerationType;
  8. import javax.persistence.Id;
  9. import javax.persistence.JoinColumn;
  10. import javax.persistence.JoinTable;
  11. import javax.persistence.ManyToMany;
  12. import javax.persistence.OneToMany;
  13. import javax.persistence.OneToOne;
  14. import javax.persistence.PrimaryKeyJoinColumn;
  15. import javax.persistence.Table;
  16. @Entity
  17. @Table(name = "t_customers")
  18. public class Customer
  19. {
  20. private int id;
  21. private String name;
  22. private Referee referee;
  23. private Collection orders;
  24. @OneToMany(mappedBy = "customer", cascade = CascadeType.ALL)
  25. public Collection getOrders()
  26. {
  27. return orders;
  28. }
  29. public void setOrders(Collection orders)
  30. {
  31. this.orders = orders;
  32. }
  33. @Id
  34. @GeneratedValue(strategy = GenerationType.IDENTITY)
  35. public int getId()
  36. {
  37. return id;
  38. }
  39. ... ...
  40. }

其中@OneToMany的mappedBy属性指定了Order类中获得Customer对象的属性名。Order类的代码如下:

  1. package entity;
  2. import javax.persistence.Column;
  3. import javax.persistence.Entity;
  4. import javax.persistence.GeneratedValue;
  5. import javax.persistence.GenerationType;
  6. import javax.persistence.Id;
  7. import javax.persistence.JoinColumn;
  8. import javax.persistence.JoinColumns;
  9. import javax.persistence.JoinTable;
  10. import javax.persistence.ManyToOne;
  11. import javax.persistence.Table;
  12. @Entity
  13. @Table(name = "t_orders")
  14. public class Order
  15. {
  16. private int id;
  17. private String productId;
  18. private int count;
  19. private Customer customer;
  20. @ManyToOne
  21. @JoinColumn(name = "customer_id")
  22. public Customer getCustomer()
  23. {
  24. return customer;
  25. }
  26. public void setCustomer(Customer customer)
  27. {
  28. this.customer = customer;
  29. }
  30. @Id
  31. @GeneratedValue(strategy = GenerationType.IDENTITY)
  32. public int getId()
  33. {
  34. return id;
  35. }
  36. ... ...
  37. }

其中@JoinColumn注释的name属性指定t_orders表中用于连接t_customers表的外键名。

可以使用下面的代码进行测试:

  1. Customer customer = new Customer();
  2. customer.setName("微软");
  3. List< Order> orders = new ArrayList< Order>();
  4. Order order =new Order();
  5. order.setProductId("1234");
  6. order.setCount(20);
  7. order.setCustomer(customer);
  8. orders.add(order);
  9. order = new Order();
  10. order.setProductId("4321");
  11. order.setCount(12);
  12. order.setCustomer(customer);
  13. orders.add(order);
  14. customer.setOrders(orders);
  15. em.persist(customer);

除此之外,还可以使用@JoinTable指定连接表来映射one-to-many关系。连接表的结构如图2所示。

t_customers_orders表
图2 t_customers_orders表

首选需要将Customer类的getOrders方法修改成下的形式:

  1. @OneToMany
  2. @JoinTable(name = "t_customers_orders", joinColumns = @JoinColumn(name = "t_customers_id",
  3. referencedColumnName = "id"), inverseJoinColumns =
  4. @JoinColumn(name = "orders_id", referencedColumnName = "id"))
  5. public Collection getOrders()
  6. {
  7. return orders;
  8. }

其中name属性指定图2所示的连接表的名称。joinColumns指定了t_customers表和t_customers_orders表中相连接的字段。inverseJoinColumns指定了t_orders表和t_customers_orders表中相连接的字段。这时t_orders表中的customer_id字段就不再需要了。因此,需要将Order表中的customer属性(getter和setter方法)去掉。

在持久化Customer和Order对象时,需要对Order对象进行持久化后才能对Customer对象进行持久化。

寻找产品:
姓       名: 电   话:
公       司: E-mail:
描       述: