Web.config 配置文件中節點

<connectionStrings>

<add name="ConnectionString" connectionString="Data Source=jde;Persist Security Info=True;User ID=jde;Password=jde;Unicode=True" providerName="System.Data.OracleClient"/>

</connectionStrings>

以上是 oracle 數據庫的連接字符串

name ：連接字符串名

connectionString ：連接字符串

Data Souuce ：本地機：就是數據庫名；遠程機子：如果在本地裝有 oracle 數據庫的客戶端則也是數據庫名，否則參考網絡資源要加一個域。

User ID ：用戶名

?

?

?

OraDBHelper.cs 文件

*******************************************************************************

using System;

using System.Data;

using System.Configuration;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.OracleClient; ??

?

/// <summary>

///OraDBHelper 的摘要說明

/// </summary>

?

??? public class OraDBHelper

??? {

??????? public static OracleCommand cmd = null;

??????? public static OracleConnection conn = null;

??????? public static string connstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

??????? public OraDBHelper()

??????? { }

??????? #region 建立數據庫連接對象

??????? /// <summary>??

??????? /// 建立數據庫連接 ??

??????? /// </summary>??

??????? /// <returns> 返回一個數據庫的連接 OracleConnection 對象 </returns> ??

??????? public static OracleConnection init()

??????? {

??????????? try

??????????? {

??????????????? conn = new OracleConnection(connstr);

??????????????? if (conn.State != ConnectionState.Open)

??????????????? {

??????????????????? conn.Open();

??????????????? }

??????????? }

??????????? catch (Exception e)

??????????? {

??????????????? throw new Exception(e.Message.ToString());

??????????? }

??????????? return conn;

??????? }

??????? #endregion

?

??????? #region 設置 OracleCommand 對象

??????? /// <summary>??

??????? /// 設置 OracleCommand 對象 ?????????

??????? /// </summary>??

??????? /// <param name="cmd">OracleCommand 對象 </param> ??

??????? /// <param name="cmdText"> 命令文本 </param> ??

??????? /// <param name="cmdType"> 命令類型 </param> ??

??????? /// <param name="cmdParms"> 參數集合 </param> ??

??????? private static void SetCommand(OracleCommand cmd, string cmdText, CommandType cmdType, OracleParameter[] cmdParms)

??????? {

??????????? cmd.Connection = conn;

??????????? cmd.CommandText = cmdText;

??????????? cmd.CommandType = cmdType;

??????????? if (cmdParms != null)

??????????? {

??????????????? cmd.Parameters.AddRange(cmdParms);

??????????? }

??????? }

??????? #endregion

?

??????? #region 執行相應的 sql 語句，返回相應的 DataSet 對象

??????? /// <summary>??

??????? /// 執行相應的 sql 語句，返回相應的 DataSet 對象 ??

??????? /// </summary>??

??????? /// <param name="sqlstr">sql 語句 </param> ??

??????? /// <returns> 返回相應的 DataSet 對象 </returns> ??

??????? public static DataSet GetDataSet(string sqlstr)

??????? {

??????????? DataSet set = new DataSet();

??????????? try

??????????? {

??????????????? init();

??????????????? OracleDataAdapter adp = new OracleDataAdapter(sqlstr, conn);

??????????????? adp.Fill(set);

??????????????? conn.Close();

??????????? }

??????????? catch (Exception e)

??????????? {

??????????????? throw new Exception(e.Message.ToString());

??????????? }

??????????? return set;

??????? }

??????? #endregion

?

??????? #region 執行相應的 sql 語句，返回相應的 DataSet 對象

??????? /// <summary>??

??????? /// 執行相應的 sql 語句，返回相應的 DataSet 對象 ??

??????? /// </summary>??

??????? /// <param name="sqlstr">sql 語句 </param> ??

??????? /// <param name="tableName"> 表名 </param> ??

??????? /// <returns> 返回相應的 DataSet 對象 </returns> ??

??????? public static DataSet GetDataSet(string sqlstr, string tableName)

??????? {

??????????? DataSet set = new DataSet();

??????????? try

??????????? {

??????????????? init();

??????????????? OracleDataAdapter adp = new OracleDataAdapter(sqlstr, conn);

??????????????? adp.Fill(set, tableName);

??????????????? conn.Close();

??????????? }

??????????? catch (Exception e)

??????????? {

??????????????? throw new Exception(e.Message.ToString());

??????????? }

??????????? return set;

??????? }

????? ??#endregion

?

??????? #region 執行不帶參數 sql 語句，返回所影響的行數

??????? /// <summary>??

??????? /// 執行不帶參數 sql 語句，返回所影響的行數 ??

??????? /// </summary>??

??????? /// <param name="cmdstr"> 增，刪，改 sql 語句 </param> ??

??????? /// <returns> 返回所影響的行數 </returns> ??

??????? public static int ExecuteNonQuery(string cmdText)

??????? {

??????????? int count;

??????????? try

??????????? {

??????????????? init();

??????????????? cmd = new OracleCommand(cmdText, conn);

??????????????? count = cmd.ExecuteNonQuery();

??????????????? conn.Close();

??????????? }

??????????? catch (Exception ex)

??????????? {

??????????????? throw new Exception(ex.Message.ToString());

??????????? }

??????????? return count;

??????? }

??????? #endregion

?

??????? #region 執行帶參數 sql 語句或存儲過程，返回所影響的行數

??????? /// <summary>??

??????? ///? 執行帶參數 sql 語句或存儲過程，返回所影響的行數 ??

??????? /// </summary>??

??????? /// <param name="cmdText"> 帶參數的 sql 語句和存儲過程名 </param> ??

??????? /// <param name="cmdType"> 命令類型 </param> ??

??????? /// <param name="cmdParms"> 參數集合 </param> ??

??????? /// <returns> 返回所影響的行數 </returns> ??

??????? public static int ExecuteNonQuery(string cmdText, CommandType cmdType, OracleParameter[] cmdParms)

??????? {

??????????? int count;

??????????? try

??????????? {

??????????????? init();

??????????????? cmd = new OracleCommand();

??????????????? SetCommand(cmd, cmdText, cmdType, cmdParms);

??????????????? count = cmd.ExecuteNonQuery();

??????????????? cmd.Parameters.Clear();

??????????????? conn.Close();

??????????? }

??????????? catch (Exception ex)

??????????? {

??????????????? throw new Exception(ex.Message.ToString());

??????????? }

??????????? return count;

??????? }

??????? #endregion

?

??????? #region 執行不帶參數 sql 語句，返回一個從數據源讀取數據的 OracleDataReader 對象

??????? /// <summary>??

??????? /// 執行不帶參數 sql 語句，返回一個從數據源讀取數據的 OracleDataReader 對象 ??

??????? /// </summary>??

??????? /// <param name="cmdstr"> 相應的 sql 語句 </param> ??

??????? /// <returns> 返回一個從數據源讀取數據的 OracleDataReader 對象 </returns> ??

??????? public static OracleDataReader ExecuteReader(string cmdText)

??????? {

??????????? OracleDataReader reader;

??????????? try

??????????? {

??????????????? init();

??????????????? cmd = new OracleCommand(cmdText, conn);

???????????? ???reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

?

??????????? }

??????????? catch (Exception ex)

??????????? {

??????????????? throw new Exception(ex.Message.ToString());

??????????? }

??????????? return reader;

??????? }

??????? #endregion

?

??????? #region 執行帶參數的 sql 語句或存儲過程，返回一個從數據源讀取數據的 OracleDataReader 對象

??????? /// <summary>??

??????? /// 執行帶參數的 sql 語句或存儲過程，返回一個從數據源讀取數據的 OracleDataReader 對象 ??

??????? /// </summary>??

??????? /// <param name="cmdText">sql 語句或存儲過程名 </param> ??

??????? /// <param name="cmdType"> 命令類型 </param> ??

??????? /// <param name="cmdParms"> 參數集合 </param> ??

??????? /// <returns> 返回一個從數據源讀取數據的 OracleDataReader 對象 </returns> ??

??????? public static OracleDataReader ExecuteReader(string cmdText, CommandType cmdType, OracleParameter[] cmdParms)

??????? {

??????????? OracleDataReader reader;

??????????? try

??????????? {

??????????????? init();

??????????????? cmd = new OracleCommand();

??????????????? SetCommand(cmd, cmdText, cmdType, cmdParms);

??????????????? reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

??????????? }

??????????? catch (Exception ex)

??????????? {

??????????????? throw new Exception(ex.Message.ToString());

??????????? }

??????????? return reader;

??????? }

??????? #endregion

?

??????? #region 執行不帶參數 sql 語句 , 返回結果集首行首列的值 object

??????? /// <summary>??

??????? /// 執行不帶參數 sql 語句 , 返回結果集首行首列的值 object ??

??????? /// </summary>??

??????? /// <param name="cmdstr"> 相應的 sql 語句 </param> ??

??????? /// <returns> 返回結果集首行首列的值 object</returns> ??

??????? public static object ExecuteScalar(string cmdText)

??????? {

??????????? object obj;

??????????? try

??????????? {

??????????????? init();

??????????????? cmd = new OracleCommand(cmdText, conn);

??????????????? obj = cmd.ExecuteScalar();

??????????????? conn.Close();

??????????? }

? ??????????catch (Exception ex)

??????????? {

??????????????? throw new Exception(ex.Message.ToString());

??????????? }

??????????? return obj;

??????? }

??????? #endregion

?

??????? #region 執行帶參數 sql 語句或存儲過程 , 返回結果集首行首列的值 object

??????? /// <summary>??

??????? /// 執行帶參數 sql 語句或存儲過程 , 返回結果集首行首列的值 object ??

??????? /// </summary>??

??????? /// <param name="cmdText">sql 語句或存儲過程名 </param> ??

??????? /// <param name="cmdType"> 命令類型 </param> ??

??????? /// <param name="cmdParms"> 返回結果集首行首列的值 object</param> ??

??????? /// <returns></returns>??

??????? public static object ExecuteScalar(string cmdText, CommandType cmdType, OracleParameter[] cmdParms)

??????? {

??????????? object obj;

??????????? try

??????????? {

??????????????? init();

??????????????? cmd = new OracleCommand();

??????????????? SetCommand(cmd, cmdText, cmdType, cmdParms);

??????????????? obj = cmd.ExecuteScalar();

??????????????? conn.Close();

??????????? }

??????????? catch (Exception ex)

??????????? {

??????????????? throw new Exception(ex.Message.ToString());

? ?????????? }

??????????? return obj;

??????? }

??????? #endregion

??? }??

這是 oracle 數據庫的一個 DBHelp 類，方法參考來源于網絡

?

OraDBHelper.cs asp.net 通用oracle數據庫讀寫類