<beans>
?<bean id="dataSource"
??class="org.springframework.jdbc.datasource.DriverManagerDataSource"
??abstract="false" singleton="true" lazy-init="default"
??autowire="default" dependency-check="default">
?<property name="driverClassName"><value>oracle.jdbc.OracleDriver</value></property>
?<property name="url"><value>jdbc:oracle:thin:@10.240.144.11:1521:XYMES</value></property>
?<property name="username"><value>reel</value></property>
?<property name="password"><value>reel</value></property>
?</bean>
</beans>
------------------------------------
package com.kim.spring;
import java.util.List;
import javax.sql.DataSource;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
public class Test
{
?/**
? * @param args
? */
?public void aMethod()throws Exception
?{?
??ApplicationContext ac=new FileSystemXmlApplicationContext("F:\\kim\\kimjob\\springkim\\src\\applicationContext.xml");
??DataSource dataSource=(DataSource)ac.getBean("dataSource");
??JdbcTemplate jt=new JdbcTemplate(dataSource);
??List l= jt.queryForList("select * from abc");
??System.out.println(l.get(0).toString());
??System.out.println(l.get(0));
??int i= jt.update("update abc set bb='8'");
??System.out.println(i);
??
?}
?public static void main(String[] args)
?{
??// TODO Auto-generated method stub
??Test t=new Test();
??try
??{
???t.aMethod();
??} catch (Exception e)
??{
???// TODO: handle exception
???e.printStackTrace();
??}
?}
}
---------------------------------
結果：
log4j:WARN No appenders could be found for logger (org.springframework.core.CollectionFactory).
log4j:WARN Please initialize the log4j system properly.
{AA=2, BB=8, CC=2}
1