以上是oracle數據" />

亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

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

系統 1809 0

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數據庫讀寫類


更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯系: 360901061

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

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦!!!

發表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 日韩一区二区在线观看 | 成人中文字幕一区二区三区 | 91青青青 | 午夜免费福利不卡网址92 | 有色视频在线观看免费高清 | 在线观看黄色免费视频 | 日本久久久久亚洲中字幕 | 久久桃花网| 性视频一级 | 亚洲国产乱 | 欧美日本中文字幕 | 老子影院午夜伦不卡手机 | 一级片一级毛片 | 中文字幕在线观看第二页 | 欧美日韩一区二区不卡三区 | 精品日本亚洲一区二区三区 | 欧美成人二区 | 一级aa免费视频毛片 | 欧美曰韩免费视频一区 | 亚洲九月天| 国产精品www | 国产成人精品高清免费 | 日韩精品久久不卡中文字幕 | 毛片毛片免费看 | 久久综合精品国产一区二区三区 | 91在线免费公开视频 | 亚洲精品a | 性xxx欧美 | 国产精品嘿咻嘿咻在线播放 | 99视频在线播放 | 久久国产精品二国产精品 | 天天伊人网| xx色综合 | 精品久久国产老人久久综合 | 午夜宅男免费完整在线观看 | 免费看一级欧美毛片 | 国产高清精品一级毛片 | 国产亚洲精品自在久久不卡 | 九九免费观看全部免费视频 | 香蕉视频在线免费播放 | 天天射天天色天天干 |