用C#如何连接Oracle数据库并且进行操作

sunhongxiang 2008-12-02 02:34:06
各位大虾 ,本人刚刚接触ORCLE数据库,对该数据库一点都不懂,请大家指教一下,如何连接数据库并且进行操作
...全文
8344 4 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
jiang_jiajia10 2008-12-02
  • 打赏
  • 举报
回复
http://www.cnblogs.com/tech-faraWay/archive/2006/07/10/446813.html

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;
}


jiang_jiajia10 2008-12-02
  • 打赏
  • 举报
回复
http://www.cnblogs.com/tech-faraWay/archive/2006/07/10/446813.html

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;
}


llsen 2008-12-02
  • 打赏
  • 举报
回复
和sql差不多啊

只是类换乘orl类了
tangserver 2008-12-02
  • 打赏
  • 举报
回复
//首先添加两条引用
using System.Data.OracleClient;
using System.Data;

//在窗体上添加一个按钮,叫Button1,双击Button1,输入以下代码
private void Button1_Click(object sender, System.EventArgs e)
{
string ConnectionString="Data Source=sky;user=system;password=manager;";//写连接串
OracleConnection conn=new OracleConnection(ConnectionString);//创建一个新连接
try
{
conn.Open();
OracleCommand cmd=conn.CreateCommand();
cmd.CommandText="select * from MyTable";//在这儿写sql语句
OracleDataReader odr=cmd.ExecuteReader();//创建一个OracleDateReader对象
while(odr.Read())//读取数据,如果odr.Read()返回为false的话,就说明到记录集的尾部了
{
Response.Write(odr.GetOracleString(1).ToString());//输出字段1,这个数是字段索引,具体怎么使用字段名还有待研究
}
odr.Close();
}
catch(Exception ee)
{
Response.Write(ee.Message); //如果有错误,输出错误信息
}
finally
{
conn.Close(); //关闭连接
}
}

111,096

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术 C#
社区管理员
  • C#
  • AIGC Browser
  • by_封爱
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧