Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚ¶ÁÈ¡Êý¾Ý¿â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ÀàÐ͵쬵«ÊǾÍÊÇÔÚÒ³ÃæÉÏÏÔʾ²»³öÀ´£¬Ôõô»ØÊ£¿£¿

ÆäʵÕâ¾ÍÊÇÑéÖ¤ÂëͼƬµÄÏÔʾԭÀí

ÕâÑùÒ²¿´²»¼û¹þ

ûÈËÖªµÀÂ𣿣¿£¿£¿£¿£¿£¿£¿
{{--


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

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 ......

Çóc#²Ù×÷sqlserverÊý¾Ý¿âÎÊÌâ

ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......

Çósqlserver 2005 Êý¾Ý¿âÁ¬½Ó½â¾öÎÊÌâ¡£

ÏÖÔÚÎҵı¾»úÊÇÓõÄsqlserver2000°æ±¾µÄ(¿ÉÒÔÕý³£µÄÁ¬½Ó)¡£Êý¾ÝÁ¬½ÓÈçÏ£ºproxool.xml
XML code:

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
......

sqlserverÁÙʱ±í

exec('select * into #aaa from Base_Email' )

select * from #aaa

drop table #aaa


(48 ÐÐÊÜÓ°Ïì)
ÏûÏ¢ 208£¬¼¶±ð 16£¬×´Ì¬ 0£¬µÚ 4 ÐÐ
¶ÔÏóÃû '#aaa' ÎÞЧ¡£
......

sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ

    sqlServerͨ¹ýpowerDesignerÄæÏò¹¤³ÌΪʲô±¨´íÎóÄØ£¿µ«ÊÇ´ò¿ªÒ»¸öÔø¾­´Óaccess·´ÏòµÃµ½µÄpdmºó£¬ÔÙת»»µ½´ËpdmÀï²»»á±¨´íÎ󣬵«ÊÇ´ò¿ªÆäËûpdm»òÕßн¨Ò»¸öpdm,¶¼»á±¨ÏÂÃæ´íÎó£¬Çë´ó¼Ò°ïÎÒ¿´¿´°É£¬Ê®· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ