using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.OleDb;using System.Data;using System.Configuration;
public class AccessDB { private static string connString;
public static string ConnString { get { return AccessDB.connString; } set { AccessDB.connString = value; } } private static OleDbConnection conn; private string commandText;
public string CommandText { get { return commandText; } set { commandText = value; } }
public AccessDB() { connString = ConfigurationManager.ConnectionStrings["AccessConnString"].ToString();
string[] tempConnStrings = connString.Split('#'); tempConnStrings[1] = AppDomain.CurrentDomain.BaseDirectory + tempConnStrings[1]; connString = tempConnStrings[0] + tempConnStrings[1] + tempConnStrings[2]; //connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Windows.Forms.Application.StartupPath + @"\Kangzhi.Sedu.Material.dll;User Id=admin;Password=;"; } /// <summary> /// 得到数据库连接 /// </summary> /// <returns></returns> public static OleDbConnection GetConnection() { conn = new OleDbConnection(ConnString); try { conn.Open(); } catch (Exception e) { Console.WriteLine(e.StackTrace); } return conn; } /// <summary> /// 得到命令对象 /// </summary> /// <returns></returns> public OleDbCommand GetOleDbCommmand() { OleDbConnection conn = AccessDB.GetConnection(); OleDbCommand cmd = new OleDbCommand(commandText, conn); return cmd; } /// <summary> /// 得到数据读取器 /// </summary> /// <returns></returns> public OleDbDataReader GetOleDbDataReader() { OleDbCommand cmd = this.GetOleDbCommmand(); OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); return dr; } /// <summary> /// 关闭连接 /// </summary> public void CloseConnection() { conn.Close(); } }
posted on 2009-11-23 11:20 彬子 阅读( ...) 评论( ...) 编辑 收藏转载于:https://www.cnblogs.com/wangzb/archive/2009/11/23/1608561.html
