dbmanager.cs

来自「聊天系统的经」· CS 代码 · 共 87 行

using System;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;


namespace 学生信息管理
{
	/*
	 * 连接数据库的类 
	 * 
	 * 
	 */

	public class DBManagers
	{
		private String _server;
		private String _database;	
		private OleDbConnection conn;

		public DBManagers()
		{
		}

		//连接字符串的属性
		public String Server
		{
			get{return this._server;}
			set{this._server = value;}
		}

		public String Database
		{
			get{return this._database;}
			set{this._database = value;}
		}

		

		public OleDbConnection Conn
		{
			get{return this.conn;}
			set{this.conn = value;}
		}

		//创建连接
		public void createConn()
		{
			String strconn = string.Empty;

			strconn += "Provider="+this._server+";";
			strconn += "Data Source="+this._database;
			
			conn =  new OleDbConnection();
			conn.ConnectionString = strconn;
		}

		//打开连接
		public void openConn()
		{
			try
			{
				if(conn.State != ConnectionState.Open)
				{
					this.conn.Open();
				}
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
				Console.WriteLine(ex);
			}
			
		}

		//关闭连接
		public void closeConn()
		{
			if(conn.State != ConnectionState.Closed )
			{
				this.conn.Close();
			}
		}

	}
}