aop （spring 事物对于unchecked可以回滚，但是对于checked例外不回滚）

来源：互联网发布：淘宝app图标素材编辑：程序博客网时间：2024/05/29 09:06

cn.itcast.bean

[java] view plaincopy
package cn.itcast.bean;  
  
public class Person {  
    private Integer id;  
    private String name;  
    public Integer getId() {  
        return id;  
    }  
    public void setId(Integer id) {  
        this.id = id;  
    }  
    public String getName() {  
        return name;  
    }  
    public void setName(String name) {  
        this.name = name;  
    }  
      
    public Person()  
    {}  
    public Person (String name)   
    {  
        this.name=name;  
    }  
      
}  

cn.itcast.service

[java] view plaincopy
package cn.itcast.service;  
  
import java.util.List;  
  
import cn.itcast.bean.Person;  
  
public interface PersonService {  
    public void save(Person person);  
    public void update(Person person);  
    public  Person getPerson(Integer personid);  
    public List<Person>getPerson();  
    public void delete(Integer personid);  
      
  
}  

cn.itcast.service.impl

[java] view plaincopy
package cn.itcast.service.impl;  
  
import java.sql.ResultSet;  
import java.sql.SQLException;  
  
import org.springframework.jdbc.core.RowMapper;  
  
import cn.itcast.bean.Person;  
  
public class PersonRowMapper implements RowMapper {  
  
    public Object mapRow(ResultSet rs, int index) throws SQLException {  
          
        Person person=new Person(rs.getString("name"));  
        person.setId(rs.getInt("id"));  
        return person;  
    }  
  
}  

package cn.itcast.service.impl;import java.util.List;import javax.sql.DataSource;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.transaction.annotation.Transactional;import cn.itcast.bean.Person;import cn.itcast.service.PersonService;@Transactionalpublic class PersonServiceBean implements PersonService {private JdbcTemplate jdbcTemplate;public void setDataSource(DataSource dataSource) {this.jdbcTemplate = new JdbcTemplate(dataSource);}//unchecked,可以回滚//checked不会回滚（这个例子就是checked例外）public void delete(Integer personid) throws Exception{jdbcTemplate.update("delete from person  where id=?", new Object[]{personid},new int[]{java.sql.Types.INTEGER});throw new Exception("运行期例外");}public Person getPerson(Integer personid) {return (Person)jdbcTemplate.queryForObject("select * from person where id=?",new Object[]{personid} ,new int[]{java.sql.Types.INTEGER},new PersonRowMapper());}@SuppressWarnings("unchecked")public List<Person> getPerson() {return (List<Person>)jdbcTemplate.query("select * from person",new PersonRowMapper());}public void save(Person person) {//第一个参数是sql语句，第二个参数是参数（数组），第三个是参数的类型（数组）jdbcTemplate.update("insert into person(name) values(?)", new Object[]{person.getName()},new int[]{java.sql.Types.VARCHAR});}public void update(Person person) {jdbcTemplate.update("update person set name=? where id=?", new Object[]{person.getName(),person.getId()},new int[]{java.sql.Types.VARCHAR,java.sql.Types.INTEGER});}}

junit.test

package junit.test;import org.junit.BeforeClass;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import org.springframework.transaction.annotation.Transactional;import cn.itcast.bean.Person;import cn.itcast.service.PersonService;public class PersonServiceTest {private static PersonService personService;@BeforeClasspublic static void setUpBeforeClass() throws Exception {try {ApplicationContext cxt=new ClassPathXmlApplicationContext("beans.xml");personService=(PersonService)cxt.getBean("personService");} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}@Testpublic void save(){personService.save(new Person("传智播客"));}@Testpublic void getPerson(){Person person=personService.getPerson(1);System.out.println(person.getName());}@Testpublic void update(){Person person=personService.getPerson(1);person.setName("sun**");personService.update(person);}@Testpublic void delete(){try {personService.delete(4);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}@Testpublic void getBeans(){for(Person person:personService.getPerson()){System.out.println(person.getName());}}}

beans.xml

[html] view plaincopy
<?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:context="http://www.springframework.org/schema/context"   
       xmlns:aop="http://www.springframework.org/schema/aop"  
       xmlns:tx="http://www.springframework.org/schema/tx"  
       xsi:schemaLocation="http://www.springframework.org/schema/beans  
           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd  
           http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd  
           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd  
           http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">  
  
     <context:property-placeholder location="classpath:jdbc.properties"/>  
     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">  
        <property name="driverClassName" value="${driverClassName}"/>  
        <property name="url" value="${url}"/>  
        <property name="username" value="${username}"/>  
        <property name="password" value="${password}"/>  
         <!-- 连接池启动时的初始值 -->  
         <property name="initialSize" value="${initialSize}"/>  
         <!-- 连接池的最大值 -->  
         <property name="maxActive" value="${maxActive}"/>  
         <!-- 最大空闲值.当经过一个高峰时间后，连接池可以慢慢将已经用不到的连接慢慢释放一部分，一直减少到maxIdle为止 -->  
         <property name="maxIdle" value="${maxIdle}"/>  
         <!--  最小空闲值.当空闲的连接数少于阀值时，连接池就会预申请去一些连接，以免洪峰来时来不及申请 -->  
         <property name="minIdle" value="${minIdle}"/>  
     </bean>  
  
    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
       <property name="dataSource" ref="dataSource"/>  
    </bean>  
    <tx:annotation-driven transaction-manager="txManager"/>  
      
    <bean id="personService" class="cn.itcast.service.impl.PersonServiceBean">  
        <property name="dataSource" ref="dataSource"/>  
    </bean>  
</beans>  