WebLogic WorkShop中的数据库操作事务 - JTA

此代码或许还有不正确的地方,不是最佳方案,但是能够满足事务的提交和回滚.

workshop中新建class文件(java),名字为jta.java,代码如下:

1. package mypackage;
2.  
3. import java.io.Serializable;
4. import java.sql.*;
5. import javax.sql.*;
6. import javax.naming.Context;
7. import javax.naming.InitialContext;
8. import javax.transaction.SystemException;
9. import javax.transaction.UserTransaction;
10. public class jta implements Serializable
11. {
12.     public Context ctx;
13.     public UserTransaction tx;
14.     public DataSource ds;
15.     public Connection myConn;
16.     public Statement stmt;
17.     public String v_sqlstr;
18.  
19.     public void exeJTASQL()
20.     {
21.         int i;
22.         String l_sqlstr[];
23.  
24.         if ( v_sqlstr.trim().length() == 0 )
25.         {
26.             System.out.println("参数错误");
27.         }
28.  
29.         l_sqlstr = v_sqlstr.split(";");
30.         try
31.         {
32.             ctx = new InitialContext();
33.             tx = (UserTransaction)ctx.lookup("javax.transaction.UserTransaction");
34.             tx.begin();
35.             ds = (DataSource)ctx.lookup("CMSDS");
36.             myConn = ds.getConnection();
37.             stmt = myConn.createStatement();
39.             for ( i=0; i<l_sqlstr.length; i++ )
40.             {
41.                 if ( l_sqlstr[i].startsWith("insert") == true ||
42.                      l_sqlstr[i].startsWith("update") == true ||
43.                      l_sqlstr[i].startsWith("delete") == true )
44.                 {
45.                     System.out.println(i + ":" + l_sqlstr[i]);
46.                     stmt.executeUpdate(l_sqlstr[i].toString().toString());
47.                 }
48.             }
49.           
50.             tx.commit();
51.             System.out.println("数据提交");
52.             stmt.close();
53.             System.out.println("关闭stmt");
54.         }
55.         catch ( Exception e)
56.         {
57.             System.out.println("执行出错 message:" + e);  
58.             try
59.             {
60.                 tx.rollback();
61.                 System.out.println("事务回滚");
62.             }
63.             catch(SystemException se)
64.             {
65.                 System.out.println("回滚错误 message:" + se);
66.             }
67.         }
68.         finally
69.         {
70.             try
71.             {
72.                 if ( myConn != null )
73.                 {
74.                     if ( !myConn.isClosed() )
75.                     {
76.                         myConn.close();
77.                         System.out.println("关闭myConn");
78.                     }
79.                 }
80.             }
81.             catch(SQLException sqle)
82.             {
83.                 ;
84.             }
85.         }
86.     }
87.  
88.     public void setV_sqlstr(String v_sqlstr)
89.     {
90.         this.v_sqlstr = v_sqlstr;
91.     }
92. }

在workshop中的jpf程序的Action中使用:

1. import mypackage.jta;
3. /**
4.  * @jpf:action
5.  * @jpf:forward name="success" path="newPage1.jsp"
6.  */ 
7. protected Forward newAction1() throws Exception
8. {
9.         String sqlstr;
10.    
11.         jta jtatest;               /*创建类jta的一个实例jtatest*/
12.         jtatest = new jta();       /*初始化jtatest*/
13.         /*组装sqlstr语句,注意每个语句结束的";"符号,语句必须是insert,update,delete开头*/
14.         sqlstr = "insert into table values('aaaa',11,222,'aaaaaaa');";
15.         sqlstr = sqlstr + "update table1 set name='高级管理员';";
16.         sqlstr = sqlstr + "insert into table3 values('111',802,100);";
17.         System.out.println("sqlstr:" + sqlstr);
18.         jtatest.setV_sqlstr(sqlstr); /*将这段sql语句赋值给实例jtatest的成员变量*/
19.         jtatest.exeJTASQL();         /*调用方法*/
20.         return new Forward("success");
21. }