/*************************************************?
*作者：趙崇
*小組：
*說明：
*創建日期：2014/11/27?16:55:22
*版本號：V1.0.0
**************************************************/
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Data;
using?System.Data.SqlClient;
using?System.Configuration;

namespace?動態創建庫V2._0
{
????public?sealed?class?SQLHelper
????{
????????private?SqlCommand?cmd?=?null;
????????private?SqlConnection?conn?=?null;
????????private?SqlDataReader?sdr?=?null;

????????public?static?SQLHelper?instance?=?new?SQLHelper（）;

????????#region?數據庫連接字符串需要手動創建
????????/////?

????????/////?私有的構造函數
????????/////?
?
????????private?SQLHelper（）
????????{
????????????string?strConn?=?ConfigurationManager.ConnectionStrings[“MSSql2012“].ConnectionString;
????????????conn?=?new?SqlConnection（strConn）;
????????}
????????#endregion

????????///?

????????///?設置數據庫連接字符串——張連海
????????///?

????????///?
????????public?void?SetConnection（string?strConnName）
????????{
????????????string?strConnAll?=?ConfigurationManager.ConnectionStrings[strConnName].ConnectionString;
????????????String?strConn?=?strConnAll.Substring（strConnAll.IndexOf（“data?source“）?strConnAll.IndexOf（“MultipleActiveResultSets“）?-?strConnAll.IndexOf（“data?source“））;
????????????conn?=?new?SqlConnection（strConn）;
????????}

????????///?

????????///?單例模式
????????///?

????????///?
????????public?static?SQLHelper?GetInstance（）
????????{
????????????return?instance;
????????}

????????///?

????????///?獲得數據庫連接
????????///?

????????///?
????????private?SqlConnection?GetConnection（）
????????{
????????????if?（conn.State?==?ConnectionState.Closed）
????????????{
????????????????conn.Open（）;
????????????}
????????????return?conn;
????????}

????????///?

????????///?關閉連接
????????///?

????????///?數據庫連接
????????public?static?void?Close（SqlConnection?conn）
????????{
????????????if?（conn?!=?null）
????????????{
????????????????try
????????????????{
????????????????????conn.Close（）;
????????????????}
????????????????catch?（SqlException?e）
????????????????{
????????????????????throw?e;
????????????????}
????????????}
????????}

????????#region??執行帶參數的增刪改命令：?ExecuteNonQuery（string?cmmText?SqlParameter[]?para?CommandType?cmmType）
????????///?

????????///?執行帶參數的增刪改命令
????????///?

????????///?
????????///?
????????///?
????????///?
????????public?int?ExecuteNonQuery（string?cmmText?SqlParameter[]?para?CommandType?cmmType）
????????{
????????????using?（cmd?=?new?SqlCommand（cmmText?GetConnection（）））
????????????{
????????????????cmd.CommandType?=?cmmType;
????????????????cmd.P

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-11-27?16:54??動態創建庫V2.0\
?????目錄???????????0??2014-11-29?17:21??動態創建庫V2.0\動態創建庫V2.0\
?????目錄???????????0??2014-11-27?16:54??動態創建庫V2.0\動態創建庫V2.0\Properties\
?????文件????????1333??2014-11-27?16:54??動態創建庫V2.0\動態創建庫V2.0\Properties\AssemblyInfo.cs
?????文件????????5598??2014-11-27?17:30??動態創建庫V2.0\動態創建庫V2.0\SQLHelper.cs
?????文件????????1245??2014-11-27?16:54??動態創建庫V2.0\動態創建庫V2.0\Web.Debug.config
?????文件????????1306??2014-11-27?16:54??動態創建庫V2.0\動態創建庫V2.0\Web.Release.config
?????文件?????????484??2014-11-27?16:59??動態創建庫V2.0\動態創建庫V2.0\Web.config
?????目錄???????????0??2014-11-27?16:56??動態創建庫V2.0\動態創建庫V2.0\bin\
?????文件????????9728??2014-11-29?17:22??動態創建庫V2.0\動態創建庫V2.0\bin\動態創建庫V2.0.dll
?????文件?????????484??2014-11-27?16:59??動態創建庫V2.0\動態創建庫V2.0\bin\動態創建庫V2.0.dll.config
?????文件???????28160??2014-11-29?17:22??動態創建庫V2.0\動態創建庫V2.0\bin\動態創建庫V2.0.pdb
?????目錄???????????0??2014-11-27?16:54??動態創建庫V2.0\動態創建庫V2.0\obj\
?????目錄???????????0??2014-11-29?17:22??動態創建庫V2.0\動態創建庫V2.0\obj\Debug\
?????文件????????8422??2014-11-29?16:37??動態創建庫V2.0\動態創建庫V2.0\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????目錄???????????0??2014-11-29?18:30??動態創建庫V2.0\動態創建庫V2.0\obj\Debug\TempPE\
?????文件???????????0??2014-11-27?16:54??動態創建庫V2.0\動態創建庫V2.0\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
?????文件???????????0??2014-11-27?16:54??動態創建庫V2.0\動態創建庫V2.0\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
?????文件???????????0??2014-11-27?16:54??動態創建庫V2.0\動態創建庫V2.0\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
?????文件?????????994??2014-11-28?14:16??動態創建庫V2.0\動態創建庫V2.0\obj\Debug\動態創建庫V2.0.csproj.FileListAbsolute.txt
?????文件????????3320??2014-11-28?11:13??動態創建庫V2.0\動態創建庫V2.0\obj\Debug\動態創建庫V2.0.csprojResolveAssemblyReference.cache
?????文件????????9728??2014-11-29?17:22??動態創建庫V2.0\動態創建庫V2.0\obj\Debug\動態創建庫V2.0.dll
?????文件???????28160??2014-11-29?17:22??動態創建庫V2.0\動態創建庫V2.0\obj\Debug\動態創建庫V2.0.pdb
?????文件????????5523??2014-11-28?15:41??動態創建庫V2.0\動態創建庫V2.0\動態創建庫---趙崇.cs
?????文件?????????430??2014-11-27?17:16??動態創建庫V2.0\動態創建庫V2.0\動態創建庫V2.0.aspx
?????文件????????6082??2014-11-29?17:21??動態創建庫V2.0\動態創建庫V2.0\動態創建庫V2.0.aspx.cs
?????文件?????????816??2014-11-27?17:06??動態創建庫V2.0\動態創建庫V2.0\動態創建庫V2.0.aspx.designer.cs
?????文件????????5366??2014-11-28?15:44??動態創建庫V2.0\動態創建庫V2.0\動態創建庫V2.0.csproj
?????文件????????1099??2014-11-28?15:44??動態創建庫V2.0\動態創建庫V2.0\動態創建庫V2.0.csproj.user
?????文件????????1026??2014-11-27?16:54??動態創建庫V2.0\動態創建庫V2.0.sln
?????文件???????51200??2014-11-28?15:44??動態創建庫V2.0\動態創建庫V2.0.v12.suo
............此處省略0個文件信息