oracle中的事务怎么写？

Question

请问各位大侠，有懂的麻烦帮帮我

Answer 1

public bool ExecuteSqlTran(ArrayList SQLStringList)
        {
            bool b = false;
            try
            {
                Open();
                OracleCommand cmd = new OracleCommand();
                cmd.Connection = con;
                OracleTransaction tx = con.BeginTransaction();
                cmd.Transaction = tx;
                try
                {
                    for (int n = 0; n < SQLStringList.Count; n++)
                    {
                        string strsql = SQLStringList[n].ToString();
                        if (strsql.Trim().Length > 1)
                        {
                            cmd.CommandText = strsql;
                            cmd.ExecuteNonQuery();
                        }
                    }
                    tx.Commit();
                    b = true;
                }
                catch (System.Data.OracleClient.OracleException Etx)
                {
                    tx.Rollback();
                    //throw new Exception(Etx.Message);
                }
            }
            catch (System.Data.OracleClient.OracleException E)
            {
                //throw new Exception(E.Message);
            }
            finally
            {
                Close();
            }
            return b;
        }Open()和Close()方法是自定义的，就是用来打开和关闭连接的