通过Spring配置数据源及单元测试2010-03-04 12:441.xml文件(转http://hi.baidu.com/cyberfeipunk/blo)

通过Spring配置数据源及单元测试2010-03-04 12:441.xml文件

<?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:tx="http://www.springframework.org/schema/tx"
        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
                            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
                            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
   <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
   <property name="url" value="jdbc:oracle:thin:@localhost:1521:DFDB"></property>
   <property name="username" value="scott"></property>
   <property name="password" value="tiger"></property>
</bean>
<bean id="abstractDao" abstract="true">
   <property name="dataSource">
    <ref local="dataSource"/>
   </property>
</bean>
<bean id="catDao" class="org.catpro.dao.impl.CatDaoImpl" parent="abstractDao">
</bean>

</beans>  

2,Dao

package org.catpro.dao;

import java.util.List;

import org.catpro.vo.Cat;

public interface CatDao {
List<Cat> searchCat();

int delete(String kinds);
}

3，DaoImpl

package org.catpro.dao.impl;


import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;

import org.catpro.dao.CatDao;
import org.catpro.dao.conn.ConnectionPool;
import org.catpro.vo.Cat;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

public class CatDaoImpl extends JdbcDaoSupport implements CatDao {
private JdbcTemplate jdbcTemplate;

   /**
* Dao 根据种类删除信息
*/
public int delete(String kinds) {
   int result = 0;
   String sql = "delete from cat where kinds=?";
   Object[] parameValues=new Object[]{kinds};
   int[] types=new int[]{Types.VARCHAR};
   this.jdbcTemplate=this.getJdbcTemplate();
   result=this.jdbcTemplate.update(sql,parameValues,types);
   return result;
}

}

4,单元测试

package org.catpro.dao.test;

import org.catpro.dao.CatDao;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import junit.framework.TestCase;

public class CatDaoTest extends TestCase {
private ApplicationContext context = null;
@Override
protected void setUp() throws Exception {
   super.setUp();
   context=new ClassPathXmlApplicationContext("org/catpro/dao/config/dao-config.xml");
}
public void testDelete(){
   CatDao catDao=(CatDao)context.getBean("catDao");
   int result=catDao.delete("中国");
   assertTrue(result>0);
}
}