JdbcDaoSupport运用

JdbcDaoSupport应用

1.applicationContext.xml配置文件:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="myDataSource"
   class="org.apache.commons.dbcp.BasicDataSource"
   destroy-method="close">
   <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
   <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:lrmora9" />
   <property name="username" value="dmis2006_sj" />
   <property name="password" value="omssj" />
   <property name="maxActive" value="5" />
   <property name="maxIdle" value="3" />
   <property name="minIdle" value="2" />
   <property name="maxWait" value="2" />
   <property name="initialSize" value="1" />
   <property name="removeAbandoned" value="true" />
   <property name="removeAbandonedTimeout" value="180" />
   <property name="logAbandoned" value="true" />
</bean>

<bean id="jdbcDao" class="com.lrm.study.jdbc.SpringJdbcDaoSupportApp">
   <property name="dataSource">
    <ref bean="myDataSource" />
   </property>
</bean>
</beans>

 

2.测试类：

package com.lrm.study.springJDBCDao;

import java.util.List;
import java.util.Map;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

public class SpringJdbcDaoSupportApp extends JdbcDaoSupport{
/**
*@Create on May 10, 2010 by lrm
*/
public static void main(String[] args) {
   //applicationContext.xml这个文件放到src下，如果报找不到这样的文件，直接拷贝到web-root下的classes下
   ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
   SpringJdbcDaoSupportApp jdbcDao = (SpringJdbcDaoSupportApp) ctx.getBean("jdbcDao");
   String sql = "select t.ftypename from dmis_eqptype t where t.fcategory = '保护'";
   List reList = jdbcDao.queryListBySql(sql);
   if(reList.size()>0){
    for (int i = 0; i < reList.size(); i++) {
     String typename = ((Map)reList.get(i))==null?"":((Map)reList.get(i)).get("ftypename").toString();
     System.out.println(typename);
    }
   }
}

public List queryListBySql(String sql){
   return this.getJdbcTemplate().queryForList(sql);
}

}

 

注意：这里需求相关的jar包支持，否则会报错.commons-dbcp-1.2.1.jar ;commons-pool-1.2.jar ;commons-collections-3.1.jar; spring-1.2.6.jar; spring-aop.jar;ojdbc14.jar