Caucho maker of Resin Server | Application Server (Java EE Certified) and Web Server


 

Resin Documentation

home company docs 
app server 
 Resin Server | Application Server (Java EE Certified) and Web Server
 

collections: the @onetomany relation


The @OneToMany relation adds collection extensions to the query language and provides a Java Collection containing the children. @OneToMany represents a collection of children belonging to a parent, like students in Gryffindor house at Hogwarts school.

The Many-To-One tutorial illustrated that a many-to-one relation links one source entity to another target entity. A one-to-many relation links the target entity back to the source entity.

In this example, each House has many Students, each Student has one House. House has a one-to-many relationship with Student, Student has a many-to-one relationship with House

Demo

Files in this tutorial

WEB-INF/resin-web.xmlweb.xml configuration
WEB-INF/classes/META-INF/persistence.xmlpersistence.xml configuration
WEB-INF/classes/example/Student.javaThe student bean
WEB-INF/classes/example/House.javaThe house bean
WEB-INF/classes/example/OneToManyServlet.javaThe test servlet

Data Model: Object and Database Models

Database Schema

The database schema is unchanged from the Many-To-One tutorial, and might look like:

SQL
CREATE TABLE house (
  id BIGINT PRIMARY KEY auto_increment,

  name VARCHAR(250),
)

CREATE TABLE student (
  id BIGINT PRIMARY KEY auto_increment,

  name VARCHAR(250),

  house BIGINT REFERENCES house(id)
)

@OneToMany - the relation's "inverse" side

The House bean has a students field that returns the students that belong to the house. House annotates getStudents with @OneToMany to describe the relationship. The @JoinColumn is used to specify the foreign key, the field in Student that is the @ManyToOne link.

House.java
  @OneToMany(mappedBy="house")
  private Set<Student> _students;

@ManyToOne - the relation's "owning" side

A @OneToMany always requires a corresponding @ManyToOne on the target entity. The Student has a house field annotated a @ManyToOne, unchanged from the Many-To-One tutorial.

Student.java
  @ManyToOne
  @JoinColumn(name="house")
  private House _house;

java.util.Collection: Using House.getStudents()

The one-to-many relation provides a House the ability to get all of its Students. Resin will perform any necessary database lookup.

The example queries all houses and prints their names and all of their students.

Using House.getStudents()
private void doService(PrintWriter out)
  throws java.io.IOException
{
  public void service(HttpServletRequest req, HttpServletResponse res)
    throws java.io.IOException, ServletException
  {
    PrintWriter out = res.getWriter();

    res.setContentType("text/html");

    String sql = "SELECT h FROM House h";
    
    Query allHouse = _entityManager.createQuery("SELECT o FROM House o");

    List houses = allHouse.getResultList();

    for (int i = 0; i < houses.size(); i++) {
      House house = (House) houses.get(i);

      out.println("<h3>" + house.getName() + "</h3>");

      for ( Student student : house.getStudents() ) {
        out.println( student.getName() + "<br>" );
      }
    }
  }
}

Query extensions

Result Collections: SELECT h.students

h.students
SELECT h.students FROM House h WHERE h.name='Gryffindor'

Joins: FROM House h, IN(h.students) s

IN
SELECT s FROM House h, IN(h.students) s WHERE h.name='Gryffindor'

Membership: s MEMBER OF h.students

MEMBER OF
SELECT s FROM Student s, House h WHERE s MEMBER OF h.students

Empty: h.students IS EMPTY

IS EMPTY
SELECT h FROM House h WHERE h.students IS EMPTY

Demo


Copyright © 1998-2015 Caucho Technology, Inc. All rights reserved. Resin ® is a registered trademark. Quercustm, and Hessiantm are trademarks of Caucho Technology.

Cloud-optimized Resin Server is a Java EE certified Java Application Server, and Web Server, and Distributed Cache Server (Memcached).
Leading companies worldwide with demand for reliability and high performance web applications including SalesForce.com, CNET, DZone and many more are powered by Resin.

home company docs 
app server