DBH

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;


namespace WindowsFormsApplication2
{
    class DBHelper
    {
        public class DBHelper {
            private string connString = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
            private SqlConnection connection;
            public SqlConnection Connection {
                get {
                    if (connection==null)
                    {
                        connection = new SqlConnection(connString);
                    }
                    return connection;
                }
            }
            public void OC() {
                if (Connection.State == ConnectionState.Closed)
                {
                    Connection.Open();
                }
                else if (Connection.State == ConnectionState.Broken)
                {
                    Connection.Close();
                    Connection.Open();
                }
                
                
                
            }
            public void CC() {
                if (Connection.State == ConnectionState.Open||Connection.State == ConnectionState.Broken)
                {
                    Connection.Close();
                }
            }
        }
    }
}

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;


namespace WindowsFormsApplication2
{
    /// <summary>
    /// 此类维护数据库连接字符串，和 Connection 对象
    /// </summary>
    public class DBHelper
    {
        // 数据库连接字符串
        private string connString = @"Data Source=.;Initial Catalog=MySchool;Integrated Security=True";


        // 数据库连接 Connection 对象
        private SqlConnection connection;


        /// <summary>
        /// Connection对象
        /// </summary>
        public SqlConnection Connection
        {
            get
            {
                if (connection == null)
                {
                    connection = new SqlConnection(connString);
                }
                return connection;
            }
        }


        /// <summary>
        /// 打开数据库连接
        /// </summary>
        public void OpenConnection()
        {
            if (Connection.State == ConnectionState.Closed)
            {
                Connection.Open();
            }
            else if (Connection.State == ConnectionState.Broken)
            {
                Connection.Close();
                Connection.Open();
            }
        }


        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        public void CloseConnection()
        {
            if (Connection.State == ConnectionState.Open || Connection.State == ConnectionState.Broken)
            {
                Connection.Close();
            }
        }
    }
}