使用如下方法连接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(); }