111,096
社区成员




using System.Data.OracleClient;
public class ORCLDataAccess:DAO
{
//数据库连接对像
private OracleConnection conn = null;
//数据库命令对像
private OracleCommand cmd = new OracleCommand();
//DataAdapter对像
private OracleDataAdapter adapter = new OracleDataAdapter();
private OracleParameter parameter = new OracleParameter();
private OracleDataReader reader = null;
private OracleTransaction trans = null;
/// <summary>
/// 该实例使用的数据库连接字符串
/// </summary>
private string connectionString = ApplicationConfiguration.DBConnectionString;
connectionString =“user id=bsrs_sys;data source=BNURS_COMPUTER1;password=sys”;
#region DAO 成员
/// <summary>
/// 数据库类型
/// </summary>
public System.Data.DbType DatabaseType
{
get
{
return new System.Data.DbType();
}
}
/// <summary>
/// 数据库DataReader对像
/// </summary>
public System.Data.IDataReader DataReader
{
get
{
return this.reader;
}
set
{
reader = (OracleDataReader)value;
}
}
public System.Data.IDbConnection DbConnection
{
get
{
if (conn == null)
{
conn = new OracleConnection(connectionString);
}
return conn;
}
}
/// <summary>
/// 执行命令类型
/// </summary>
public System.Data.CommandType Commandtype
{
set { throw new Exception("The method or operation is not implemented."); }
}
public System.Data.IDbCommand DataCommand
{
get
{
return this.cmd;
}
set
{
cmd = (OracleCommand)value;
}
}
public System.Data.IDbDataParameter NewParameter(string parameterName, System.Data.DbType dbType)
{
throw new Exception("The method or operation is not implemented.");
}
/// <summary>
/// 参数设置
/// </summary>
/// <param name="parameterName"></param>
/// <param name="dbType"></param>
/// <param name="size"></param>
/// <returns></returns>
public System.Data.IDbDataParameter NewParameter(string parameterName, System.Data.DbType dbType, int size)
{
throw new Exception("The method or operation is not implemented.");
}
/// <summary>
/// OracleDataAdapter
/// </summary>
public System.Data.IDbDataAdapter DataAdapter
{
get
{
if (adapter != null)
{
return adapter;
}
else
{
adapter = new OracleDataAdapter();
return adapter;
}
}
}
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
if (connectionString == null)
{
connectionString = System.Configuration.ConfigurationSettings.AppSettings["myConnection"];
}
if (conn == null)
{
conn = new OracleConnection(connectionString);
conn.Open();
}
else
{
if (conn.State == ConnectionState.Closed)
conn.Open();
}
}
/// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
if (conn != null&&conn.State == ConnectionState.Open)
{
conn.Close();
}
}
/// <summary>
/// 开始执行数据库事务
/// </summary>
/// <returns></returns>
public System.Data.IDbTransaction BeginTransaction()
{
Open();
trans = conn.BeginTransaction();
return trans;
}
/// <summary>
/// 开始数据库连接
/// </summary>
/// <param name="isolationLevel"></param>
/// <returns></returns>
public System.Data.IDbTransaction BeginTransaction(IsolationLevel isolationLevel)
{
Open();
trans = conn.BeginTransaction(isolationLevel);
return trans;
}
/// <summary>
/// 执行无返回值的操作
/// </summary>
/// <param name="commandText">数据操作字符串</param>
/// <returns>返回影响的行数</returns>
public int ExecuteNonQuery(string commandText)
{
Open();
int rValue = 0;
cmd.Connection = conn;
try
{
cmd.CommandText = commandText;
cmd.CommandType = CommandType.Text;
rValue = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
return rValue;
}
/// <summary>
/// 执行无返回值的数据操作命令
/// </summary>
/// <returns>返回影响的行数</returns>
public int ExecuteNonQuery()
{
Open();
int rValue = 0;
cmd.Connection = conn;
try
{
rValue = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
return rValue;
}
using System.Data.OracleClient;
public class ORCLDataAccess:DAO
{
//数据库连接对像
private OracleConnection conn = null;
//数据库命令对像
private OracleCommand cmd = new OracleCommand();
//DataAdapter对像
private OracleDataAdapter adapter = new OracleDataAdapter();
private OracleParameter parameter = new OracleParameter();
private OracleDataReader reader = null;
private OracleTransaction trans = null;
/// <summary>
/// 该实例使用的数据库连接字符串
/// </summary>
private string connectionString = ApplicationConfiguration.DBConnectionString;
connectionString =“user id=bsrs_sys;data source=BNURS_COMPUTER1;password=sys”;
#region DAO 成员
/// <summary>
/// 数据库类型
/// </summary>
public System.Data.DbType DatabaseType
{
get
{
return new System.Data.DbType();
}
}
/// <summary>
/// 数据库DataReader对像
/// </summary>
public System.Data.IDataReader DataReader
{
get
{
return this.reader;
}
set
{
reader = (OracleDataReader)value;
}
}
public System.Data.IDbConnection DbConnection
{
get
{
if (conn == null)
{
conn = new OracleConnection(connectionString);
}
return conn;
}
}
/// <summary>
/// 执行命令类型
/// </summary>
public System.Data.CommandType Commandtype
{
set { throw new Exception("The method or operation is not implemented."); }
}
public System.Data.IDbCommand DataCommand
{
get
{
return this.cmd;
}
set
{
cmd = (OracleCommand)value;
}
}
public System.Data.IDbDataParameter NewParameter(string parameterName, System.Data.DbType dbType)
{
throw new Exception("The method or operation is not implemented.");
}
/// <summary>
/// 参数设置
/// </summary>
/// <param name="parameterName"></param>
/// <param name="dbType"></param>
/// <param name="size"></param>
/// <returns></returns>
public System.Data.IDbDataParameter NewParameter(string parameterName, System.Data.DbType dbType, int size)
{
throw new Exception("The method or operation is not implemented.");
}
/// <summary>
/// OracleDataAdapter
/// </summary>
public System.Data.IDbDataAdapter DataAdapter
{
get
{
if (adapter != null)
{
return adapter;
}
else
{
adapter = new OracleDataAdapter();
return adapter;
}
}
}
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
if (connectionString == null)
{
connectionString = System.Configuration.ConfigurationSettings.AppSettings["myConnection"];
}
if (conn == null)
{
conn = new OracleConnection(connectionString);
conn.Open();
}
else
{
if (conn.State == ConnectionState.Closed)
conn.Open();
}
}
/// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
if (conn != null&&conn.State == ConnectionState.Open)
{
conn.Close();
}
}
/// <summary>
/// 开始执行数据库事务
/// </summary>
/// <returns></returns>
public System.Data.IDbTransaction BeginTransaction()
{
Open();
trans = conn.BeginTransaction();
return trans;
}
/// <summary>
/// 开始数据库连接
/// </summary>
/// <param name="isolationLevel"></param>
/// <returns></returns>
public System.Data.IDbTransaction BeginTransaction(IsolationLevel isolationLevel)
{
Open();
trans = conn.BeginTransaction(isolationLevel);
return trans;
}
/// <summary>
/// 执行无返回值的操作
/// </summary>
/// <param name="commandText">数据操作字符串</param>
/// <returns>返回影响的行数</returns>
public int ExecuteNonQuery(string commandText)
{
Open();
int rValue = 0;
cmd.Connection = conn;
try
{
cmd.CommandText = commandText;
cmd.CommandType = CommandType.Text;
rValue = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
return rValue;
}
/// <summary>
/// 执行无返回值的数据操作命令
/// </summary>
/// <returns>返回影响的行数</returns>
public int ExecuteNonQuery()
{
Open();
int rValue = 0;
cmd.Connection = conn;
try
{
rValue = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
return rValue;
}