Oracle操作Demo（未验证）

2015-12-21 16:58:07 访问(2025) 赞(0) 踩(0)


        /// <summary>
        /// 测试Oracle的链接
        /// </summary>
        /// <param name="dbConnectionString"></param>
        /// <returns></returns>
        protected void OracleConnTest(string dbConnectionString)
        {
             

            OracleConnection conn = null;
            OracleTransaction tran = null;

            try
            {
                conn = new OracleConnection(dbConnectionString);
                conn.Open();

                tran = conn.BeginTransaction();

                LogicOne(tran);
                LogicTwo(tran);

                if (tran != null)
                {
                    tran.Commit();
                    tran.Dispose();
                    tran = null;
                }
               
            }
            catch (Exception err)
            {
                if (tran != null)
                {
                    tran.Rollback();
                    tran.Dispose();
                    tran = null;
                }

                throw err;
            }
            finally
            {

                if (conn != null)
                {
                    if (conn.State != ConnectionState.Closed)
                    {
                        conn.Close();
                    }

                    conn.Dispose();
                    conn = null;
                }
            } 
        }

        protected object LogicOne(OracleTransaction tran)
        {
            OracleConnection conn = tran.Connection;

            OracleCommand cmd = new OracleCommand();
            cmd.CommandText = "select sysdate as retValue from sys.dual ";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = conn;

            object obj = cmd.ExecuteScalar();

            return obj;
        }


        protected object LogicTwo(OracleTransaction tran)
        {
            OracleConnection conn = tran.Connection;

            OracleCommand cmd = new OracleCommand();
            cmd.CommandText = "select sysdate as retValue from sys.dual ";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = conn;

            object obj = cmd.ExecuteScalar();

            return obj;
        }