package model;

import java.util.Date;
import util.DateTimeUtil;

/**
* Schedule class
*
*
* @hibernate.class
*    table="schedule"
*
* @struts.form
*    extends="org.apache.struts.validator.ValidatorForm"
*    include-all="true"
*/
public class Schedule {
   protected int scheduleId;
   protected Date startTime;
   protected double hours;
   protected Venue venue;


   public void setScheduleId(int scheduleId) {
      this.scheduleId = scheduleId;
   }

   /**
    * @hibernate.id
    *    generator-class="native"
    */   
   public int getScheduleId() {
      return scheduleId;
   }


   public void setStartTime(Date startTime) {
      this.startTime = startTime;
   }

   /**
    * @hibernate.property
    *    not-null="true"
    */
   public Date getStartTime() {
      return startTime;
   }
   
   
   public Date getEndTime() {
      return DateTimeUtil.addMinute(startTime, (int)(hours*60));
   }

   public void setHours(double hours) {
      this.hours = hours;
   }
   
   
   /**
    * @hibernate.property
    *    not-null="true"
    */
   public double getHours() {
      return hours;
   }
   

   public void setVenue(Venue venue) {
      this.venue = venue;
   }

   /**
    * @hibernate.one-to-one
    *    cascade="all"
    */
   public Venue getVenue() {
      return venue;
   }

package model;

/**
* Venue class
*
*
* @hibernate.class
*    table="venue"
*
* @struts.form
*    extends="org.apache.struts.validator.ValidatorForm"
*    include-all="true"
*/
public class Venue extends BaseObject {
   protected String shortName;
   protected String venueName;
   protected int venueId;

   public void setShortName(String shortName) {
      this.shortName = shortName;
   }

   /**
    * @hibernate.property
    *    column="shortName"
    *    not-null="false"
    */
   public String getShortName() {
      return shortName;
   }

   public void setVenueId(int venueId) {
      this.venueId = venueId;
   }

   /**
    * @hibernate.id
    *    column="venueId"
    *    generator-class="native"
    */
   public int getVenueId() {
      return venueId;
   }

   public void setVenueName(String venueName) {
      this.venueName = venueName;
   }

   /**
    * @hibernate.property
    *    column="venueName"
    *    not-null="true"
    */
   public String getVenueName() {
      return venueName;
   }
   
}

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
    <class
        name="model.Schedule"
        table="schedule"
        dynamic-update="false"
        dynamic-insert="false"
    >

        <id
            name="scheduleId"
            column="scheduleId"
            type="int"
        >
            <generator class="native">
            </generator>
        </id>

        <property
            name="startTime"
            type="java.util.Date"
            update="true"
            insert="true"
            column="startTime"
            not-null="true"
        />

        <property
            name="hours"
            type="double"
            update="true"
            insert="true"
            column="hours"
            not-null="true"
        />

        <one-to-one
            name="venue"
            class="model.Venue"
            cascade="all"
            outer-join="auto"
            constrained="false"
        />

        <!--
            To add non XDoclet property mappings, create a file named
                hibernate-properties-Schedule.xml
            containing the additional properties and place it in your merge dir.
        -->

    </class>

</hibernate-mapping>

CREATE TABLE VENUE(VENUEID INTEGER NOT NULL IDENTITY PRIMARY KEY,SHORTNAME VARCHAR(255),VENUENAME VARCHAR(255) NOT NULL)
CREATE TABLE SCHEDULE(SCHEDULEID INTEGER NOT NULL IDENTITY PRIMARY KEY,STARTTIME TIMESTAMP NOT NULL,HOURS DOUBLE NOT NULL)