connectionbuilder.cs

来自「c#开发宝典 光盘内容。本光盘主要为书中的源程序」· CS 代码 · 共 36 行

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

namespace StudentsMIS.DataAccess
{
	/// <summary>
	/// ConnectionBuilder 实现数据库连接。
	/// </summary>
	public class ConnectionBuilder
	{
		public static string connectionString = "";
    
    public static OleDbConnection BuildOleDbConnection()
    {
      if(connectionString == "")
      {
        connectionString = BuildSqlString();
      }
      OleDbConnection conn = new OleDbConnection(connectionString);
      conn.Open();
      return conn;
    }

    public static string BuildSqlString()
    {
      StringBuilder connectionString = new StringBuilder(@"Provider=Microsoft.Jet.OLEDB.4.0;");
      connectionString.Append(@"Data Source=").Append(System.Configuration.ConfigurationSettings.AppSettings["db.path"]).Append(";");
      connectionString.Append("Persist Security Info = False;");
      return connectionString.ToString();
    }

    public static string dbPath = "";
	}
}