dbunit+spring

1.dbunit+spring 必须 

   dbunit2.2+spring.2.5+junit4.4+spring-test-2.5.6.jar+commons-dbcp-1.0.jar+commons-pool-1.0.jar

2.被测试类

public class PersonDaoImpl2 implements PersonDao {
	private HibernateTemplate template;
	
	public Person find(Integer id) throws SQLException, Exception {
		Person person = null;
		person = (Person) this.template.get(Person.class, id);
		return person;
	}
}

 3.applicationContext.xml

                <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
		<property name="url" value="jdbc:mysql://127.0.0.1:3306/hejietest"></property>
		<property name="username" value="root"></property>
		<property name="password" value="hejie"></property>
	</bean>
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
		   <ref local="dataSource" />
		 </property>
		<property name="configLocation" value="classpath:hibernate.cfg.xml">
		</property>
	</bean>
	<bean id="template" class="org.springframework.orm.hibernate3.HibernateTemplate">
		<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="dataSource"></property>
	</bean>
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"></property>
	</bean>
	<!-- dao -->
	<bean id="personDao2" class="com.dao.PersonDaoImpl2">
		<property name="template" ref="template"></property>
	</bean>

 4.hibernate.cfg.xml

<session-factory>
		<property name="myeclipse.connection.profile">mysql</property>
		<property name="show_sql">true</property>
		<mapping resource="com/entity/Dbunit.hbm.xml" />
	</session-factory>

 5.测试类

@ContextConfiguration(locations={"classpath:/applicationContext.xml"})  一个数组可以读多个文件
public class DBSpringTest extends AbstractTransactionalJUnit4SpringContextTests  {
	@Autowired  //注入
	private PersonDaoImpl2 personDao;
	@Autowired
	private JdbcTemplate jdbcTemplate;
	@Autowired
	private LocalSessionFactoryBean sessionFactory ;
	@BeforeTransaction  //在测试前执行，带事务
	public void beforeFun(){
		System.out.println("====before===");
		String deleteAllSql = "delete from dbunit";
		jdbcTemplate.execute(deleteAllSql);
		String insertSql = "insert into dbunit values(1,'tr','pass')";
		jdbcTemplate.execute(insertSql);
//		jdbcTemplate.execute("commit");
	}
	@Test  //测试方法
	public void testFind() throws SQLException, Exception{
		System.out.println(personDao.find(1).getName()+"   "+sessionFactory);
	}
	@AfterTransaction     //测试后运行，带事务
	public void afterFun(){
		System.out.println("===after====");
//		String insertSql = "insert into dbunit values(1,'tr','pass')";
//		jdbcTemplate.execute(insertSql);
	}
	
}

 

 

 

 

评论

2 楼 qq262549820 2011-03-04  

1 楼 qq262549820 2011-03-04  

引用

真的看不懂！…………我是初学者！