namespace PlasticDAL { public class DBHelper { //定义数据库链接属性 private static SqlConnection objSqlConnection; /// summary /// 获得数据库连接状态 /// /summary public static SqlConnection ObjSqlConnection { get { string DBConnectionStri namespace plasticdal{public class dbhelper{//定义数据库链接属性private static SqlConnection objSqlConnection;////// 获得数据库连接状态/// public static SqlConnection ObjSqlConnection{get{string DBConnectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;if (objSqlConnection == null){objSqlConnection = new SqlConnection(DBConnectionString);objSqlConnection.Open();}else if (objSqlConnection.State == System.Data.ConnectionState.Closed){objSqlConnection.Open();}else if (objSqlConnection.State == System.Data.ConnectionState.Broken){objSqlConnection.Close();objSqlConnection.Open();}return objSqlConnection;}}public static void CloseConn(){if (objSqlConnection.State==ConnectionState.Open){objSqlConnection.Close();}}public static int ExecuteNonQueryBySql(string sql){SqlCommand objSqlCommand = new SqlCommand(sql, ObjSqlConnection);return objSqlCommand.ExecuteNonQuery();}public static SqlDataReader GetReaderBySql(string sql){SqlCommand cmd = new SqlCommand(sql, ObjSqlConnection);SqlDataReader reader = cmd.ExecuteReader();return reader;}}}
DB类
•
👁 0人浏览过