oledbconn.cs

网上书店系统由两部分组成:购书网站和订单处理中心。其中购书网站是一个Web应用程序, 用户可以通过Web浏览器登录到此网站.在此网站

using System;
using System.Data.OleDb;
using System.Data;

namespace Bookshop
{
	/// <summary>
	/// OleDbConn 的摘要说明。
	/// </summary>
	public class OleDbConn
	{
		private static OleDbConnection conn;
		public OleDbConn()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//

		}	
		private static bool InitConn()
		{
			if( conn == null || conn.State != ConnectionState.Open )
			{
				string connectString = System.Configuration.ConfigurationSettings.AppSettings["connString"];
				conn = new OleDbConnection( connectString );
				conn.Open();
				return true;
			}
			return false;
		}
		public static OleDbDataReader ExecuteReader( string commandString )
		{
			InitConn();
			OleDbCommand temp= new OleDbCommand( commandString, conn );
			OleDbDataReader tempReader = temp.ExecuteReader();
			return tempReader;
		}
		public static DataSet ExecuteDataSet( string commandString )
		{
			InitConn();
			OleDbDataAdapter tempAdapter = new OleDbDataAdapter( commandString, conn );
			DataSet tempSet = new DataSet();
			tempAdapter.Fill(tempSet);
			return tempSet;
		}
		public static int ExecuteNonQuery( string commandString )
		{
			InitConn();
			OleDbCommand temp= new OleDbCommand( commandString, conn );
			return temp.ExecuteNonQuery();
		}
		public static bool CloseConn()
		{
			if( conn != null )
			{
				if( conn.State == ConnectionState.Open )
				{
					conn.Close();
					return true;
				}
				else
				{
					return true;
				}
			}
			else
			{
				return false;
			}
		}
	}
}