Spring学习笔记(七)
来源:互联网 发布:java 树遍历treenode 编辑:程序博客网 时间:2024/05/23 01:14
1、spring+jdbc集成步骤
(1)配置数据源
(2)配置事务(注解方式和XML方式)
2、实例(注解方式)
(1)Person.java
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() {super();// TODO Auto-generated constructor stub}public Person(Integer id, String name) {super();this.id = id;this.name = name;}@Overridepublic String toString() {return "Person [id=" + id + ", name=" + name + "]";}}
(2)PersonService.java
public interface PersonService {public void save(Person person);public void update(Person person);public Person getPerson(Integer id);public List<Person> getPersons();public void delete(Integer id);}
(3)PersonServiceImpl.java
@Transactionalpublic class PersonServiceImpl implements PersonService { private JdbcTemplate jdbcTemplate;public void setDataSource(DataSource dataSource) {this.jdbcTemplate = new JdbcTemplate(dataSource);}@Overridepublic void save(Person person) {jdbcTemplate.update("insert into person(id,name) values(?,?)", new Object[]{person.getId(), person.getName()},new int[]{java.sql.Types.INTEGER, java.sql.Types.VARCHAR});}@Overridepublic 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});}@Transactional(propagation=Propagation.NOT_SUPPORTED)@SuppressWarnings("unchecked")@Overridepublic Person getPerson(Integer id) {return (Person)jdbcTemplate.queryForObject("select * from person where id=?", new Object[]{id}, new int[]{java.sql.Types.INTEGER}, new PersonRowMapper());}@Transactional(propagation=Propagation.NOT_SUPPORTED)@SuppressWarnings("unchecked")@Overridepublic List<Person> getPersons() {return (List<Person>)jdbcTemplate.query("select * from person", new PersonRowMapper());}@Overridepublic void delete(Integer id) {jdbcTemplate.update("delete from person where id=?", new Object[]{id},new int[]{java.sql.Types.INTEGER});}}
(4)PersonRowMapper.java
public class PersonRowMapper implements RowMapper {@Overridepublic Object mapRow(ResultSet rs, int index) throws SQLException {Person person = new Person();person.setId(rs.getInt("id"));person.setName(rs.getString("name"));return person;}}
(5)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> <!-- 采用@Transactional注解方式使用事务 --><tx:annotation-driven transaction-manager="txManager"/><bean id="personService" class="com.spring.service.impl.PersonServiceImpl"><property name="dataSource" ref="dataSource"/></bean></beans>
(6)jdbc.properties
driverClassName=org.gjt.mm.mysql.Driverurl=jdbc\:mysql\://localhost\:3306/hwd?useUnicode\=true&characterEncoding\=UTF-8username=rootpassword=123456initialSize=1maxActive=500maxIdle=2minIdle=1
(7)PersonServiceImplTest.java
public class PersonServiceImplTest {private static PersonService personService;@BeforeClasspublic static void setUpBeforeClass() throws Exception {ApplicationContext ctx = new ClassPathXmlApplicationContext("beans.xml");personService = (PersonService)ctx.getBean("personService");}@Testpublic void testSave() {Person person = new Person(1, "Tom");personService.save(person);}@Testpublic void testUpdate() {Person person = new Person(1, "Jerry");personService.update(person);}@Testpublic void testGetPerson() {Person person = personService.getPerson(1);System.out.println(person);}@Testpublic void testGetPersons() {List<Person> persons = personService.getPersons();System.out.println(persons);}@Testpublic void testDelete() {personService.delete(1);}}
3、实例(XML方式)
(1)Person.java
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() {super();// TODO Auto-generated constructor stub}public Person(Integer id, String name) {super();this.id = id;this.name = name;}@Overridepublic String toString() {return "Person [id=" + id + ", name=" + name + "]";}}(2)PersonService.java
public interface PersonService {public void save(Person person);public void update(Person person);public Person getPerson(Integer id);public List<Person> getPersons();public void delete(Integer id);}
(3)PersonServiceImpl.java
public class PersonServiceImpl implements PersonService { private JdbcTemplate jdbcTemplate;public void setDataSource(DataSource dataSource) {this.jdbcTemplate = new JdbcTemplate(dataSource);}@Overridepublic void save(Person person) {jdbcTemplate.update("insert into person(id,name) values(?,?)", new Object[]{person.getId(), person.getName()},new int[]{java.sql.Types.INTEGER, java.sql.Types.VARCHAR});}@Overridepublic 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});}@SuppressWarnings("unchecked")@Overridepublic Person getPerson(Integer id) {return (Person)jdbcTemplate.queryForObject("select * from person where id=?", new Object[]{id}, new int[]{java.sql.Types.INTEGER}, new PersonRowMapper());}@SuppressWarnings("unchecked")@Overridepublic List<Person> getPersons() {return (List<Person>)jdbcTemplate.query("select * from person", new PersonRowMapper());}@Overridepublic void delete(Integer id) {jdbcTemplate.update("delete from person where id=?", new Object[]{id},new int[]{java.sql.Types.INTEGER});}}
(4)PersonRowMapper.java
public class PersonRowMapper implements RowMapper {@Overridepublic Object mapRow(ResultSet rs, int index) throws SQLException {Person person = new Person();person.setId(rs.getInt("id"));person.setName(rs.getString("name"));return person;}}
(5)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> <!-- 采用基于XML方式使用事务 --><aop:config> <aop:pointcut id="transactionPointcut" expression="execution(* com.spring.service..*.*(..))"/> <aop:advisor advice-ref="txAdvice" pointcut-ref="transactionPointcut"/></aop:config> <tx:advice id="txAdvice" transaction-manager="txManager"> <tx:attributes> <tx:method name="get*" read-only="true" propagation="NOT_SUPPORTED"/> <tx:method name="*"/> </tx:attributes></tx:advice><bean id="personService" class="com.spring.service.impl.PersonServiceImpl"><property name="dataSource" ref="dataSource"/></bean></beans>
(6)jdbc.properties
driverClassName=org.gjt.mm.mysql.Driverurl=jdbc\:mysql\://localhost\:3306/hwd?useUnicode\=true&characterEncoding\=UTF-8username=rootpassword=123456initialSize=1maxActive=500maxIdle=2minIdle=1
(7)PersonServiceImplTest.java
public class PersonServiceImplTest {private static PersonService personService;@BeforeClasspublic static void setUpBeforeClass() throws Exception {ApplicationContext ctx = new ClassPathXmlApplicationContext("beans.xml");personService = (PersonService)ctx.getBean("personService");}@Testpublic void testSave() {Person person = new Person(1, "Tom");personService.save(person);}@Testpublic void testUpdate() {Person person = new Person(1, "Jerry");personService.update(person);}@Testpublic void testGetPerson() {Person person = personService.getPerson(1);System.out.println(person);}@Testpublic void testGetPersons() {List<Person> persons = personService.getPersons();System.out.println(persons);}@Testpublic void testDelete() {personService.delete(1);}}
0 0
- Spring学习笔记(七)
- Spring学习笔记(七)
- Spring学习笔记(七)
- 学习Spring笔记七
- Spring学习笔记(七)Spring对Dao的支持
- Spring笔记(七)
- 韩顺平Spring框架学习,学习笔记(七)
- Spring学习笔记(七):IOC控制反转
- Spring 学习笔记(七)——远程服务
- Spring 学习笔记(七) SpringMVC与Hibernate的整合
- spring in action 学习笔记(七)注入内部bean
- 学习笔记(七)
- Spring Boot学习笔记(七) Docker
- Spring学习笔记(七) --- 运行时值注入
- Spring学习(七)spring整合mybatis
- 【Spring学习笔记七】-Spring MVC基本配置和实例
- Duwamish7学习笔记(七)
- J2ME学习笔记(七)
- css3自定义checkbox与radiobox
- JS四步实现毫秒拖拽时钟
- 山科大oj--Matrix Problem : Array Practice
- [maxsprict] 一个转换逐帧动画以及改变骨骼层级的脚本
- centos6.4 64位下安装nfs文件共享系统
- Spring学习笔记(七)
- 类
- 欢迎使用CSDN-markdown编辑器
- 四种复制方法效率比较
- css
- Java并发系列-23、阻塞队列
- Windows API实现的栈及使用(支持线程安全,以原子方式操作)
- 学习web程序员角度ubuntu自修速学课程安装flash player笔记
- echarts的地图下钻静态实现,中国下钻到各省、直辖市。(省级下钻到市级、县级貌似也类似吧)