oracle 数据库连接代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】 oracle 数据库连接

作者:Dezai.CN / 发布于2013/6/13/ 644


	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Text;
	using System.Data;
	using System.Data.OracleClient;

	namespace MES.Code
	{
	 public class Query
	 {
	 private OracleConnection conn;//数据库连接对象
	 private OracleTransaction transaction;

	 public Query()
	 {
	 string oracleConn = "Data Source=NEWDB; User ID=SYSTEM; Password=admin; Min Pool Size=10; Max Pool Size=100; Connection Lifetime=120; Connection Timeout=60; Incr Pool Size=3; Decr Pool Size=1;";
	 //实例化数据连接对象，与Access数据库ddb.mdb连接
	 conn = new OracleConnection(oracleConn);
	 //conn.ConnectionString = "Data Source=NEWDB; User ID=SYSTEM; Password=admin; Min Pool Size=10; Max Pool Size=100; Connection Lifetime=120; Connection Timeout=60; Incr Pool Size=3; Decr Pool Size=1;";
	 //打开连接
	 //conn.Open();
	 }
	 //private string BuildConnectionString(string TNSName, string UserID, string Password)
	 //{
	 // OracleConnectionStringBuilder _conn = new OracleConnectionStringBuilder()
	 // {
	 // _conn.DataSource = TNSName;
	 // _conn.DecrPoolSize = 5;
	 // _conn.IncrPoolSize = 10;
	 // _conn.Pooling = true;
	 // _conn.MaxPoolSize = 100;
	 // _conn.MinPoolSize = 5;
	 // _conn.ConnectionLifeTime = 120;
	 // _conn.ConnectionTimeout = 60;
	 // _conn.UserID = UserID;
	 // _conn.Password = Password;
	 // }
	 // return _conn.ConnectionString;
	 //}

	 /// <summary>
	 /// 本地查询
	 /// </summary>
	 /// <param name="queryString">查询串</param>
	 /// <returns>查询结果的DataSet对象</returns>
	 public DataSet dsQuery(string queryString)
	 {
	 //如果连接关闭，则打开数据库连接
	 if (conn.State == ConnectionState.Closed) conn.Open();
	 //事务
	 //transaction.Connection.BeginTransaction();
	 DataSet ds;
	 try
	 {
	 ds = new DataSet();
	 //创建一个数据表对象
	 //DataTable dt = new DataTable("Result");
	 OracleDataAdapter adapter = new OracleDataAdapter();
	 OracleCommand myCommand = new OracleCommand(queryString, conn);
	 //设置adapter的查询命令
	 adapter.SelectCommand = myCommand;
	 //将查询结果填入数据表对象
	 adapter.Fill(ds);
	 //将数据表对象加入数据集中
	 //ds.Tables.Add(dt);
	 }
	 finally
	 {
	 conn.Close();
	 }
	 return ds;
	 }
	 /// <summary>
	 /// 更新表中数据
	 /// </summary>
	 /// <param name="sqlString">更新数据的SQL语句串</param>
	 /// <returns>更新是否成功，成功：true;失败：false</returns>
	 public bool UpdateTable(string sqlString)
	 {
	 bool flag;
	 if (conn.State == ConnectionState.Closed) conn.Open();
	 //根据SQL语句创建一个命令对象
	 OracleCommand myCommand = new OracleCommand(sqlString, conn);
	 try
	 {
	 //执行命令
	 if (myCommand.ExecuteNonQuery() > 0) flag = true;
	 else flag = false;
	 }
	 finally
	 {
	 conn.Close();
	 }
	 return flag;
	 }
	 /// <summary>
	 /// 插入数据
	 /// </summary>
	 /// <param name="sqlString">插入数据的sql语句</param>
	 /// <returns>更新是否成功，成功：return;失败：false</returns>
	 public bool Insert(string sqlString)
	 {
	 bool flag;
	 if (conn.State == ConnectionState.Closed) conn.Open();
	 OracleCommand myCoammand = new OracleCommand(sqlString, conn);
	 try
	 {
	 if (myCoammand.ExecuteNonQuery() > 0) flag = true;
	 else flag = false;
	 }
	 finally
	 {
	 conn.Close();
	 }
	 return flag;
	 }
	 }
	}

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　数据库连接　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)