<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close"
      p:driverClassName="com.mysql.jdbc.Driver"
      p:url="jdbc:mysql://localhost:3306/test" p:username="root" p:password="root" />

<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <!--<property name="configLocation" value="classpath:hibernate.cfg.xml" />-->
    <property name="packagesToScan" value="com.spring.model" />
    <!--<property name="annotatedPackages" value="com.websimba.spring.model"/>-->
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect" >org.hibernate.dialect.MySQL5Dialect</prop>
            <prop key="hibernate.show_sql" >true</prop>
            <prop key="current_session_context_class">thread</prop>
            <prop key="hbm2ddl.auto">update</prop>
            <prop key="hibernate.charSet">UTF-8</prop>
        </props>
    </property>
</bean>

<tx:annotation-driven transaction-manager="transactionManager" />
<bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
    <property name="sessionFactory" ref="sessionFactory" />
</bean>

@Component
public class CatTestDaoImpl implements CatTestDao {

    @Autowired
    private SessionFactory sessionFactory;

    @Transactional
    @SuppressWarnings("unchecked")
    public List<Categories> listCat() {
        return sessionFactory.getCurrentSession().createQuery("from Categories").list();
    }
}

@Controller
public class HomeController {

    @Autowired
    private CatTestDaoImpl catTestDao;

    @RequestMapping(value = "/", method = RequestMethod.GET)
    public String home(Map<String,Object> map){
        map.put("Categories", new Categories());
        map.put("CategoriesList",catTestDao.listCat());
        return "home";
    }
}