<!-- Dispatcher Servlet -->
  <servlet>
    <description></description>
    <display-name>app-dispatcher</display-name>
    <servlet-name>app-dispatcher</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>app-dispatcher</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>

  <!-- Context Listener -->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>
        classpath:applicationContext.xml
    </param-value>
  </context-param>

<context:component-scan base-package="com.app" />

    <mvc:annotation-driven></mvc:annotation-driven>

    <!-- Resource mapping for css, js, sass files -->
    <mvc:resources mapping="/resources/**" location="/resources/" />

    <bean id="jspViewResolver"
        class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/html/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>

    <bean id="tilesConfigurer"
        class="org.springframework.web.servlet.view.tiles3.TilesConfigurer">
        <property name="definitions">
            <list>
                <value>/WEB-INF/template/tiles-definitions.xml</value>
            </list>
        </property>
    </bean>

<context:annotation-config></context:annotation-config>
    <context:component-scan base-package="com"></context:component-scan>
    <tx:annotation-driven />

    <!-- Spring Hibernate Set up
         http://docs.spring.io/spring/docs/current/spring-framework-reference/html/orm.html -->

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql://localhost:3306/unicare_test"></property>
        <property name="username" value="unicare"></property>
        <property name="password" value="unicare"></property>

    </bean>

    <bean id="transactionManager"
            class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.connection.useUnicode">true</prop>
                <prop key="hibernate.connection.characterEncoding">UTF-8</prop>
                <prop key="hibernate.connection.charSet">UTF-8</prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>

        </property>

        <property name="packagesToScan">
                <list>
                    <value>com.app.books</value>

                </list>
            </property>
    </bean>

    <bean id="exceptionTranslator"
        class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor">
    </bean>

@Repository
@Transactional
@Component("bookDao")
public class BookDao {

    @Autowired
    private SessionFactory sessionFactory;


    public Session session(){
        return sessionFactory.getCurrentSession();
    }

    // Get all list of books
    public List<Book> getBookList(){

        @SuppressWarnings("unchecked")
        List<Book> returnObj = session().createQuery("from Book").list();

        return returnObj;
    }

}