using?System;
using?System.Collections;
using?System.Collections.Generic;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.Common;
using?System.Data.OleDb;
using?System.Data.SqlClient;
using?System.Reflection;
using?System.IO;
using?System.ComponentModel;
using?ADOX;//該命名空間包含創建ACCESS的類（方法）
using?JRO;//該命名空間包含壓縮ACCESS的類（方法）
using?System.Data;//1引入操作Access數據庫名稱空間
using?System.Configuration;//2引入讀取配置文件的名稱空間
using?System.xml;
using?System.Web;
using?System.Security.Cryptography;


namespace?KeyboardPiano
{
????#region?DBAccess?數據操作和常用函數
????public?class?DBAccess
????{
????????private?string?connectionString?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?Application.StartupPath.ToString（）?+?“\\sheetMusic.dat“;

????????private?DbConnection?dbConn;
????????private?OleDbFactory?dbFactory;

????????public?DBAccess（）
????????{
????????????dbFactory?=?OleDbFactory.Instance;
????????????dbConn?=?dbFactory.CreateConnection（）;
????????}

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

????????///?檢查數據庫連接是否打開
????????///?

????????public?void?CheckConnection（）
????????{

????????????if?（dbConn.State?==?System.Data.ConnectionState.Closed）
????????????{
????????????????try
????????????????{
????????????????????dbConn.ConnectionString?=?connectionString;
????????????????????dbConn.Open（）;
????????????????}
????????????????catch?（ArgumentException?e）
????????????????{
????????????????????const?string?sConnectionerror?=?“數據連接失敗?！?
????????????????????ShowErrorMsg（sConnectionerror?+?e.Message）;
????????????????}
????????????}
????????}

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

????????///?取得數據庫連接
????????///?

????????public?DbConnection?Connection
????????{
????????????get
????????????{
????????????????CheckConnection（）;
????????????????return?dbConn;
????????????}
????????}

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

????????///?創建Command
????????///?

????????///?SQL語法
????????///?
????????public?DbCommand?DBCommand（string?sqlString）
????????{
????????????DbCommand?cmd?=?dbFactory.CreateCommand（）;
????????????cmd.CommandText?=?sqlString;
????????????cmd.Connection?=?Connection;
????????????return?cmd;
????????}

????????public?OleDbFactory?DBFactory
????????{
????????????get
????????????{
????????????????return?dbFactory;
????????????}
????????}
????????///?

????????///?創建DataAdapter
????????///?

????????///?SQL語法
????????///?
????????public?DbDataAdapter?DBDataAdapter（string?sqlString）
????????{
????????????DbDataAdapter?dr?=?dbFactory.CreateDataAdapter（）;
????????????dr.SelectCommand?=?DBCommand（sqlString）;
????????????return?dr;
????????}

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

????????///?通過語法，取得數值，返回是值的數組
????????///?

????????///?SQL語法
????????///?
????????public?object[]?DBSelectValue（string?sqlString）
?????

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

?????文件???????4286??2011-03-07?16:17??KeyboardPiano\1312160.ico

?????文件??????28672??2011-02-25?15:18??KeyboardPiano\bin\Debug\AxInterop.ShockwaveFlashobjects.dll

?????文件??????16021??2006-03-22?12:25??KeyboardPiano\bin\Debug\DiamondBlue.ssk

?????文件??????16669??2006-03-22?12:26??KeyboardPiano\bin\Debug\DiamondGreen.ssk

?????文件??????36864??2011-02-24?09:40??KeyboardPiano\bin\Debug\Interop.ADOX.dll

?????文件???????9216??2011-02-24?09:40??KeyboardPiano\bin\Debug\Interop.JRO.dll

?????文件??????32768??2011-03-07?16:17??KeyboardPiano\bin\Debug\Interop.ShockwaveFlashobjects.dll

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

?????文件????2434048??2011-02-26?10:13??KeyboardPiano\bin\Debug\Keybarod2.fla

?????文件?????325734??2011-02-26?10:18??KeyboardPiano\bin\Debug\Keybarod2.swf

?????文件?????285184??2011-03-07?16:17??KeyboardPiano\bin\Debug\KeyboardPiano.exe

?????文件?????128512??2011-03-07?16:17??KeyboardPiano\bin\Debug\KeyboardPiano.pdb

?????文件???????2560??2011-02-26?13:53??KeyboardPiano\bin\Debug\KeyboardPiano.suo

?????文件??????14328??2011-03-07?16:17??KeyboardPiano\bin\Debug\KeyboardPiano.vshost.exe

?????文件????????490??2007-07-21?01:33??KeyboardPiano\bin\Debug\KeyboardPiano.vshost.exe.manifest

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

?????文件??????15899??2007-12-22?09:46??KeyboardPiano\bin\Debug\MP10.ssk

?????文件??????16292??2007-12-22?09:41??KeyboardPiano\bin\Debug\MSN.ssk

?????文件???????9218??2006-03-22?06:14??KeyboardPiano\bin\Debug\Page.ssk

?????文件????1506304??2011-02-26?09:10??KeyboardPiano\bin\Debug\piano.fla

?????文件?????151927??2011-02-26?09:07??KeyboardPiano\bin\Debug\piano.swf

?????文件??????12389??2006-03-22?05:57??KeyboardPiano\bin\Debug\RealOne.ssk

?????文件???????7680??2011-02-26?14:35??KeyboardPiano\bin\Debug\RunningWord.dll

?????文件??????24064??2011-02-26?14:35??KeyboardPiano\bin\Debug\RunningWord.pdb

?????文件?????172032??2011-02-24?16:16??KeyboardPiano\bin\Debug\sheetMusic.dat

?????文件??????13459??2006-03-22?05:58??KeyboardPiano\bin\Debug\SportsOrange.ssk

?????文件??????15928??2007-12-22?09:10??KeyboardPiano\bin\Debug\Vista2_color7.ssk

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

?????文件?????118063??2011-02-24?20:05??KeyboardPiano\DBAccessCommon.cs

?????文件???????1662??2011-02-25?15:34??KeyboardPiano\ImportPiano.cs

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