发个盗版[c#操作数据库类].

 

  1    /**//// <summary>
  2    /// 数据库类
  3    /// </summary>
  4    public class Db4SQL
  5    {
  6        private SqlConnection lConnection;
  7        private bool lConnectionKeepOpenTf;
  8        private string lConnectionStr;
  9        private SqlConnection lConnectionWithTransaction;
 10        private SqlTransaction lTransaction;
 11        private int lTransactionCount;
 12
 13        /**//// <summary>
 14        /// 
 15        /// </summary>
 16        public Db4SQL()
 17        {
 18            this.lConnectionKeepOpenTf = false;
 19            this.lTransactionCount = 0;
 20            this.lConnectionStr = Global.Static.SQLDbConnectionStr;
 21        }
 22
 23        /**//// <summary>
 24        /// 把两个SqlConnection连接关闭lConnection,lConnectionWithTransaction,同时重置连接字符串lConnectionStr=Global.Static.SQLDbConnectionStr
 25        /// </summary>
 26        public void ConnectionClear()
 27        {
 28            ConnectionStrInit();
 29            if ((this.lConnection != null) && (this.lConnection.State == ConnectionState.Open))
 30            {
 31                this.lConnection.Close();
 32                this.lConnection = null;
 33            }
 34            if ((this.lConnectionWithTransaction != null) && (this.lConnectionWithTransaction.State == ConnectionState.Open))
 35            {
 36                this.lConnectionWithTransaction.Close();
 37                this.lConnectionWithTransaction = null;
 38            }
 39        }
 40
 41        /**//// <summary>
 42        /// 得到一个SqlConnection对象
 43        /// </summary>
 44        /// <param name="pInTransactionTf">是否开事务</param>
 45        /// <returns></returns>
 46        internal SqlConnection ConnectionGet(bool pInTransactionTf)
 47        {
 48            if (pInTransactionTf)
 49            {
 50                if (this.lConnectionWithTransaction == null)
 51                {
 52                    throw new Exception("TransactionBegin 未执行");
 53                }
 54                return this.lConnectionWithTransaction;
 55            }
 56            if (this.lConnectionKeepOpenTf)
 57            {
 58                if (this.lConnection == null)
 59                {
 60                    this.lConnection = new SqlConnection(this.lConnectionStr);
 61                }
 62                if (this.lConnection.State != ConnectionState.Open)
 63                {
 64                    this.lConnection.Open();
 65                }
 66                return this.lConnection;
 67            }
 68            SqlConnection connection = new SqlConnection(this.lConnectionStr);
 69            connection.Open();
 70            return connection;
 71        }
 72
 73        /**//// <summary>
 74        /// 得到一个DataTable
 75        /// </summary>
 76        /// <param name="pSqlStr">要执行的字符串</param>
 77        /// <returns></returns>
 78        public System.Data.DataTable DataTableGet(string pSqlStr)
 79        {
 80            return this.DataTableGet(pSqlStr, false);
 81        }
 82
 83        /**//// <summary>
 84        /// 得到一个DataTable
 85        /// </summary>
 86        /// <param name="pSqlStr">要执行的字符串</param>
 87        /// <param name="pInTransactionTf">是否在事务中</param>
 88        /// <returns></returns>
 89        public System.Data.DataTable DataTableGet(string pSqlStr, bool pInTransactionTf)
 90        {
 91            SqlConnection connection = this.ConnectionGet(pInTransactionTf);
 92            SqlCommand command = new SqlCommand(pSqlStr, connection);
 93            if (pInTransactionTf)
 94            {
 95                command.Transaction = this.lTransaction;
 96            }
 97            command.CommandTimeout = 0x2710;//10000
 98            command.CommandType = CommandType.Text;
 99            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
            adapter.SelectCommand = command;
            System.Data.DataTable dataTable = new System.Data.DataTable();
            try
            {
                adapter.Fill(dataTable);
            }
            catch (System.Exception exception)
            {
                throw new Exception(exception.Message+" 执行(" + pSqlStr + ")时出错");
            }
            finally
            {
                if (!pInTransactionTf && !this.lConnectionKeepOpenTf)
                {
                    connection.Close();
                }
            }
            return dataTable;
        }

        /**//// <summary>
        /// 执行一条语句
        /// </summary>
        /// <param name="pSqlString"></param>
        /// <returns>返回影响条数</returns>
        public int Execute(string pSqlString)
        {
            return this.Execute(pSqlString, false);
        }

        /**//// <summary>
        /// 执行一条语句
        /// </summary>
        /// <param name="pSqlString"></param>
        /// <param name="pInTransactionTf"></param>
        /// <returns>返回影响条数</returns>
        public int Execute(string pSqlString, bool pInTransactionTf)
        {
            SqlConnection connection = this.ConnectionGet(pInTransactionTf);
            SqlCommand command = new SqlCommand(pSqlString, connection);
            command.CommandTimeout = 0x2710;
            if (pInTransactionTf)
            {
                command.Transaction = this.lTransaction;
            }
            try
            {
                return command.ExecuteNonQuery();
            }
            catch (System.Exception exception)
            {
                throw new Exception(exception.Message + "执行(" + pSqlString + ")时出错");
            }
            finally
            {
                if (!pInTransactionTf && !this.lConnectionKeepOpenTf)
                {
                    connection.Close();
                }
            }
            return 0;
        }

        /**//// <summary>
        /// 得到 0行0列 的值
        /// </summary>
        /// <param name="pSqlString"></param>
        /// <returns></returns>
        public object FindAField(string pSqlString)
        {
            return this.FindAField(pSqlString, false);
        }

        /**//// <summary>
        /// 得到 0行0列 的值
        /// </summary>
        /// <param name="pSqlString"></param>
        /// <param name="pInTransactionTf"></param>
        /// <returns></returns>
        public object FindAField(string pSqlString, bool pInTransactionTf)
        {
            SqlCommand command = new SqlCommand(pSqlString, this.ConnectionGet(pInTransactionTf));
            command.CommandTimeout = 0x2710;//10000
            if (pInTransactionTf)
            {
                command.Transaction = this.lTransaction;
                try
                {
                    return command.ExecuteScalar();
                }
                catch (System.Exception exception)
                {
                    throw new Exception(exception.Message + "执行(" + pSqlString + ")时出错");
                }
            }
            else if (!this.lConnectionKeepOpenTf)
            {
                try
                {
                    return command.ExecuteScalar();
                }
                catch (System.Exception exception2)
                {
                    throw new Exception(exception2.Message+"执行(" + pSqlString + ")时出错");
                }
                finally
                {
                    command.Connection.Close();
                }
            }
            else
            {
                try
                {
                    return command.ExecuteScalar();
                }
                catch (System.Exception exception3)
                {
                    throw new Exception(exception3.Message+"执行(" + pSqlString + ")时出错");
                }
            }
            return null;
        }

        /**//// <summary>
        /// 是否存在以pTableID为名称的表
        /// </summary>
        /// <param name="pTableID"></param>
        /// <returns></returns>
        public bool TableExistsTf(string pTableID)
        {
            string pSqlString = "select count(*) from sysobjects Where id = object_id(N'[" + pTableID + "]') And OBJECTPROPERTY(id, N'IsUserTable') = 1";
            return (int.Parse(this.FindAField(pSqlString).ToString()) == 1);
        }

        /**//// <summary>
        /// 开始事务
        /// </summary>
        public void TransactionBegin()
        {
            if (this.lTransactionCount == 0)
            {
                this.lConnectionWithTransaction = new SqlConnection(this.ConnectionStr);
                this.lConnectionWithTransaction.Open();
                this.lTransaction = this.lConnectionWithTransaction.BeginTransaction();
            }
            this.lTransactionCount++;
        }

        /**//// <summary>
        /// 提交事务
        /// </summary>
        public void TransactionCommit()
        {
            if (this.lTransactionCount == 0)
            {
                throw new Exception("TransactionBegin未执行");
            }
            this.lTransactionCount--;
            if (this.lTransactionCount == 0)
            {
                this.lTransaction.Commit();
                this.lConnectionWithTransaction.Close();
                this.lConnectionWithTransaction = null;
            }
        }

        /**//// <summary>
        /// 回滚事务
        /// </summary>
        public void TransactionRollback()
        {
            if (this.lTransactionCount == 0)
            {
                throw new Exception("TransactionBegin未执行");
            }
            this.lTransactionCount--;
            if (this.lTransactionCount == 0)
            {
                this.lTransaction.Rollback();
                this.lConnectionWithTransaction.Close();
                this.lConnectionWithTransaction = null;
            }
        }

        /**//// <summary>
        /// 是否存在某视图
        /// </summary>
        /// <param name="pViewName"></param>
        /// <returns></returns>
        public bool ViewExistsTf(string pViewName)
        {
            string pSqlString = "select count(*) from sysobjects Where id = object_id(N'[" + pViewName + "]') And OBJECTPROPERTY(id, N'IsView') = 1";
            return (int.Parse(this.FindAField(pSqlString).ToString()) == 1);
        }


        /**//// <summary>
        /// 是否把连接保持Open
        /// </summary>
        public bool ConnectionKeepOpenTf
        {
            get
            {
                return this.lConnectionKeepOpenTf;
            }
            set
            {
                this.lConnectionKeepOpenTf = value;
                if ((!this.lConnectionKeepOpenTf && (this.lConnection != null)) && (this.lConnection.State == ConnectionState.Open))
                {
                    this.lConnection.Close();
                }
            }
        }

        /**//// <summary>
        /// 连接字符串
        /// </summary>
        public string ConnectionStr
        {
            get
            {
                return this.lConnectionStr;
            }
        }

        /**//// <summary>
        /// 初始化连接字符串lConnectionStr
        /// </summary>
        private void ConnectionStrInit()
        {
            this.lConnectionStr = Global.Static.SQLDbConnectionStr;
        }

        /**//// <summary>
        /// 事务
        /// </summary>
        internal SqlTransaction Transaction
        {
            get
            {
                return this.lTransaction;
            }
        }
    }





    /**//// <summary>
    /// 数据库类
    /// </summary>
    public class Db4ACCESS
    {
        private OleDbConnection lConnection;
        private bool lConnectionKeepOpenTf;
        private string lConnectionStr;
        private OleDbConnection lConnectionWithTransaction;
        private OleDbTransaction lTransaction;
        private int lTransactionCount;

        /**//// <summary>
        /// 
        /// </summary>
        public Db4ACCESS()
        {
            this.lConnectionKeepOpenTf = false;
            this.lTransactionCount = 0;
            this.lConnectionStr = Global.Static.ACCESSDbConnectionStr;
        }

        /**//// <summary>
        /// 把两个Connection连接关闭lConnection,lConnectionWithTransaction,同时重置连接字符串lConnectionStr=Global.Static.ACCESSDbConnectionStr
        /// </summary>
        public void ConnectionClear()
        {
            ConnectionStrInit();

            if ((this.lConnection != null) && (this.lConnection.State == ConnectionState.Open))
            {
                this.lConnection.Close();
                this.lConnection = null;
            }
            if ((this.lConnectionWithTransaction != null) && (this.lConnectionWithTransaction.State == ConnectionState.Open))
            {
                this.lConnectionWithTransaction.Close();
                this.lConnectionWithTransaction = null;
            }
        }

        /**//// <summary>
        /// 得到一个Connection对象
        /// </summary>
        /// <param name="pInTransactionTf">是否开事务</param>
        /// <returns></returns>
        internal OleDbConnection ConnectionGet(bool pInTransactionTf)
        {
            if (pInTransactionTf)
            {
                if (this.lConnectionWithTransaction == null)
                {
                    throw new Exception("TransactionBegin 未执行");
                }
                return this.lConnectionWithTransaction;
            }
            if (this.lConnectionKeepOpenTf)
            {
                if (this.lConnection == null)
                {
                    this.lConnection = new OleDbConnection(this.lConnectionStr);
                }
                if (this.lConnection.State != ConnectionState.Open)
                {
                    this.lConnection.Open();
                }
                return this.lConnection;
            }
            OleDbConnection connection = new OleDbConnection(this.lConnectionStr);
            connection.Open();
            return connection;
        }

        /**//// <summary>
        /// 得到一个DataTable
        /// </summary>
        /// <param name="pSqlStr">要执行的字符串</param>
        /// <returns></returns>
        public System.Data.DataTable DataTableGet(string pSqlStr)
        {
            return this.DataTableGet(pSqlStr, false);
        }

        /**//// <summary>
        /// 得到一个DataTable
        /// </summary>
        /// <param name="pSqlStr">要执行的字符串</param>
        /// <param name="pInTransactionTf">是否在事务中</param>
        /// <returns></returns>
        public System.Data.DataTable DataTableGet(string pSqlStr, bool pInTransactionTf)
        {
            OleDbConnection connection = this.ConnectionGet(pInTransactionTf);
            OleDbCommand command = new OleDbCommand(pSqlStr, connection);
            if (pInTransactionTf)
            {
                command.Transaction = this.lTransaction;
            }
            command.CommandTimeout = 0x2710;//10000
            command.CommandType = CommandType.Text;
            OleDbDataAdapter adapter = new OleDbDataAdapter();            
            OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
            adapter.SelectCommand = command;
            System.Data.DataTable dataTable = new System.Data.DataTable();
            try
            {
                adapter.Fill(dataTable);
            }
            catch (System.Exception exception)
            {
                throw new Exception(exception.Message+" 执行(" + pSqlStr + ")时出错");
            }
            finally
            {
                if (!pInTransactionTf && !this.lConnectionKeepOpenTf)
                {
                    connection.Close();
                }
            }
            return dataTable;
        }

        /**//// <summary>
        /// 执行一条语句
        /// </summary>
        /// <param name="pSqlString"></param>
        /// <returns>返回影响条数</returns>
        public int Execute(string pSqlString)
        {
            return this.Execute(pSqlString, false);
        }

        /**//// <summary>
        /// 执行一条语句
        /// </summary>
        /// <param name="pSqlString"></param>
        /// <param name="pInTransactionTf"></param>
        /// <returns>返回影响条数</returns>
        public int Execute(string pSqlString, bool pInTransactionTf)
        {
            OleDbConnection connection = this.ConnectionGet(pInTransactionTf);
            OleDbCommand command = new OleDbCommand(pSqlString, connection);
            command.CommandTimeout = 0x2710;
            if (pInTransactionTf)
            {
                command.Transaction = this.lTransaction;
            }
            try
            {
                return command.ExecuteNonQuery();
            }
            catch (System.Exception exception)
            {
                throw new Exception(exception.Message + "执行(" + pSqlString + ")时出错");
            }
            finally
            {
                if (!pInTransactionTf && !this.lConnectionKeepOpenTf)
                {
                    connection.Close();
                }
            }
            return 0;
        }

        /**//// <summary>
        /// 得到 0行0列 的值
        /// </summary>
        /// <param name="pSqlString"></param>
        /// <returns></returns>
        public object FindAField(string pSqlString)
        {
            return this.FindAField(pSqlString, false);
        }

        /**//// <summary>
        /// 得到 0行0列 的值
        /// </summary>
        /// <param name="pSqlString"></param>
        /// <param name="pInTransactionTf"></param>
        /// <returns></returns>
        public object FindAField(string pSqlString, bool pInTransactionTf)
        {
            OleDbCommand command = new OleDbCommand(pSqlString, this.ConnectionGet(pInTransactionTf));
            command.CommandTimeout = 0x2710;//10000
            if (pInTransactionTf)
            {
                command.Transaction = this.lTransaction;
                try
                {
                    return command.ExecuteScalar();
                }
                catch (System.Exception exception)
                {
                    throw new Exception(exception.Message + "执行(" + pSqlString + ")时出错");
                }
            }
            else if (!this.lConnectionKeepOpenTf)
            {
                try
                {
                    return command.ExecuteScalar();
                }
                catch (System.Exception exception2)
                {
                    throw new Exception(exception2.Message+"执行(" + pSqlString + ")时出错");
                }
                finally
                {
                    command.Connection.Close();
                }
            }
            else
            {
                try
                {
                    return command.ExecuteScalar();
                }
                catch (System.Exception exception3)
                {
                    throw new Exception(exception3.Message+"执行(" + pSqlString + ")时出错");
                }
            }
            return null;
        }

        /**//// <summary>
        /// 是否存在以pTableID为名称的表
        /// </summary>
        /// <param name="pTableID"></param>
        /// <returns></returns>
        public bool TableExistsTf(string pTableID)
        {
            string pSqlString = "select count(*) from "+pTableID;
            try
            {
                this.Execute(pSqlString);
            }
            catch
            {
                return false;
            }
            return true;
        }

        /**//// <summary>
        /// 开始事务
        /// </summary>
        public void TransactionBegin()
        {
            if (this.lTransactionCount == 0)
            {
                this.lConnectionWithTransaction = new OleDbConnection(this.ConnectionStr);
                this.lConnectionWithTransaction.Open();
                this.lTransaction = this.lConnectionWithTransaction.BeginTransaction();
            }
            this.lTransactionCount++;
        }

        /**//// <summary>
        /// 提交事务
        /// </summary>
        public void TransactionCommit()
        {
            if (this.lTransactionCount == 0)
            {
                throw new Exception("TransactionBegin未执行");
            }
            this.lTransactionCount--;
            if (this.lTransactionCount == 0)
            {
                this.lTransaction.Commit();
                this.lConnectionWithTransaction.Close();
                this.lConnectionWithTransaction = null;
            }
        }

        /**//// <summary>
        /// 回滚事务
        /// </summary>
        public void TransactionRollback()
        {
            if (this.lTransactionCount == 0)
            {
                throw new Exception("TransactionBegin未执行");
            }
            this.lTransactionCount--;
            if (this.lTransactionCount == 0)
            {
                this.lTransaction.Rollback();
                this.lConnectionWithTransaction.Close();
                this.lConnectionWithTransaction = null;
            }
        }


        /**//// <summary>
        /// 是否把连接保持Open
        /// </summary>
        public bool ConnectionKeepOpenTf
        {
            get
            {
                return this.lConnectionKeepOpenTf;
            }
            set
            {
                this.lConnectionKeepOpenTf = value;
                if ((!this.lConnectionKeepOpenTf && (this.lConnection != null)) && (this.lConnection.State == ConnectionState.Open))
                {
                    this.lConnection.Close();
                }
            }
        }

        /**//// <summary>
        /// 连接字符串
        /// </summary>
        public string ConnectionStr
        {
            get
            {
                return this.lConnectionStr;
            }
        }

        /**//// <summary>
        /// 初始化连接字符串lConnectionStr
        /// </summary>
        private void ConnectionStrInit()
        {
            this.lConnectionStr = Global.Static.ACCESSDbConnectionStr;
        }

        /**//// <summary>
        /// 事务
        /// </summary>
        internal OleDbTransaction Transaction
        {
            get
            {
                return this.lTransaction;
            }
        }

    }

 1    /**//// <summary>
 2    /// Global 的摘要说明。
 3    /// </summary>
 4    public class Static
 5    {
 6        private Static()
 7        {
 8            //
 9            // TODO: 在此处添加构造函数逻辑
            //
        }

        /**//// <summary>
        /// such as: server=127.0.0.1;database=tt;uid=sa;pwd=;
        /// </summary>
        public static string SQLDbConnectionStr="";
        /**//// <summary>
        /// such as: PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=dataBasePath;Password=pwd;
        /// </summary>
        public static string ACCESSDbConnectionStr="";
    }