在spring采用純JDBC進(jìn)行數(shù)據(jù)庫操作：

applicationContext.xml

view plaincopy to clipboardprint?
<?xml version="1.0" encoding="UTF-8"?> 
<beans 
 xmlns="http://www./schema/beans" 
 xmlns:xsi="http://www./2001/XMLSchema-instance" 
 xsi:schemaLocation="http://www./schema/beans http://www./schema/beans/spring-beans-2.0.xsd"> 
 <!-- JDBC模板 --> 
 <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> 
          <property name="dataSource"> 
                   <ref local="dataSource"/>          
          </property> 
 </bean> 
 <!-- 數(shù)據(jù)源 --> 
 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> 
          <property name="driverClassName"> 
                   <value>org.gjt.mm.mysql.Driver</value> 
          </property> 
          <property name="url"> 
                   <value>jdbc:mysql://localhost:3306/test</value> 
          </property> 
          <property name="username"> 
                   <value>root</value>                  
          </property> 
          <property name="password">          
                   <value>root</value> 
          </property> 
 </bean> 
 <!--事務(wù)模板 --> 
 <bean id="transactionTemplate" class="org.springframework.transaction.support.TransactionTemplate"> 
          <property name="transactionManager"> 
                   <ref local="transactionManager"/> 
          </property> 
 </bean> 
 <!-- jdbc事務(wù)管理器 --> 
 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 
          <property name="dataSource">          
           <ref local="dataSource"/> 
  </property> 
 </bean> 
</beans> 
<?xml version="1.0" encoding="UTF-8"?>
<beans
 xmlns="http://www./schema/beans"
 xmlns:xsi="http://www./2001/XMLSchema-instance"
 xsi:schemaLocation="http://www./schema/beans http://www./schema/beans/spring-beans-2.0.xsd">
 <!-- JDBC模板 -->
 <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
          <property name="dataSource">
                   <ref local="dataSource"/>       
          </property>
 </bean>
 <!-- 數(shù)據(jù)源 -->
 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
          <property name="driverClassName">
                   <value>org.gjt.mm.mysql.Driver</value>
          </property>
          <property name="url">
                   <value>jdbc:mysql://localhost:3306/test</value>
          </property>
          <property name="username">
                   <value>root</value>               
          </property>
          <property name="password">       
                   <value>root</value>
          </property>
 </bean>
 <!--事務(wù)模板 -->
 <bean id="transactionTemplate" class="org.springframework.transaction.support.TransactionTemplate">
          <property name="transactionManager">
                   <ref local="transactionManager"/>
          </property>
 </bean>
 <!-- jdbc事務(wù)管理器 -->
 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
          <property name="dataSource">       
           <ref local="dataSource"/>
  </property>
 </bean>
</beans>
 

測試代碼：

view plaincopy to clipboardprint?
package com.spring.jdbc;  
 
import org.springframework.beans.factory.BeanFactory;  
import org.springframework.beans.factory.xml.XmlBeanFactory;  
import org.springframework.core.io.ClassPathResource;  
import org.springframework.core.io.Resource;  
import org.springframework.jdbc.core.JdbcTemplate;  
import org.springframework.transaction.TransactionStatus;  
import org.springframework.transaction.support.TransactionCallbackWithoutResult;  
import org.springframework.transaction.support.TransactionTemplate;  
 
/** 
 * JDBC編程式事務(wù)控制 
 * @author nk 
 * 
 */ 
public class JdbcTemplateTest {  
         public static void main(String[] args) {  
                  Resource resource = new ClassPathResource("applicationContext.xml");  
                  BeanFactory factory = new XmlBeanFactory(resource);                  
                  final JdbcTemplate jdbcTemplate = (JdbcTemplate)factory.getBean("jdbcTemplate");  
                  //不會被回滾  
                  jdbcTemplate.execute("insert into test(name,age) values('Tom2',20)");  
                  TransactionTemplate transactionTemplate = (TransactionTemplate)factory.getBean("transactionTemplate");  
                  //回調(diào)方法中的jdbc操作,，如果未發(fā)生異常則會自動提交,，發(fā)生異常則會回滾  
                  transactionTemplate.execute(new TransactionCallbackWithoutResult(){          
                           protected void doInTransactionWithoutResult(TransactionStatus status) {  
                                    try {  
                                             jdbcTemplate.execute("insert into test(name,age) values('Tom',20)");  
                                             jdbcTemplate.execute("insert into test(name,ages) values('Tom',20)");  
                                    } catch (Exception e) {  
                                             status.setRollbackOnly();  //回滾  
                                             System.out.println("回滾事務(wù)");                  
                                    }          
                           }  
                  });  
         }  
} 

 

本文來自CSDN博客,，轉(zhuǎn)載請標(biāo)明出處：http://blog.csdn.net/yeson6/archive/2009/12/07/4954589.aspx