DBHelper类

public class DBhelp
    {
        //1:连接字符串方式1
        public static string connStr = "server=.;database=数据库名;uid=账号;pwd=密码";
        //1:连接字符串方式2
        public static string connStr = "server=.;database=3CDB;Integrated Security=true;";
        //2:连接对象
        public static SqlConnection conn = null;
        //3:打开数据库，封装成一个方法
        public static void InitConnection() {
            //1:是否已经有连接对象了
            if (conn == null)
            {
                conn = new SqlConnection(connStr);

            }
            //2:连接对象的状态
            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            if (conn.State == ConnectionState.Broken)
            {
                conn.Close();
                conn.Open();

            }
        }
        //4:增删改
        public static int getExecuteNonQuery(string sqlStr) {
            InitConnection();
            int rs = 0;
            //命令操作
            SqlCommand cmd = new SqlCommand(sqlStr,conn);
            rs=cmd.ExecuteNonQuery();
            return rs;
        }
        //5:查询所有列表 CSY
        public static SqlDataReader getDataReader(string sqlStr)
        {
            InitConnection();
            SqlDataReader rs = null;
            //命令操作
            SqlCommand cmd = new SqlCommand(sqlStr, conn);
            rs = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            return rs;
        }
        //6:聚合函数
        public static object getExecuteScalar(string sqlStr)
        {
            InitConnection();
            object rs = null;
            //命令操作
            SqlCommand cmd = new SqlCommand(sqlStr, conn);
            rs = cmd.ExecuteScalar();
            return rs;
        }
        //7:Table==断开式的连接
        public static DataTable GetDataTable(string sqlStr) {
            DataTable dt= new DataTable();
            //1：连接数据库
            InitConnection();

            //2:创建适配器
            SqlDataAdapter sda=new SqlDataAdapter(sqlStr,conn);
            //3:填充数据
            sda.Fill(dt);
            conn.Close();
            return dt;
        }
        //8.DataSet
        public static DataSet GetDataSet(string sqlStr)
        {
            DataSet ds = new DataSet();
            //1：连接数据库
            InitConnection();
            //2:创建适配器
            SqlDataAdapter sda = new SqlDataAdapter(sqlStr, conn);
            //3:填充数据
            sda.Fill(ds);
            conn.Close();
            return ds;
        }

    }