Access Helper 类似sqlhelper的好东东

Access Helper 类似sqlhelper的好东东

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;


///

/// AccessHelper 的摘要说明
///

public class AccessHelper
{
protected static OleDbConnection conn = new OleDbConnection();
protected static OleDbCommand comm = new OleDbCommand();

public AccessHelper()
{
//
// TODO: 在此处添加构造函数逻辑
//
}

///

/// 打开数据库
///

private static void openConnection()
{
if (conn.State == ConnectionState.Closed)
{
conn.ConnectionString = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["myconn"]);
comm.Connection = conn;
try
{
conn.Open();
}
catch (Exception e)
{ throw new Exception(e.Message); }

}

}
///

/// 关闭数据库
///

private static void closeConnection()
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
comm.Dispose();
}
}
///

/// 执行sql语句
///

///
public static void excuteSql(string sqlstr)
{
try
{
openConnection();
https://www.sodocs.net/doc/d73142140.html,mandType = CommandType.Text;
https://www.sodocs.net/doc/d73142140.html,mandText = sqlstr;
comm.ExecuteNonQuery();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{ closeConnection(); }
}
///

/// 返回指定sql语句的OleDbDataReader对象，使用时请注意关闭这个对象。
///

///
///
public static OleDbDataReader dataReader(string sqlstr)
{
OleDbDataReader dr = null;
try
{
openConnection();
https://www.sodocs.net/doc/d73142140.html,mandText = sqlstr;
https://www.sodocs.net/doc/d73142140.html,mandType = CommandType.Text;

dr = comm.ExecuteReader(CommandBehavior.CloseConnection);
}
catch
{
try
{
dr.Close();
closeConnection();
}
catch { }
}
return dr;
}
///

/// 返回指定sql语句的OleDbDataReader对象,使用时请注意关闭
///

///
///
public static void dataReader(string sqlstr, ref OleDbDataReader dr)
{

try
{
openConnection();
https://www.sodocs.net/doc/d73142140.html,mandText = sqlstr;
https://www.sodocs.net/doc/d73142140.html,mandType = CommandType.Text;
dr = comm.ExecuteReader(CommandBehavior.CloseConnection);
}
catch
{
try
{
if (dr != null && !dr.IsClosed)
dr.Close();
}
catch
{
}
finally
{
closeConnection();
}
}
}
///

/// 返回指定sql语句的dataset
///

///
///
public static DataSet dataSet(string sqlstr)
{
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter();
try
{
openConnection();
https://www.sodocs.net/doc/d73142140.html,mandType = CommandType.Text;
https://www.sodocs.net/doc/d73142140.html,mandText = sqlstr;
da.SelectCommand = comm;
da.Fill(ds);

}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
closeConnection();
}
return ds;
}
///

/// 返回指定sql语句的dataset
///

///
///
public static void dataSet(string sqlstr, ref DataSet ds)
{
OleDbDataAdapter da = new OleDbDataAdapter();
try
{
openConnection();
https://www.sodocs.net/doc/d73142140.html,mandType = CommandType.Text;
https://www.sodocs.net/doc/d73142140.html,mandText = sqlstr;
da.SelectCommand = comm;
da.Fill(ds);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
closeConnection();
}
}
///

/// 返回指定sql语句的datatable
///

///
///
public static DataTable dataTable(string sqlstr)
{
DataTable dt = new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter();
try
{
openConnection();
https://www.sodocs.net/doc/d73142140.html,mandType = CommandType.Text;
https://www.sodocs.net/doc/d73142140.html,mandText = sqlstr;
da.SelectCommand = comm;
da.Fill(dt);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
closeConnection();
}
return dt;
}
///

/// 返回指定sql语句的datatable
///

///
///
public static void dataTable(string sqlstr, ref DataTable dt)
{
OleDbDataAdapter da = new OleDbDataAdapter();
try
{
openConnection();
https://www.sodocs.net/doc/d73142140.html,ma

ndType = CommandType.Text;
https://www.sodocs.net/doc/d73142140.html,mandText = sqlstr;
da.SelectCommand = comm;
da.Fill(dt);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
closeConnection();
}
}
///

/// 返回指定sql语句的dataview
///

///
///
public static DataView dataView(string sqlstr)
{
OleDbDataAdapter da = new OleDbDataAdapter();
DataView dv = new DataView();
DataSet ds = new DataSet();
try
{
openConnection();
https://www.sodocs.net/doc/d73142140.html,mandType = CommandType.Text;
https://www.sodocs.net/doc/d73142140.html,mandText = sqlstr;
da.SelectCommand = comm;
da.Fill(ds);
dv = ds.Tables[0].DefaultView;
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
closeConnection();
}
return dv;
}
}