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" 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" /> </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