sqlserver数据库访问帮助类

/// <summary>
/// 数据库访问帮助类
/// </summary>
public static class DbHelper
{
private const string ConnStr = "server=127.0.0.1;database=db_test;Uid=user1;Pwd=Ps123321;";


/// <summary>
/// 执行 增、删、改
/// </summary>
/// <param name="sql"></param>
/// <param name="sqlParams"></param>
/// <returns></returns>
public static int ExecuteNonQuery(string sql, params SqlParameter[] sqlParams)
{
    using (SqlConnection conn = new SqlConnection(ConnStr))
    {
        conn.Open();
        using (SqlCommand comm = conn.CreateCommand())
        {
            comm.CommandText = sql;
            comm.CommandType = CommandType.Text;
            if (sqlParams != null)
                comm.Parameters.AddRange(sqlParams);
            return comm.ExecuteNonQuery();
        }
    }
}

/// <summary>
/// 返回1个查询结果
/// </summary>
/// <param name="sql"></param>
/// <param name="sqlParams"></param>
/// <returns></returns>
public static object ExecuteScalar(string sql, params SqlParameter[] sqlParams)
{
    using (SqlConnection conn = new SqlConnection(ConnStr))
    {
        conn.Open();
        using (SqlCommand comm = conn.CreateCommand())
        {
            comm.CommandText = sql;
            comm.CommandType = CommandType.Text;
            if (sqlParams != null)
                comm.Parameters.AddRange(sqlParams);
            return comm.ExecuteScalar();
        }
    }
}

/// <summary>
/// 返回查询，返回结果集
/// </summary>
/// <param name="sql"></param>
/// <param name="sqlParams"></param>
/// <returns></returns>
public static DataTable ExecuteQuery(string sql, params SqlParameter[] sqlParams)
{
    using (SqlConnection conn = new SqlConnection(ConnStr))
    {
        conn.Open();
        using (SqlCommand comm = conn.CreateCommand())
        {
            comm.CommandText = sql;
            comm.CommandType = CommandType.Text;
            if (sqlParams!=null)
                comm.Parameters.AddRange(sqlParams);
            using (SqlDataAdapter adp = new SqlDataAdapter(comm))
            {
                DataSet ds = new DataSet();
                adp.Fill(ds);
                return ds.Tables[0];
            }
        }
    }
}
}