SQLHelper

最新推荐文章于 2019-10-15 14:38:00 发布

Mr_HanQR

最新推荐文章于 2019-10-15 14:38:00 发布

阅读量284

点赞数

分类专栏：技术日记文章标签： ADO.Net

本文链接：https://blog.csdn.net/Mr_HanQR/article/details/43305207

版权

技术日记专栏收录该内容

7 篇文章 0 订阅

订阅专栏

public class SQLHelper
	{
        private static readonly string str = ConfigurationManager.ConnectionStrings["strCon"].ConnectionString;
        /// <summary>
        /// 增删改方法
        /// </summary>
        /// <param name="sql">传sql语句</param>
        /// <param name="param">如果sql语句带参数，则传参数，如果没有则不用传</param>
        /// <returns>返回int类型的（int行受影响）</returns>
        public static int ExeCuteNonQuery(string sql, params SqlParameter[] param)
        {
            using (SqlConnection con = new SqlConnection(str))
            {
                using (SqlCommand cmd = new SqlCommand(sql, con))
                {
                    con.Open();
                    if (param != null)
                    {
                        cmd.Parameters.AddRange(param);//把用户传过来的参数给cmdparameters
                    }
                    return cmd.ExecuteNonQuery();
                }
 
            }
 
        }
        /// <summary>
        /// 读第一列第一行
        /// </summary>
        /// <param name="sql">传sql语句</param>
        /// <param name="param">如果sql是带参数的，则传参</param>
        /// <returns>返回object类型的</returns>
        public static object ExeCuteScalar(string sql, params SqlParameter[] param)
        {
            using (SqlConnection con = new SqlConnection(str))
            {
                using (SqlCommand cmd = new SqlCommand(sql, con))
                {
                    con.Open();
                    if (param != null)
                    {
                        cmd.Parameters.AddRange(param);
                    }
                    return cmd.ExecuteScalar();
                }
            }
        }
        /// <summary>
        /// 读数据库
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <param name="param">如果sql语句带参数，则在这传参</param>
        /// <returns>返回SqlDataReader类型</returns>
        public static SqlDataReader ExeCuteReader(string sql, params SqlParameter[] param)
        {
            SqlConnection con = new SqlConnection(str);
            using (SqlCommand cmd=new SqlCommand (sql,con))
            {
                try
                {
                    con.Open();
                    if (param!=null)
                    {
                        cmd.Parameters.AddRange(param);
                    }
                    return cmd.ExecuteReader(CommandBehavior.CloseConnection);
                }
                catch(Exception ex)
                {
                    con.Close();
                    con.Dispose();
                    throw ex;
                }
            }
        }
    
        public static DataTable GetTable(string sql,params SqlParameter[]param)
        {
            DataTable dt = new DataTable();            
 
            using (SqlDataAdapter sda=new SqlDataAdapter(sql,str))
            {
                if (param != null)
                {
                    sda.SelectCommand.Parameters.AddRange(param);
                }
                sda.Fill(dt);
            }
            return dt;
        }
    }