½«Í¼Æ¬±£´æµ½±íÖв¢ÓÃajax¼¼Êõ»ñȡͼƬ
´´½¨ÓÃÓÚ±£´æÍ¼Æ¬µÄ±í£º
create table stockImages
( imageid int primary key identity(1,1),
[filename] varchar(50),
img varbinary(max))
²åÈë±¾µØÍ¼Æ¬£º
insert into stockImages
select '·ç¾°',bulkcolumn
from 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())
Ïà¹ØÎĵµ£º
×î½üÍøÉÏÌáµÄºÜ¶àµÄÒ»¸öиÅÄî¾ÍÊÇ AJAX ÁË, ÄÇô, AJAX ÊÇÊ²Ã´ÄØ? ÒÔÏÂÄÚÈÝÒýÓÃÍøÉÏ×ÊÁÏ:
AJAXÈ«³ÆÎª“Asynchronous JavaScript and XML”£¨Òì²½JavaScriptºÍXML£©£¬ÊÇÖ¸Ò»ÖÖ´´½¨½»»¥Ê½ÍøÒ³Ó¦ÓõÄÍøÒ³¿ª·¢¼¼Êõ¡£ËüÓлúµØ°üº¬ÁËÒÔϼ¸ÖÖ¼¼Êõ£º
Ajax£¨Asynchronous JavaScript + XML£©µÄ¶¨Òå
»ùÓÚ web±ê×¼£¨sta ......
±ê×¼XMLHttpRequest²Ù×÷
abort()
Í£Ö¹µ±Ç°ÇëÇó
getAllResponseHeaders()
°ÑHTTPÇëÇóµÄËùÓÐÏìÓ¦Êײ¿×÷Ϊ¼ü/Öµ¶Ô·µ»Ø
getResponseHeader("header")
·µ»ØÖ¸¶¨Êײ¿µÄ´®Öµ
void open(string method, string url, boolean asynch)
½¨Á¢¶Ô·þÎñÆ÷µÄµ÷Óá£method²Î ......
AJAX¼¼Êõ½éÉÜ
AJAX µÄÈ«³ÆÖ¸Òì²½µÄ JavaScript ¼° XML£¨Asynchronous JavaScript And XML£©
ÔÚѧϰAJAX֮ǰ£¬ÄãÐèÒªÁ˽âµÄ֪ʶÓУº
HTML / XHTML
JavaScript
µ±È»»¹ÓÐһЩÆäËûµÄ¼¼Êõ£ºCSS¡¢DOM¡¢XML¡¢XMLHttpRequest
AJAX ²»ÊÇÒ»ÖÖеıà³ÌÓïÑÔ£¬¶øÊÇÒ»ÖÖÓÃÓÚ´´½¨¸üºÃ¸ü¿ìÒÔ¼°½»»¥ÐÔ¸üÇ¿µÄ Web Ó¦ÓóÌÐòµÄ¼¼Êõ¡£
ͨ¹ ......
JSON²å¼þÌṩÁËÒ»ÖÖÃûΪjsonµÄResultType£¬Ò»µ©ÎªÄ³¸öActionÖ¸¶¨ÁËÒ»¸öÀàÐÍΪjsonµÄResult£¬Ôò¸ÃResultÎÞÐèÓ³Éäµ½ÈκÎÊÓͼ×ÊÔ´¡£ÒòΪJSON²å¼þ»á¸ºÔð½«ActionÀïµÄ״̬ÐÅÏ¢ÐòÁл¯³ÉJSON¸ñʽµÄÊý¾Ý£¬²¢½«¸ÃÊý¾Ý·µ»Ø¸ø¿Í»§¶ËÒ³ÃæµÄJavaScript¡£
¡¡¡¡¼òµ¥µØËµ£¬JSON²å¼þÔÊÐíÎÒÃÇÔÚJavaScriptÖÐÒì²½µ÷ÓÃAction£¬¶øÇÒAction²»ÔÙÐè ......
ÔÚAjax url´«²Îʱ³öÏÖÖÐÎÄÂÒÂëµÄÇé¿ö
Àý1: xmlHttp.open("GET","Engine.aspx?Action=getmainsort&Type=2&Parent="+escape("ÖÐÎÄ")+"&Stochastic=" + Math.random(),true);
µ«ÊÇÕâ¸öÖ»ÄÜÆÕͨµÄ<a href=''.ÓÐЧ¹û¡£Èç¹ûÊÇajax´«ÖµµÄ»°»¹ÊDz»ÐеÄ...ÓÐÈËÌá³ö:Òª ......