<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
   "-//Hibernate/Hibernate Mapping DTD//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
   <class
      name="ca.spintechnologies.runningmap.Athlete"
      table = "ATHLETE">
      <id
         name="id"
         column="id"
         type="integer">
            <generator class="increment"/>
      </id>
      <property name="email" column="email"/>
      <property name="userPassword" column="userpassword"/>
      <property name="userLevel" column="userlevel"/>
      <property name="userName" column="username"/>
      <property name="firstName" column="firstname"/>
      <property name="lastName" column="lastname"/>
      <property name="isActive" column="isactive"/>
      <property name="creationDate" column="creationdate"/>
      <idbag name="routes"
             table = "athlete_route"
             lazy = "true"
             cascade = "save-update">
             <collection-id type="integer" column="id">
                <generator class="sequence"/>
             </collection-id>
             <key column="athlete_id"/>
             <many-to-many class="ca.spintechnologies.runningmap.Route" column="route_id"/>
      </idbag>
   </class>
</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
   "-//Hibernate/Hibernate Mapping DTD//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
   <class
      name="ca.spintechnologies.runningmap.Route"
      table = "ROUTE">
      <id
         name="id"
         column="id"
         type="integer">
            <generator class="increment"/>
      </id>
      <property name="name" column="name"/>
      <property name="distance" column="distance"/>
   </class>
</hibernate-mapping>

Session session = util.currentSession();
           Transaction tx= session.beginTransaction();
           Query  query = session.createQuery("from Athlete as athlete where athlete.userName like '" + myUserName +
"'");
           Iterator it = query.iterate();
           if (it.hasNext()){
               myAthlete = (Athlete)it.next();
               myPassword = myAthlete.getUserPassword();
           }
           else{
              message.append("message='username does not exist' ");
           }
           tx.commit();
           HibernateUtil.closeSession();   
        }catch(Exception e){
           message.append("message='" + e.toString()+ "' ");
           System.out.println("****RMDB_ValidateUser; caught exception: " + e.toString()); 
        }   

package ca.spintechnologies.runningmap;
import java.util.HashSet;
import java.util.Set;
import java.util.Date;

public class Athlete{
   private int id;
   private String email;
   private String userPassword;
   private String userLevel;
   private String userName;
   private String firstName;
   private String lastName;
   private Date creationDate;
   private boolean isActive;
   
   private Set cities = new HashSet();
   private Set routes = new HashSet();
   private Set results = new HashSet();
 
   public Athlete(){}
   
 
   public int getId(){
      return id;
   }
   public void setId(int myId){
      this.id = myId;
   }
   //
   public boolean getIsActive(){
        return isActive;
   }
   public void setIsActive(boolean myBool){
        this.isActive = myBool;
   }
   //
   public Date getCreationDate(){
        return creationDate;
   }
   public void setCreationDate(Date myDate){
        this.creationDate = myDate;
   }
   //
   public String getEmail(){
      return email;
   }
   public void setEmail(String myEmail){
      this.email = myEmail;
   }
   //
   public String getUserPassword(){
      return userPassword;
   }
   public void setUserPassword(String myPassword){
      this.userPassword = myPassword;
   }
   //
   public String getUserLevel(){
      return userLevel;
   }
   public void setUserLevel(String myLevel){
      this.userLevel = myLevel;
   }
   
   public String getUserName(){
      return userName;
   }
   public void setUserName(String myUserName){
      this.userName = myUserName;
   }

   public String getFirstName(){
      return firstName;
   }
   public void setFirstName(String myFirstName){
      this.firstName = myFirstName;
   }

   public String getLastName(){
      return lastName;
   }
   public void setLastName(String myLastName){
      this.lastName = myLastName;
   }
   
   public Set getCities(){
      return this.cities;
   }
   public boolean removeCity(City myCity){
         if(this.cities.contains(myCity)){
              this.cities.remove(myCity);
              return true;
         }
         else{
              return false;
         }
   }
   public void addCity(City myCity){
         this.cities.add(myCity);
   }
   
   
   
   public Set getRoutes(){
      return this.routes;
   }
   public void setRoutes(Set myRouteSet){
       if(myRouteSet != null){
          this.routes = myRouteSet;
       }
       else{
          System.out.println("***From Athlete: myRouteSet is null");
       }
         
   }
   public void addRoute(Route myRoute){
         this.routes.add(myRoute);
   }
   
   public Set getResults(){
         return this.results;
   }
   public void addResult(Result myResult){
         this.results.add(myResult);
   }
}