I summarized it from an appfuse project.

Section 1.

Any DAO test suit should inherit the object of AbstractTransactionalDataSourceSpringContextTests, which is used to test a data source.

 There might be many DAO objects to be tested in a project. Those DAO objects share the same configuration. Therefore, the best way is to create a new an abstract class BaseDaoTestCase extends AbstractTransactionalDataSourceSpringContextTests. The method  of getConfigLocations() must be implemented, which is to return a string array including the configuration files such as “applicationContext-hibernate.xml”, “applicationContext-resources.xml” and “applicationContext-service.xml”, etc. Those files can be used for many sub DAO test suits. Here is an example of BaseDaoTestCase:

package com.pplus.test.dao;

 

import java.util.Enumeration;

import java.util.HashMap;

import java.util.Map;

import java.util.MissingResourceException;

import java.util.ResourceBundle;

 

import org.apache.commons.beanutils.BeanUtils;

import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

import org.springframework.test.AbstractTransactionalDataSourceSpringContextTests;

 

/**

  * Base class for running Dao tests.

  * @author mraible

  */

 

public abstract class BaseDaoTestCase extends AbstractTransactionalDataSourceSpringContextTests {

    protected final Log log = LogFactory.getLog(getClass());

    protected ResourceBundle rb ;

 

    protected String[] getConfigLocations() {

        setAutowireMode( AUTOWIRE_BY_NAME );

        String dir= "file:D:/yin/CN2.0/CN21/WEB-INF/" ;

        //*

        return new String [] {dir+ "applicationContext-hibernate.xml" ,

                                dir+ "applicationContext-resources.xml" ,

                                dir+ "applicationContext-service.xml"

                              };

                              //*/

 

    }

   

    public BaseDaoTestCase() {

        // Since a ResourceBundle is not required for each class, just

        // do a simple check to see if one exists

        String className = this .getClass().getName();

 

        try {

            rb = ResourceBundle.getBundle(className);

        } catch (MissingResourceException mre) {

            //log.warn("No resource bundle found for: " + className);

        }

    }

 

    /**

     * Utility method to populate a javabean - style object with values

     * from a Properties file

     * @param obj

     * @return Object populated object

     * @throws Exception

     */

    protected Object populate(Object obj) throws Exception {

        // loop through all the beans methods and set its properties from

        // its .properties file

        Map map = new HashMap();

 

        for (Enumeration keys = rb .getKeys(); keys.hasMoreElements();) {

            String key = (String) keys.nextElement();

            map.put(key, rb .getString(key));

        }

 

        BeanUtils.copyProperties(obj, map);

 

        return obj;

    }

}

 

Section 2.

Creates a TestCase inherits BaseDaoTestCase. Generally, it includes two attributes: an object dao to be tested and an value object which reflects the key fields of the module object.  We must innovate the setter of dao. Here is an example:

package com.pplus.test.dao;

 

 

import java.util.List;

 

import javax.sql.DataSource;

 

import com.pplus.dao.TcnrDriverDao;

import com.pplus.model.TcnrDriver;

 

import org.springframework.orm.ObjectRetrievalFailureException;

 

public class TcnrDriverDaoTest extends BaseDaoTestCase {

    private Integer tcnrDriverId = new Integer("1");

    private TcnrDriverDao dao = null;

 

    public void setTcnrDriverDao(TcnrDriverDao dao) {

        this.dao = dao;

    }

   

  

 

            public void testAddTcnrDriver() throws Exception {

        TcnrDriver tcnrDriver = new TcnrDriver();

 

        // set required fields

 

        dao.saveTcnrDriver(tcnrDriver);

 

        // verify a primary key was assigned

        assertNotNull(tcnrDriver.getDriverid());

 

        // verify set fields are same after save

    }

 

    public void testGetTcnrDriver() throws Exception {

        TcnrDriver tcnrDriver = dao.getTcnrDriver(tcnrDriverId);

        assertNotNull(tcnrDriver);

    }

 

    public void testGetTcnrDrivers() throws Exception {

        TcnrDriver tcnrDriver = new TcnrDriver();

 

        List results = dao.getTcnrDrivers(tcnrDriver);

        assertTrue(results.size() > 0);

    }

 

    public void testSaveTcnrDriver() throws Exception {

        TcnrDriver tcnrDriver = dao.getTcnrDriver(tcnrDriverId);

 

        // update required fields

 

        dao.saveTcnrDriver(tcnrDriver);

 

    }

 

    public void testRemoveTcnrDriver() throws Exception {

        Integer removeId = new Integer("3");

        dao.removeTcnrDriver(removeId);

        try {

            dao.getTcnrDriver(removeId);

            fail("tcnrDriver found in database");

        } catch (ObjectRetrievalFailureException e) {

            assertNotNull(e.getMessage());

        }

    }

}