c#连接Mysql DBHelp 类

来自：http://outofmemory.cn/code-snippet/2380/c-connection-Mysql-DBHelp-class

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
//导命名空间
using System.Data;
using MySql.Data.MySqlClient;
using System.Configuration;

namespace Test.DAL.MySql
{
    public class DBHelp
    {
        private readonly string connString = ConfigurationManager.ConnectionStrings["mysql"].ToString();
        private MySqlConnection mySqlConnection = null;
        private MySqlCommand mySqlCommand = null;
        protected MySqlDataReader mySqlDataReader = null;

        private MySqlDataAdapter mySqlDataAdapter = null;
        private DataSet dataSet = null;

        private int i = 0;

        private MySqlConnection ExecuteMySqlConnection()
        {
            try
            {
                this.mySqlConnection = new MySqlConnection(this.connString);
                this.mySqlConnection.Open();
            }
            catch (Exception)
            {

                throw;
            }
            return this.mySqlConnection;
        }

        private MySqlCommand ExecuteMySqlCommand(string sql,CommandType commandType,MySqlParameter[] mySqlParameter)
        {
            try
            {
                this.mySqlConnection = this.ExecuteMySqlConnection();
                this.mySqlCommand = new MySqlCommand(sql, this.mySqlConnection);
                if (mySqlParameter != null && mySqlParameter.Length > 0)
                {
                    this.mySqlCommand.Parameters.AddRange(mySqlParameter);
                }
                this.mySqlCommand.CommandType = commandType;
            }
            catch (Exception)
            {

                throw;
            }
            return this.mySqlCommand;
        }

        protected MySqlDataReader ExecuteMySqlDataReader(string sql, CommandType commandType, MySqlParameter[] mySqlParameter)
        {
            try
            {
                this.mySqlCommand = this.ExecuteMySqlCommand(sql, commandType, mySqlParameter);
                this.mySqlDataReader = this.mySqlCommand.ExecuteReader();
            }
            catch (Exception)
            {

                throw;
            }
            return this.mySqlDataReader;
        }

        protected DataSet ExecuteDataSet(string sql, CommandType commandType, MySqlParameter[] mySqlParameter)
        {
            this.dataSet = new DataSet();
            try
            {
                this.mySqlCommand = this.ExecuteMySqlCommand(sql, commandType, mySqlParameter);
                this.mySqlDataAdapter = new MySqlDataAdapter(this.mySqlCommand);
                this.mySqlDataAdapter.Fill(dataSet);
            }
            catch (Exception)
            {

                throw;
            }
            return this.dataSet;
        }

        protected int ExecuteScalar(string sql, CommandType commandType, MySqlParameter[] mySqlParameter)
        {
            try
            {
                this.mySqlCommand = this.ExecuteMySqlCommand(sql, commandType, mySqlParameter);
                this.i = int.Parse(this.mySqlCommand.ExecuteScalar().ToString());
            }
            catch (Exception)
            {

                throw;
            }
            return this.i;
        }

        protected int ExecuteNonQuery(string sql, CommandType commandType, MySqlParameter[] mySqlParameter)
        {
            try
            {
                this.mySqlCommand = this.ExecuteMySqlCommand(sql, commandType, mySqlParameter);
                this.i = this.mySqlCommand.ExecuteNonQuery();
            }
            catch (Exception)
            {

                throw;
            }
            return this.i;
        }

        protected void CloseConnection(MySqlConnection mySqlConnection)
        {
            try
            {
                if (mySqlConnection != null)
                {
                    mySqlConnection = null;
                    mySqlConnection.Close();
                }
            }
            catch (Exception)
            {

                throw;
            }
        }

        protected void CloseDataReader(MySqlDataReader mySqlDataReader)
        {
            try
            {
                if (mySqlDataReader != null)
                {
                    mySqlDataReader = null;
                    mySqlDataReader.Close();
                }
            }
            catch (Exception)
            {

                throw;
            }
        }
    }
}