spring用jdbc访问oracle数据库方法

第一步：在MyEclipse中创建工程，支持spring

第二步：

创建一个连接数据库的类

<pre name="code" class="java"><span style="font-size:14px;">package com.sai.dao;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;


import javax.sql.DataSource;


public class ExecuteDao {
<span style="white-space:pre">	</span>private DataSource dataSource;


<span style="white-space:pre">	</span>public DataSource getDataSource() {
<span style="white-space:pre">		</span>return dataSource;
<span style="white-space:pre">	</span>}


<span style="white-space:pre">	</span>public void setDataSource(DataSource dataSource) {
<span style="white-space:pre">		</span>this.dataSource = dataSource;
<span style="white-space:pre">	</span>}
<span style="white-space:pre">	</span>
<span style="white-space:pre">	</span>public void save(){
<span style="white-space:pre">		</span>try {
<span style="white-space:pre">			</span>Connection conn = dataSource.getConnection();
<span style="white-space:pre">			</span>PreparedStatement ps = conn.prepareStatement("insert into user_ values('wu','123')");
<span style="white-space:pre">			</span>ps.execute();
<span style="white-space:pre">			</span>conn.close();
<span style="white-space:pre">			</span>ps.close();
<span style="white-space:pre">		</span>} catch (SQLException e) {
<span style="white-space:pre">			</span>// TODO Auto-generated catch block
<span style="white-space:pre">			</span>e.printStackTrace();
<span style="white-space:pre">		</span>}
<span style="white-space:pre">	</span>}
}
</span>

第三步：对application.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:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">

 <bean id="dataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
        <property name="username" value="scott"/>
        <property name="password" value="123"/>
 </bean>
 
 <bean id="executeDao" class="com.sai.dao.ExecuteDao">
 	<property name="dataSource" ref="dataSource"></property>
 </bean>
</beans>

第四步：写一个测试类

package com.sai.test;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.sai.dao.ExecuteDao;

public class Test {
	public static void main(String[] args) {
		ApplicationContext factory = new ClassPathXmlApplicationContext("applicationContext.xml");
		ExecuteDao dao = (ExecuteDao)factory.getBean("executeDao");
		dao.save();
	}
}