using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data.SqlClient;
using?System.Data;
namespace?青鳥網(wǎng)吧管理系統(tǒng)
{
?????????///?

????????///?此類維護(hù)數(shù)據(jù)庫連接字符串，和?Connection?對象
????????///?

????????public?class?DBHelper
????????{
????????????//?數(shù)據(jù)庫連接字符串
????????????private?string?connString?=?@“Data?Source=.;Initial?Catalog=db_QinNiaoBar;Integrated?Security=true“;

????????????//?數(shù)據(jù)庫連接?Connection?對象
????????????private?SqlConnection?connection;

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

????????????///?Connection對象
????????????///?

????????????public?SqlConnection?Connection
????????????{
????????????????get
????????????????{
????????????????????if?（connection?==?null）
????????????????????{
????????????????????????connection?=?new?SqlConnection（connString）;
????????????????????}
????????????????????return?connection;
????????????????}
????????????}

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

????????????///?打開數(shù)據(jù)庫連接
????????????///?

????????????public?void?OpenConnection（）
????????????{
????????????????if?（Connection.State?==?ConnectionState.Closed）
????????????????{
????????????????????Connection.Open（）;
????????????????}
????????????????else?if?（Connection.State?==?ConnectionState.Broken）
????????????????{
????????????????????Connection.Close（）;
????????????????????Connection.Open（）;
????????????????}
????????????}

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

????????????///?關(guān)閉數(shù)據(jù)庫連接
????????????///?

????????????public?void?CloseConnection（）
????????????{
????????????????if?（Connection.State?==?ConnectionState.Open?||?Connection.State?==?ConnectionState.Broken）
????????????????{
????????????????????Connection.Close（）;
????????????????}
????????????}
????????}
????}

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

?????文件????????144??2012-10-25?20:29??完整版\青鳥網(wǎng)吧管理系統(tǒng)\app.config

?????文件?????516096??2009-04-03?14:37??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\IrisSkin2.dll

?????文件??????50635??2006-03-21?14:11??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\diamondblue.gif

?????文件??????16021??2006-03-22?12:25??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\DiamondBlue.ssk

?????文件??????45088??2006-03-21?14:12??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\diamondgreen.gif

?????文件??????16669??2006-03-22?12:26??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\DiamondGreen.ssk

?????文件??????12238??2008-07-26?10:45??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\MidsummerColor2.ssk

?????文件??????24639??2006-03-22?10:39??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\midsummer_color2.gif

?????文件??????48102??2006-03-21?14:18??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\mp10.gif

?????文件??????15899??2006-03-22?05:55??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\MP10.ssk

?????文件??????31443??2006-03-21?14:19??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\msn.gif

?????文件??????16292??2006-03-22?05:55??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\MSN.ssk

?????文件??????28488??2006-03-21?14:21??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\oneblue.gif

?????文件??????16262??2008-07-26?11:04??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\OneBlue.ssk

?????文件??????26443??2006-03-22?12:36??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\onecyan.gif

?????文件??????14246??2008-07-26?11:04??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\OneCyan.ssk

?????文件??????33946??2006-03-22?10:42??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\page.gif

?????文件???????9218??2006-03-22?06:14??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\Page.ssk

?????文件??????12389??2008-07-26?09:25??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\RealOne.ssk

?????文件??????22183??2006-03-22?12:40??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\sportsblack.gif

?????文件??????11351??2008-07-26?11:16??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\SportsBlack.ssk

?????文件??????29210??2008-07-26?11:20??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\SteelBlack.ssk

?????文件??????45569??2006-03-22?11:12??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\warm_color2.gif

?????文件??????52479??2006-03-22?11:20??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\wave.gif

?????文件??????47607??2006-07-13?23:30??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\Wave.ssk

?????文件??????43378??2006-03-22?06:33??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\WaveColor1.ssk

?????文件??????45510??2008-07-26?11:22??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\WaveColor2.ssk

?????文件??????48066??2006-03-22?11:30??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\wave_color1.gif

?????文件??????54854??2006-03-21?14:51??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\xpblue.gif

?????文件??????13189??2006-03-22?06:00??完整版\青鳥網(wǎng)吧管理系統(tǒng)\bin\Debug\skin\XPBlue.ssk

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