C#连接Oracle数据库并进行简单查询操作

使用如下方法连接Oracle数据库，需要提前安装Oracle客户端，并且配置tnsnames.ora，否则连接过程中会报错。

首先需要在解决方案中添加对System.Data.OracleClient.dll的引用

 

 

引入命名空间
using System.Data.OracleClient;
using System.Data;

查询操作

//创建连接字符串
string ConnectionString = "Data Source=orcl;User ID=scott;password=tiger";
//创建连接
OracleConnection conn = new OracleConnection(ConnectionString);
try
{
//打开连接
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM T_STUDENT";
//创建OracleDataReader对象
OracleDataReader odr = cmd.ExecuteReader(); 
while (odr.Read())
{
//数字1 表示你想查询的那一行的第一个字段的值，后面以此类推
Console.WriteLine(odr.GetOracleString(1).ToString())
}
odr.Close();
}
catch (Exception ex)
{
//输出报错信息
}
finally
{
//关闭连接
conn.Close();
}

 

插入操作

string connStr = "Data Source=orcl;User ID=scott;password=tiger";
OracleConnection conn = new OracleConnection(connStr);
try
{

conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into t_student(xh,xm) values(200050,'张三')";
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
Console.WriteLine("插入成功!");
}
else
{
Console.WriteLine("插入失败！");
}

}
catch (Exception ex)
{
//输出报错信息
}
finally
{
conn.Close();
}

 

删除操作

string connStr = "Data Source=orcl;User ID=scott;password=tiger";
OracleConnection conn = new OracleConnection(connStr);
try
{
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "delete t_student where xh = 200050";
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
Console.WriteLine("删除成功!");
}
else
{
Console.WriteLine("删除失败！");
}

}
catch (Exception ex)
{
//输出错误信息
}
finally
{
conn.Close();
}
}

 

更改操作

string connStr = "Data Source=orcl;User ID=scott;password=tiger";
OracleConnection conn = new OracleConnection(connStr);
try
{
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "update t_student set xm='张飞' where xh = 200021";
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
Console.WriteLine("更改成功!");
}
else
{
Console.WriteLine("更改失败！");
}

}
catch (Exception ex)
{
//输出错误信息
}
finally
{
conn.Close();
}