1.定义一个数据源
<
bean
id
=
"comboPooledDataSource"
class
=
"com.mchange.v2.c3p0.ComboPooledDataSource"
>
<
property
value
=
"${jdbc.driverClass}"
name
=
"driverClass"
/>
<
property
value
=
"${jdbc.url}"
name
=
"jdbcUrl"
/>
<
property
value
=
"${jdbc.username}"
name
=
"user"
/>
<
property
value
=
"${jdbc.password}"
name
=
"password"
/>
</
bean
>
2.定义jdbc的jdbcTemplate
<
bean
id
=
"jdbcTemplate"
class
=
"org.springframework.jdbc.core.JdbcTemplate"
>
<
property
name
=
"dataSource"
ref
=
"comboPooledDataSource"
></
property
>
</
bean
>
3.配置事物管理器
<
bean
name
=
"transactionManager"
class
=
"DataSourceTransactionManager"
>
<
property
name
=
"dataSource"
ref
=
"comboPooledDataSource"
></
property
>
</
bean
4.开启事物
<!-- 开启注解事物管理 替代了
xml
里面的切面和通知-->
<
tx:annotation-driven
transaction-manager
=
"transactionManager"
/>
5.在该Bean的代码中标注@Tran
sactional
service层 逻辑处理层 也就是真正实现方法层