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

????namespace?DBbase
????{
????????public?class?DBHelper
????????{
????????????private?static?DBHelper?theInstance?=?new?DBHelper（）;
????????????private?string?strConn?=?null;
????????????public?DBHelper（）
????????????{
????????????????//
????????????????//?TODO:?在此處添加構(gòu)造函數(shù)邏輯
????????????????//
????????????????strConn?=?ConfigurationSettings.AppSettings[“baseConnection“].ToString（）;
????????????}

????????????public?static?OleDbConnection?GetNewConn（）
????????????{
????????????OleDbConnection?myConn?=?new?OleDbConnection（theInstance.strConn）;
????????????????myConn.Open（）;
????????????????return?myConn;
????????????}

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

????????????///?無需返回的SQL執(zhí)行
????????????///?

????????????///?
????????????public?static?int?NonQuery（string?SQLCommand）
????????????{
????????????????using?（OleDbConnection?myConn?=?GetNewConn（））
????????????????{
????????????????OleDbCommand?_sqlCommand?=?new?OleDbCommand（SQLCommand?myConn）;
????????????????????return?_sqlCommand.ExecuteNonQuery（）;
????????????????}

????????????}

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

????????????///?返回記錄集的SQL執(zhí)行
????????????///?

????????????///?
????????????///?
????????????public?static?DataTable?QurySql（string?SQLCommand）
????????????{

????????????????using?（OleDbConnection?myConn?=?GetNewConn（））
????????????????{

????????????????OleDbCommand?_sqlCommand?=?new?OleDbCommand（SQLCommand?myConn）;
?????????????????????OleDbDataAdapter?_sqlDataAdapter?=?new?OleDbDataAdapter（_sqlCommand）;

????????????????????DataTable?_dt?=?new?DataTable（“returnTable“）;
????????????????????_sqlDataAdapter.Fill（_dt）;

????????????????????return?_dt;
????????????????}

????????????}
????????????///?

????????????///?執(zhí)行SQL返回DataSet
????????????///?

????????????///?
????????????///?
????????????public?static?DataSet?QurySqlToDS（string?SQLCommand）
????????????{
????????????????using?（OleDbConnection?myConn?=?GetNewConn（））
????????????????{
????????????????OleDbCommand?_sqlCommand?=?new?OleDbCommand（SQLCommand?myConn）;
????????????????OleDbDataAdapter?_sqlDataAdapter?=?new?OleDbDataAdapter（_sqlCommand）;

????????????????????DataSet?_ds?=?new?DataSet（“returnDataSet“）;
????????????????????_sqlDataAdapter.Fill（_ds）;

????????????????????return?_ds;
????????????????}
????????????}
????????????///?

????????????///?返回第一行的一列的值
????????????///?

????????????///?
????????????///?
????????????public?static?object?SalarQury（string?SQLCommand）
????????????{

????????????????using?（OleDbConnection?myConn?=?GetNewConn（））
???????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-04-21?14:42??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\
?????目錄???????????0??2017-04-21?11:19??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\
?????目錄???????????0??2017-04-21?11:19??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\.vs\
?????目錄???????????0??2017-04-21?11:19??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\.vs\Studentm\
?????目錄???????????0??2017-04-21?11:19??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\.vs\Studentm\v14\
?????文件???????52736??2018-12-25?09:31??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\.vs\Studentm\v14\.suo
?????目錄???????????0??2017-04-21?14:41??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\
?????文件?????????991??2017-04-21?11:19??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm.sln
?????文件?????????389??2017-04-21?12:49??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\App.config
?????目錄???????????0??2017-04-21?11:37??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\bin\
?????目錄???????????0??2017-04-21?14:27??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\bin\Debug\
?????文件???????22016??2017-04-21?14:41??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\bin\Debug\Studentm.exe
?????文件?????????389??2017-04-21?12:49??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\bin\Debug\Studentm.exe.config
?????文件???????58880??2017-04-21?14:41??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\bin\Debug\Studentm.pdb
?????文件???????22696??2018-12-25?08:52??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\bin\Debug\Studentm.vshost.exe
?????文件?????????389??2017-04-21?12:49??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\bin\Debug\Studentm.vshost.exe.config
?????文件?????????490??2017-03-19?05:00??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\bin\Debug\Studentm.vshost.exe.manifest
?????目錄???????????0??2017-04-21?11:37??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\bin\Release\
?????目錄???????????0??2017-04-21?14:40??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\BLL\
?????文件?????????631??2017-04-21?14:40??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\BLL\StudentBLL.cs
?????文件?????????381??2017-04-21?12:15??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\BLL\UserBLL.cs
?????目錄???????????0??2017-04-21?14:40??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\DAL\
?????文件????????1537??2017-04-21?14:40??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\DAL\StudentDAL.cs
?????文件?????????676??2017-04-21?13:16??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\DAL\UserDAL.cs
?????目錄???????????0??2017-04-21?14:41??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\data\
?????文件??????430080??2017-04-21?14:40??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\data\Student.accdb
?????文件???????14266??2017-04-21?11:40??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\DBHelper.cs
?????文件????????4883??2017-04-21?14:41??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\frmMain.cs
?????文件???????14226??2017-04-21?14:41??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\frmMain.Designer.cs
?????文件????????5817??2017-04-21?14:41??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\frmMain.resx
?????文件????????1128??2017-04-21?14:13??C#?學生管理系統(tǒng)?鏈接Access數(shù)據(jù)庫\Studentm\Studentm\Login.cs
............此處省略29個文件信息