~SingleForum~无废话记录~ Topic: SPRING事务管理的一个例子 http://www.ll19.com/bb/ ~19~记录点有用的好吗？少说废话少装b~ en Tue, 07 Feb 2012 09:22:53 +0000 admin on "SPRING事务管理的一个例子" http://www.ll19.com/bb/topic/112#post-112 Sun, 03 Jan 2010 16:21:01 +0000 admin 112@http://www.ll19.com/bb/ <p>SPRING事务管理的一个例子<br />
PLAIN TEXT
JAVA:
  1. &#60;br /&#62;
  2.     /***&#60;br /&#62;
  3.      *&#60;br /&#62;
  4.      * 删除TAGS 需要同时删除tree_posts_tags表中的相关信息&#60;br /&#62;
  5.      */&#60;br /&#62;
  6.     public int removeTagsandPost(final String tagsID) {&#60;/p&#62;
  7. &#60;p&#62;  String countTags = &#34;&#34;;&#60;br /&#62;
  8.         final InvocationResult result = new InvocationResult();&#60;/p&#62;
  9. &#60;p&#62;  DataSourceTransactionManager tran = new DataSourceTransactionManager(&#60;br /&#62;
  10.                 getDataSource());&#60;br /&#62;
  11.         TransactionTemplate trantemplate = new TransactionTemplate(tran);&#60;/p&#62;
  12. &#60;p&#62;  countTags = (String) trantemplate.execute(new TransactionCallback() {&#60;br /&#62;
  13.             public Object doInTransaction(TransactionStatus status) {&#60;/p&#62;
  14. &#60;p&#62;    try {&#60;br /&#62;
  15.                     String sqlTags = &#34;delete from tree_tags t where t.t_id = &#34;&#60;br /&#62;
  16.                             + NumberUtils.toLong(tagsID);&#60;br /&#62;
  17.                     String sqlPostTags = &#34;delete from tree_posts_tags t where t.t_id = &#34;&#60;br /&#62;
  18.                             + NumberUtils.toLong(tagsID);&#60;/p&#62;
  19. &#60;p&#62;     int count = getJdbcTemplate().update(sqlTags,&#60;br /&#62;
  20.                             new Object[] {}, new int[] {});&#60;br /&#62;
  21.                     int countPostTags = getJdbcTemplate().update(sqlPostTags,&#60;br /&#62;
  22.                             new Object[] {}, new int[] {});&#60;/p&#62;
  23. &#60;p&#62;     return String.valueOf(count + countPostTags);&#60;/p&#62;
  24. &#60;p&#62;    } catch (TransactionException te) {&#60;br /&#62;
  25.                     status.setRollbackOnly();&#60;br /&#62;
  26.                     if (result.getException() == null) {&#60;br /&#62;
  27.                         throw te;&#60;br /&#62;
  28.                     } else {&#60;br /&#62;
  29.                     }&#60;br /&#62;
  30.                     return 0;&#60;br /&#62;
  31.                 }&#60;br /&#62;
  32.             }&#60;br /&#62;
  33.         });&#60;/p&#62;
  34. &#60;p&#62;  return NumberUtils.toInt(countTags);&#60;br /&#62;

</p>