将图片保存到表中并用ajax技术获取图片

来源：互联网发布：卡密授权系统源码编辑：程序博客网时间：2024/06/14 18:21

创建用于保存图片的表：

create table stockImages( imageid int primary key identity(1,1), [filename] varchar(50), img varbinary(max))

插入本地图片：

insert into stockImagesselect '风景',bulkcolumnfrom openrowset(bulk 'd://img.jpg',single_blob) as x

创建存储过程，检索图片，将二进制数据包含在XML文档片段中：

create proc getImage @id int as declare @xmlResult xml set @xmlResult=(select * from stockImages where imageid=@id for xml auto,elements,root('Items'),binary base64) select @xmlResult

使用一般处理文件获取检索到得XML文档并发送到客户端：

<%@ WebHandler Language="C#" Class="ImageHandler" %>using System;using System.Web;using System.Data;using System.Data.SqlClient;using System.Configuration;using System.Xml;public class ImageHandler : IHttpHandler { public void ProcessRequest (HttpContext context) { string connectionString = ConfigurationManager.ConnectionStrings[ "uploadConnectionString"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("getImage", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@id", SqlDbType.Int).Value = context.Request.QueryString["id"]; try { connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { context.Response.ContentType = "text/xml"; context.Response.Write(reader.GetSqlXml(0).Value); } reader.Close(); } finally { connection.Close(); } } public bool IsReusable { get { return false; } }}

客户端获取从服务器端发送来的XML文档片度从中获取二进制数据并显示（显示二进制图片，IE6及IE7不支持，Firefox完全支持）：

<%@ Page Language="C#" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><mce:script runat="server"></mce:script><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>无标题页</title> <mce:script type="text/javascript"></mce:script></head><body> <form id="form1" runat="server"> <div> </div> <br /> <input type="button" onclick="sendRequest();" value="getImage" /> <br /> <img src="" id="binaryImage" style=" display:none;" mce_style=" display:none;" alt="" /> </form></body></html>