C#项目数据库连接工具类

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

namespace Cooks
{
    class DbUtils
    {
        public static string DbUrl = "Data Source=.;Initial CataLog=cooke;Integrated Security=True";
        private SqlConnection connection;

        public SqlConnection Connection
        {
            get {
                if (connection == null) {
                    connection = new SqlConnection(DbUrl);
                }
                return connection;
            }
        }

        public void OpenConnection() {
            if (connection.State == System.Data.ConnectionState.Broken) {
                connection.Close();
                connection.Open();
            }
            if (connection.State == System.Data.ConnectionState.Closed) {
                connection.Open();
            }
        }

        public void CloseConnection() {
        
//通过状态码判断connection是否处于打开状态
            if (connection.State == System.Data.ConnectionState.Broken || connection.State == System.Data.ConnectionState.Open) {
                connection.Close();
            }
        }
    }
}