namespace Com.LXJ.Database
{
/// <summary>
/// conn 的摘要說明。
/// </summary>
public class ConnDbForAcccess
{
/// <summary>
/// 連接數(shù)據(jù)庫字符串
/// </summary>
private string connectionString;

/// <summary>
/// 存儲數(shù)據(jù)庫連接（保護(hù)類，只有由它派生的類才能訪問）
/// </summary>
protected OleDbConnection Connection;

/// <summary>
/// 構(gòu)造函數(shù)：數(shù)據(jù)庫的默認(rèn)連接
/// </summary>
public ConnDbForAcccess()
{
string connStr;
connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString();
// connStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString(); //從web.config配置中讀取
connectionString = connStr;
//connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalapplicationPath + connStr;
// connectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString();
//
Connection = new OleDbConnection(connectionString);
}

/// <summary>
/// 構(gòu)造函數(shù)：帶有參數(shù)的數(shù)據(jù)庫連接
/// </summary>
/// <param name="newConnectionString"></param>
public ConnDbForAcccess(string newConnectionString)
{
//connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + newConnectionString;
connectionString = newConnectionString;
Connection = new OleDbConnection(connectionString);
}

/// <summary>
/// 獲得連接字符串
/// </summary>
public string ConnectionString
{
get
{
return connectionString;
}
}

/// <summary>
/// 執(zhí)行SQL語句沒有返回結(jié)果，如：執(zhí)行刪除、更新、插入等操作
/// </summary>
/// <param name="strSQL"></param>
/// <returns>操作成功標(biāo)志</returns>
public bool ExeSQL(string strSQL)
{
bool resultState = false;

Connection.Open();
OleDbTransaction myTrans = Connection.BeginTransaction();
OleDbCommand command = new OleDbCommand(strSQL, Connection, myTrans);

try
{
command.ExecuteNonQuery();
myTrans.Commit();
resultState = true;
}
catch
{
myTrans.Rollback();
resultState = false;
}
finally
{
Connection.Close();
}
return resultState;
}

/// <summary>
/// 執(zhí)行SQL語句返回結(jié)果到DataReader中
/// </summary>
/// <param name="strSQL"></param>
/// <returns>dataReader</returns>
private OleDbDataReader ReturnDataReader(string strSQL)
{
Connection.Open();
OleDbCommand command = new OleDbCommand(strSQL, Connection);
OleDbDataReader dataReader = command.ExecuteReader();
Connection.Close();

return dataReader;
}

/// <summary>
/// 執(zhí)行SQL語句返回結(jié)果到DataSet中
/// </summary>
/// <param name="strSQL"></param>
/// <returns>DataSet</returns>
public DataSet ReturnDataSet(string strSQL)
{
Connection.Open();
DataSet dataSet = new DataSet();
OleDbDataAdapter OleDbDA = new OleDbDataAdapter(strSQL, Connection);
OleDbDA.Fill(dataSet, "objDataSet");

Connection.Close();
return dataSet;
}

/// <summary>
/// 執(zhí)行一查詢語句，同時返回查詢結(jié)果數(shù)目
/// </summary>
/// <param name="strSQL"></param>
/// <returns>sqlResultCount</returns>
public int ReturnSqlResultCount(string strSQL)
{
int sqlResultCount = 0;

try
{
Connection.Open();
OleDbCommand command = new OleDbCommand(strSQL, Connection);
OleDbDataReader dataReader = command.ExecuteReader();

while (dataReader.Read())
{
sqlResultCount++;
}
dataReader.Close();
}
catch
{
sqlResultCount = 0;
}
finally
{
Connection.Close();
}
return sqlResultCount;
}

}
}