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

namespace?MyTicketSystem
{
????public?class?DBHelper
????{
????????//連接字符串
????????private?string?connstring?=?“Data?Source=.;Initial?Catalog=MyTicket;User?ID=sa;Pwd=123456“;
??????//數據庫連接對象
????????private?SqlConnection?connction;
????????public?SqlConnection?Connction
????????{
????????????get?{
????????????????if?（connction==null）
????????????????{
????????????????????connction?=?new?SqlConnection（connstring）;
????????????????}
????????????????return?connction;
????????????}
????????}
????????//打開數據庫
????????public?void?OpenConnection（）
????????{
????????????if?（connction.State==ConnectionState.Closed）
????????????{
????????????????Connction.Open（）;
????????????}
????????????else?if（connction.State==ConnectionState.Broken）
????????????{
????????????????Connction.Close（）;
????????????????Connction.Open（）;
????????????}
????????}
????????//關閉數據庫
????????public?void?CloseConnection（）
????????{
????????????if?（connction.State==ConnectionState.Open||（connction.State==ConnectionState.Broken））
????????????{
????????????????Connction.Close（）;
????????????}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????3940??2017-12-25?15:05??航班查詢預訂系統\hangban.sql
?????文件?????4259840??2017-12-25?15:08??航班查詢預訂系統\MyTicket_data.mdf
?????文件?????1048576??2017-12-25?15:08??航班查詢預訂系統\MyTicket_log.ldf
?????目錄???????????0??2017-12-25?15:07??航班查詢預訂系統\MyTicketSystem\
?????文件?????????932??2017-12-20?15:20??航班查詢預訂系統\MyTicketSystem\MyTicketSystem.sln
?????文件???????42496??2017-12-25?15:06??航班查詢預訂系統\MyTicketSystem\MyTicketSystem.v11.suo
?????目錄???????????0??2017-12-25?15:07??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\
?????文件?????????187??2017-12-20?15:20??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\App.config
?????目錄???????????0??2017-12-25?15:07??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\bin\
?????目錄???????????0??2017-12-25?15:07??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\bin\Debug\
?????文件???????19456??2017-12-25?15:03??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\bin\Debug\MyTicketSystem.exe
?????文件?????????187??2017-12-20?15:20??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\bin\Debug\MyTicketSystem.exe.config
?????文件???????32256??2017-12-25?15:03??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\bin\Debug\MyTicketSystem.pdb
?????文件???????22984??2017-12-25?15:06??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\bin\Debug\MyTicketSystem.vshost.exe
?????文件?????????187??2017-12-20?15:20??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\bin\Debug\MyTicketSystem.vshost.exe.config
?????文件?????????490??2016-07-16?19:44??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\bin\Debug\MyTicketSystem.vshost.exe.manifest
?????文件????????1347??2017-12-21?09:42??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\DBHelper.cs
?????文件????????6552??2017-12-25?15:04??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\Form1.cs
?????文件???????20654??2017-12-25?14:32??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\Form1.Designer.cs
?????文件????????7663??2017-12-25?14:32??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\Form1.resx
?????文件????????3846??2017-12-20?17:42??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\MyTicketSystem.csproj
?????目錄???????????0??2017-12-25?15:07??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\obj\
?????目錄???????????0??2017-12-25?15:07??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\obj\Debug\
?????文件????????1308??2017-12-21?09:16??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\obj\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件????????7047??2017-12-20?16:52??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件?????????800??2017-12-25?15:06??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\obj\Debug\MyTicketSystem.csproj.FileListAbsolute.txt
?????文件?????????975??2017-12-25?15:03??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\obj\Debug\MyTicketSystem.csproj.GenerateResource.Cache
?????文件???????19456??2017-12-25?15:03??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\obj\Debug\MyTicketSystem.exe
?????文件?????????180??2017-12-25?15:03??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\obj\Debug\MyTicketSystem.Form1.resources
?????文件???????32256??2017-12-25?15:03??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\obj\Debug\MyTicketSystem.pdb
?????文件?????????180??2017-12-25?15:03??航班查詢預訂系統\MyTicketSystem\MyTicketSystem\obj\Debug\MyTicketSystem.Properties.Resources.resources
............此處省略11個文件信息