Spring Test Transactional @Rollback

作者：範宗雲 来源：原创 发布时间：2015-04-19 归档：spring-test

		    <project>
			  <properties>
			    <spring.version>4.1.5.RELEASE</spring.version>
			    <mysql.version>5.1.17</mysql.version>
			    <junit.version>4.11</junit.version>
			    <hamcrest.version>1.3</hamcrest.version>
			    <aspectj.version>1.6.8</aspectj.version>
			  </properties>
			  <dependencies>
			    <dependency>
			      <groupId>org.springframework</groupId>
			      <artifactId>spring-context</artifactId>
			      <version>${spring.version}</version>
			    </dependency>
			    <dependency>
			      <groupId>org.springframework</groupId>
			      <artifactId>spring-jdbc</artifactId>
			      <version>${spring.version}</version>
			    </dependency>
			    <dependency>
			      <groupId>org.springframework</groupId>
			      <artifactId>spring-test</artifactId>
			      <version>${spring.version}</version>
			      <scope>test</scope>
			    </dependency>
			    <dependency>
			      <groupId>mysql</groupId>
			      <artifactId>mysql-connector-java</artifactId>
			      <version>${mysql.version}</version>
			    </dependency>
			    <dependency>
			      <groupId>org.aspectj</groupId>
			      <artifactId>aspectjweaver</artifactId>
			      <version>${aspectj.version}</version>
			    </dependency>
			    <dependency>
			      <groupId>org.hamcrest</groupId>
			      <artifactId>hamcrest-all</artifactId>
			      <version>${hamcrest.version}</version>
			      <scope>test</scope>
			    </dependency>
			    <dependency>
			      <groupId>junit</groupId>
			      <artifactId>junit</artifactId>
			      <version>${junit.version}</version>
			      <scope>test</scope>
			      <exclusions>
			        <exclusion>
			          <groupId>org.hamcrest</groupId>
			          <artifactId>hamcrest-core</artifactId>
			        </exclusion>
			      </exclusions>
			    </dependency>
			  </dependencies>
			</project>
		    

		    <?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:tx="http://www.springframework.org/schema/tx"
			  xmlns:aop="http://www.springframework.org/schema/aop"
			  xsi:schemaLocation="http://www.springframework.org/schema/beans
			  http://www.springframework.org/schema/beans/spring-beans.xsd
			  http://www.springframework.org/schema/context
			  http://www.springframework.org/schema/context/spring-context.xsd
			  http://www.springframework.org/schema/tx 
			  http://www.springframework.org/schema/tx/spring-tx.xsd
			  http://www.springframework.org/schema/aop 
			  http://www.springframework.org/schema/aop/spring-aop.xsd">
			  
			  <context:annotation-config />
			  
			  <context:component-scan base-package="org.lychie" />
			  
			  <context:property-placeholder location="classpath:jdbc.properties" />
			  <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
			    <property name="url" value="${jdbc.url}" />
			    <property name="username" value="${jdbc.username}" />
			    <property name="password" value="${jdbc.password}" />
			    <property name="driverClassName" value="${jdbc.driverClassName}" />
			  </bean>
			  
			  <bean class="org.springframework.jdbc.core.JdbcTemplate">
			    <property name="dataSource" ref="dataSource" />
			  </bean>
			  
			  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
			    <property name="dataSource" ref="dataSource" />
			  </bean>
			 
			  <tx:annotation-driven transaction-manager="transactionManager"/>
			  
			  <tx:advice id="txAdvice" transaction-manager="transactionManager">
			    <tx:attributes>
			      <tx:method name="save*" propagation="REQUIRED" rollback-for="Throwable" />
			      <tx:method name="insert*" propagation="REQUIRED" rollback-for="Throwable" />
			      <tx:method name="update*" propagation="REQUIRED" rollback-for="Throwable" />
			      <tx:method name="delete*" propagation="REQUIRED" rollback-for="Throwable" />
			      <tx:method name="*" read-only="true" /> 
			    </tx:attributes>
			  </tx:advice>
			
			  <aop:config>
			    <aop:advisor pointcut="execution(* org.lychie.dao.*.*(..))" advice-ref="txAdvice" />
			  </aop:config>
			  
			</beans>
		    

		    public class LoggerRule implements TestRule {
			
				@Override
				public Statement apply(final Statement base, final Description description) {
					return new Statement() {
						@Override
						public void evaluate() throws Throwable {
							String method = description.getDisplayName();
							System.out.println("---> " + method + " is ready to execute");
							base.evaluate();
							System.out.println("---> " + method + " has been executed");
						}
					};
				}
				
			}
		    

		    @Repository
			public class EmployeeDaoImpl implements EmployeeDao {
			
				@Autowired
				private JdbcTemplate jdbcTemplate;
				
				@Override
				public List<Employee> getAll() {
					String sql = "SELECT * FROM Employee";
					return jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Employee.class));
				}
			
				@Override
				public boolean insert(Employee employee) {
					String sql = "INSERT INTO Employee(id, name, age, mail) VALUES(?, ?, ?, ?)";
					int result = jdbcTemplate.update(sql, null, employee.getName(), employee.getAge(), employee.getMail());
					return result > 0;
				}
			
			}
		    

		    @RunWith(SpringJUnit4ClassRunner.class)
			@ContextConfiguration("/beans.xml")
			@Transactional
			public class EmployeeDaoImplTest {
			
				@Autowired
				private EmployeeDao employeeDao;
				
				@Rule
				public TestRule loggerRule = new LoggerRule();
			
				@Test
				@Rollback
				public void testInsert() {
					Employee employee = new Employee();
					employee.setAge(20);
					employee.setName("店小四");
					employee.setMail("dianxiaosi@yeah.net");
					boolean successful = employeeDao.insert(employee);
					assertThat(successful, is(true));
				}
			
			}