静态代码块链接数据库，返回链接对象

2019-11-11 04:08:23

字体：大中小

来源：转载

供稿：网友

public static string connectString = ConfigurationManager.ConnectionStrings["bbsConnectionString"].ConnectionString; public static SqlConnection _SqlConn; public static SqlCommand SqlCmd; //数据库连接属性 public static SqlConnection SqlConn { get { if (_SqlConn == null) //如果当前连接状态为null，打开链接 { _SqlConn = new SqlConnection(connectString); _SqlConn.Open(); } else if (_SqlConn.State == ConnectionState.Closed) //如果当前连接状态为关闭，打开链接 { _SqlConn.Open(); } else if (_SqlConn.State == ConnectionState.Open) //如果当前连接状态为用户打开忘记关闭，先关闭连接再打开链接 { _SqlConn.Close(); _SqlConn.Open(); } else if (_SqlConn.State == ConnectionState.Broken) //如果与数据源的链接中断，先关闭连接再打开链接 { _SqlConn.Close(); _SqlConn.Open(); } return _SqlConn; } }

上一篇：有向图强连通分量的Tarjan算法

下一篇：Spring集成MyBatis框架