數據庫中圖片存儲及讀取
2024-07-21 02:22:38
供稿：網友
中國最大的web開發資源網站及技術社區，
開發環境：window 2000、sqlserver2000、.net framework sdk正式版
開發語言：c#、asp.net
簡介：數據庫中圖片存儲及讀取
說明：在asp中，我們用request.totalbytes、request.binaryread()來上傳圖片，這個可惡的binaryread()方法非常笨，單個文件上傳倒沒什么大事，單如果多個圖片上?？删突ù髿饬α恕?！而現在asp.net中將會把解決以前asp中文件上傳的種種問題，使你在asp.net中輕輕松松開發出功能強大的上傳程序，下面大家看看例子啦。
首先在sql server中建立一個圖片存儲的數庫表，sqlscript如下:
if exists (select * from dbo.sysobjects where id = object_id(n"[dbo].[image]") and objectproperty(id, n"isusertable") = 1)
drop table [dbo].[image]
go
create table [dbo].[image] (
[img_pk] [int] identity (1, 1) not null ,
[img_name] [varchar] (50) null ,
[img_data] [image] null ,
[img_contenttype] [varchar] (50) null
) on [primary] textimage_on [primary]
go
alter table [dbo].[image] with nocheck add
constraint [pk_image] primary key nonclustered
(
[img_pk]
) on [primary]
go
------------------------------------------------------------
一、上傳圖片:
imgupload.aspx文件:
<%@ page language="c#" codebehind="imgupload.aspx.cs" autoeventwireup="false" inherits="study.uploadimage.imgupload" %>
<!doctype html public "-//w3c//dtd html 4.0 transitional//en" >
<html>
<head>
<title>imgupload</title>
<meta name="generator" content="microsoft visual studio 7.0">
<meta name="code_language" content="c#">
<meta name="vs_defaultclientscript" content="javascript">
<meta name="vs_targetschema" content="http://schemas.microsoft.com/intellisense/ie5">
</head>
<body>
<form enctype="multipart/form-data" runat="server" id="form1" name="form1">
文件名 <input type="text" id="imgname" runat="server" name="imgname">
<br>
選擇文件 <input id="uploadfile" type="file" runat="server" name="uploadfile">
<br>
<asp:button text="上傳" runat="server" id="button1" />
</form>
<a href="imgview.aspx?id=1" target="_blank">看圖</a>
</body>
</html>
codebehind文件:
using system;
using system.collections;
using system.componentmodel;
using system.data;
using system.drawing;
using system.web;
using system.web.sessionstate;
using system.web.ui;
using system.web.ui.webcontrols;
using system.web.ui.htmlcontrols;
using system.io;
using system.data.sqlclient;
namespace study.uploadimage
{
/// <summary>
/// imgupload 的摘要說明。
/// </summary>
public class imgupload : system.web.ui.page
{
protected system.web.ui.webcontrols.button button1;
protected system.web.ui.htmlcontrols.htmlinputtext imgname;
protected system.web.ui.htmlcontrols.htmlinputfile uploadfile;
private void page_load(object sender, system.eventargs e)
{
// 在此處放置用戶代碼以初始化頁面
}
private void button1_click(object sender, system.eventargs e)
{
stream imgstream;
int imglen;
string imgname_value;
string imgcontenttype;
string imguploadedname;
imgstream = uploadfile.postedfile.inputstream;
imglen = uploadfile.postedfile.contentlength;
imguploadedname = uploadfile.postedfile.filename;
byte[] imgbinarydata=new byte[imglen];
imgcontenttype = uploadfile.postedfile.contenttype;
imgname_value = imgname.value;
try
{
if(imgname_value.length < 1)
{
imgname_value = getlastrightof("http://",imguploadedname );
}
}
catch(exception myex)
{
response.write(myex.message);
}
int n = imgstream.read(imgbinarydata, 0, imglen);
int numrowsaffected = mydatabasemethod(imgname_value, imgbinarydata, imgcontenttype);
if(numrowsaffected > 0)
response.write( "<br> uploaded image " );
else
response.write ( "<br> an error occurred uploading the image.d " );
}
public string getlastrightof(string lookfor,string mystring)
{
int strpos;
strpos = mystring.lastindexof(lookfor);
return mystring.substring(strpos + 1);
}
public int mydatabasemethod(string imgname,byte[] imgbin,string imgcontenttype)
{
sqlconnection connection = new sqlconnection(application["test_conn"].tostring());
string sql="insert into image (img_name,img_data,img_contenttype) values ( @img_name, @img_data,@img_contenttype )";
sqlcommand command=new sqlcommand ( sql,connection );
sqlparameter param0=new sqlparameter ( "@img_name", sqldbtype.varchar,50 );
param0.value = imgname;
command.parameters.add( param0 );
sqlparameter param1=new sqlparameter ( "@img_data", sqldbtype.image );
param1.value = imgbin;
command.parameters.add( param1 );
sqlparameter param2 =new sqlparameter ( "@img_contenttype", sqldbtype.varchar,50 );
param2.value = imgcontenttype;
command.parameters.add( param2 );
connection.open();
int numrowsaffected = command.executenonquery();
connection.close();
return numrowsaffected;
}
#region web form designer generated code
override protected void oninit(eventargs e)
{
//
// codegen：該調用是 asp.net web 窗體設計器所必需的。
//
initializecomponent();
base.oninit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void initializecomponent()
{
this.button1.click += new system.eventhandler(this.button1_click);
this.load += new system.eventhandler(this.page_load);
}
#endregion
}
}
------------------------------------------------------------
二、瀏覽圖片：
imgvies.aspx文件：
<%@ page language="c#" codebehind="imgview.aspx.cs" autoeventwireup="false" inherits="study.uploadimage.imgview" %>
<!doctype html public "-//w3c//dtd html 4.0 transitional//en" >
<html>
<head>
<title>imgview</title>
<meta name="generator" content="microsoft visual studio 7.0">
<meta name="code_language" content="c#">
<meta name="vs_defaultclientscript" content="javascript">
<meta name="vs_targetschema" content="http://schemas.microsoft.com/intellisense/ie5">
</head>
<body ms_positioning="gridlayout">
</body>
</html>
codebehind文件：
using system;
using system.collections;
using system.componentmodel;
using system.data;
using system.drawing;
using system.web;
using system.web.sessionstate;
using system.web.ui;
using system.web.ui.webcontrols;
using system.web.ui.htmlcontrols;
using system.data.sqlclient;
namespace study.uploadimage
{
/// <summary>
/// imgview 的摘要說明。
/// </summary>
public class imgview : system.web.ui.page
{
private void page_load(object sender, system.eventargs e)
{
sqlconnection mydsn = new sqlconnection(application["test_conn"].tostring());
mydsn.open();
int imgid = int.parse(request.querystring["id"]);
string sqltext = "select img_name, img_data, img_contenttype from image where img_pk=" + imgid;
trace.write(sqltext);
sqlcommand mycommand = new sqlcommand (sqltext, mydsn);
sqldatareader dr =mycommand.executereader();
if(dr.read())
{
response.contenttype = (dr["img_contenttype"].tostring());
response.binarywrite((byte[])dr["img_data"]);
}
mydsn.close();
}
#region web form designer generated code
override protected void oninit(eventargs e)
{
//
// codegen：該調用是 asp.net web 窗體設計器所必需的。
//
initializecomponent();
base.oninit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void initializecomponent()
{
this.load += new system.eventhandler(this.page_load);
}
#endregion
}
}
這樣這個程序就完成了，簡單吧。當然還很多改進之處，希望大家多想想多編編一定可以寫出更多的圖象上傳程序。
