class DBHelper
{
//数据库四参数
private string strConn = "Data Source=.;Initial Catalog=MobileManager;User ID=sa;Pwd=1234";
//Connection对象
private SqlConnection connection;
public SqlConnection Connection
{
get
{
if (connection==null)
{
connection=new SqlConnection(strConn);
}
return connection;
}
}
public void OpenConnection()
{
if (Connection.State == ConnectionState.Closed)
{
Connection.Open();
}
else if (Connection.State == ConnectionState.Broken)
{
Connection.Close();
Connection.Open();
}
}
public void CloseConnection()
{
if (Connection.State == ConnectionState.Open || Connection.State == ConnectionState.Broken)
{
Connection.Close();
}
}
C#连接数据库(DBhelper)
最新推荐文章于 2024-09-04 07:00:00 发布