【C#】我的SqlHelper

最新推荐文章于 2024-05-25 18:00:05 发布

原创最新推荐文章于 2024-05-25 18:00:05 发布 · 939 阅读

0 ·

CC 4.0 BY-SA版权

C#操作SqlServer 专栏收录该内容

12 篇文章

订阅专栏

博客提及了两个版本，分别为第一个版本和另一个版本，但未给出更多详细信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

第一个版本

public static class SqlHelper
{
    //SqlServer身份验证
    public static string connectionString = "server=.;database=School;uid=sa;pwd=123";
    //Windwos身份验证
    //static string connectionString = "server=.;database=School;Integrated Security =true;";

    /// <summary>
    /// 判断数据库释放连接成功
    /// </summary>
    /// <returns></returns>
    public static bool OpenDB()
    {
        try
        {
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                conn.Close();
                return true;
            }
        }
        catch { }
        return false;
    }

    /// <summary>
    /// 用于增删改操作，返回影响行数
    /// </summary>
    public static int ExecuteNonQuery(string sql, params SqlParameter[] parameters)
    {
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            using (SqlCommand cmd = new SqlCommand(sql, conn))
            {
                conn.Open();
                cmd.Parameters.AddRange(parameters);
                return cmd.ExecuteNonQuery();
            }
        }
    }

    /// <summary>
    /// 用于查询操作，返回查询结果集中第一行的第一列
    /// </summary>
    public static object ExecuteScalar(string sql, params SqlParameter[] parameters)
    {
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            using (SqlCommand cmd = new SqlCommand(sql, conn))
            {
                conn.Open();
                cmd.Parameters.AddRange(parameters);
                return cmd.ExecuteScalar();
            }
        }
    }

    /// <summary>
    /// 用于查询操作，返回DataTable
    /// </summary>
    public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters)
    {
        using (SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString))
        {
            DataTable dt = new DataTable();
            adapter.SelectCommand.Parameters.AddRange(parameters);
            adapter.Fill(dt);
            return dt;
        }
    }

    public static SqlDataReader ExecuteReader(string sql, params SqlParameter[] parameters)
    {
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            using (SqlCommand cmd = new SqlCommand(sql, conn))
            {
                conn.Open();
                cmd.Parameters.AddRange(parameters);
                return cmd.ExecuteReader(CommandBehavior.CloseConnection);
            }
        }
    }
}

另一个版本

public static class SqlHelper
{
    /// <summary>
    /// 判断数据库是否连接成功
    /// </summary>
    public static bool OpenDataBase(string DBCString)
    {
        try
        {
            using (SqlConnection conn = new SqlConnection(DBCString))
            {
                conn.Open();
                conn.Close();
                return true;
            }
        }
        catch { }
        return false;
    }

    /// <summary>
    ///  用于增删改操作，返回影响行数
    /// </summary>
    public static int ExecuteNonQuery(string DBCString, string sql, params SqlParameter[] parameters)
    {
        using (SqlConnection conn = new SqlConnection(DBCString))
        {
            using (SqlCommand cmd = conn.CreateCommand())
            {
                conn.Open();
                cmd.CommandText = sql;
                cmd.Parameters.AddRange(parameters);
                return cmd.ExecuteNonQuery();
            }
        }
    }

    /// <summary>
    /// 用于查询操作，返回查询结果集中第一行的第一列
    /// </summary>
    public static object ExecuteScalar(string DBCString, string sql, params SqlParameter[] parameters)
    {
        using (SqlConnection conn = new SqlConnection(DBCString))
        {
            using (SqlCommand comm = conn.CreateCommand())
            {
                conn.Open();
                comm.CommandText = sql;
                comm.Parameters.AddRange(parameters);
                return comm.ExecuteScalar();
            }
        }
    }

    /// <summary>
    /// 用于查询操作，返回DataTable
    /// </summary>
    public static DataTable ExecuteDataTable(string DBCString, string sql, params SqlParameter[] parameters)
    {
        using (SqlDataAdapter adapter = new SqlDataAdapter(sql, DBCString))
        {
            DataTable dt = new DataTable();
            adapter.SelectCommand.Parameters.AddRange(parameters);
            adapter.Fill(dt);
            return dt;
        }
    }

    public static SqlDataReader ExecuteReader(string DBCString, string sql, params SqlParameter[] parameters)
    {
        using (SqlConnection conn = new SqlConnection(DBCString))
        {
            using (SqlCommand cmd = conn.CreateCommand())
            {
                conn.Open();
                cmd.CommandText = sql;
                cmd.Parameters.AddRange(parameters);
                return cmd.ExecuteReader(CommandBehavior.CloseConnection);
            }
        }
    }
}