spring注解事物例子

1.applicationContext.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-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"  
    xmlns:tx="http://www.springframework.org/schema/tx">  
  

   <!-- 定义JdbcTemplate的Bean -->  

   <!--<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"  

       <property name="dataSource" ref="dataSource">

       </bean>  -->

    <tx:annotation-driven transaction-manager="transactionManager" />  

    <bean id="transactionManager"  
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager ">  
        <property name="dataSource">  
            <ref bean="dataSource" />  
        </property>  
    </bean>  
  
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">  
        <property name="url"  
            value="jdbc:mysql://localhost:3306/ibatis?characterEncoding=utf8" />  
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />  
        <property name="username" value="root" />  
        <property name="password" value="root" />  
        <property name="maxActive" value="100" />  
        <property name="maxIdle" value="30" />  
        <property name="maxWait" value="1000" />  
        </bean>  
  
    <bean id="userService" class="com.spring.service.UserServiceImpl">  
        <property name="dataSource" ref="dataSource" ></property>
    </bean>  
  
</beans>  

2.创建对应的数据表的PO.

package com.spring.po;

public class User{
    
    private String username;
    private String password;
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
}

3.数据操作接口

package com.spring.service;

import org.springframework.transaction.annotation.Transactional;

import com.spring.po.User;
@Transactional(propagation=org.springframework.transaction.annotation.Propagation.REQUIRED)
public interface UserService{
    
    public void save(User user);
}

4.接口实现类。

package com.spring.service;

import javax.sql.DataSource;

import org.springframework.jdbc.core.JdbcTemplate;

import com.spring.po.User;

public class UserServiceImpl implements UserService{
    
    private JdbcTemplate JdbcTemplate;
    

    public void setDataSource(DataSource dataSource) {
        this.JdbcTemplate = new JdbcTemplate(dataSource);
    }

    public void save(User user){
        JdbcTemplate.update(" insert into User(username,password) values(?,?) ",
               new Object[]{user.getUsername(),user.getPassword()});
    }
}

5.测试

package com.spring.test;

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

import com.spring.po.User;
import com.spring.service.UserService;

public class Test{
    
    public static void main(String[] args){
     ApplicationContext    ctx=new FileSystemXmlApplicationContext("src/applicationContext.xml");
     UserService s=(UserService)ctx.getBean("userService");
     User user =new User();
     user.setUsername("123456");
     user.setPassword("123456");
     s.save(user);
    }
}

转载于:https://my.oschina.net/yangfeima/blog/899278