Author: Unknown
•19:28

using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;

///


/// 数据库访问类的基类
///

public class CDateOle
{
//SQL连接对象
protected OleDbConnection objConn;
//SQL命令对象
protected OleDbCommand objCmd;
//Data Reader对象
protected OleDbDataReader objReader;
protected OleDbDataAdapter myCommand;
protected DataSet ds;
public DataRow dr;
//SQL语句
protected string strSql;
//构造时初始化连接
public CDateOle()
{
//初始化类的实例
objConn = new OleDbConnection();
objCmd = new OleDbCommand();
ds= new DataSet();
//取得连接字符串
objConn.ConnectionString = " Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + HttpContext.Current.Server.MapPath("data/data.mdb");
try
{
/////////////////////////////////////////////////////////////////////////
//打开数据库联接
//objConn.Open();
//设置objCmd对象的连接属性
objCmd.Connection = objConn;
/////////////////////////////////////////////////////////////////////////
}
catch (OleDbException ex)
{
//抛出异常,数据库open失败
throw ex;
}
}
//析构函数
~CDateOle()
{
/////////////////////////////////////////////////////////////////////////////
//释放Command对象
objCmd.Dispose();
//关闭数据库连接
//objConn.Close();
//释放Connection
//objConn.Dispose();

//////////////////////////////////////////////////////////////////////////////////////////////////////

}

}
This entry was posted on 19:28 and is filed under . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

0 评论: