¹ØÓÚ¶ÁÈ¡Êý¾Ý¿âsqlserver imageÀàÐÍ
Response.Clear();
Response.ContentType = "image/jpeg";
string idCard = Request.QueryString["id"];
if (!string.IsNullOrEmpty(idCard))
{
PersonalInfoManager manager = new PersonalInfoManager();
PersonalInfo info = manager.SelectPersonalInfoByIdCard(idCard);
if(info.Photo!=null&&info.Photo.Length>0)
Response.OutputStream.Write(info.Photo,0, info.Photo.Length);
}
Response.End();
¾¹ýµ÷ÊÔ²éѯ³öÀ´ÓÐÊý¾Ý£¬ÇÒ´æµ½Êý¾Ý¿âµÄͼƬΪjpgÀàÐ͵쬵«ÊǾÍÊÇÔÚÒ³ÃæÉÏÏÔʾ²»³öÀ´£¬Ôõô»ØÊ£¿£¿
ÆäʵÕâ¾ÍÊÇÑéÖ¤ÂëͼƬµÄÏÔʾÔÀí
ÕâÑùÒ²¿´²»¼û¹þ
ûÈËÖªµÀÂ𣿣¿£¿£¿£¿£¿£¿£¿
{{--
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
ÏÖÔÚÎҵı¾»úÊÇÓõÄsqlserver2000°æ±¾µÄ(¿ÉÒÔÕý³£µÄÁ¬½Ó)¡£Êý¾ÝÁ¬½ÓÈçÏ£ºproxool.xml
XML code:
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
......
exec('select * into #aaa from Base_Email' )
select * from #aaa
drop table #aaa
(48 ÐÐÊÜÓ°Ïì)
ÏûÏ¢ 208£¬¼¶±ð 16£¬×´Ì¬ 0£¬µÚ 4 ÐÐ
¶ÔÏóÃû '#aaa' ÎÞЧ¡£
......
sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ£¿µ«ÊÇ´ò¿ªÒ»¸öÔø¾´Óaccess·´ÏòµÃµ½µÄpdmºó£¬ÔÙת»»µ½´ËpdmÀï²»»á±¨´íÎ󣬵«ÊÇ´ò¿ªÆäËûpdm»òÕßн¨Ò»¸öpdm,¶¼»á±¨ÏÂÃæ´íÎó£¬Çë´ó¼Ò°ïÎÒ¿´¿´°É£¬Ê®· ......