62,074
社区成员
发帖
与我相关
我的任务
分享
public static class DBHelper
{
//连接数据库的字符串
//private static string conStr = "server=.;Initial Catalog=Stuassmanage;Integrated Security=true;";
////连接数据库的字符串
//private static string conStr ="Data Source=PC-200911301058;Initial Catalog=Stuassmanage;Integrated Security=True";
//私有的连接对象
private static SqlConnection connection;
public class Data
{
private Data()
{
}
public static string SqlConString
{
get { return ConfigurationManager.AppSettings["StuassmanageConnectionString"]; }
}
}
//公共静态的连接对象供外部访问
public static SqlConnection Connection
{
get
{
if (connection == null)
{
//connection = new SqlConnection(conStr);
connection = new SqlConnection(Data.SqlConString);//新建一个连接对象
connection.Open();
}
if (connection.State == ConnectionState.Closed)//如果连接对象是关闭的,则将其打开
{
connection.Open();
}
if (connection.State == ConnectionState.Broken)//如果连接对象的连接断开了,现将其关闭再打开
{
connection.Close();
connection.Open();
}
return connection;
}
}
<connectionStrings>
<add name="StuassmanageConnectionString" connectionString="Data Source=PC-200911301058;Initial Catalog=Stuassmanage;User ID=sa;Password=123"
providerName="System.Data.SqlClient" />
</connectionStrings>