-.数据访问层实现Ⅱ-SQL Server代码.doc

数据库辅助类SQLServerDALHelper.cs: ?using?System;?using?System.Collections.Generic;?using?System.Configuration;?using?System.Data;?using?System.Data.SqlClient;??namespace?NGuestBook.SQLServerDAL?{?????///?summary????///?SQLServer数据库操作助手????///?/summary????public?sealed?class?SQLServerDALHelper????{????????///?summary????????///?用于连接SQLServer数据库的连接字符串，存于Web.config中????????///?/summary????????private?static?readonly?string?_sqlConnectionString?=?ConfigurationManager.AppSettings[SQLServerConnectionString];????????///?summary????????///?执行SQL命令，不返回任何值????????///?/summary????????///?param?name=sqlSQL命令/param????????public?static?void?ExecuteSQLNonQurey(string?sql)????????{????????????SqlConnection?connection?=?new?SqlConnection(_sqlConnectionString);????????????SqlCommand?command?=?new?SqlCommand(sql,connection);????????????connection.Open();????????????command.ExecuteNonQuery();????????????connection.Close();????????}????????///?summary????????///?执行SQL命令，并返回SqlDataReader????????///?/summary????????///?param?name=sqlSQL命令/param????????///?returns包含查询结果的SqlDataReader/returns????????public?static?SqlDataReader?ExecuteSQLReader(string?sql)????????{????????????SqlConnection?connection?=?new?SqlConnection(_sqlConnectionString);????????????SqlCommand?command?=?new?SqlCommand(sql,?connection);????????????connection.Open();????????????SqlDataReader?sqlReader?=?command.ExecuteReader();????????????//connection.Close();????????????return?sqlReader;????????}????????///?summary????????///?执行存储过程，不返回任何值????????///?/summary????????///?param?name=storedProcedureName存储过程名/param????????///?param?name=parameters参数/param????????public?static?void?ExecuteProcedureNonQurey(string?storedProcedureName,IDataParameter[]?parameters)????????{????????????SqlConnection?connection?=?new?SqlConnection(_sqlConnectionString);????????????SqlCommand?command?=?new?SqlCommand(storedProcedureName,connection);????????????command.CommandType?=?CommandType.Stor