存个DBHelper

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

namespace HotelManager.DAL
{

    public class DBHelper
    {

       static  string strConn = "server=.;uid=sa;pwd=sa;database=HotelManager";

        /// <summary>
        /// 执行SQL语句（单向操作）
        /// </summary>
        /// <param name="sql">SQL语句</param>
        /// <returns></returns>
        public static int ExecuteCommand(string sql)
        {
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                SqlCommand cmd = new SqlCommand(sql,conn);
                try
                {
                    conn.Open();
                    return cmd.ExecuteNonQuery();

                }
                catch
                {
                    throw new
                        Exception("操作数据库出现错误！");
                }
                finally
                {
                    if (conn.State == ConnectionState.Open)
                    {
                        conn.Close();
                    }
                }
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="arr">Sql占位参数</param>
        /// <returns></returns>
        public static int ExecuteCommand
            (string sql,params SqlParameter[] arr)
        {
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.Parameters.AddRange(arr);
                try
                {
                    conn.Open();
                    return cmd.ExecuteNonQuery();

                }
                catch
                {
                    throw new
                        Exception("操作数据库出现错误！");
                }
                finally
                {
                    if (conn.State == ConnectionState.Open)
                    {
                        conn.Close();
                    }
                }
            }
        }


        /// <summary>
        /// 执行SQL语句（查询单条数据）
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static SqlDataReader GetReader(string sql)
        {
            SqlConnection conn = new SqlConnection(strConn);
            SqlCommand cmd = new SqlCommand(sql,conn);
            try
            {
                conn.Open();
                return cmd.ExecuteReader(CommandBehavior.CloseConnection);
            }
            catch
            {
                throw new
                        Exception("操作数据库出现错误！");
            }
        }

        public static SqlDataReader GetReader(string sql,params SqlParameter[] arr)
        {
            SqlConnection conn = new SqlConnection(strConn);
            SqlCommand cmd = new SqlCommand(sql, conn);
            cmd.Parameters.AddRange(arr);
            try
            {
                conn.Open();
                return cmd.ExecuteReader(CommandBehavior.CloseConnection);
            }
            catch
            {
                throw new
                        Exception("操作数据库出现错误！");
            }
        }


        public static DataTable GetDataSet(string sql)
        {
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                SqlDataAdapter da = new SqlDataAdapter(sql, conn);
                DataTable dtSource = new DataTable("Source");
                da.Fill(dtSource);
                return dtSource;
            }
        }
        public static DataTable GetDataSet(string sql,params SqlParameter[] arr)
        {
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                SqlDataAdapter da = new SqlDataAdapter(sql, conn);
                da.SelectCommand.Parameters.AddRange(arr);
                DataTable dtSource = new DataTable("Source");
                da.Fill(dtSource);
                return dtSource;
            }
        }


        public static object ExecuteScalar(string sql)
        {
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                SqlCommand cmd = new SqlCommand(sql, conn);
                try
                {
                    conn.Open();
                    return cmd.ExecuteScalar();

                }
                catch
                {
                    throw new
                        Exception("操作数据库出现错误！");
                }
                finally
                {
                    if (conn.State == ConnectionState.Open)
                    {
                        conn.Close();
                    }
                }
            }
        }

        public static object ExecuteScalar(string sql,params SqlParameter[] arr)
        {
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.Parameters.AddRange(arr);
                try
                {
                    conn.Open();
                    return cmd.ExecuteScalar();

                }
                catch
                {
                    throw new
                        Exception("操作数据库出现错误！");
                }
                finally
                {
                    if (conn.State == ConnectionState.Open)
                    {
                        conn.Close();
                    }
                }
            }
        }

    }
}