conn

最新推荐文章于 2023-08-17 16:58:33 发布

gaotongzhao

最新推荐文章于 2023-08-17 16:58:33 发布

阅读量517

点赞数

文章标签： string null

本文链接：https://blog.csdn.net/gaotongzhao/article/details/6717241

版权

         private static SqlConnection conn;
        public static SqlConnection Conn
        {
            get
            {

                string connstr = "Data Source=localhost;Initial Catalog=JDZDJ;User ID=sa;Password=NPTsoft365!!";
                if (conn == null)
                {
                    conn = new SqlConnection(connstr);
                    conn.Open();
                }
                else if (conn.State == System.Data.ConnectionState.Closed)
                {
                    conn.Open();
                }
                else if (conn.State == System.Data.ConnectionState.Broken)
                {
                    conn.Close();
                    conn.Open();
                }
                return conn;
            }
        }