database.cs

来自「采用C#和SQL Server 2000开发 功能比较全面的酒店管理系统」· CS 代码 · 共 74 行

using System;
using System.Data;
using System.Data.SqlClient;
using System.ComponentModel;

namespace 酒店管理系统
{
	/// <summary>
	/// DataBase 的摘要说明。
	/// </summary>
	public class DataBase : IDisposable
	{
		// member
		private SqlConnection sqlConn;
		public static string sConn = "Persist Security Info=False;Integrated Security=SSPI;database=hotelbook;server=localhost;Connect Timeout=30";

		public void Dispose()
		{
			Dispose( true );
			GC.SuppressFinalize( true );
		}

		protected void Dispose( bool disposing )
		{
			if ( !disposing )
			{
				return;
			}
			if ( sqlConn != null )
			{
				sqlConn.Dispose();
				sqlConn = null;
			}
		}

		public void Open()
		{
			// 建立数据库连接对象
			sqlConn = new SqlConnection( sConn );
			// 打开数据库连接
			sqlConn.Open();
		}

		public void Close()
		{
			if ( sqlConn != null )
				sqlConn.Close();
		}

		public DataView RunSelectSQL( string sSQLString )
		{
			this.Open();
			DataSet SqlDS = new DataSet();
			SqlDataAdapter SqlDA = new SqlDataAdapter( sSQLString, this.sqlConn );
			SqlDA.Fill( SqlDS );
			return SqlDS.Tables[ 0 ].DefaultView;
		}

		public void RunDelOrInsSQL( string sSQLString )
		{
			this.Open();
			SqlCommand SqlComm = new SqlCommand( sSQLString, this.sqlConn );
			SqlComm.ExecuteNonQuery();
		}

		public DataBase()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
	}
}