connection.cs

《Visual Basic案例开发》一书的源代码

using System;
using System.Configuration;

namespace _36Hang.Data
{
	/// <summary>
	/// Connection 的摘要说明。
	/// </summary>
	public class Connection
	{	
		private string _Server;
		private string _Database;
		private string _Username;
		private string _Password;

		public Connection(string Server,string Database,string Username,string Password)
		{
			_Server = Server;
			_Database = Database;
			_Username = Username;
			_Password = Password;
		}

		/// <summary>
		/// 执行数据库查询
		/// </summary>
		/// <param name="Sql">数据库查询语句</param>
		public void Execute(string Sql)
		{
			try
			{
				SqlClient.Connection objConnection = new SqlClient.Connection(_Server,_Database,_Username,_Password);
				objConnection.Execute(Sql);
			}
			catch(Exception e)
			{
				throw(e);
			}
		}

		/// <summary>
		/// 获得数据库查询结果
		/// 用于获得全部查询结果
		/// </summary>
		/// <param name="Sql">数据库查询语句</param>
		/// <returns>数据库查询结果</returns>
		public string Records(string Sql)
		{
			try
			{
				SqlClient.Connection objConnection = new SqlClient.Connection(_Server,_Database,_Username,_Password);
				return objConnection.Records(Sql);
			}
			catch(Exception e)
			{
				throw(e);
			}
		}

		/// <summary>
		/// 获得数据库查询结果
		/// 用于获取由 Page、Length 参数指定条件的查询结果
		/// </summary>
		/// <param name="Sql">数据库查询语句</param>
		/// <param name="Page">数据库查询结果的页数</param>
		/// <param name="Length">数据库查询结果的页长</param>
		/// <returns>数据库查询结果</returns>
		public string Records(string Sql,int Page,int Length)
		{
			try
			{
				SqlClient.Connection objConnection = new SqlClient.Connection(_Server,_Database,_Username,_Password);
				return objConnection.Records(Sql,Page,Length);
			}
			catch(Exception e)
			{
				throw(e);
			}
		}
	}
}