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 類,方法參考來源于網絡
?
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號聯系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
