然后把一下的代碼考到一個空的cs中文件中,就能用了。usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Web;usingSystem.Web.Secu" />

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

我自己用的oracle通用類

系統 1762 0

首先在web.config文件中添加

?<appSettings>
??<add key="Oracle" value="Data Source=****;user=*****;password=*****;"/>
?</appSettings>

然后把一下的代碼考到一個空的cs中文件中,就能用了。

?

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;//必須添加
using System.IO;
using System.Text;


using System.Web.SessionState;


/// <summary>
/// ClsOracleDB 的摘要說明? 使用中
/// </summary>
public class ClsOracleDB
{
??? //用OracleConnection連接Oracle
??? public System.Data.OracleClient.OracleConnection cnn;

??? public string Connstr
??? {
??????? get
??????? {
??????????? return System.Configuration.ConfigurationSettings.AppSettings["Oracle"];
??????? }
??? }

  /// <summary>
  /// 打開數據庫連接
  /// </summary>
??? public void Open()
  {
??????? cnn=new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["Oracle"]);
  ??? cnn.Open();
  }

?

??? /// <summary>
  /// 打開數據庫連接,返回cnn
  /// </summary>
  public OracleConnection OpenCnn()
  {
????? cnn=new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["Oracle"]);
  ? cnn.Open();
  ? return(cnn);
  }

??? /// <summary>
  /// 關閉數據庫連接
  /// </summary>
  public void Close()
  {
????? cnn.Close();
  }

??? /// <summary>
  /// 返回DataSet
  /// </summary>
  /// <param name="CmdString"></param>
  /// <param name="TableName"></param>
  /// <returns></returns>
  public DataSet GetDataSet(string CmdString,string TableName)
  {
????? Open();
  ? OracleDataAdapter myDa =new OracleDataAdapter();
  ? myDa.SelectCommand = new OracleCommand(CmdString,cnn);
  ? DataSet myDs =new DataSet();
  ? myDa.Fill(myDs,TableName);
  ? Close();
  ? return myDs;
  }

??? /// <summary>
  /// 返回OleDbDataReader
  /// </summary>
  /// <param name="CmdString"></param>
  /// <returns></returns>
  public OracleDataReader GetDataReader(string CmdString)
  {
????? Open();
  ? OracleCommand myCmd =new OracleCommand(CmdString,cnn);
  ? OracleDataReader myDr =myCmd.ExecuteReader();
 ?  return myDr;
  }

??? /// <summary>
??? /// 返回影響數據庫的行數? 更新數據庫數據
  /// </summary>
  /// <param name="CmdString"></param>
  /// <returns></returns>
  public int ExecuteSQL(string CmdString)
  {
????? Open();
  ? OracleCommand myCmd =new OracleCommand(CmdString,cnn);
  ? int Cmd =myCmd.ExecuteNonQuery();
 ?  Close();
 ?  return Cmd;
  }

??? /// <summary>
  /// 邦定DroDownList
  /// </summary>
  /// <param name="DroDList"></param>控件名
  /// <param name="sql"></param>連接字符串
  /// <param name="TableName"></param>表名
  /// <param name="DataTextFd"></param>提供文本內容的數據源字段
  /// <param name="DataValueFd"></param>為列表項提供值的數據源字段
??? public void DroList(DropDownList DroDList, string sql, string TableName, string DataTextFd, string DataValueFd)
??? {
??????? Open();
??????? OracleDataAdapter myDa = new OracleDataAdapter(sql, cnn);
??????? myDa.SelectCommand.CommandType = CommandType.Text;
??????? DataSet myDs = new DataSet();
??????? try
??????? {
??????????? myDa.Fill(myDs, TableName);
??????????? DroDList.DataSource = myDs.Tables[TableName];
??????????? DroDList.DataTextField = DataTextFd;
??????????? DroDList.DataValueField = DataValueFd;
??????????? DroDList.DataBind();
??????? }
??????? catch (System.Exception e)
??????? {
??????????? //Response.Write(e.Message);
??????????? LeeGunn.Web.UI.MessageBox.MessageBox.Show(e.Message);
??????? }
??????? finally
??????? {
??????????? Close();
??????? }
??? }

??? //可以用了
??? public void SavePic()
??? {
??????? string WarnGradeName;
??????? int i;
??????? string TmpdirPath;
??????? TmpdirPath = "\\" + "file" + "\\" + "warnicon";
???????
??????? // WarnGradeName = HttpContext.Current.Server.MapPath(System.Web.HttpContext.Current.Request.ApplicationPath);

??????? string sqlstr;

??????? DataSet myallds = new DataSet();
??????? string tablename;
??????? tablename = "WARNMETEDIS";

??????? sqlstr = "SELECT ID,WARNNAME FROM WARNMETEDIS ORDER BY WARNNAME";
??????? i = 1;

??????? myallds = GetDataSet(sqlstr, tablename);

??????? if (myallds.Tables[0].Rows.Count >= 1)
??????? {
??????????? for (i = 0; i < myallds.Tables[0].Rows.Count; i ++ )
??????????? {
??????????????? WarnGradeName = myallds.Tables[0].Rows[i][1].ToString();
??????????????? string[] photos = System.IO.Directory.GetFiles(HttpContext.Current.Server.MapPath(System.Web.HttpContext.Current.Request.ApplicationPath) + TmpdirPath, WarnGradeName + ".jpg");

??????????????? if (photos[0].Trim() != "")
??????????????? {
??????????????????? StringBuilder sbSQL = new StringBuilder("UPDATE WARNMETEDIS SET WARNICON = :WARNICON11 WHERE WARNNAME='" + WarnGradeName + "'");

??????????????????? OracleConnection cn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["Oracle"]);
??????????????????? OracleCommand cmd = cn.CreateCommand();
??????????????????? cmd.CommandText = sbSQL.ToString();

??????????????????? FileStream fs;
??????????????????? fs =File.OpenRead(photos[0]);
??????????????????? int lentth;
??????????????????? byte[] pic = new byte[fs.Length];
??????????????????? lentth = Convert.ToInt32(fs.Length);
??????????????????? fs.Read(pic, 0, lentth);
??????????????????? fs.Close();

??????????????????? cmd.Parameters.Add(":WARNICON11", OracleType.Blob).Value = pic;
??????????????????? try
??????????????????? {
??????????????????????? cn.Open();
??????????????????????? cmd.ExecuteNonQuery();
??????????????????? }
??????????????????? catch (Exception ex)
??????????????????? {
??????????????????????? //Response.Write(ex.Message);
??????????????????????? LeeGunn.Web.UI.MessageBox.MessageBox.Show(ex.Message);
??????????????????? }
??????????????????? finally
??????????????????? {
??????????????????????? cn.Close();
??????????????????? }
??????????????? }
??????????????? else
??????????????? {
??????????????????? LeeGunn.Web.UI.MessageBox.MessageBox.Show("沒有數據");
??????????????? }
??????????? }
??????? }
??? }

??? //public

?

??? #region 參考存取圖片代碼

??? #region 創建的數據表
??? // CREATE TABLE TEST_TABLE
??? //(
??? //?? ID???? VARCHAR2(36 BYTE),
??? //?? NAME?? VARCHAR2(50 BYTE),
??? //?? PHOTO? BLOB
??? //)
??? #endregion

??? //保存圖片到數據庫
??? private void CankaoSavePic()
??? {
??????? //StringBuilder sbSQL = new StringBuilder("insert into Test_Table(ID,Name,Photo) values(:ID,:Name,:Photo)");
??????? //OracleConnection cn = new OracleConnection(strCn);
??????? //OracleCommand cmd = cn.CreateCommand();
??????? //cmd.CommandText = sbSQL.ToString();
??????? //cmd.Parameters.Add(":ID", OracleType.VarChar, 36).Value = Guid.NewGuid().ToString();
??????? //cmd.Parameters.Add(":Name", OracleType.VarChar, 50).Value = fileUp.FileName; ;
??????? //int intLen = fileUp.PostedFile.ContentLength;
??????? //byte[] pic = new byte[intLen];
??????? //fileUp.PostedFile.InputStream.Read(pic, 0, intLen);
??????? //cmd.Parameters.Add(":Photo", OracleType.Blob).Value = pic;
??????? //try
??????? //{
??????? //??? cn.Open();
??????? //??? cmd.ExecuteNonQuery();
??????? //}
??????? //catch (Exception ex)
??????? //{
??????? //??? Response.Write(ex.Message);
??????? //}
??????? //finally
??????? //{
??????? //??? cn.Close();
??????? //}
??? }

??? //從數據庫中讀取圖片
??? private void CankaoReadPic()
??? {
?????? // OracleConnection cn = new OracleConnection(strCn);
?????? // OracleCommand cmd = cn.CreateCommand();
?????? // cmd.CommandText = "select photo from test_table";
?????? // try
?????? // {
?????? //???? cn.Open();
?????? //???? MemoryStream stream = new MemoryStream();
?????? //???? IDataReader reader = cmd.ExecuteReader();
?????? //???? if (reader.Read())
?????? //???? {

?????? //???????? byte[] pic = (byte[])reader[0];
?????? //???????? //byte[] pic = (byte[])cmd.ExecuteScalar();
?????? //???????? stream.Write(pic, 0, pic.Length);
?????? //???????? //Bitmap bitMap = new Bitmap(stream);
?????? //???????? //Response.ContentType = "image/Jpeg";
?????? //???????? //bitMap.Save(Response.OutputStream, ImageFormat.Jpeg);
?????? //???????? //注釋部分可以將圖片顯示在IE中,而不是下載圖片,
?????? //???????? //下面的方法直接下載文件?
?????? //???????? Response.ContentType = "application/octet-stream";
?????? //???????? Response.AddHeader("Content-Disposition", "attachment;FileName= demo.JPG");
?????? //???????? Response.BinaryWrite(pic);
?????? //???????? Response.End();
?????? //???? }
?????? // }
?????? // catch (Exception ex)
?????? //{
?????? //???? Response.Write(ex.Message);
?????? //}
?????? //finally
?????? //{
?????? //???? cn.Close();
?????? //}
?? }
??? #endregion


?? public ClsOracleDB()
?{
??//
??// TODO: 在此處添加構造函數邏輯
??//
?}
}

我自己用的oracle通用類


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

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯系: 360901061

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

【本文對您有幫助就好】

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

發表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 国产综合精品一区二区 | 在线 | 一区二区三区 | 四虎国产精品免费久久影院 | 欧美日本一二三区 | 免费观看a毛片一区二区不卡 | 青青热久久国产久精品秒播 | 欧美一级在线毛片免费观看 | 亚洲国产成人久久99精品 | 免费精品精品国产欧美在线 | 色综合网站在线 | 亚洲视频中文字幕在线 | 国产成人乱码一区二区三区 | 午夜视频在线网站 | 久久综合久久美利坚合众国 | 日本黄色网址免费 | 欧美一级www片免费观看 | 国产区精品福利在线观看精品 | 在线观看 亚洲 | 99热久久这里只精品国产9 | 欧美成人在线观看 | 国产精品久久久久久久午夜片 | 国产精品亚洲欧美日韩久久 | 欧美国产日韩在线播放 | 操野逼| 久久伊人精品综合观看99 | 高清一级毛片一本到免费观看 | 9966久久精品免费看国产 | 欧美一区二区三区久久久 | 国产精品一区在线播放 | 精品福利视频第一 | 九九在线观看精品视频6 | 综综综综合网 | 午夜性爽视频男人的天堂在线 | 尤物福利| 国内精品久久久久久久aa护士 | 久久久夜夜夜 | 五月天国产 | 欧美亚洲桃花综合 | 在线欧美视频免费观看国产 | 成人午夜亚洲影视在线观看 | 国产成人一区二区三区在线视频 |