<bean id="dataSource"
        class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"
        p:driverClass="${jdbc.driverClassName}"
        p:jdbcUrl="${jdbc.databaseurl}"
        p:user="${jdbc.username}"
        p:password="${jdbc.password}" />

<bean id="sessionFactory"
    class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="packagesToScan">
    	<list>
           <value>com.checkout.core.model</value>
       </list>
    </property>
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">${jdbc.dialect}</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.hbm2ddl.auto">update</prop>            
            <prop key="hibernate.c3p0.min_size">10</prop>
			<prop key="hibernate.c3p0.max_size">200</prop>
			<prop key="hibernate.c3p0.timeout">90</prop>
			<prop key="hibernate.c3p0.max_statements">50</prop>
			<prop key="hibernate.c3p0.idle_test_period">3000</prop>
        </props>
    </property>
</bean>

<bean id="transactionManager"
    class="org.springframework.orm.hibernate3.HibernateTransactionManager">
    <property name="sessionFactory" ref="sessionFactory" />
</bean>	

<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
	<property name="sessionFactory" ref="sessionFactory" />
	<property name="maxResults" value="5000" />
</bean>

<bean id="abstractDAO" abstract="true" p:hibernateTemplate-ref="hibernateTemplate" class="com.checkout.core.dao.impl.AbstractDAOImpl" />

@Repository
public abstract class AbstractDAOImpl<T extends DataObject> extends HibernateDaoSupport implements AbstractDAO<T> {

	protected Criteria createCriteria() {
		return getSession().createCriteria(getObjectClass());
	}

	protected Criteria createCriteria(String alias) {
		return getSession().createCriteria(getObjectClass(), alias);
	}	

	public List<T> list(int fromIndex, int toIndex, String orderBy, boolean isAscending, Filter filter, Map<String, Object> context) {
		Criteria criteria = createCriteria();
		List<T> result = criteria.list();
		// DetachedCriteria criteria = DetachedCriteria.forClass(getObjectClass());
		// List<T> result = getHibernateTemplate().findByCriteria(criteria, fromIndex, toIndex - fromIndex);
		// criteria.setProjection(Projections.rowCount());
		// context.put(PersistenceService.TOTAL_COUNT, getHibernateTemplate().findByCriteria(criteria, 0, 1).iterator().next());
		return result;
	}

	public T get(Long id) {
		return (T) getSession().get(getObjectClass(), id);
		// return getHibernateTemplate().get(getObjectClass(), id);
	}
	.....................................
}

DetachedCriteria criteria = DetachedCriteria.forClass(getObjectClass());
criteria.addRestriction(Restrictions.eq("id", 1));
User user = getHibernateTemplate().findByCriteria(criteria).iterator().next();

Criteria criteria = getSession().createCriteria(getObjectClass());
criteria.addRestriction(Restrictions.eq("id", 1));
User user = criteria.list().iterator().next();

ViewController{
    public void fillUserList()
    
    public void fillUserTable()
}