黑马程序员-自己动手写SQLHelper

来源：互联网发布：乌克兰手机社交软件编辑：程序博客网时间：2024/06/05 18:48

---------------- Windows Phone 7手机开发、.Net培训、期待与您交流！--------------------

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

namespace DataSetTest
{
    class SQLHelper
    {
        public static string connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;

        public static int ExecuteNonQuery(string Sql, CommandType type, params SqlParameter[] parameters)
        {
            int result;
            using (SqlConnection conn=new SqlConnection(connStr))
            {
                using (SqlCommand cmd=conn.CreateCommand())
                {
                    conn.Open();
                    cmd.CommandText = Sql;
                    cmd.CommandType = type;
                    if (parameters!=null)
                    {
                        foreach (SqlParameter parameter in parameters)
                        {
                            cmd.Parameters.Add(parameter);
                        }
                    }
                    result = cmd.ExecuteNonQuery();
                }
            }
            return result;
        }

        public static object ExecuteScalar(string Sql, CommandType type, params SqlParameter[] parameters)
        {
            object obj=null;
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    conn.Open();
                    cmd.CommandText = Sql;
                    cmd.CommandType = type;
                    if (parameters != null)
                    {
                        foreach (SqlParameter parameter in parameters)
                        {
                            cmd.Parameters.Add(parameter);
                        }
                    }
                    obj = cmd.ExecuteScalar();
                }
            }
            return obj;
        }

        public static SqlDataReader ExecuteReader(string Sql, CommandType type, params SqlParameter[] parameters)
        {
            SqlDataReader dataReader = null;
            SqlConnection conn = new SqlConnection(connStr);//返回SqlDataReader不能用using

            using (SqlCommand cmd = conn.CreateCommand())
            {
                conn.Open();
                cmd.CommandText = Sql;
                cmd.CommandType = type;
                if (parameters != null)
                {
                    foreach (SqlParameter parameter in parameters)
                    {
                        cmd.Parameters.Add(parameter);
                    }
                }
                dataReader = cmd.ExecuteReader();
            }

            return dataReader;
        }

        public static DataSet ExecuteDataSet(string Sql, CommandType type, params SqlParameter[] parameters)
        {
            DataSet ds = new DataSet();
             using (SqlConnection conn = new SqlConnection(connStr))
            {
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    conn.Open();
                    cmd.CommandText = Sql;
                    cmd.CommandType = type;
                    if (parameters != null)
                    {
                        foreach (SqlParameter parameter in parameters)
                        {
                            cmd.Parameters.Add(parameter);
                        }
                    }
                    SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
                    dataAdapter.Fill(ds);
                }
            }
             return ds;
        }
    }
}

---------------- Windows Phone 7手机开发、.Net培训、期待与您交流！--------------------