<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping  PUBLIC  "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping  package ="com.demo.db">
	< class  lazy="false" name="User" table="user_">
		<id column="id" name="id" type="int">
			<generator  class ="native" />
		</id>

		<many-to-one cascade="none"  class ="Company" name="company">
			<column name="company_id" not- null ="false" />
		</many-to-one>

		<many-to-one cascade="none"  class ="Role" name="role">
			<column name="role_id" not- null ="true" />
		</many-to-one>

		<property name="name" type="java.lang.String">
			<column name="name" not- null ="true" sql-type="VARCHAR" />
		</property>
		
		<property name="login" type="java.lang.String">
			<column name="login" not- null ="true" sql-type="VARCHAR" />
		</property>
		
		<property name="password" type="java.lang.String">
			<column name="password" not- null ="true" sql-type="VARCHAR" />
		</property>

	</ class >
</hibernate-mapping>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping  PUBLIC  "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping  package ="com.demo.db">
	< class  lazy="false" name="Role" table="role">
		<id column="id" name="id" type="int">
			<generator  class ="native" />
		</id>
		
		<property name="name" type="java.lang.String">
			<column name="name" not- null ="true" sql-type="VARCHAR" />
		</property>
		
		<property name="descr" type="java.lang.String">
			<column name="descr" not- null ="true" sql-type="VARCHAR" />
		</property>
	</ class >
</hibernate-mapping>

/*
 * Created on 14.02.2005
 *
 */
 package  com.demo.db;

 public   class  User {

     private   int  id;
    
     private  Company company;
     private  Role role;
     private  String name;
     private  String login;
     private  String password;
    
     public  User() {
        
    }
    
    /**
     * @return Returns the company.
     */
     public  Company getCompany() {
         return  company;
    }
    /**
     * @param company The company to set.
     */
     public   void  setCompany(Company company) {
         this .company = company;
    }
    /**
     * @return Returns the id.
     */
     public   int  getId() {
         return  id;
    }
    /**
     * @param id The id to set.
     */
     public   void  setId( int  id) {
         this .id = id;
    }
    /**
     * @return Returns the login.
     */
     public  String getLogin() {
         return  login;
    }
    /**
     * @param login The login to set.
     */
     public   void  setLogin(String login) {
         this .login = login;
    }
    /**
     * @return Returns the name.
     */
     public  String getName() {
         return  name;
    }
    /**
     * @param name The name to set.
     */
     public   void  setName(String name) {
         this .name = name;
    }
    /**
     * @return Returns the password.
     */
     public  String getPassword() {
         return  password;
    }
    /**
     * @param password The password to set.
     */
     public   void  setPassword(String password) {
         this .password = password;
    }
    /**
     * @return Returns the role.
     */
     public  Role getRole() {
         return  role;
    }
    /**
     * @param role The role to set.
     */
     public   void  setRole(Role role) {
         this .role = role;
    }
}

/*
 * Created on 14.02.2005
 *
 */
 package  com.demo.db;

 public   class  Role {

     int  id;
    String name;
    String descr;
    
     public  String getDescr() {
         return  descr;
    }
     public   void  setDescr(String descr) {
         this .descr = descr;
    }
     public   int  getId() {
         return  id;
    }
     public   void  setId( int  id) {
         this .id = id;
    }
     public  String getName() {
         return  name;
    }
     public   void  setName(String name) {
         this .name = name;
    }
    /**
     * 
     */
     public  Role() {
         super ();
        // TODO Auto-generated constructor stub
    }
  

}