c# mysql 封装_C#简单通用的数据库连接封装

usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Data;usingSystem.Data.SqlClient;namespaceDbLib

{///

///数据库类///

public classDatabase : IDisposable

{///

///受保护的数据库连接///

protected SqlConnection connection = null;///

///受保护的数据库连接字符串///

protected string connString = string.Empty;///

///构造函数，初始化数据库连接///

/// 数据库连接

publicDatabase(SqlConnection sqlConnection)

{this.connection =sqlConnection;

Open();this.connString =sqlConnection.ConnectionString;

}///

///构造函数，初始化数据库连接字符串///

/// 数据库连接字符串

public Database(stringstrConn)

{this.connString =strConn;

Open();

}///

///公共方法：打开数据库连接///

public voidOpen()

{try{if (connection == null)

{

connection= newSqlConnection(connString);

}if (connection.State !=ConnectionState.Open)

{

connection.Open();

}

}catch(Exception ex)

{throw newException(ex.ToString());

}

}///

///公共方法：关闭数据库连接///

public voidClose()

{if ((connection != null) && (connection.State !=ConnectionState.Closed))

{

connection.Close();

}

}///

///公共方法：获取数据库连接///

///

publicSqlConnection GetConnection()

{returnconnection;

}///

///公共方法：获取数据库连接字符串///

///

public stringGetConnString()

{returnconnString;

}///

///公共方法：释放非托管资源；实现IDisposable接口///

public voidDispose()

{if (connection != null)

{

connection= null;

GC.Collect();

}

}

}

}