c# mysql dbhelp_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;

}

}

}

}