JdbcTemplate

Spring的数据库操作：

applicationContext.xml

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  <property name="driverClassName">
             <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
  </property>
  <property name="url">
      <value>jdbc:microsoft:sqlserver://localhost:1433;databasename=wdf</value>
  </property>
  <property name="username">
      <value>sa</value>
  </property>
  <property name="password">
      <value>sa</value>
  </property>
   </bean>
   <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource">
    <ref bean="dataSource"/>
    </property>
   </bean>
   <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
   <property name="dataSource">
    <ref bean="dataSource"/>
    </property>
   </bean>
   <bean id="helloDAO" class="com.wdf.dao.HelloDAO">
   <property name="jdbcTemplate">
   <ref bean="jdbcTemplate"/>
   </property>
   <property name="transactionManager">
   <ref bean="transactionManager"/>
   </property>
   </bean>

HelloDAO.java

package com.wdf.dao;

import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.DefaultTransactionDefinition;

public class HelloDAO {
  private JdbcTemplate jdbcTemplate;
  private PlatformTransactionManager transactionManager;
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
public void setTransactionManager(PlatformTransactionManager transactionManager) {
this.transactionManager = transactionManager;
}
public int create(String msg){
DefaultTransactionDefinition def=new DefaultTransactionDefinition();
TransactionStatus status=transactionManager.getTransaction(def);
try {
  jdbcTemplate.update("insert into hello values('won','HelloWorld')");
  System.out.println("insert into hello !!!");
} catch (Exception e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
  transactionManager.rollback(status);
}finally{
  transactionManager.commit(status);
}
return 1;
}
}
Test.java

public class Test {

/**
  * @param args
  */
public static void main(String[] args) {
  // TODO Auto-generated method stub
  ApplicationContext actx=new FileSystemXmlApplicationContext("applicationContext.xml");
    HelloDAO hello=(HelloDAO)actx.getBean("helloDAO");
    hello.create(null);
}

}