<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd">

        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
            <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://localhost:3306/tranning"/>
            <property name="username" value="root"/>
            <property name="password" value=""/>
        </bean>
        <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
            <property name="dataSource" ref="dataSource" />
            <property name="annotatedClasses">
                <list>
                    <value>com.ma.trainning.entities.Administrateur</value>
                    <value>com.ma.trainning.entities.Stagiaire</value>
                </list>
            </property>
            <property name="hibernateProperties">
                <props>
                    <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                </props>
            </property>
        </bean>
        <bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
            <property name="sessionFactory" ref="sessionFactory"></property>
        </bean>

        <tx:annotation-driven transaction-manager="transactionManager"/>

        <context:annotation-config />
        <context:component-scan base-package="com.ma.trainning"/>
</beans>

package com.ma.trainning.service;

import static org.junit.Assert.*;

import java.util.List;

import org.junit.AfterClass;
import org.junit.BeforeClass;
import org.junit.Test;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.ma.trainning.dao.AdminInterDAO;
import com.ma.trainning.entities.Administrateur;

public class AdminDAOTest {

    private static ClassPathXmlApplicationContext context;
    private static AdminInterDAO admindao;

    @BeforeClass
    public static void setUpBeforeClass() throws Exception {
        context = new ClassPathXmlApplicationContext("application-context.xml");
        admindao = (AdminInterDAO) context.getBean("admindao");
    }

    @AfterClass
    public static void tearDownAfterClass() throws Exception {
        context.close();
    }

    @Test
    public void testAddAdmin() {
        fail("Not yet implemented");
    }

    @Test
    public void testDeleteAdmin() {
        fail("Not yet implemented");
    }

    @Test
    public void testGetAllAdmin() {
        List<Administrateur> AllAdmin = admindao.getAllAdmin();
        assertNotNull(AllAdmin);
        assertTrue(AllAdmin.size() > 0);
    }

    @Test
    public void testUpdateAdmin() {
        fail("Not yet implemented");
    }

    @Test
    public void testFindById() {
        fail("Not yet implemented");
    }

}

package com.ma.trainning.dao;

import java.util.List;

import com.ma.trainning.entities.Administrateur;

public interface AdminInterDAO {
    public void addAdmin(Administrateur ad);
    public Administrateur findById(Integer id);
    public void deleteAdmin(Integer id);
    public List<Administrateur> getAllAdmin();
    public void updateAdmin(Administrateur ad);

}

package com.ma.trainning.dao;

import java.util.List;

import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.ma.trainning.entities.Administrateur;
@Service("admindao")
@Transactional
public class AdminImpliDA0 implements AdminInterDAO {

    @Autowired
    private SessionFactory sessionFactory;

    @Override
    public void addAdmin(Administrateur ad) {
        sessionFactory.getCurrentSession().beginTransaction();
        sessionFactory.getCurrentSession().merge(ad);
        sessionFactory.getCurrentSession().getTransaction().commit();
    }

    @Override
    public void deleteAdmin(Integer id) {
        sessionFactory.getCurrentSession().beginTransaction();
        Administrateur ad=findById(id);
        sessionFactory.getCurrentSession().delete(ad);
    }

    @SuppressWarnings("unchecked")
    @Override
    public List<Administrateur> getAllAdmin() {
        return sessionFactory.getCurrentSession().createQuery("from Administrateur").list();
    }

    @Override
    public void updateAdmin(Administrateur ad) {
        sessionFactory.getCurrentSession().beginTransaction();
        sessionFactory.getCurrentSession().update(ad);
        sessionFactory.getCurrentSession().getTransaction().commit();
    }

    @Override
    public Administrateur findById(Integer id) {
        return sessionFactory.getCurrentSession().load(Administrateur.class, id);
    }

}