C#中连接数据库常用的类文件及方法

已经将连接数据库常用方法写到一个类里，只需调用即可

using System;

using System.Data;
using System.Data.SqlClient;
using System.Text;


class DBUtil
{
    // 定义连接字符串
    private static string strConnect = System.Configuration.ConfigurationSettings.AppSettings["connStr"];


    public static int SqlExecuteNonQuery(SqlCommand objCommand)
    {
        SqlConnection objConnection = new SqlConnection(strConnect);
        objCommand.Connection = objConnection;


        try
        {
            if (objConnection.State == ConnectionState.Closed) objConnection.Open();
            return objCommand.ExecuteNonQuery();
        }
        catch (Exception e)
        {
            throw e;
        }
        finally
        {
            if (objConnection.State == ConnectionState.Open) objConnection.Close();
        }
    }


    public static int SqlExecuteNonQuery(string strCmd)
    {
        SqlCommand objCommand = new SqlCommand(strCmd);
        return SqlExecuteNonQuery(objCommand);
    }


    public static object SqlExecuteScalar(SqlCommand objCommand)
    {
        SqlConnection objConnection = new SqlConnection(strConnect);
        objCommand.Connection = objConnection;


        try
        {
            if (objConnection.State == ConnectionState.Closed) objConnection.Open();
            return objCommand.ExecuteScalar();
        }
        catch (Exception e)
        {
            throw e;
        }
        finally
        {
            if (objConnection.State == ConnectionState.Open) objConnection.Close();
        }
    }


    public static object SqlExecuteScalar(string strCmd)
    {
        SqlCommand objCommand = new SqlCommand(strCmd);
        return SqlExecuteScalar(objCommand);
    }


    public static DataSet GetDataSet(SqlCommand objCommand, string strTableName)
    {
        SqlConnection objConnection = new SqlConnection(strConnect);
        objCommand.Connection = objConnection;


        try
        {
            if (objConnection.State == ConnectionState.Closed) objConnection.Open();
            SqlDataAdapter objDataAdapter = new SqlDataAdapter(objCommand);
            DataSet objDataSet = new DataSet();
            objDataAdapter.Fill(objDataSet, strTableName);
            return objDataSet;
        }
        catch (Exception e)
        {
            throw e;
        }
        finally
        {
            if (objConnection.State == ConnectionState.Open) objConnection.Close();
        }
    }


    public static DataSet GetDataSet(string strCmd, string strTableName)
    {
        SqlCommand objCommand = new SqlCommand(strCmd);
        return GetDataSet(objCommand, strTableName);
    }
}