DB类

最新推荐文章于 2021-01-20 20:05:20 发布

chai1338

最新推荐文章于 2021-01-20 20:05:20 发布

阅读量497

点赞数 1

文章标签： string sql 数据库 class cmd null

本文链接：https://blog.csdn.net/chai1338/article/details/6442150

版权

namespace PlasticDAL
{

    public class DBHelper
    {

//定义数据库链接属性
private static SqlConnection objSqlConnection;

        /// <summary>
        /// 获得数据库连接状态
        /// </summary>
        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;
        }

}
}