1 using System;
  2 using System.Configuration;
  3 using System.Data;
  4 using System.Collections;
  5 using Oracle.DataAccess.Client;
  6 
  7 namespace Cont.DAL.Leave
  8 {
  9     /// <summary>
 10     ///Oracle數據庫操作幫助類
 11     /// </summary>
 12     public class OracleHelper
 13     {
 14         //從配置文件中讀取配置好的連接字符串
 15         private static  OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());
 16         private static OracleTransaction tran = null;
 17 
 18         /// <summary>
 19         /// 返回受影響的行數
 20         /// </summary>
 21         /// <param name="sql">sql語句</param>
 22         /// <returns></returns>
 23         public static int NonQuery(string sql)
 24         {
 25             try
 26             {
 27                 OracleCommand cmd = new OracleCommand(sql, conn);
 28                 int i = cmd.ExecuteNonQuery();
 29                 return i;//將受影響的行數返回
 30             }
 31             catch (Exception se)
 32             {
 33                 throw se;
 34             }
 35           
 36         }
 37         /// <summary>
 38         /// 返回一個臨時表數據，一般執行顯示表中多條數據操作  select
 39         /// </summary>
 40         /// <param name="sql">要執行的查詢sql語句</param>
 41         /// <returns>返回一個DataTable</returns>
 42         public static DataTable GetTable(string sql)
 43         {
 44             try
 45             {
 46                 conn.Open();
 47                 OracleDataAdapter sda = new OracleDataAdapter(sql, conn);
 48                 DataTable dt = new DataTable();
 49                 sda.Fill(dt);
 50                 return dt;
 51             }
 52             catch (Exception se)
 53             {
 54                 throw se;
 55             }
 56             finally
 57             {
 58                 conn.Close();
 59             }
 60 
 61         }
 62         /// <summary>
 63         /// 執行查詢操作，返回一個結果集
 64         /// </summary>
 65         /// <param name="sql">要執行的sql語句</param>
 66         /// <returns>返回一個讀取器</returns>
 67         public static OracleDataReader Reader(string sql)
 68         {
 69             try
 70             {
 71                 conn.Open();
 72                 OracleCommand cmd = new OracleCommand(sql, conn);
 73                 OracleDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);//讀取器和數據源此處不能被關閉
 74                 return sdr;
 75             }
 76             catch (Exception se)
 77             {
 78                 throw se;
 79             }
 80         }
 81         /// <summary>
 82         /// 執行查詢操作，返回一個單值，一般執行根據名稱找編號或執行聚合函數
 83         /// </summary>
 84         /// <param name="sql">要執行的sql查詢語句</param>
 85         /// <returns>返回一個object類型</returns>
 86         public static object Scalar(string sql)
 87         {
 88             try
 89             {
 90                 conn.Open();
 91                 OracleCommand cmd = new OracleCommand(sql, conn);
 92                 object obj = cmd.ExecuteScalar();
 93                 return obj;
 94             }
 95             catch (Exception se)
 96             {
 97                 throw se;
 98             }
 99             finally
100             {
101                 conn.Close();
102             }
103         }
104 
105         /// <summary>
106         ///開始事務 
107         /// </summary>
108         public static void BeginTran()
109         {
110             conn.Open();
111             tran = conn.BeginTransaction();
112         }
113 
114         /// <summary>
115         /// 提交事務
116         /// </summary>
117         public static void CommitTran()
118         {
119             tran.Commit();
120             tran.Dispose();
121             conn.Close();
122             tran = null;
123         }
124 
125         /// <summary>
126         /// 回滾
127         /// </summary>
128         public static void RollbackTran()
129         {
130             tran.Rollback();
131             tran.Dispose();
132             conn.Close();
133             tran = null;
134         }
135     }
136 }

View Code

?

轉載于:https://www.cnblogs.com/pxkuan/p/9252513.html

總結

以上是生活随笔為你收集整理的oracleHelper 操作帮助类的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。