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

namespace?MyKTV
{
????class?DBHelper
????{

//@“Data?Source=.;Initial?Catalog=GoodsManager;Integrated?Security=True“
????????string?connString?=?@“Data?Source=.;Initial?Catalog=MyKTV;Integrated?Security=True“;
????????private?SqlConnection?conn;

????????//創建Connection對象
????????public?SqlConnection?Conn
????????{
????????????get
????????????{
????????????????if?（conn?==?null）
????????????????{
????????????????????conn?=?new?SqlConnection（connString）;
????????????????}
????????????????return?conn;
????????????}
????????????set?{?conn?=?value;?}
????????}

????????//打開連接
????????public?void?OpenConnection（）
????????{
????????????if?（Conn.State?==?ConnectionState.Closed）
????????????{
????????????????Conn.Open（）;
????????????}
????????????else?if?（Conn.State?==?ConnectionState.Broken）
????????????{
????????????????Conn.Close（）;
????????????????Conn.Open（）;
????????????}
????????}

????????//關閉連接
????????public?void?CloseConnection（）
????????{
????????????if?（Conn.State?==?ConnectionState.Open
????????????||?Conn.State?==?ConnectionState.Broken）
????????????{
????????????????Conn.Close（）;
????????????}
????????}

????????//執行非查詢操作
????????public?int?DbExcuteNoQuery（string?sql）
????????{
????????????try
????????????{
????????????????OpenConnection（）;
????????????????SqlCommand?cmd?=?new?SqlCommand（sqlConn）;
????????????????return?cmd.ExecuteNonQuery（）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????Console.WriteLine（ex.Message）;
????????????????return?-1;
????????????}
????????????finally
????????????{
????????????????CloseConnection（）;
????????????}?
????????}

????????//執行查詢返回單一結果
????????public?object?DbExcuteScalar（string?sql）
????????{
????????????try
????????????{
????????????????OpenConnection（）;
????????????????SqlCommand?cmd?=?new?SqlCommand（sqlConn）;
????????????????return?cmd.ExecuteScalar（）;
?????????????}
????????????catch?（Exception?ex）
????????????{
????????????????Console.WriteLine（ex.Message）;
?		return?null;
????????????}
????????????finally
????????????{
????????????????CloseConnection（）;
????????????}????
????????}
????????
????????//執行查詢（此連接未關閉請務必用完后手動關閉）
????????public?SqlDataReader?DBSearch（string?sql）
????????{
????????????SqlDataReader?reader?=?null;
????????????try
????????????{
????????????????OpenConnection（）;
????????????????SqlCommand?cmd?=?new?SqlCommand（sql?Conn）;
????????????????reader?=?cmd.ExecuteReader（）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????Console.WriteLine（ex.Message）;
????????????}
????????????return?reader;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-08-09?21:09??后臺最終版\
?????目錄???????????0??2011-11-25?09:47??后臺最終版\KTVDatabase\
?????文件?????7340032??2014-11-19?13:00??后臺最終版\KTVDatabase\MyKTV.mdf
?????文件?????1048576??2014-11-19?13:00??后臺最終版\KTVDatabase\MyKTV_log.ldf
?????目錄???????????0??2014-11-18?18:10??后臺最終版\MyKTV\
?????文件?????????984??2014-11-10?21:39??后臺最終版\MyKTV.sln
?????文件???????67584??2014-11-18?17:33??后臺最終版\MyKTV.v11.suo
?????文件???????25600??2014-11-11?16:08??后臺最終版\MyKTV.v12.suo
?????文件?????????187??2014-11-10?21:39??后臺最終版\MyKTV\App.config
?????目錄???????????0??2014-11-18?18:10??后臺最終版\MyKTV\bin\
?????目錄???????????0??2014-11-18?18:10??后臺最終版\MyKTV\bin\Debug\
?????文件???????22714??2014-11-16?16:23??后臺最終版\MyKTV\bin\Debug\$this.BackgroundImage.jpg
?????文件???????93174??2014-11-16?16:14??后臺最終版\MyKTV\bin\Debug\$this.Icon.ico
?????文件???????11776??2014-11-11?14:51??后臺最終版\MyKTV\bin\Debug\AxInterop.APlayer3Lib.dll
?????文件???????17408??2014-11-11?20:16??后臺最終版\MyKTV\bin\Debug\AxInterop.MSVidCtlLib.dll
?????文件???????53760??2014-11-11?20:16??后臺最終版\MyKTV\bin\Debug\AxInterop.WMPLib.dll
?????文件???????13824??2014-11-18?16:58??后臺最終版\MyKTV\bin\Debug\Interop.APlayer3Lib.dll
?????文件??????322560??2014-11-18?16:58??后臺最終版\MyKTV\bin\Debug\Interop.MSVidCtlLib.dll
?????文件??????331264??2014-11-18?16:58??后臺最終版\MyKTV\bin\Debug\Interop.WMPLib.dll
?????文件?????1519616??2014-11-18?17:32??后臺最終版\MyKTV\bin\Debug\MyKTV.exe
?????文件?????????187??2014-11-10?21:39??后臺最終版\MyKTV\bin\Debug\MyKTV.exe.config
?????文件??????181760??2014-11-18?17:31??后臺最終版\MyKTV\bin\Debug\MyKTV.pdb
?????文件???????22984??2014-11-18?17:33??后臺最終版\MyKTV\bin\Debug\MyKTV.vshost.exe
?????文件?????????187??2014-11-10?21:39??后臺最終版\MyKTV\bin\Debug\MyKTV.vshost.exe.config
?????文件?????????490??2012-06-06?02:06??后臺最終版\MyKTV\bin\Debug\MyKTV.vshost.exe.manifest
?????目錄???????????0??2014-11-10?22:43??后臺最終版\MyKTV\bin\Release\
?????文件????????2928??2014-11-11?16:10??后臺最終版\MyKTV\DBHelper.cs
?????文件?????????392??2014-11-16?16:42??后臺最終版\MyKTV\frmAbout.cs
?????文件????????6158??2014-11-16?16:42??后臺最終版\MyKTV\frmAbout.Designer.cs
?????文件??????180122??2014-11-16?16:42??后臺最終版\MyKTV\frmAbout.resx
?????文件????????5395??2014-11-16?16:17??后臺最終版\MyKTV\FrmAddSinger.cs
............此處省略76個文件信息