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

namespace?畢設選題系統C
{
????class?DBAccess
????{
????????#region??全局變量
????????//定義全局變量，記錄“基礎信息”各窗體中的表名及SQL語句
????????public?static?string?strSQLCmdString?=?““?strTable?=?““?strField?=?““;
????????//定義一個SqlConnection類型的公共變量My_con，用于判斷數據庫是否連接成功
????????public?static?SqlConnection?sqlConnection;
????????public?static?string?strSQLConnection?=?“server=（local）;database=畢設管理系統;uid=sa;pwd=123456“;
????????public?static?int?nLoginType?=?0;????????????//用戶登錄與重新登錄的標識
????????public?static?DBAccess?dbAccess;
????????public?static?double?Balance?=?0;//?當前余額

????????#endregion

????????#region??讀取配置文件
????????public?static?bool?LoadConfiguration（）
????????{
????????????FileStream?fileStream?=?null;
????????????StreamReader?streamReader?=?null;
????????????try
????????????{
????????????????fileStream?=?new?FileStream（“Configuration.txt“?FileMode.Open?FileAccess.Read）;
????????????????streamReader?=?new?StreamReader（fileStream）;
????????????????strSQLConnection?=?streamReader.ReadLine（）;
????????????????return?true;
????????????}
????????????catch?（Exception）
????????????{
????????????????if?（streamReader?!=?null）
????????????????{
????????????????????streamReader.Close（）;
????????????????}
????????????????MessageBox.Show（“配置文件讀取錯誤！“）;
????????????????return?false;
????????????}
????????}

????????#endregion

????????#region??建立數據庫連接
????????public?static?SqlConnection?GetConnection（）
????????{
????????????sqlConnection?=?new?SqlConnection（strSQLConnection）;????//用SqlConnection對象與指定的數據庫相連接
????????????sqlConnection.Open（）;???????????????????????????????????//打開數據庫連接
????????????return?sqlConnection;???????????????????????????????????//返回SqlConnection對象的信息
????????}
????????#endregion

????????#region??測試數據庫是否賦加
????????public?void?OpenConnection（）
????????{
????????????GetConnection（）;
????????????//CloseConnection（）;
????????}
????????#endregion

????????#region??關閉數據庫連接
????????public?void?CloseConnection（）
????????{
????????????if?（sqlConnection.State?==?ConnectionState.Open）???//判斷是否打開與數據庫的連接
????????????{
????????????????sqlConnection.Close（）;???//關閉數據庫的連接
????????????????sqlConnection.Dispose（）;???//釋放My_con變量的所有空間
????????????}
????????}
????????#endregion

????????#region??讀取指定表中的信息
????????public?SqlDataReader?GetReaderofCommand（string?SQLstr）
????????{
????????????GetConnection（）;???//打開與數據庫的連接
????????????SqlCommand?sqlCommand?=?sqlConnection.CreateCommand（）;?//創建一個SqlCommand對象，用于執行SQL語句
????????????sqlCommand.CommandText?=?SQLstr;????//獲取指定的SQL語句
????????????SqlDataReader?dataReader?=?sqlCommand.ExecuteReader（）;?//執行SQL語名句，生成一個SqlDataReader對象
????????????return?dataReader;
????????}
????????#endregion?執行帶參數的Sql語句，無返回值
????????public?void?GetSQLCommand（st

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????8983??2020-06-28?10:13??畢設選題系統?.sql
?????目錄???????????0??2020-06-24?20:02??畢設選題系統C\
?????目錄???????????0??2020-06-24?20:02??畢設選題系統C\.vs\
?????目錄???????????0??2020-06-24?20:02??畢設選題系統C\.vs\畢設選題系統C\
?????目錄???????????0??2020-06-24?20:02??畢設選題系統C\.vs\畢設選題系統C\v15\
?????文件???????61440??2020-06-25?12:02??畢設選題系統C\.vs\畢設選題系統C\v15\.suo
?????目錄???????????0??2020-06-24?20:02??畢設選題系統C\.vs\畢設選題系統C\v15\Server\
?????目錄???????????0??2020-06-24?20:02??畢設選題系統C\.vs\畢設選題系統C\v15\Server\sqlite3\
?????文件???????????0??2020-06-24?20:02??畢設選題系統C\.vs\畢設選題系統C\v15\Server\sqlite3\db.lock
?????文件??????675840??2020-06-25?11:55??畢設選題系統C\.vs\畢設選題系統C\v15\Server\sqlite3\storage.ide
?????文件???????32768??2020-06-25?08:12??畢設選題系統C\.vs\畢設選題系統C\v15\Server\sqlite3\storage.ide-shm
?????文件?????4136512??2020-06-25?12:00??畢設選題系統C\.vs\畢設選題系統C\v15\Server\sqlite3\storage.ide-wal
?????目錄???????????0??2020-06-25?12:02??畢設選題系統C\畢設選題系統C\
?????文件????????1155??2020-06-24?20:11??畢設選題系統C\畢設選題系統C.sln
?????文件?????????189??2020-06-24?20:02??畢設選題系統C\畢設選題系統C\App.config
?????目錄???????????0??2020-06-24?20:04??畢設選題系統C\畢設選題系統C\bin\
?????目錄???????????0??2020-06-24?20:11??畢設選題系統C\畢設選題系統C\bin\Debug\
?????文件??????116736??2020-06-25?12:01??畢設選題系統C\畢設選題系統C\bin\Debug\畢設選題系統C.exe
?????文件?????????189??2020-06-24?20:02??畢設選題系統C\畢設選題系統C\bin\Debug\畢設選題系統C.exe.config
?????文件??????249344??2020-06-25?12:01??畢設選題系統C\畢設選題系統C\bin\Debug\畢設選題系統C.pdb
?????目錄???????????0??2020-06-24?20:04??畢設選題系統C\畢設選題系統C\bin\Release\
?????文件????????5629??2020-06-24?20:10??畢設選題系統C\畢設選題系統C\DBAccess.cs
?????目錄???????????0??2020-06-24?20:02??畢設選題系統C\畢設選題系統C\obj\
?????目錄???????????0??2020-06-25?12:01??畢設選題系統C\畢設選題系統C\obj\Debug\
?????文件????????1443??2020-06-25?08:19??畢設選題系統C\畢設選題系統C\obj\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件????????7296??2020-06-25?11:55??畢設選題系統C\畢設選題系統C\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????????0??2020-06-24?20:02??畢設選題系統C\畢設選題系統C\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
?????文件???????????0??2020-06-24?20:02??畢設選題系統C\畢設選題系統C\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
?????文件???????????0??2020-06-24?20:02??畢設選題系統C\畢設選題系統C\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
?????目錄???????????0??2020-06-24?20:02??畢設選題系統C\畢設選題系統C\obj\Debug\TempPE\
?????文件??????????42??2020-06-25?11:55??畢設選題系統C\畢設選題系統C\obj\Debug\畢設選題系統C.csproj.CoreCompileInputs.cache
............此處省略107個文件信息