C#连接ORACLE
来源:互联网 发布:java航空订票系统 编辑:程序博客网 时间:2024/05/17 03:20
- using System;
- using System.Collections.Generic;
- using System.Text;
- using System.Data;
- using System.Data.SqlClient;
- using System.Data.OracleClient;
- namespace CShap连接Oracle
- {
- class db
- {
- public OracleConnection GetCon()
- {
- String constr = "server=ACCP;uid=scott;pwd=tiger;";
- OracleConnection oCon = new OracleConnection(constr);
- return oCon;
- }
- static void Main(string[] args)
- {
- db obj = new db();
- OracleConnection ocon = obj.GetCon();
- OracleCommand oCom = new OracleCommand("select * from emp", ocon);
- ocon.Open();
- OracleDataReader odr = oCom.ExecuteReader();
- while (odr.Read())
- {
- String name = odr.GetString(1).ToString();
- String job = odr.GetString(2).ToString();
- Console.WriteLine("姓名:" + name + " 工作:" + job);
- }
- ocon.Close();
- }
- }
- }