{"rsdb":{"rid":"244573","subhead":"","postdate":"0","aid":"168307","fid":"57","uid":"1","topic":"1","content":"
\u4e00\u3001\u5c06\u56fe\u7247\u5b58\u5165Oracle<\/a>\u6570\u636e\u5e93<\/a><\/p> \n \u793a\u4f8b\u8868NEWS\u7684\u7ed3\u6784\u4e3a\uff1anewsid number(10),title varchar2(100),image(blob)<\/p> \n \u65b9\u6cd51\uff1a\u5229\u7528OracleCommandBuilder\u7c7b(\u8be5\u7c7b\u7528\u4e8e\u81ea\u52a8\u751f\u6210\u7528\u4e8e\u534f\u8c03 DataSet \u7684\u66f4\u6539\u4e0e\u5173\u8054\u7684\u6570\u636e\u5e93\u7684\u5355\u8868\u547d\u4ee4\u3002)<\/p> \n \u65b9\u6cd52\uff1a\u5229\u7528\u8fc7\u7a0b<\/p> \n \u4e8b\u5148\u5b9a\u4e49\u7684Oracle\u8fc7\u7a0b\u4e3a\uff1a<\/p> \n \u4e0b\u9762\u662f\u5c06\u6570\u636e\u5b58\u5165\u6570\u636e\u5e93\u7684\u4ee3\u7801\uff1a<\/p> \n \r\n Dim cn As New OracleConnection("data source=site;uid=gf;pwd=macro;") \r\n cn.Open() \r\n \r\n Dim da As New OracleDataAdapter("select * from news", cn) \r\n Dim myCB As New OracleCommandBuilder(da) \r\n Dim ds As New DataSet("news") \r\n da.MissingSchemaAction = MissingSchemaAction.AddWithKey \r\n Dim fs As Stream = File1.PostedFile.InputStream 'File1\u4e3a\u6587\u4ef6\u9009\u62e9\u6846\uff0c\u4f5c\u4e3a\u670d\u52a1\u5668\u63a7\u4ef6\u4f7f\u7528 \r\n Dim mydata(fs.Length) As Byte \r\n fs.Read(mydata, 0, fs.Length) \r\n fs.Close() \r\n da.Fill(ds, "news") \r\n Dim myRow As DataRow = ds.Tables("news").NewRow \r\n myRow("newsid") = txtNewsID.Text \r\n myRow("title") = txtTitle.Text \r\n myRow("image") = mydata \r\n ds.Tables("news").Rows.Add(myRow) \r\n da.Update(ds, "news") <\/pre> \n
\r\nCREATE OR REPLACE PROCEDURE "GF"."NEWS_ADD" \r\n (in_newsid in \r\n news.newsid%type, \r\n in_title in news.title%type, \r\n in_imag in news.image%type) \r\n as \r\n begin \r\n insert into gf.news values(in_newsid,in_title,in_image); \r\n end; <\/pre> \n
\r\n Dim cn As New OracleConnection("data source=site;uid=gf;pwd=macro;") \r\n cn.Open() \r\n \r\n Dim cmd As New OracleCommand("news_add", cn) \r\n cmd.CommandType = CommandType.StoredProcedure \r\n cmd.Parameters.Add(New OracleParameter("in_newsid", OracleType.Number, 10)) \r\n cmd.Parameters("in_newsid").Value = txtNewsID.Text.Trim \r\n cmd.Parameters.Add(New OracleParameter("in_title", OracleType.VarChar, 100)) \r\n cmd.Parameters("in_title").Value = txtTitle.Text.Trim \r\n \r\n Dim fs As Stream = File1.PostedFile.InputStream \r\n Dim mydata(fs.Length) As Byte '\u5b9a\u4e49\u4e00\u4e2a\u5b57\u8282\u6570\u7ec4\u7528\u4e8e\u8bfb\u53d6\u56fe\u7247\u6d41 \r\n fs.Read(mydata, 0, fs.Length) \r\n fs.Close() \r\n \r\n cmd.Parameters.Add(New OracleParameter("in_image", OracleType.Blob)) \r\n cmd.Parameters("in_image").Value = mydata \r\n \r\n cmd.ExecuteNonQuery() \r\n \r\n cn.Close() <\/pre> \n<\/div>","orderid":"0","title":"\u5c06\u56fe\u7247\u5b58\u5165Oracle\u6570\u636e\u5e93\u7684\u65b9\u6cd5\uff08\u4ee3\u7801\u6559\u7a0b\uff09","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"127","pages":"1","comments":"0","posttime":"2018-02-13 12:56:58","list":"1518497818","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"\u56fe\u7247<\/A> \u5b58\u5165<\/A> Oracle<\/A> \u6570\u636e\u5e93<\/A> \u65b9\u6cd5<\/A> \u4ee3\u7801<\/A> \u6559\u7a0b<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"113.87.122.142","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"\u5c06\u56fe\u7247\u5b58\u5165Oracle\u6570\u636e\u5e93\u7684\u65b9\u6cd5\uff08\u4ee3\u7801\u6559\u7a0b\uff09","lastview":"1703053814","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}