using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.OleDb;

namespace?HotelManager
{
????class?Database
????{
????????//數據庫連接字符串
????????public?static?string?ConnStr?=?@“Provider=Microsoft.Jet.OLEDB.4.0;?Data?source=password.mdb;“;
????????public?static?OleDbConnection?oleDbConnection?=?new?System.Data.OleDb.OleDbConnection（ConnStr）;

????????//數據庫操作：驗證，判斷數據庫中是否存在一條滿足SQL語句的記錄
????????public?static?string?Yanzheng（string?sql）
????????{
????????????oleDbConnection.Open（）;
????????????string?ret?=?“no“;
????????????try
????????????{
????????????????String?query?=?sql;
????????????????OleDbCommand?oleDbCommand?=?new?OleDbCommand（query?oleDbConnection）;

????????????????OleDbDataReader?reader?=?oleDbCommand.ExecuteReader（）;
????????????????if?（reader.Read（））
????????????????????ret?=?“ok“;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????ret?=?ex.Message;
????????????}
????????????finally
????????????{
????????????????oleDbConnection.Close（）;
????????????}
????????????return?ret;
????????}
????????//數據庫操作:讀取所有數據
????????public?static?DataSet?Fangtai（string?sqlstring?sql1）
????????{
????????????DataSet?ds?=?new?DataSet（）;
????????????string?ret?=?““;
????????????oleDbConnection.Open（）;
????????????try
????????????{
????????????????OleDbDataAdapter?adapter?=?new?OleDbDataAdapter（sql?ConnStr）;
????????????????adapter.Fill（ds?sql1）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????ret?=?ex.Message;
????????????}
????????????finally
????????????{
????????????????oleDbConnection.Close（）;
????????????}
????????????return?ds;
????????}
????????//數據庫操作：更新數據
????????public?static?string?zengjia（string?sqlstring?sql1string?fanghao）
????????{
????????????string?ret?=?“no“;
????????????oleDbConnection.Open（）;
????????????try
????????????{
????????????????String?query?=?“select?*?from?“?+?sql1?+?“?where?房間號=‘“?+?fanghao?+?“‘“;
????????????????OleDbCommand?oleDbCommand?=?new?OleDbCommand（query?oleDbConnection）;
????????????????OleDbDataReader?reader?=?oleDbCommand.ExecuteReader（）;
????????????????if?（reader.Read（））
????????????????{
????????????????????ret?=?“該房間已經存在，請確定房間號！“;
????????????????}
????????????????else
????????????????{
????????????????????reader.Close（）;
????????????????????query?=?sql;
????????????????????oleDbCommand?=?new?OleDbCommand（query?oleDbConnection）;
????????????????????oleDbCommand.ExecuteNonQuery（）;
????????????????????ret?=?“ok“;
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????ret?=?ex.Message;
????????????}
????????????finally
????????????{
????????????????oleDbConnection.Close（）;
????????????}
????????????
????????????return?ret;
????????}
????????//數據庫操作：刪除數據
????????public?static?string?shanchu（string?sql）
????????{
????????????string?ret?=?“no“;
????????????oleDbConnection.Open（

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

?????文件???????5032??2006-04-04?15:20??HotelManager\HotelManager\bin\Debug\DeepCyan.ssk

?????文件??????17010??2006-03-22?05:57??HotelManager\HotelManager\bin\Debug\GlassOrange.ssk

?????文件??????65536??2009-04-14?19:43??HotelManager\HotelManager\bin\Debug\HotelManager.exe

?????文件??????97792??2009-04-14?19:43??HotelManager\HotelManager\bin\Debug\HotelManager.pdb

?????文件???????5632??2005-11-11?22:25??HotelManager\HotelManager\bin\Debug\HotelManager.vshost.exe

?????文件?????516096??2006-08-18?11:50??HotelManager\HotelManager\bin\Debug\IrisSkin2.dll

?????文件??????15156??2006-03-22?05:55??HotelManager\HotelManager\bin\Debug\MacOS.ssk

?????文件??????16262??2006-03-22?12:32??HotelManager\HotelManager\bin\Debug\OneBlue.ssk

?????文件?????458752??2009-04-10?21:05??HotelManager\HotelManager\bin\Debug\Password.mdb

?????文件??????31723??2006-07-11?00:45??HotelManager\HotelManager\bin\Debug\vista1.ssk

?????文件??????15904??2006-07-18?23:12??HotelManager\HotelManager\bin\Debug\Vista2_color1.ssk

?????文件??????12600??2006-07-13?23:36??HotelManager\HotelManager\bin\Debug\XPSilver.ssk

?????文件???????5577??2009-04-07?17:05??HotelManager\HotelManager\Database.cs

?????文件???????5409??2009-04-08?09:54??HotelManager\HotelManager\HotelManager.csproj

?????文件???????1236??2009-04-14?19:43??HotelManager\HotelManager\obj\Debug\HotelManager.csproj.GenerateResource.Cache

?????文件??????65536??2009-04-14?19:43??HotelManager\HotelManager\obj\Debug\HotelManager.exe

?????文件??????97792??2009-04-14?19:43??HotelManager\HotelManager\obj\Debug\HotelManager.pdb

?????文件????????180??2009-04-07?15:47??HotelManager\HotelManager\obj\Debug\HotelManager.Properties.Resources.resources

?????文件????????180??2009-04-07?17:26??HotelManager\HotelManager\obj\Debug\HotelManager.主界面.resources

?????文件????????180??2009-04-07?15:47??HotelManager\HotelManager\obj\Debug\HotelManager.實時房態.resources

?????文件???????8228??2009-04-08?09:18??HotelManager\HotelManager\obj\Debug\HotelManager.押金管理.resources

?????文件????????180??2009-04-08?10:20??HotelManager\HotelManager\obj\Debug\HotelManager.用戶信息.resources

?????文件????????180??2009-04-14?19:43??HotelManager\HotelManager\obj\Debug\HotelManager.用戶登陸.resources

?????文件????????180??2009-04-08?09:57??HotelManager\HotelManager\obj\Debug\HotelManager.訂房登記.resources

?????文件???????5696??2009-04-08?09:18??HotelManager\HotelManager\obj\Debug\ResolveAssemblyReference.cache

?????文件???????4608??2009-04-07?13:11??HotelManager\HotelManager\obj\Debug\TempPE\Properties.Resources.Designer.cs.dll

?????文件???????2891??2009-04-14?19:44??HotelManager\HotelManager\obj\HotelManager.csproj.FileListAbsolute.txt

?????文件????????478??2009-04-07?10:00??HotelManager\HotelManager\Program.cs

?????文件???????1202??2009-04-07?09:21??HotelManager\HotelManager\Properties\AssemblyInfo.cs

?????文件???????2848??2009-04-07?13:11??HotelManager\HotelManager\Properties\Resources.Designer.cs

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