依赖
<?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:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" 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-3.2.xsd">
配置文件中引入属性文件
<bean>方式
<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location" value="jdbc.properties" /> </bean>
<context/>
<context:property-placeholder location="classpath:jdbc.properties" />
配置C3P0连接池
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="${jdbc.DriverClassName}" /> <property name="jdbcUrl" value="${jdbc.url}" /> <property name="user" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> </bean>
增查改删
jdbcTemplate.update("insert into account values(null,?,?)", "zly", 1234d); jdbcTemplate.update("delete from account where id=2"); jdbcTemplate.update("update account set name = ? where id = ?","zly",1d); String name = jdbcTemplate.queryForObject("select name from account where id=?", String.class,1d) Long integer = jdbcTemplate.queryForObject("select count(*) from account where name like ?", Long.class,"z%")
封装成类
list:
List<Account> query = jdbcTemplate.query("select * from account", new MyRowMapper()); for (Account account : query) { System.out.println(account); }
单个类
Account account = jdbcTemplate.queryForObject("select * from account where id=?", new MyRowMapper(), 1d);
MyRowMapper类(类名不是一定的 但是要继承RowMapper接口 重写mapRow方法)
class MyRowMapper implements RowMapper<Account>{ private Account account; @Override public Account mapRow(ResultSet resultSet, int i) throws SQLException { ClassPathXmlApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring.xml"); account = (Account)applicationContext.getBean("account"); account.setMoney(resultSet.getDouble("money")); account.setUsername(resultSet.getString("name")); account.setId(resultSet.getLong("id")); return account; } }
事务简介
Spring编程式事务配置
配置平台事务管理器
<!--配置事务管理器-->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
Spring提供了事务管理的模板类
<!--配置事务管理模板-->
<bean id="transactionTemplate"
class="org.springframework.transaction.support.TransactionTemplate">
<property name="transactionManager" ref="transactionManager"/>
</bean>
事务管理代码
XML方式声明事务管理
配置事务管理器
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
AOP的配置
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="*" propagation="REQUIRED"/>
</tx:attributes>
</tx:advice>
注解方式声明事务管理
开启注解事务
在业务层添加注解