using?Oracle.ManagedDataAccess.Client;
using?Oracle.ManagedDataAccess.Types;
using?System;
using?System.Collections;
using?System.Collections.Generic;
using?System.Data;
using?System.Linq;
using?System.Text;

namespace?libDbHelper
{
????public?class?DbHelperOracle
????{
????????private?OracleConnection?m_Conn?=?null;
????????private?OracleCommand?m_Cmd?=?null;
????????bool?bAutoCloseConn?=?true;

????????///?

????????///?Oracle數(shù)據(jù)庫操作
????????///?

????????///?數(shù)據(jù)庫連接字符串
????????///?DATA?SOURCE=192.168.0.1:1521/mesdb;User?ID=HZEVTADMIN;Password=HZEVTADMIN;
????????///?自動關(guān)閉數(shù)據(jù)庫連接
????????public?DbHelperOracle（string?strConnbool?bAutoCloseConnection）
????????{
????????????try
????????????{
????????????????bAutoCloseConn?=?bAutoCloseConnection;
????????????????m_Conn?=?new?OracleConnection（strConn）;
????????????????m_Cmd?=?new?OracleCommand（）;
????????????????m_Cmd.CommandTimeout?=?10;
????????????????m_Cmd.Connection?=?m_Conn;
????????????}
????????????catch（Exception?e）
????????????{
????????????????throw?e;
????????????}
????????}
????????public?OracleConnection?Conn
????????{
????????????get?{?return?m_Conn;?}
????????}
????????public?OracleCommand?Cmd
????????{
????????????get?{?return?m_Cmd;?}
????????}

????????///?

????????///?通過SQL語句提交命令
????????///?

????????///?要執(zhí)行的SQL語句
????????///?受影響的行數(shù)
????????public?int?ExecDataBySql（string?strSql）
????????{
????????????int?intReturnValue;
????????????m_Cmd.CommandType?=?CommandType.Text;
????????????m_Cmd.CommandText?=?strSql;
????????????try
????????????{
????????????????if?（m_Conn.State?==?ConnectionState.Broken?||?m_Conn.State?==?ConnectionState.Closed）
????????????????{
????????????????????m_Conn.Open（）;
????????????????}
????????????????intReturnValue?=?m_Cmd.ExecuteNonQuery（）;
????????????}
????????????catch?（Exception?e）
????????????{
????????????????throw?e;
????????????}
????????????finally
????????????{
????????????????if（bAutoCloseConn）
????????????????????m_Conn.Close（）;
????????????}
????????????return?intReturnValue;
????????}

????????///?

????????///?SQL語句提交數(shù)據(jù)（含事務(wù)回滾）
????????///?

????????///?SQL語句（多條）
????????///?bool值，提交是否成功
????????public?bool?TranExecDataBySql（ArrayList?strSqls）
????????{
????????????bool?booIsSucceed;
????????????if?（m_Conn.State?==?ConnectionState.Closed?||?m_Conn.State?==?ConnectionState.Broken）
????????????{
????????????????m_Conn.Open（）;
????????????}
????????????//創(chuàng)建事務(wù)
????????????OracleTransaction?sqlTran?=?m_Conn.BeginTransaction（）;
????????????try
????????????{
????????????????m_Cmd.Transaction?=?sqlTran;
????????????????m_Cmd.CommandType?=?CommandType.Text;
????????????????for?（int?i?=?0;?i?????????????????{
????????????