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

½«Ö¸¶¨µÄ±í/ÊÓͼÖеÄÊý¾Ýµ¼³öΪ html Îļþ

IF OBJECT_ID(N'dbo.p_ExportHtml') IS NOT NULL
    DROP PROC dbo.p_ExportHtml;
GO
/*-- == µ¼³ö±í/ÊÓͼÖеÄÊý¾ÝΪhtml Îļþ======================
´Ë´æ´¢¹ý³ÌÓÃÓÚ½«Ö¸¶¨µÄ±í/ÊÓͼÖеÄÊý¾Ýµ¼³öΪ html Îļþ
ÓÉÓÚÊÇʹÓô洢¹ý³Ì, Òò´ËÎļþĿ¼»ùÓÚ sql server ·þÎñÆ÷
´æ´¢¹ý³ÌÖлáʹÓÃxp_cmdshell µ÷ÓÃbcp À´Ð´Îļþ
Òò´Ë±ØÐë´ò¿ªxp_cmdshell ¹¦ÄÜ, ¿ÉÒÔʹÓÃÏÂÃæµÄ½Å±¾ÊµÏÖ
EXEC sp_configure N'show advanced options', 1 RECONFIGURE;
EXEC sp_configure N'xp_cmdshell', 1 RECONFIGURE;
---------------------------------------------------------
-- µ÷ÓÃʾÀý
EXEC dbo.p_ExportHtml
    @object_name = N'sys.objects',
    @file_name = N'c:\test.html';
---------------------------------------------------------
-- »·¾³ÒªÇó
ÊÊÓÃÓÚsql server 2005 »òÕ߸ü¸ßµÄ°æ±¾
-- ==== ×Þ½¨2008.11(ÒýÓÃÇë±£Áô´ËÐÅÏ¢) =============== */
CREATE PROC dbo.p_ExportHtml
    @object_name sysname,
    @file_name nvarchar(260),
    @title nvarchar(1000) = NULL -- html ±êÌâ, ΪNULLʱʹÓÃ@object_name
AS
SET NOCOUNT ON;
DECLARE
    @sql_field nvarchar(max),
    @sql_body nvarchar(max);
SELECT
    @sql_field = N'',
    @sql_body = N''
SELECT
    @sql_field = @sql_field
           + N' UNION ALL SELECT field_name = N' + QUOTENAME(C.name, N''''),
    @sql_body = @sql_body
           + N', [td/@align] = '
              + QUOTENAME(
                     CASE
                         WHEN T.name LIKE N'%int'
        


Ïà¹ØÎĵµ£º

ÍêÉÆ×Ô¼ºµÄhtml parse

       ˵À´²ÑÀ¢£¬ÎÒ·¢ÏÖ×Ô¼ºÐ´µÄÄǸöhtml parse¹ýÓÚÀíÏ뻯£¬½âÎöxml»¹²î²»¶à£¬Ïë½âÎöÏÖ½ñµÄhtml£¬¹À¼ÆÊDz»´ó¿ÉÄܵģ¬ËùÒÔÎÒ°Ñ´úÂëÖØÐ´ÁËÒ»±é£¬Êý¾Ý½á¹¹¸Ä³ÉË«ÏòÁ´±í£¬ÕâÑù½âÎöËٶȸü¿ì£¬×î´ó³Ì¶ÈµØ¶Ôhtml½øÐÐÈÝ´í´¦Àí£¬ÊÔÑéʱ·¢ÏÖµÄÈ·¿ÉÒÔ½âÎöÆÕͨhtml×Ö·û´®£¬²»ÐèÒªÔÙÑϸñ·ûºÏÄǸöxhtml±ê× ......

Javascript·ÃÎÊhtmlÒ³ÃæµÄ¿Ø¼þ

·ÃÎʿؼþµÄÖ÷Òª¶ÔÏóÊÇ:document¶ÔÏó¡£·Ö±ð¶ÔÓ¦µ±Ç°ÎĵµËùÓеģ¨×Ó¶ÔÏ󣩸öÈ˹۵㡣²¢ÇÒÒѾ­ÌṩµÄ¼¸¸öÖ÷Òª·½·¨À´·ÃÎʶÔÏó¡£
1.       document.getElementById
2.       document.getElementsByName
3        &n ......

Ãæ¶ÔHTML¿Ø¼þÎÒÔÙÒ»´Î´óÒâÁË

µ±HTML¿Ø¼þµÄid="ctl00_contentPlaceHolder_ddl_academy",name="ctl00$contentPlaceHolder$ddl_academy"ʱ
Request.Form["ctl00$contentPlaceHolder$ddl_academy"]¶ø²»ÊÇ
Request.Form["ctl00_contentPlaceHolder_ddl_academy"] ......

HTML ¿ò¼Ü noframes ×÷ÓÃ

<html>
<frameset cols="25%,50%,25%">
 <frame src="/example/html/frame_a.html">
 <frame src="/example/html/frame_b.html">
 <frame src="/example/html/frame_c.html">
<noframes>
<!--  ÔÚä¯ÀÀÆ÷²»Ö§³ÖÊ ......

ÔÚHTMLÓïÑÔÖеÄMeta(ת×ÔÍøÂç)

metaÊÇÓÃÀ´ÔÚHTMLÎĵµÖÐÄ£ÄâHTTPЭÒéµÄÏìӦͷ±¨ÎÄ¡£meta ±êÇ©ÓÃÓÚÍøÒ³µÄ<he
ad>Óë</head>ÖУ¬meta ±êÇ©µÄÓô¦ºÜ¶à¡£meta µÄÊôÐÔÓÐÁ½ÖÖ£ºnameºÍhttp-equiv
¡£nameÊôÐÔÖ÷ÒªÓÃÓÚÃèÊöÍøÒ³£¬¶ÔÓ¦ÓÚcontent£¨ÍøÒ³ÄÚÈÝ£©£¬ÒÔ±ãÓÚËÑË÷ÒýÇæ»úÆ÷
È˲éÕÒ¡¢·ÖÀࣨĿǰ¼¸ºõËùÓеÄËÑË÷ÒýÇæ¶¼Ê¹ÓÃÍøÉÏ»úÆ÷ÈË×Ô¶¯²éÕÒmetaÖµÀ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ