练手的手写sqlHelper

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;

namespace MyWeb.SqlHelper
{
    public class SqlHelper
    {
        private static readonly string connectionString = ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;
        public static int ExecuteNonQuery(string sql, params SqlParameter[] pams)
        {
            using (SqlConnection con=new SqlConnection(connectionString))
            {
                using (SqlCommand com=new SqlCommand(sql,con))
                {
                    con.Open();
                    if (pams!=null)
                    {
                        com.Parameters.AddRange(pams);
                    }
                    return com.ExecuteNonQuery();
                }
            }
        }

        public static object ExecuteScalar(string sql, params SqlParameter[] pams)
        {
            using (SqlConnection con=new SqlConnection(connectionString))
            {
                using (SqlCommand com=new SqlCommand(sql,con))
                {
                    con.Open();
                    if (pams!=null)
                    {
                        com.Parameters.AddRange(pams);
                    }
                    return com.ExecuteScalar();
                   
                }    
            }
        }
        public static SqlDataReader ExecuteReader(string sql, params SqlParameter[] param)
        {
            using (SqlConnection con=new SqlConnection(connectionString))
            {
                using (SqlCommand com=new SqlCommand(sql,con))
                {
                    con.Open();
                    if (param!=null)
                    {
                        com.Parameters.AddRange(param);
                    }
                    return com.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
                }
            }
        }
        public static DataTable GetDateTable(string sql, params SqlParameter[] param)
        {
            using (SqlDataAdapter adapter=new SqlDataAdapter(sql,connectionString))
            {
                DataTable dt = new DataTable();
                if (param!=null)
                {
                    adapter.SelectCommand.Parameters.AddRange(param);
                }
                return dt;
            }
        }

    }
}