Java(TM) Boutique - Mapping Java Objects to a Database with Castor-JDO

Reviews :

Mapping Java Objects to a Database with Castor-JDO:

Reading from the database

Having data in the media, movie, and actor tables we'll now see how easy it is to create objects with data from the database. Assume that we want to find all movies where Keanu Reeves is an actor. The only thing we need to get started is to query his name, and magic happens: all objects are ready to use. The next program lists the movies and the medias where Keanu Reeves appears:

package hansen.playground;
import org.exolab.castor.jdo.*;
import java.util.*;

public class ReadActor {
  public static void main(String[] args) {
    try {
      // Define the JDO object
      JDO jdo = new JDO("mydb"); 
      jdo.setConfiguration("database.xml"); 

      // Open a connection to the database
      Database db = jdo.getDatabase();
      
      // Begin a transaction
      db.begin(); 
      
      OQLQuery query; 
      QueryResults results; 
      query = db.getOQLQuery(
        "SELECT a FROM hansen.playground.Actor a WHERE a.name=$1");
      query.bind("Keanu Reeves");  
      results = query.execute(Database.ReadOnly);
      Actor actor = (Actor)results.next();
      
      System.out.println("Actor: " + actor.getName());
      Collection movies = actor.getMovies();
      for (Iterator it = movies.iterator(); it.hasNext();) {
        Movie movie = (Movie)it.next();
        System.out.println("Movie: " + movie.getTitle());
        Media media = movie.getMedia();
        System.out.println("Media: " + media.getType());
      }  

      // Commit the transaction
      db.commit(); 
      db.close(); 

    } catch (PersistenceException e) {
      e.printStackTrace(); 
    }  
  }
}

- Listing 8: Reading from the database -

The output from the program is this:

Actor: Keanu Reeves
Movie: The Matrix
Media: DVD
Movie: Chain Reaction
Media: VHS

The execute method specifies "readonly", since we're not updating any data. There might be a performance gain in doing this.

Applet Index
(sorted alphabetically)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z #s

The Java Source
(applets w/source code)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z

How to Add Java Applets to Your Site

New on the Java Boutique:

New Review:

Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling API boasts simplicity, ease-of-integration, a well-rounded feature set, and it's free!

New Applet:

Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA sequences into three useful formats.