数据库打开关闭操作
刚刚接触.net记录些东西慢慢学习,呵呵
记录些打开关闭的操作,希望浏览过的人有好的方法也提供下
public class DataBase:IDisposable
{
protected SqlConnection Connection; //数据库连接对象
protected string ConnectionString; //连接字符串变量
/// <summary>
/// 构造函数,获取连接字符
/// </summary>
public DataBase()
{
ConnectionString = "";
}
#region 数据库打开与关闭
/// <summary>
/// 打开连接
/// </summary>
protected void Open()
{
if (Connection == null)
{
Connection = new SqlConnection(ConnectionString);
}
if(Connection.State.Equals(ConnectionState.Open()))
{
Connection.Open();
}
}
/// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
if (Connection != null)
{
Connection.Close();
Dispose();
}
}
/// <summary>
/// 释放资源
/// </summary>
public void Dispose()
{
if (Connection != null)
{
Dispose();
Connection = null;
}
}
}
浙公网安备 33010602011771号