persondaojdbctest.java

是spring和hibernate的一个测试工程,用Junit做为基础!

package lee;

import org.springframework.context.support.FileSystemXmlApplicationContext; 
import org.springframework.context.ApplicationContext; 
import org.springframework.test.AbstractTransactionalDataSourceSpringContextTests;

import junit.framework.TestCase;
import junit.textui.TestRunner;

import javax.sql.DataSource;
import java.util.*;
/**
 * @author  yeeku.H.lee [e-mail]
 * @version  1.0
 * Copyright (C), 2005-2008, yeeku.H.Lee
 * This program is protected by copyright laws.
 * Program Name:
 * Date: 
 */
public class PersonDaoJdbcTest extends AbstractTransactionalDataSourceSpringContextTests
{
	private PersonDao pd;
	
	public String[] getConfigLocations()
	{
		String[] result = {"bean.xml"};
		return result;
	}

	public void testGetPerson()
	{
		pd = (PersonDao)applicationContext.getBean("personDao");
		assertEquals(jdbcTemplate.queryForInt("SELECT p_age FROM person_test where p_id = 32" ) ,
			pd.getPerson(32).getAge());
		assertEquals(jdbcTemplate.queryForObject("SELECT p_name FROM person_test where p_id = 32" ,String.class ) ,
			pd.getPerson(32).getName());
	} 

	public void testCreatePerson()
	{
		pd = (PersonDao)applicationContext.getBean("personDao");
		PersonBean pb = new PersonBean("中国人",24);
		assertEquals(pd.createPerson(pb),1);
	}

	public void testDeletePersonsByAge()
	{
		pd = (PersonDao)applicationContext.getBean("personDao");
		assertEquals(jdbcTemplate.update("delete from person_test where p_age between 2 and 80"),
			pd.deletePersonsByAge(2,80));
	}

	public void testFindPersonsByName()
	{
		pd = (PersonDao)applicationContext.getBean("personDao");
		List tmp1 = jdbcTemplate.queryForList("select * from person_test where p_name like '%ee%'");
		List tmp2 = pd.findPersonsByName("ee");
		for (int i = 0; i < tmp1.length ; i++ )
		{
			assertEquals( ((Map)tmp1.get(0)).get("p_name") , ( (PersonBean)tmp2.get(0) ).getName() );
			assertEquals( ((Map)tmp1.get(0)).get("p_age") , ( (PersonBean)tmp2.get(0) ).getAge() );
		}
	}

    public static void main(String[] args)
	{		
		TestRunner.run(PersonDaoJdbcTest.class);
    }
}