封装SQLHelper

最新推荐文章于 2022-12-21 17:27:37 发布

weixin_30706691

最新推荐文章于 2022-12-21 17:27:37 发布

阅读量57

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/jara/p/3657705.html

本文介绍了一个名为SQLHelper的类，它包含了用于执行SQL语句的三个方法：ExecuteNonQuery、ExecuteScalar和ExecuteDataTable。这些方法分别用于执行SQL命令并返回影响的行数、执行SQL命令并返回单个值、以及执行SQL命令并返回数据表。

//
//  author: agile
//  datetime:5/29/2011 8:59:13 AM
//  class:  SQLHelper
//
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
 
namespace SqlHelper
{
    class SQLHelper
    {
        public static int ExecuteNonQuery(string sql,params SqlParameter[] parameters) 
        {
            string conn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
            using (SqlConnection strconn = new SqlConnection(conn)) 
            {
                strconn.Open();
                using (SqlCommand cmd = strconn.CreateCommand()) 
                {
                    cmd.CommandText = sql;
                    foreach (SqlParameter parameter in parameters)
                    {
                        cmd.Parameters.Add(parameter); 
                    }
                    return cmd.ExecuteNonQuery();
                }
            }
 
        }
        public static object ExecuteScalar(string sql, params SqlParameter[] parameters) 
        {
            string conn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
            using (SqlConnection strconn = new SqlConnection(conn))
            {
                strconn.Open();
                using (SqlCommand cmd = strconn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    foreach (SqlParameter parameter in parameters)
                    {
                        cmd.Parameters.Add(parameter);
                    }
                    return cmd.ExecuteScalar();
                }
            }
 
        }
        public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters)
        {
            string conn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
            using (SqlConnection strconn = new SqlConnection(conn))
            {
                strconn.Open();
                using (SqlCommand cmd = strconn.CreateCommand())
                {
                    cmd.CommandText = sql;
                     foreach (SqlParameter parameter in parameters)
                    {
                        cmd.Parameters.Add(parameter);
                    }
                    DataSet dataset = new DataSet();
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(dataset);
                    return dataset.Tables[0];
 
                 }             
            }
            
        }
    }
}

转载于:https://www.cnblogs.com/jara/p/3657705.html