using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
public class DBHelper
{
//1.封装连接打开数据库
//1.1定义连接字符串
public static string ConnString = "server=.;database=User;Integrated Security=true";
//1.3定义连接对象
public static SqlConnection Conn = null;
//1.4进行 方法封装
public static void InitConnection()
{
//1.4.1 实例化对象
if (Conn == null)
{
Conn = new SqlConnection(ConnString);
}
//1.4.2 打开数据库
if (Conn.State == ConnectionState.Closed)
{
Conn.Open();
}
if (Conn.State == ConnectionState.Broken)
{
Conn.Close();
Conn.Ope