当前位置:Gxlcms > 数据库问题 > Spring第三天——JdbcTemplate和spring事务管理

Spring第三天——JdbcTemplate和spring事务管理

时间:2021-07-01 10:21:17 帮助过:12人阅读

    aspectJ的aop操作(基于注解,对比day02配置操作)(会用)
    *jdbcTemplate操作(实现CRUD)
    *spring配置连接池
    *spring事务管理

一、AspectJ的基于注解的AOP操作
    (day02的配置回顾,略显麻烦,配置稍多)

    建立项目记得导入day02操作aop的那些包(如果是复制项目一定要修改项目的context name)
    再把配置文件拿过来

  1. <span style="font-size: 16px"><?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"<span style="color: #000000">
  3. xmlns:xsi</span>="http://www.w3.org/2001/XMLSchema-instance"<span style="color: #000000">
  4. xmlns:aop</span>="http://www.springframework.org/schema/aop" xsi:schemaLocation=<span style="color: #000000">"
  5. </span> http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/beans </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/beans/spring-beans-4.3.xsd</span>
  6. http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/aop </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/aop/spring-aop.xsd</span><span style="color: #008000">"> </span>
  7. <!-- 开启aop代理(开启aop操作) -->
  8. <aop:aspectj-autoproxy></aop:aspectj-autoproxy>
  9. <!-- 配置创建对象 -->
  10. <bean id="book" <span style="color: #0000ff">class</span>="cn.aop.Book"></bean>
  11. <bean id="buyBook" <span style="color: #0000ff">class</span>="cn.aop.BuyBook"></bean>
  12. </beans></span>

    建立两个类:Book 和 BuyBook

 

  依旧使用配置文件创建对象,开启aop操作
    在增强的类上使用注解实现增强的操作

 

    在增强的类上使用注解完成aop操作
    在类上加@Aspect
    在方法上加真正的注解
  @Before 前置通知
  @AfterReturning 后置通知
  @Around 环绕通知
  @AfterThrowing 抛出通知
  @After 最终通知

 

  value属性值为原来的表达式的值
  (表达式写法需要注意)
  其它项目不用时请将其关闭!

 

  1. <span style="font-size: 16px"><span style="color: #0000ff">package</span><span style="color: #000000"> cn.aop;
  2. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> Book {
  3. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> buy(){
  4. System.out.println(</span>"Book.buy"<span style="color: #000000">);
  5. }
  6. }</span></span>
  1. <span style="font-size: 16px"><span style="color: #0000ff">package</span><span style="color: #000000"> cn.aop;
  2. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.aspectj.lang.annotation.Aspect;
  3. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.aspectj.lang.annotation.Before;
  4. @Aspect
  5. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> BuyBook {
  6. </span><span style="color: #008000">//</span><span style="color: #008000">方法上使用注解完成真正的增强操作</span>
  7. @Before(value="execution(* cn.aop.Book.*(..))"<span style="color: #000000">)
  8. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> before1(){
  9. System.out.println(</span>"BuyBook.before"<span style="color: #000000">);
  10. }
  11. }</span></span>

二、jdbcTemplate操作
  spring是一站式的框架,对应javaEE三层框架都有不同的解决方案,jdbcTemplate就是对应于DAO层的
  spring对不同的持久化层技术都作了不同的支持
  JDBC === jdbcTemplate
  Hibernate === HibernateTemplate (少写很多的操作)
  MyBatis JPA等都有不同的支持

  jdbcTemplate使用(CRUD操作)和DBUtils比较类似(但是并没有DBUtils方便,只是jdbc模板是spring封装好的)

  具体的使用:
    准备工作:
      导包:spring-jdbc spring-tx(事务)
    说到数据库,当然少不了最最最基本驱动jar包

           技术分享

  添加:
    依赖连接池获得连接,创建对象,设置数据库信息
    创建jdbcTemplate对象,设置数据源

  建表
    使用jdbcTemplate实现操作(和DBUtils是非常像的)
    增加修改在类中,删除不再赘述,只是SQL语句的差异
    当然,具体的信息可以通过log4j看到(待补充log4j的详细用法)

  1. <span style="font-size: 16px"><span style="color: #0000ff">package</span><span style="color: #000000"> cn.jdbc;
  2. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.junit.Test;
  3. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.springframework.jdbc.core.JdbcTemplate;
  4. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.springframework.jdbc.datasource.DriverManagerDataSource;
  5. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> JDBCDemo01 {
  6. @Test
  7. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> add(){
  8. </span><span style="color: #008000">//</span><span style="color: #008000">创建对象,设置数据库信息</span>
  9. DriverManagerDataSource dataSource = <span style="color: #0000ff">new</span><span style="color: #000000"> DriverManagerDataSource();
  10. dataSource.setDriverClassName(</span>"com.mysql.jdbc.Driver"<span style="color: #000000">);
  11. </span><span style="color: #008000">//</span><span style="color: #008000">本机时可以写成jdbc:mysql:</span><span style="color: #008000">//</span><span style="color: #008000">/mydb</span>
  12. dataSource.setUrl("jdbc:mysql://localhost:3306/mydb"<span style="color: #000000">);
  13. dataSource.setUsername(</span>"root"<span style="color: #000000">);
  14. dataSource.setPassword(</span>"root"<span style="color: #000000">);
  15. </span><span style="color: #008000">//</span><span style="color: #008000">创建jdbcTemplate对象,设置数据源</span>
  16. JdbcTemplate jdbcTemplate = <span style="color: #0000ff">new</span><span style="color: #000000"> JdbcTemplate(dataSource);
  17. </span><span style="color: #008000">//</span><span style="color: #008000">使用jdbcTemplate实现操作(已经建表)</span>
  18. String sql = "insert into user values(?,?)"<span style="color: #000000">;
  19. </span><span style="color: #008000">//</span><span style="color: #008000">注意使用的方法,dbutils调的也是update方法,参数是SQL和可变参数</span>
  20. <span style="color: #0000ff">int</span> i = jdbcTemplate.update(sql, "lulu","123"<span style="color: #000000">);
  21. System.out.println(i);
  22. }
  23. </span><span style="color: #008000">//</span><span style="color: #008000">测试模板的修改方法,这是SQL语句的方法</span>
  24. <span style="color: #000000"> @Test
  25. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> update(){
  26. </span><span style="color: #008000">//</span><span style="color: #008000">创建对象,设置数据库信息</span>
  27. DriverManagerDataSource dataSource = <span style="color: #0000ff">new</span><span style="color: #000000"> DriverManagerDataSource();
  28. dataSource.setDriverClassName(</span>"com.mysql.jdbc.Driver"<span style="color: #000000">);
  29. </span><span style="color: #008000">//</span><span style="color: #008000">本机时可以写成jdbc:mysql:</span><span style="color: #008000">//</span><span style="color: #008000">/mydb</span>
  30. dataSource.setUrl("jdbc:mysql://localhost:3306/mydb"<span style="color: #000000">);
  31. dataSource.setUsername(</span>"root"<span style="color: #000000">);
  32. dataSource.setPassword(</span>"root"<span style="color: #000000">);
  33. </span><span style="color: #008000">//</span><span style="color: #008000">创建jdbcTemplate对象,设置数据源</span>
  34. JdbcTemplate jdbcTemplate = <span style="color: #0000ff">new</span><span style="color: #000000"> JdbcTemplate(dataSource);
  35. String sql </span>= "update user set username=? where username=?"<span style="color: #000000">;
  36. </span><span style="color: #0000ff">int</span> i = jdbcTemplate.update(sql, "lucy","lulu"<span style="color: #000000">);
  37. System.out.println(i);
  38. }
  39. }</span></span>

  *查询:查询是重点
    (QueryRunner runner = new QueryRunner(dataSource);
    runner.query(sql,new BeanHandler<User>(User.class));
    具体的ResultSetHandler可参考DBUtils部分)
    使用jdbcTemplate实现查询时,有接口RowMapper,但没有像dbutils一样提供实现类
    需要自己提供实现类(学习这个的目的不是为了更加方便,而是一般的,如果允许,尽量使用少的技术)
    回顾JDBC底层实现查询结果,将结果集封装到对象中
  查询的具体实现:
    1.返回某一个值
      queryForObject(sql, requiredType) 返回类型,如Integer.class(统计记录数)
    2.返回一个对象
      jdbcTemplate.queryForObject(sql, rowMapper, args)
      第二个是结果集的处理,第三个是可变参数
      第二个接口可以写匿名内部类,当然也可以单独写个类(更直观)

    RowMapper实现类
      class MyRowMapper implements RowMapper<User>{

      public User mapRow(ResultSet arg0, int arg1) throws SQLException {
    第二个 int arg1 表示行号(结果集的行号)
      return null;
    3.返回一个集合
      jdbcTemplate.query(sql, rowMapper, args)
      第三个是可变参数(当然有可省略的重载方法),返回的是集合
      数据封装也要自己写

 给出一个Demo如下(注意最后给出的实现类):

 

  1. <span style="font-size: 16px"><span style="color: #0000ff">package</span><span style="color: #000000"> cn.jdbc;
  2. </span><span style="color: #0000ff">import</span><span style="color: #000000"> java.sql.ResultSet;
  3. </span><span style="color: #0000ff">import</span><span style="color: #000000"> java.sql.SQLException;
  4. </span><span style="color: #0000ff">import</span><span style="color: #000000"> java.util.List;
  5. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.junit.Test;
  6. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.springframework.jdbc.core.JdbcTemplate;
  7. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.springframework.jdbc.core.RowMapper;
  8. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.springframework.jdbc.datasource.DriverManagerDataSource;
  9. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> JDBCDemo02 {
  10. </span><span style="color: #008000">//</span><span style="color: #008000">演示查询返回某个值</span>
  11. <span style="color: #000000"> @Test
  12. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> count(){
  13. </span><span style="color: #008000">//</span><span style="color: #008000">创建对象,设置数据库信息</span>
  14. DriverManagerDataSource dataSource = <span style="color: #0000ff">new</span><span style="color: #000000"> DriverManagerDataSource();
  15. dataSource.setDriverClassName(</span>"com.mysql.jdbc.Driver"<span style="color: #000000">);
  16. </span><span style="color: #008000">//</span><span style="color: #008000">本机时可以写成jdbc:mysql:</span><span style="color: #008000">//</span><span style="color: #008000">/mydb</span>
  17. dataSource.setUrl("jdbc:mysql://localhost:3306/mydb"<span style="color: #000000">);
  18. dataSource.setUsername(</span>"root"<span style="color: #000000">);
  19. dataSource.setPassword(</span>"root"<span style="color: #000000">);
  20. </span><span style="color: #008000">//</span><span style="color: #008000">创建jdbcTemplate对象,设置数据源</span>
  21. JdbcTemplate jdbcTemplate = <span style="color: #0000ff">new</span><span style="color: #000000"> JdbcTemplate(dataSource);
  22. String sql </span>= "SELECT COUNT(*) FROM user"<span style="color: #000000">;
  23. Integer i </span>= jdbcTemplate.queryForObject(sql, Integer.<span style="color: #0000ff">class</span><span style="color: #000000">);
  24. System.out.println(i);
  25. }
  26. </span><span style="color: #008000">//</span><span style="color: #008000">演示返回对象</span>
  27. <span style="color: #000000"> @Test
  28. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> obj(){
  29. </span><span style="color: #008000">//</span><span style="color: #008000">创建对象,设置数据库信息</span>
  30. DriverManagerDataSource dataSource = <span style="color: #0000ff">new</span><span style="color: #000000"> DriverManagerDataSource();
  31. dataSource.setDriverClassName(</span>"com.mysql.jdbc.Driver"<span style="color: #000000">);
  32. </span><span style="color: #008000">//</span><span style="color: #008000">本机时可以写成jdbc:mysql:</span><span style="color: #008000">//</span><span style="color: #008000">/mydb</span>
  33. dataSource.setUrl("jdbc:mysql://localhost:3306/mydb"<span style="color: #000000">);
  34. dataSource.setUsername(</span>"root"<span style="color: #000000">);
  35. dataSource.setPassword(</span>"root"<span style="color: #000000">);
  36. </span><span style="color: #008000">//</span><span style="color: #008000">创建jdbcTemplate对象,设置数据源</span>
  37. JdbcTemplate jdbcTemplate = <span style="color: #0000ff">new</span><span style="color: #000000"> JdbcTemplate(dataSource);
  38. String sql </span>= "select * from user where username=?"<span style="color: #000000">;
  39. </span><span style="color: #008000">//</span><span style="color: #008000">和dbutils类似,也是new一个处理器,不过这里需要自己实现</span>
  40. User user = jdbcTemplate.queryForObject(sql, <span style="color: #0000ff">new</span> MyRowMapper(), "mary"<span style="color: #000000">);
  41. System.out.println(user);
  42. }
  43. </span><span style="color: #008000">//</span><span style="color: #008000">返回对象集合</span>
  44. <span style="color: #000000"> @Test
  45. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> objlist(){
  46. </span><span style="color: #008000">//</span><span style="color: #008000">创建对象,设置数据库信息</span>
  47. DriverManagerDataSource dataSource = <span style="color: #0000ff">new</span><span style="color: #000000"> DriverManagerDataSource();
  48. dataSource.setDriverClassName(</span>"com.mysql.jdbc.Driver"<span style="color: #000000">);
  49. </span><span style="color: #008000">//</span><span style="color: #008000">本机时可以写成jdbc:mysql:</span><span style="color: #008000">//</span><span style="color: #008000">/mydb</span>
  50. dataSource.setUrl("jdbc:mysql://localhost:3306/mydb"<span style="color: #000000">);
  51. dataSource.setUsername(</span>"root"<span style="color: #000000">);
  52. dataSource.setPassword(</span>"root"<span style="color: #000000">);
  53. </span><span style="color: #008000">//</span><span style="color: #008000">创建jdbcTemplate对象,设置数据源</span>
  54. JdbcTemplate jdbcTemplate = <span style="color: #0000ff">new</span><span style="color: #000000"> JdbcTemplate(dataSource);
  55. String sql </span>= "select * from user"<span style="color: #000000">;
  56. List</span><User> list = jdbcTemplate.query(sql, <span style="color: #0000ff">new</span><span style="color: #000000"> MyRowMapper());
  57. </span><span style="color: #0000ff">for</span><span style="color: #000000"> (User user : list) {
  58. System.out.println(user.getUsername());
  59. }
  60. }
  61. }<br>//属性封装需要自己实现
  62. </span><span style="color: #0000ff">class</span> MyRowMapper <span style="color: #0000ff">implements</span> RowMapper<User><span style="color: #000000">{
  63. </span><span style="color: #0000ff">public</span> User mapRow(ResultSet rs, <span style="color: #0000ff">int</span> num) <span style="color: #0000ff">throws</span><span style="color: #000000"> SQLException {
  64. String username </span>= rs.getString("username");<span style="color: #008000">//</span><span style="color: #008000">使用索引更高效</span>
  65. String password = rs.getString("password"<span style="color: #000000">);
  66. User user </span>= <span style="color: #0000ff">new</span><span style="color: #000000"> User();
  67. user.setUsername(username);
  68. user.setPassword(password);
  69. </span><span style="color: #0000ff">return</span><span style="color: #000000"> user;
  70. }
  71. }</span></span>

 

三、spring配置连接池和dao使用jdbcTemplate:
  导包:
    c3p0的两个jar包 c3p0 和依赖包 mchange
    在配置连接池(原始方式见数据库连接池部分)
    ComboPooledDataSource这个类本身里面就有属性和相关的set()方法
    可以使用之前学的属性注入!属性注入注入的属性就是参考set()方法命名规范

bean1.xml配置文件:

  可以创建service dao 进行稍微正式的测试,顺便复习属性注入
  给JdbcTemplate需要传入dataSource ,需要注意注意这个
  service注入dao
  dao注入jdbcTemplate
  jdbcTemplate注入dataSource

  1. <span style="font-size: 16px"><?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"<span style="color: #000000">
  3. xmlns:xsi</span>="http://www.w3.org/2001/XMLSchema-instance"<span style="color: #000000">
  4. xmlns:aop</span>="http://www.springframework.org/schema/aop" xsi:schemaLocation=<span style="color: #000000">"
  5. </span> http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/beans </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/beans/spring-beans-4.3.xsd</span>
  6. http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/aop </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/aop/spring-aop.xsd</span><span style="color: #008000">"> </span>
  7. <!-- 配置c3p0连接池 -->
  8. <bean id="dataSource" <span style="color: #0000ff">class</span>="com.mchange.v2.c3p0.ComboPooledDataSource">
  9. <!-- 进行属性注入 -->
  10. <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
  11. <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/mydb"></property>
  12. <property name="user" value="root"></property>
  13. <property name="password" value="root"></property>
  14. </bean>
  15. <!-- 在配置中配置依赖注入 -->
  16. <bean id="userService" <span style="color: #0000ff">class</span>="cn.c3p0.UserService">
  17. <!-- service中注入dao -->
  18. <property name="dao" ref="dao"></property>
  19. </bean>
  20. <bean id="dao" <span style="color: #0000ff">class</span>="cn.c3p0.UserDao">
  21. <!-- dao中注入jdbcTemplate -->
  22. <property name="jdbcTemplate" ref="jdbcTemplate"></property>
  23. </bean>
  24. <!-- 创建模板对象 -->
  25. <bean id="jdbcTemplate" <span style="color: #0000ff">class</span>="org.springframework.jdbc.core.JdbcTemplate">
  26. <!-- 给模板注入dataSource,具体可以看源码了解(set()方法等) -->
  27. <property name="dataSource" ref="dataSource"></property>
  28. </bean>
  29. </beans></span>

 

UserDao:

  1. <span style="font-size: 16px"><span style="color: #0000ff">package</span><span style="color: #000000"> cn.c3p0;
  2. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.springframework.jdbc.core.JdbcTemplate;
  3. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> UserDao {
  4. </span><span style="color: #0000ff">private</span><span style="color: #000000"> JdbcTemplate jdbcTemplate;
  5. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> setJdbcTemplate(JdbcTemplate jdbcTemplate) {
  6. </span><span style="color: #0000ff">this</span>.jdbcTemplate =<span style="color: #000000"> jdbcTemplate;
  7. }
  8. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> add() {
  9. </span><span style="color: #008000">//</span><span style="color: #008000">在这里使用jdbcTemplate new模板对象的过程都交给spring</span>
  10. String sql = "insert into user values(?,?)"<span style="color: #000000">;
  11. </span><span style="color: #0000ff">int</span> i = jdbcTemplate.update(sql, "lilei","112"<span style="color: #000000">);
  12. System.out.println(i);
  13. }
  14. }</span></span>

UserService:

  1. <span style="font-size: 16px"><span style="color: #0000ff">package</span><span style="color: #000000"> cn.c3p0;
  2. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> UserService {
  3. </span><span style="color: #0000ff">private</span><span style="color: #000000"> UserDao dao;
  4. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> setDao(UserDao dao) {
  5. </span><span style="color: #0000ff">this</span>.dao =<span style="color: #000000"> dao;
  6. }
  7. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> add(){
  8. System.out.println(</span>"service.add"<span style="color: #000000">);
  9. dao.add();
  10. }
  11. }</span></span>

四、spring的事务管理
  (不用像之前Hibernate一样写大堆的事务的代码)
    事务的回顾见JDBC部分
    事务的概念
    事务的特性
    事务的隔离性产生的问题
  spring的事务管理主要有两种方式:
    1.编程式事务管理(自己写代码,用的少)
    2.声明式事务管理(配置文件实现,注解方式实现(简单易用))
  相关的API:
    PlatformTransactionManager :spring的事务管理器接口,为不同的持久化框架提供了不同的实现类
                    例如模板的实现类:dataSourceTransactionManager
    Hibernate的实现类:HibernateTransactionManager
  无论注解还是配置文件都要配置事务管理器

  搭建转账的环境演示事务管理的操作:
  建表,添加一些数据
  创建service和dao以及注入关系的完成(区分业务层和持久层的区别,业务层只处理业务,持久层只和数据库打交道)

Service:

  1. <span style="font-size: 16px"><span style="color: #0000ff">package</span><span style="color: #000000"> cn.acount;
  2. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.springframework.transaction.annotation.Transactional;
  3. @Transactional
  4. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> AcountService {
  5. </span><span style="color: #0000ff">private</span><span style="color: #000000"> AcountDao dao;
  6. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> setDao(AcountDao dao) {
  7. </span><span style="color: #0000ff">this</span>.dao =<span style="color: #000000"> dao;
  8. }
  9. </span><span style="color: #008000">//</span><span style="color: #008000">service调dao的方法完成逻辑</span>
  10. <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> acountMoney(){
  11. dao.decrese();
  12. </span><span style="color: #008000">//</span><span style="color: #008000">int i = 1/0;</span>
  13. <span style="color: #000000"> dao.increse();
  14. }
  15. }</span></span>

Dao:

  1. <span style="font-size: 16px"><span style="color: #0000ff">package</span><span style="color: #000000"> cn.acount;
  2. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.springframework.jdbc.core.JdbcTemplate;
  3. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> AcountDao {
  4. </span><span style="color: #0000ff">private</span><span style="color: #000000"> JdbcTemplate jdbcTemplate;
  5. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> setJdbcTemplate(JdbcTemplate jdbcTemplate) {
  6. </span><span style="color: #0000ff">this</span>.jdbcTemplate =<span style="color: #000000"> jdbcTemplate;
  7. }
  8. </span><span style="color: #008000">//</span><span style="color: #008000">减少钱的方法</span>
  9. <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> decrese(){
  10. String sql </span>= "update acount set money=money+? where name=?"<span style="color: #000000">;
  11. jdbcTemplate.update(sql, </span>-1000,"小王"<span style="color: #000000">);
  12. }
  13. </span><span style="color: #008000">//</span><span style="color: #008000">增加钱的方法</span>
  14. <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> increse(){
  15. String sql </span>= "update acount set money=money+? where name=?"<span style="color: #000000">;
  16. jdbcTemplate.update(sql, </span>1000,"小李"<span style="color: #000000">);
  17. }
  18. }</span></span>

bean2.xml 要引入事务的操作的约束!
一般以后引入四个约束 beans context aop tx 示例见bean2.xml
可以测试无事务操作时可以正确执行

声明式的事务管理:
  xml实现:
(使用的是aop的思想)(jdbc的源码查看dataSourceTransactionManager)

bean2.xml

  1. <span style="font-size: 16px"><?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"<span style="color: #000000">
  3. xmlns:xsi</span>="http://www.w3.org/2001/XMLSchema-instance"<span style="color: #000000">
  4. xmlns:aop</span>="http://www.springframework.org/schema/aop"<span style="color: #000000">
  5. xmlns:context</span>="http://www.springframework.org/schema/context"<span style="color: #000000">
  6. xmlns:tx</span>="http://www.springframework.org/schema/tx" xsi:schemaLocation=<span style="color: #000000">"
  7. </span> http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/beans </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/beans/spring-beans-4.3.xsd</span>
  8. http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/tx </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/tx/spring-tx.xsd</span>
  9. http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/context </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/context/spring-context.xsd</span>
  10. http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/aop </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/aop/spring-aop.xsd</span><span style="color: #008000">"></span>
  11. <!-- 配置c3p0连接池 -->
  12. <bean id="dataSource" <span style="color: #0000ff">class</span>="com.mchange.v2.c3p0.ComboPooledDataSource">
  13. <!-- 进行属性注入 -->
  14. <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
  15. <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/mydb"></property>
  16. <property name="user" value="root"></property>
  17. <property name="password" value="root"></property>
  18. </bean>
  19. <!-- 配置service对象 -->
  20. <bean id="acountService" <span style="color: #0000ff">class</span>="cn.acount.AcountService">
  21. <!-- service中注入dao -->
  22. <property name="dao" ref="dao"></property>
  23. </bean>
  24. <!-- 配置dao对象 -->
  25. <bean id="dao" <span style="color: #0000ff">class</span>="cn.acount.AcountDao">
  26. <!-- dao中注入模板 -->
  27. <property name="jdbcTemplate" ref="jdbcTemplate"></property>
  28. </bean>
  29. <!-- 创建模板对象 -->
  30. <bean id="jdbcTemplate" <span style="color: #0000ff">class</span>="org.springframework.jdbc.core.JdbcTemplate">
  31. <!-- 模板中注入dataSource -->
  32. <property name="dataSource" ref="dataSource"></property>
  33. </bean>
  34. <!-- 事务的配置实现 -->
  35. <!-- 1.配置事务管理器 -->
  36. <bean id="transactionManager" <span style="color: #0000ff">class</span>="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  37. <!-- 注入dataSource -->
  38. <property name="dataSource" ref="dataSource"></property>
  39. </bean>
  40. <!-- 2.配置事务增强 ,需要指定事务管理器-->
  41. <tx:advice id="txadvice" transaction-manager="transactionManager">
  42. <!-- 做事务操作 -->
  43. <tx:attributes>
  44. <!-- 设置进行事务操作的方法匹配规则 -->
  45. <tx:method name="acount*" propagation="REQUIRED"/>
  46. </tx:attributes>
  47. </tx:advice>
  48. <!-- 3.配置切面 -->
  49. <aop:config>
  50. <!-- 3.1切入点 -->
  51. <aop:pointcut expression="execution(* cn.acount.AcountService.*(...))" id="pointcut1"/>
  52. <!-- 3.2切面 -->
  53. <aop:advisor advice-ref="txadvice" pointcut-ref="pointcut1"/>
  54. </aop:config>
  55. </beans></span>

  进行一个简单的测试:

 

  1. <span style="font-size: 16px"><span style="color: #0000ff">package</span><span style="color: #000000"> cn.acount;
  2. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.junit.Test;
  3. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.springframework.context.ApplicationContext;
  4. </span><span style="color: #0000ff">import</span><span style="color: #000000"> org.springframework.context.support.ClassPathXmlApplicationContext;
  5. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> Test01 {
  6. @Test
  7. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> test(){
  8. ApplicationContext context </span>=
  9. <span style="color: #0000ff">new</span> ClassPathXmlApplicationContext("bean2.xml"<span style="color: #000000">);
  10. AcountService service </span>= (AcountService) context.getBean("acountService"<span style="color: #000000">);
  11. service.acountMoney();
  12. }
  13. }</span></span>

 

 

 

  注解实现:
  配置事务管理器
  配置开启注解的操作
  在要使用事务的方法所在的类上添加注解@Transactional
  会自动找到@注解后对类里的所有方法进行事务操作

此时的配置文件如下:

bean4.xml:

 

  1. <span style="font-size: 16px"><?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"<span style="color: #000000">
  3. xmlns:xsi</span>="http://www.w3.org/2001/XMLSchema-instance"<span style="color: #000000">
  4. xmlns:aop</span>="http://www.springframework.org/schema/aop"<span style="color: #000000">
  5. xmlns:context</span>="http://www.springframework.org/schema/context"<span style="color: #000000">
  6. xmlns:tx</span>="http://www.springframework.org/schema/tx" xsi:schemaLocation=<span style="color: #000000">"
  7. </span> http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/beans </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/beans/spring-beans-4.3.xsd</span>
  8. http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/tx </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/tx/spring-tx.xsd</span>
  9. http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/context </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/context/spring-context.xsd</span>
  10. http:<span style="color: #008000">//</span><span style="color: #008000">www.springframework.org/schema/aop </span><span style="color: #008000; text-decoration: underline">http://www.springframework.org/schema/aop/spring-aop.xsd</span><span style="color: #008000">"> </span>
  11. <!-- 配置c3p0连接池 -->
  12. <bean id="dataSource" <span style="color: #0000ff">class</span>="com.mchange.v2.c3p0.ComboPooledDataSource">
  13. <!-- 进行属性注入 -->
  14. <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
  15. <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/mydb"></property>
  16. <property name="user" value="root"></property>
  17. <property name="password" value="root"></property>
  18. </bean>
  19. <!-- 配置事务管理器-->
  20. <!-- 1.配置事务管理器 -->
  21. <bean id="transactionManager" <span style="color: #0000ff">class</span>="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  22. <!-- 注入dataSource -->
  23. <property name="dataSource" ref="dataSource"></property>
  24. </bean>
  25. <!-- 开启事务的注解 ,指定事务管理器-->
  26. <tx:annotation-driven transaction-manager="transactionManager"/>
  27. <!-- 配置service对象 -->
  28. <bean id="acountService" <span style="color: #0000ff">class</span>="cn.acount.AcountService">
  29. <!-- service中注入dao -->
  30. <property name="dao" ref="dao"></property>
  31. </bean>
  32. <!-- 配置dao对象 -->
  33. <bean id="dao" <span style="color: #0000ff">class</span>="cn.acount.AcountDao">
  34. <!-- dao中注入模板 -->
  35. <property name="jdbcTemplate" ref="jdbcTemplate"></property>
  36. </bean>
  37. <!-- 创建模板对象 -->
  38. <bean id="jdbcTemplate" <span style="color: #0000ff">class</span>="org.springframework.jdbc.core.JdbcTemplate">
  39. <!-- 模板中注入dataSource -->
  40. <property name="dataSource" ref="dataSource"></property>
  41. </bean>
  42. </beans></span>

在类上加注解:完整的类信息见xml配置实现

  1. <span style="font-size: 16px"><span style="color: #000000">@Transactional
  2. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span> AcountService {</span>

 

Spring第三天——JdbcTemplate和spring事务管理

标签:classpath   line   source   环境   private   事务   管理   管理器   lap   

人气教程排行