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

namespace?DatabaseLib
{
public?class?DatabaseAccess
{
????#region?屬性
????public?static?readonly?DatabaseAccess?Instance?=?new?DatabaseAccess（）;
	private?DatabaseAccess（）
	{
		CreateConnection（）;
	}
	private?SqlConnection?conPartyManage?;
	private?SqlDataAdapter?dadPartyManage;
	private?SqlCommand?cmdPartyManage;
????private?DataSet?dstPartyManage;
????#endregion
????#region?方法

????///?

		///?創建一個數據庫連接
		///?

		private?void?CreateConnection（）
		{
????????????conPartyManage?=?new?SqlConnection（“Server=localhost;uid=sa;database=Mis_Course;Min?Pool?Size=1;“）;//連接字符串
		}

		///?

		///?從連接池中獲取一個數據庫連接
		///?

		private?bool?OpenConnection（）
		{
????????????try
????????????{
????????????????conPartyManage.Open（）;
????????????????return?true;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????return?false;
????????????}
		}

		///?

		///?釋放一個數據庫連接
		///?

		private?void?CloseConnection（）
		{
			conPartyManage.Close（）;
		}



		///?

		///?執行指定sql語句，以DataSet形式返回執行結果
		///?

		///?SQL語句
		///?DataSet中的表名
		///?存放執行結果的DataSet
		public?DataSet?GetDataSet（string?Sqlstring?TableName）
		{????????????????
????????????dadPartyManage?=?new?SqlDataAdapter（Sql?conPartyManage）;
????????????dstPartyManage?=?new?DataSet（）;
????????????try
????????????{
????????????????dadPartyManage.Fill（dstPartyManage?TableName）;
????????????????return?dstPartyManage;
????????????}
????????????catch（Exception?ex）
????????????{
????????????????return?dstPartyManage;
????????????}

		}

		///?

		///?執行指定沒有返回結果的SQL語句，并返回影響的記錄數
		///?

		///?要執行的Sql語句
		///?SQL語句執行后影響的記錄條數
		public?int?ExecSql（string?Sql）
		{???int?i;
			cmdPartyManage=new?SqlCommand（）;
			cmdPartyManage.Connection=conPartyManage;
			cmdPartyManage.CommandText=Sql;
????????????if?（OpenConnection（））
????????????{
????????????????try
????????????????{
????????????????????i?=?cmdPartyManage.ExecuteNonQuery（）;
????????????????????CloseConnection（）;
????????????????????return?i;
????????????????}
????????????????catch?（Exception?ex）
????????????????{
????????????????????return?-1;
????????????????}
????????????}
????????????else
????????????????return?-1;
		}
	
			
		///?

		///?通過該方法可以執行指定sql語句，并返回數據表
		///?

		///?SQL語句
		///?表名
		///?數據表
		public?DataTable?GetDataTable（string?Sql）
		{
			dadPartyManage=new?SqlDataAdapter（SqlconPartyManage）;
			DataTable?dt=new?DataTable（）;
????????????try
????????????{
????????????????dadPartyManage.Fill

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

?????文件????1048576??2007-12-20?16:30??第11章\Database\Mis_Course_Data.MDF

?????文件????1048576??2007-12-20?16:30??第11章\Database\Mis_Course_Log.LDF

?????文件??????20480??2007-12-20?16:30??第11章\DatabaseLib\DatabaseLib\bin\Debug\DatabaseLib.dll

?????文件??????15872??2007-12-20?16:30??第11章\DatabaseLib\DatabaseLib\bin\Debug\DatabaseLib.pdb

?????文件???????8417??2007-12-20?16:30??第11章\DatabaseLib\DatabaseLib\DatabaseDll.cs

?????文件???????1964??2007-12-20?16:30??第11章\DatabaseLib\DatabaseLib\DatabaseLib.csproj

?????文件????????150??2007-12-20?16:30??第11章\DatabaseLib\DatabaseLib\obj\DatabaseLib.csproj.FileList.txt

?????文件??????20480??2007-12-20?16:30??第11章\DatabaseLib\DatabaseLib\obj\Debug\DatabaseLib.dll

?????文件??????15872??2007-12-20?16:30??第11章\DatabaseLib\DatabaseLib\obj\Debug\DatabaseLib.pdb

?????文件???????1325??2007-12-20?16:30??第11章\DatabaseLib\DatabaseLib\Properties\AssemblyInfo.cs

?????文件????????922??2007-12-20?16:30??第11章\DatabaseLib\DatabaseLib.sln

?????文件??????11776??2007-12-20?16:30??第11章\DatabaseLib\DatabaseLib.suo

?????文件????????402??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\app.config

?????文件??????20480??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\bin\Debug\DatabaseLib.dll

?????文件??????15872??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\bin\Debug\DatabaseLib.pdb

?????文件??????49152??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\bin\Debug\Mis_CourseTeach.exe

?????文件??????62976??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\bin\Debug\Mis_CourseTeach.pdb

?????文件???????5632??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\bin\Debug\Mis_CourseTeach.vshost.exe

?????文件???????1701??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\Classes\CoursesTeaching.cs

?????文件????????188??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\Classes\Role.cs

?????文件???????4821??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\Classes\Student.cs

?????文件???????3414??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\Classes\Teacher.cs

?????文件???????1116??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\Classes\Term.cs

?????文件???????1981??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\frmLogin.cs

?????文件???????7422??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\frmLogin.Designer.cs

?????文件???????5814??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\frmLogin.resx

?????文件???????1261??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\frmMain.cs

?????文件???????7405??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\frmMain.Designer.cs

?????文件??????24114??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\frmMain.resx

?????文件??????45455??2007-12-20?16:30??第11章\Mis_CourseTeach\Mis_CourseTeach\Mis_CourseDataSet.Designer.cs

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