110,535
社区成员
发帖
与我相关
我的任务
分享
//HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
// request.Method = "get";
// request.ContentType = "text ml";
// request.Timeout = 30 * 1000;
// byte[] buffer = new byte[1024];
// using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
// {
// using (Stream reader = response.GetResponseStream())
// {
// reader.ReadTimeout = 30 * 1000;
// using (MemoryStream memory = new MemoryStream())
// {
// int index = 1;
// int sum = 0;
// while (index > 0 && sum < 100 * 1024)
// {
// index = reader.Read(buffer, 0, 1024);
// if (index > 0)
// {
// memory.Write(buffer, 0, index);
// byte[] bytes = memory.ToArray();
// sum += index;
// }
// }
// }
// }
// }
String updateSql = "update dbhtml_img set IMG=:bytes where ZT_ID='321'";
OracleCommand oraComm = new OracleCommand(updateSql, con);
oraComm.Parameters.Add(":bytes", OracleType.Blob);//添加参数
oraComm.Parameters[":bytes"].Value = bytes;//为参数赋值
oraComm.ExecuteNonQuery();
oraComm.Parameters.Add("@bytes", OracleType.Blob);//添加参数
oraComm.Parameters["@bytes"].Value = bytes;//为参数赋值
string imgpath = UrlImg(imgurl);
FileWebRequest request = (FileWebRequest)WebRequest.Create(imgpath);
FileWebResponse response = (FileWebResponse)request.GetResponse();
//获得图片的流
Stream resStream = response.GetResponseStream();
byte[] bytes = new byte[resStream.Length];
int numBytesToRead = (int)resStream.Length;
int numBytesRead = 0;
while (numBytesToRead > 0)
{
int n = resStream.Read(bytes, numBytesRead, numBytesToRead);
if (n == 0)
break;
numBytesRead += n;
numBytesToRead -= n;
}
resStream.Close();
clsDataBase dataBase = new clsDataBase();
//写到数据库的方法
dataBase.InputDataBase(bytes);
public void InputDataBase(byte[] buf)
{
Con();
try
{
byte[] bytes =buf;
String updateSql = "update dbhtml_img set IMG=:bytes where ZT_ID='110'";
OracleCommand oraComm = new OracleCommand(updateSql,con);
oraComm.Parameters.Add(":bytes", OracleType.Blob);//添加参数
oraComm.Parameters[":bytes"].Value = bytes;//为参数赋值
oraComm.ExecuteNonQuery();
}
catch { }
finally
{
cmd.Connection.Close();
cmd.Connection.Dispose();
}