package  com.test.dao;
 public   interface  DAO {
}

 public   interface  IUserDAO {

     public  List getUsers();
     public   void  deleteUser( Integer userId);
     public   void  updateUser( User user);
     public   void  insertUser( User user);
     public   void  addUser( User user);
    
}

 public   class  UserDAOHibernate  extends  HibernateDaoSupport  implements  IUserDAO {

     public  List getUsers() {
         return  getHibernateTemplate().find("from User");
    }

     public   void  deleteUser(Integer id) {
    	Object user = getHibernateTemplate().load(User. class , id);
        getHibernateTemplate().delete(user);
    }

     public  User getUser( Long  id) {
        User user = (User) getHibernateTemplate().get(User. class , id);
         return  user;
    }

     public   void  updateUser(User user) {
        getHibernateTemplate().saveOrUpdate(user);
        System.out.println("userId set to: " + ((User) user).getId());
    }

     public   void  insertUser(User user) {
        getHibernateTemplate().saveOrUpdate(user);
        System.out.println("userId set to: " + ((User) user).getId());
    }

     public   void  addUser(User user) {
        getHibernateTemplate().saveOrUpdate(user);
        System.out.println("userId set to: " + ((User) user).getId());
    }


}

 public   class  User {
     private  String id;
     private  String name;
     private  String fio;
     private  String password;
     private  String info;

     public  String getId() {
         return  id;
    }

     public   void  setId(String id) {
         this .id = id;
    }

     public  String getName() {
         return  name;
    }

     public   void  setName(String name) {
         this .name = name;
    }

     public  String getFio() {
         return  fio;
    }

     public   void  setFio(String fio) {
         this .fio = fio;
    }

     public  String getPassword() {
         return  password;
    }

     public   void  setPassword(String password) {
         this .password = password;
    }

     public  String getInfo() {
         return  info;
    }

     public   void  setInfo(String info) {
         this .info = info;
    }
}

 public   class  Test {
     private   static  ApplicationContext ctx;

     public   static   void  main ( String[] args){
        Object o =  new   org.springframework.beans.factory.support.DefaultListableBeanFactory();
        ApplicationContext ctx =  new  ClassPathXmlApplicationContext("applicationContext.xml");
        IUserDAO dao = (IUserDAO) ctx.getBean("userDAO");         
    }
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping  PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    < class  name="com.test.model.User" table="app_user">

        <id name="id" column="id" unsaved-value="0">
            <generator  class ="increment" />
        </id>
        <property name="name" column="first_name"/>
        <property name="fio" column="last_name"/>
        <property name="password" column="usr_pssword"/>
        <property name="info" column="user_info"/>        

    </ class >
</hibernate-mapping>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans  PUBLIC  "-//SPRING//DTD BEAN//EN"
    "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>

    <bean id="dataSource"  class ="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName"><value>org.firebirdsql.jdbc.FBDriver</value></property>
        <property name="url"><value>jdbc:firebirdsql:localhost:c:/temp/enetdatabase.fdb</value></property>
        <property name="username"><value>SYSDBA</value></property>
        <property name="password"><value>masterkey</value></property>
    </bean>

    <!-- Hibernate SessionFactory -->
    <bean id="sessionFactory"  class ="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource"><ref local="dataSource"/></property>
        <property name="mappingResources">
            <list>
                <value>com/test/model/User.hbm.xml</value>
            </list>
        </property>
        <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.FirebirdDialect</prop>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
        </props>
        </property>
    </bean>

    <!-- Transaction manager  for  a single Hibernate SessionFactory (alternative to JTA) -->
    <bean id="transactionManager"  class ="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory"><ref local="sessionFactory"/></property>
    </bean>

    <bean id="userDAO"  class ="com.test.dao.UserDAOHibernate">
        <property name="sessionFactory"><ref local="sessionFactory"/></property>
    </bean>    

</beans>