using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System;
using?System.Data;
using?System.Data.Common;
using?System.Configuration;
using?System;?
using?System.Collections.Generic;?using?System.Text;?
using?System.Data.SqlClient;?using?System.Configuration;?using?System.Data;

namespace?abc
{
????public?class?DBHelper
????{
????????//屬性:數據庫鏈接對象
????????private?static?SqlConnection?conn;
????????public?static?SqlConnection?Conn
????????{
????????????get
????????????{
????????????????string?connstr?=?ConfigurationManager.ConnectionStrings[“connstr“].ConnectionString;
????????????????if?（conn?==?null）
????????????????????conn?=?new?SqlConnection（connstr）;
????????????????if?（conn.State?==?ConnectionState.Closed）
????????????????????conn.Open（）;
????????????????if?（conn.State?==?ConnectionState.Broken）
????????????????{
????????????????????conn.Close（）;
????????????????????conn.Open（）;
????????????????}
????????????????return?conn;
????????????}
????????}

????????//方法:查詢DataReader
????????public?static?SqlDataReader?GetReader（string?SqlStr）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（SqlStr?Conn）;
????????????return?cmd.ExecuteReader（）;
????????}

????????public?static?SqlDataReader?GetReader（string?SqlStr?SqlParameter[]?paras）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（SqlStr?Conn）;
????????????cmd.Parameters.AddRange（paras）;
????????????return?cmd.ExecuteReader（）;
????????}

????????//查詢:DataTable
????????public?static?DataTable?GetTable（string?SqlStr）
????????{
????????????SqlDataAdapter?dap?=?new?SqlDataAdapter（SqlStr?Conn）;
????????????DataSet?ds?=?new?DataSet（）;
????????????dap.Fill（ds）;
????????????conn.Close（）;
????????????return?ds.Tables[0];

????????}

????????//增刪改
????????public?static?bool?Execute（string?SqlStr）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（SqlStr?Conn）;
????????????int?result?=?cmd.ExecuteNonQuery（）;
????????????conn.Close（）;
????????????return?result?>?0;
????????}

????????//返回首行首列
????????public?static?object?GetScalar（string?SqlStr）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（SqlStr?Conn）;
????????????object?obj?=?cmd.ExecuteScalar（）;
????????????conn.Close（）;
????????????return?obj;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????46792??2014-01-08?00:16??課設\E-R?模型圖（改）.vsdx

?????文件??????46494??2014-01-06?21:42??課設\E-R?模型圖.vsdx

?????文件?????104178??2014-01-07?21:28??課設\E—R圖.cdb

?????文件?????104228??2014-01-08?11:45??課設\E—R圖.cdm

?????文件????2531840??2014-01-03?20:52??課設\《軟件工程》課程設計任務指導-軟件工程2011級.doc

?????文件??????28334??2014-01-08?15:29??課設\數據庫腳本.sql

?????文件??????19487??2014-01-09?21:37??課設\數據庫腳本2.sql

?????文件??????55743??2014-01-07?00:42??課設\數據庫邏輯結構圖.vsdx

?????文件??????73289??2014-01-06?22:30??課設\數據流圖.vsdx

?????文件??????77185??2014-01-08?00:16??課設\數據流圖（改）.vsdx

?????文件??????88210??2014-01-06?14:22??課設\結構圖.vsdx

?????文件??????11347??2014-01-07?18:41??課設\編程\abc\abc.csproj

????..A..H.??????8704??2014-01-07?18:49??課設\編程\abc\abc.v11.suo

?????文件????????187??2014-01-07?18:41??課設\編程\abc\App.config

?????文件??????38912??2014-01-07?18:41??課設\編程\abc\bin\Debug\abc.exe

?????文件????????187??2014-01-07?18:41??課設\編程\abc\bin\Debug\abc.exe.config

?????文件?????112128??2014-01-07?18:41??課設\編程\abc\bin\Debug\abc.pdb

?????文件??????22984??2014-01-08?00:13??課設\編程\abc\bin\Debug\abc.vshost.exe

?????文件????????187??2014-01-07?18:41??課設\編程\abc\bin\Debug\abc.vshost.exe.config

?????文件????????490??2010-03-17?22:39??課設\編程\abc\bin\Debug\abc.vshost.exe.manifest

?????文件???????2419??2014-01-07?18:41??課設\編程\abc\DBHelper.cs

?????文件???????2418??2014-01-07?18:41??課設\編程\abc\Form1.cs

?????文件???????5691??2014-01-07?18:41??課設\編程\abc\Form1.Designer.cs

?????文件???????5817??2014-01-07?18:41??課設\編程\abc\Form1.resx

?????文件???????2072??2014-01-08?00:13??課設\編程\abc\obj\Debug\abc.csproj.FileListAbsolute.txt

?????文件???????1870??2014-01-07?18:41??課設\編程\abc\obj\Debug\abc.csproj.GenerateResource.Cache

?????文件???????2209??2014-01-07?18:41??課設\編程\abc\obj\Debug\abc.csprojResolveAssemblyReference.cache

?????文件??????38912??2014-01-07?18:41??課設\編程\abc\obj\Debug\abc.exe

?????文件?????112128??2014-01-07?18:41??課設\編程\abc\obj\Debug\abc.pdb

?????文件????????180??2014-01-07?18:41??課設\編程\abc\obj\Debug\abc.Properties.Resources.resources

............此處省略397個文件信息