Changes between Version 3 and Version 4 of v6/pgsummary

Timestamp:

04/17/2012 11:38:51 AM (14 years ago)

Author:

huangzhong

Comment:

--

v6/pgsummary

@@ -75 +75 @@
 
 == 驱动 ==
-* pg 里没有rollback 语句，不会自动rollback ，需要应用里触发异常。 
+* pg 里没有rollback 语句，不会自动rollback ，需要应用里触发异常。
+{{{
+1.使用JPA,方法声明为@Transactional自动回滚
+2.使用JPA，手动方式进行回滚
+EntityManagerFactory emf = ((EntityManagerFactory)EnvUtils.getEnv().getApplicationContext().getBean("entityManagerFactory"));
+EntityManager em = emf.createEntityManager();
+EntityTransaction et = em.getTransaction();
+try {
+  et.begin();//事务开始
+  em.createNativeQuery(sql).executeUpdate();
+  em.createNativeQuery(sql).executeUpdate();
+  et.commit();
+} catch (Exception e) {
+  et.rollback();
+}
+3.使用JDBC
+DataSourceTransactionManager tm = new DataSourceTransactionManager(((DataSource) EnvUtils.getEnv().getApplicationContext().getBean("dataSource")));
+TransactionTemplate tt = new TransactionTemplate(tm);
+final JdbcTemplate jt = new JdbcTemplate(((DataSource) EnvUtils.getEnv().getApplicationContext().getBean("dataSource")));
+tt.execute(new TransactionCallback() {
+    public Object doInTransaction(TransactionStatus ts) {
+        String sql = "update ent_faq set title = '压力山大' where id = 1";
+        jt.execute(sql);
+        sql = "update ent_faq set title = title || '困死我了' where id = 3";
+        jt.execute(sql);
+        return null;
+    }
+});
+}}}
 * 缺省返回的整型是Long
 {{{