然后把一下的代碼考到一個空的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條評論
主站蜘蛛池模板: 国产精品成人久久久久 | 欧美日本高清 | 精品国产呦系列在线看 | 天海翼一区二区三区高清视频 | 在线国产播放 | 久久久久久久久久久9精品视频 | 四虎四虎| 国产成人综合视频 | 韩国网站爱久久 | 四虎成人免费视频 | 一级一级毛片看看 | 成人欧美精品大91在线 | 国产a v高清一区二区三区 | 九九视频国产 | 欧美一级毛片一免费 | 美女羞羞免费网站 | 亚洲国产第一区二区三区 | 老司机久久精品视频 | 午夜影院私人 | 成人一级免费视频 | 麻豆狠色伊人亚洲综合网站 | 波多野结衣久久一区二区 | 国内精品伊人久久久久7777人 | 午夜久久久精品 | 老妇毛片| 性综合网| 国产精品久久久香蕉 | 天天久久综合 | 精品一区二区三 | 亚洲一区精品中文字幕 | 中国一级特黄特级毛片 | 在线国产视频一区 | 99久久99热久久 | 久久99精品这里精品3 | 久久网站免费观看 | 亚洲欧美另类专区 | 国产精品一一在线观看 | 国产精品久久现线拍久青草 | 伊人久久伊人 | 国产成人精品亚洲777图片 | 一级在线视频 |