aop (使用properties配置文件配置xml)（发表文章的时候要注意包与文件）

cn.itcast.bean

[java]  view plain copy

1. package cn.itcast.bean;  
2.   
3. public class Person {  
4.     private Integer id;  
5.     private String name;  
6.     public Integer getId() {  
7.         return id;  
8.     }  
9.     public void setId(Integer id) {  
10.         this.id = id;  
11.     }  
12.     public String getName() {  
13.         return name;  
14.     }  
15.     public void setName(String name) {  
16.         this.name = name;  
17.     }  
18.       
19.     public Person()  
20.     {}  
21.     public Person (String name)   
22.     {  
23.         this.name=name;  
24.     }  
25.       
26. }  

cn.itcast.service

[java]  view plain copy

1. package cn.itcast.service;  
2.   
3. import java.util.List;  
4.   
5. import cn.itcast.bean.Person;  
6.   
7. public interface PersonService {  
8.     public void save(Person person);  
9.     public void update(Person person);  
10.     public  Person getPerson(Integer personid);  
11.     public List<Person>getPerson();  
12.     public void delete(Integer personid);  
13.       
14.   
15. }  

cn.itcast.service.impl

[java]  view plain copy

1. package cn.itcast.service.impl;  
2.   
3. import java.sql.ResultSet;  
4. import java.sql.SQLException;  
5.   
6. import org.springframework.jdbc.core.RowMapper;  
7.   
8. import cn.itcast.bean.Person;  
9.   
10. public class PersonRowMapper implements RowMapper {  
11.   
12.     public Object mapRow(ResultSet rs, int index) throws SQLException {  
13.           
14.         Person person=new Person(rs.getString("name"));  
15.         person.setId(rs.getInt("id"));  
16.         return person;  
17.     }  
18.   
19. }  

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;

@Transactional
public class PersonServiceBean implements PersonService {

	private JdbcTemplate jdbcTemplate;
	
	public void setDataSource(DataSource dataSource) {
		this.jdbcTemplate = new JdbcTemplate(dataSource);
	}
	
	public void delete(Integer personid) {

		jdbcTemplate.update("delete from person  where id=?", new Object[]{personid},
				new int[]{java.sql.Types.INTEGER});
		throw new RuntimeException("运行期例外");
		
	}


	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;
	@BeforeClass
	public static void setUpBeforeClass() throws Exception {
	
		try {
			ApplicationContext cxt=new ClassPathXmlApplicationContext("beans.xml");
			personService=(PersonService)cxt.getBean("personService");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	@Test
	public void save()
	{
		personService.save(new Person("传智播客"));
	}

	@Test
	public void getPerson()
	{
		Person person=personService.getPerson(1);
		System.out.println(person.getName());
	}
	
	@Test
	public void update()
	{
		Person person=personService.getPerson(1);
		person.setName("sun**");
		personService.update(person);
	}
	@Test
	public void delete()
	{
		personService.delete(1);
	}
	
	@Test
	public void getBeans()
	{
		for(Person person:personService.getPerson())
		{
			System.out.println(person.getName());
		}
	}
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
}

beans.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: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>

jdbc.properties

driverClassName=org.gjt.mm.mysql.Driver
url=jdbc\:mysql\://localhost\:3306/itcast?useUnicode\=true&characterEncoding\=UTF-8
username=root
password=
initialSize=1
maxActive=500
maxIdle=2
minIdle=1