欢迎光临
我们一直在努力
当前位置：IDC资讯中心 > 操作系统 > Linux教程 > 正文

xslt的简单使用[xml–>html] _xsl教程

2007-08-24 分类：Linux教程 阅读(1151) 评论(0)
建站超值云服务器，限时71元/月

XSLT命令[xml格式转换]
1.循环 <xsl:for-each…>
<xsl:for-each select=”BookList/Item”>
<tr>
<th align=”left”> <xsl:value-of select=”.//title” /></th>
<td><xsl:value-of select=”.//categroy” /></td>
<td><xsl:value-of select=”.//release-date” /></td>
<td><xsl:value-of select=”.//author” /></td>
<td><xsl:value-of select=”@price” /></td>
</tr>
</xsl:for-each>
2.排序 <xsl:sort…>
3.条件处理 <xsl:if…>或<xsl:choose…>或<xsl:when…>
4.名称模板
<xsl:template name…<xsl:template name…>,<xsl:param…>
<xsl:with-param…>,<xsl:call-template…>
5.编号方式 <xsl:number value format…>


xml文档[Article.xml] <?xml version=”1.0″ encoding=”gb2312″ ?>
<?xml-stylesheet type=text/xsl href=Article.xsl?>
<Articles>
<Article>
<ArticleID>2897</ArticleID>
<Title>[分享]千万数量级分页存储过程（带效果演示）</Title>
<Author>网络</Author>
<Abstract>[分享]千万数量级分页存储过程（带效果演示）</Abstract>
<PostDateTime>2006-02-27 18:29:53</PostDateTime>
<Dots>7</Dots>
<ColumnURL>/web/Article/viewColumn.aspx?ColID=19</ColumnURL>
<ColumnID>19</ColumnID>
<ColumnName>SQL Server</ColumnName>
<FileType>1</FileType>
<FilePath>resource/sql server/2006-02-27/20060227182953.htm</FilePath>
<Editor>网络</Editor>
<EditDateTime>2006-02-27 18:29:53</EditDateTime>
<Content>
  [分享]千万数量级分页存储过程（带效果演示）效果演示：
http://www.cn5135.com/_App/Opportunities/QueryResult.aspx
CREATE PROCEDURE CN5135_SP_Pagination
/******************************************************************
千万数量级分页存储过程
*******************************************************************
参数说明:
1.Tables :表名称,视图
2.PrimaryKey :主关键字
3.Sort :排序语句，不带Order By 比如：NewsID Desc,OrderRows Asc
4.CurrentPage :当前页码
5.PageSize :分页尺寸
6.Filter :过滤语句，不带Where
7.Group :Group语句,不带Group By
效果演示：http://www.cn5135.com/_App/Opportunities/QueryResult.aspx
***************************************************************/
(
@Tables varchar(1000),
@PrimaryKey varchar(100),
@Sort varchar(200) = NULL,
@CurrentPage int = 1,
@PageSize int = 10,
@Fields varchar(1000) = *,
@Filter varchar(1000) = NULL,
@Group varchar(1000) = NULL
)
AS
/*默认排序*/
IF @Sort IS NULL OR @Sort =
SET @Sort = @PrimaryKey
DECLARE @SortTable varchar(100)
DECLARE @SortName varchar(100)
DECLARE @strSortColumn varchar(200)
>DECLARE @operator char(2)
DECLARE @type varchar(100)
DECLARE @prec int
/*设定排序语句.*/
IF CHARINDEX(DESC,@Sort)&gt;0
BEGIN
SET @strSortColumn = REPLACE(@Sort, DESC, )
SET @operator = &lt;=
END
ELSE
BEGIN
IF CHARINDEX(ASC, @Sort) = 0
SET @strSortColumn = REPLACE(@Sort, ASC, )
SET @operator = &gt;=
END
IF CHARINDEX(., @strSortColumn) &gt; 0
BEGIN
SET @SortTable = SUBSTRING(@strSortColumn, 0, CHARINDEX(.,@strSortColumn))
SET @SortName = SUBSTRING(@strSortColumn, CHARINDEX(.,@strSortColumn) + 1, LEN(@strSortColumn))
END
ELSE
BEGIN
SET @SortTable = @Tables
SET @SortName = @strSortColumn
END
SELECT @type=t.name, @prec=c.prec
FROM sysobjects o
JOIN syscolumns c on o.id=c.id
JOIN systypes t on c.xusertype=t.xusertype
WHERE o.name = @SortTable AND c.name = @SortName
IF CHARINDEX(char, @type) &gt; 0
SET @type = @type + ( + CAST(@prec AS varchar) + )
DECLARE @strPageSize varchar(50)
DECLARE @strStartRow varchar(50)
DECLARE @strFilter varchar(1000)
DECLARE @strSimpleFilter varchar(1000)
DECLARE @strGroup varchar(1000)
/*默认当前页*/
IF @CurrentPage &lt; 1
SET @CurrentPage = 1
/*设置分页参数.*/
SET @strPageSize = CAST(@PageSize AS varchar(50))
SET @strStartRow = CAST(((@CurrentPage – 1)*@PageSize + 1) AS varchar(50))
/*筛选以及分组语句.*/
IF @Filter IS NOT NULL AND @Filter !=
BEGIN
SET @strFilter = WHERE + @Filter +
SET @strSimpleFilter = AND + @Filter +
END
ELSE
BEGIN
SET @strSimpleFilter =
SET @strFilter =
END
IF @Group IS NOT NULL AND @Group !=
SET @strGroup = GROUP BY + @Group +
ELSE
SET @strGroup =
/*执行查询语句*/
EXEC(

DECLARE @SortColumn + @type +
SET ROWCOUNT + @strStartRow +
SELECT @SortColumn= + @strSortColumn + FROM + @Tables + @strFilter + +
@strGroup + ORDER BY + @Sort +
SET ROWCOUNT + @strPageSize +
SELECT + @Fields + FROM + @Tables + WHERE + @strSortColumn + @operator
+ @SortColumn + @strSimpleFilter + + @strGroup + ORDER BY + @Sort +

)
GO
 <!–<![CDATA[]]>–>
</Content>
<Remarks>
<Remark PostUserName=”guest” PostDateTime=”2006-04-10 15:26:22″>
<PostUserNickName>
访客
</PostUserNickName>
<Content>
OK!
</Content>
</Remark>
<Remark PostUserName=”test” PostDateTime=”2006-04-10 09:18:35″>
<PostUserNickName>
游客
</PostUserNickName>
<Content>
good
</Content>
</Remark>
<Remark PostUserName=”dream” PostDateTime=”2006-04-10 08:45:35″>
<PostUserNickName>
dream
</PostUserNickName>
<Content>
不错!
</Content>
</Remark>
<Remark PostUserName=”no3″ PostDateTime=”2006-04-8 15:10:45″>
<PostUserNickName>
梦幻3号
</PostUserNickName>
<Content>
看看
</Content>
</Remark>
<Remark PostUserName=”admin” PostDateTime=”2006-04-08 12:12:35″>
<PostUserNickName>


</PostUserNickName>
<Content>
去试试
</Content>
</Remark>
<Remark PostUserName=”Peter” PostDateTime=”2006-03-15 16:12:35″>
<PostUserNickName>
peterzb
</PostUserNickName>
<Content>


</Content>
</Remark>
</Remarks>
</Article>
</Articles>
xslt文档[Article.xsl]
<?xml version=”1.0″ encoding=”gb2312″ ?>
<xsl:stylesheet version=”1.0″ xmlns:xsl=”http://www.w3.org/1999/XSL/Transform“>
<xsl:output indent=”yes” method=”html” />
<xsl:template match=”/”>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=GB2312″ />
 <title>
 <xsl:value-of select=”Articles/Article/Title” />
 </title>
 <link REL=Stylesheet HREF=/web/resource/bbs.css TYPE=text/css />
 <style>
.title0 {font-size:17px;font-family:arial;font-weight:bold;text-decoration:none;color:#FFFFFF;}
A.title2:link {COLOR: #000000; TEXT-DECORATION: none}
A.title2:visited {COLOR: #000000; TEXT-DECORATION: none}
A.title2:active {COLOR: #ff0000; TEXT-DECORATION: none}
A.title2:hover {COLOR: #ff0000; TEXT-DECORATION: none}
DIV.post {
    BORDER-RIGHT: #6e8bde 1px solid; BORDER-TOP: #6e8bde 1px solid; MARGIN-BOTTOM: 3px; BORDER-LEFT: #6e8bde 1px solid; BORDER-BOTTOM: #6e8bde 1px solid; BACKGROUND-COLOR: #f0eedf
}
DIV.postTitle {
    PADDING-LEFT: 3px; FONT-WEIGHT: bolder; FONT-SIZE: 13px; PADDING-BOTTOM: 3px; PADDING-TOP: 3px; BORDER-BOTTOM: #6e8bde 1px dashed; BACKGROUND-COLOR: #d6dff7
}
DIV.postText {
    PADDING-RIGHT: 10px; MARGIN-TOP: 10px; PADDING-LEFT: 10px; FONT-SIZE: 13px; MARGIN-BOTTOM: 10px; PADDING-BOTTOM: 5px; PADDING-TOP: 1px; BACKGROUND-COLOR: whitesmoke
}
</style>
</head>
<body>
<table width=”800px” border=”0″ cellpadding=”0″ cellspacing=”0″>
<tr>
<td width=”97″>
    <a href=”/web/Article/ViewColumn.aspx?Colid=7″ target=”_blank”>VB</a>/<a href=”/web/Article/ViewColumn.aspx?Colid=11″ target=”_blank”>
        VBScript</a>
</td>
<td width=”13%”><a href=”/web/Article/ViewColumn.aspx?Colid=12″ target=”_blank”>ASP</a>/
    <a href=”/web/Article/ViewColumn.aspx?Colid=13″ target=”_blank”>ASP.NET</a>
</td>
<td width=”13%”>
    <a href=”/web/Article/ViewColumn.aspx?Colid=5″ target=”_blank”>C#</a>
</td>
<td width=”51″>
    <a href=”/web/Article/ViewColumn.aspx?Colid=30″ target=”_blank”>J#</a>
</td>
<td width=”15%”>
    <a href=”/web/Article/ViewColumn.aspx?Colid=20″ target=”_blank”>ADO</a>/<a href=”/web/Article/ViewColumn.aspx?Colid=21″ target=”_blank”>
        ADO.NET</a></td>
<td width=”17%”>
    <a href=”/web/Article/ViewColumn.aspx?Colid=9″ target=”_blank”>JAVA</a>/<a href=”/web/Article/ViewColumn.aspx?Colid=10″ target=”_blank”>
        JavaScript</a></td>
<td width=”11%”>
    <a href=”/web/Article/ViewColumn.aspx?Colid=14″ target=”_blank”>HTML</a>/<a href=”/web/Article/ViewColumn.aspx?Colid=15″ target=”_blank”>
        XML</a></td>
<td width=”12%”>
    <a href=”/web/default.aspx” target=”_blank”>返回首页</a></td>
</tr>
<tr>
<td width=”97″><a href=”/web/Article/ViewColumn.aspx?Colid=16″ target=”_blank”>CSS</a></td>
<td><a href=”/web/Article/ViewColumn.aspx?Colid=3″ target=”_blank”>C</a>/<a href=”/web/Article/ViewColumn.aspx?Colid=4″ target=”_blank”>
        C++</a></td>
<td><a href=”/web/Article/ViewColumn.aspx?Colid=6″ target=”_blank”>Delphi</a></td>
<td width=”51″>
    <a href=”/web/Article/ViewColumn.aspx?Colid=30″ target=”_blank”>PHP</a></td>
<td>
    <a href=”/web/Article/ViewColumn.aspx?Colid=5″ target=”_blank”>.NET</a></td>
<td>
    <a href=”/web/resource/CSDN/CSDN论坛精华.html” target=”_blank”>CSDN论坛精华</a></td>
<td>
    <a href=”/web/Article/ViewColumn.aspx?Colid=19″ target=”_blank”>Database</a></td>
<td><a href=”#” onClick=”javascript:window.external.addFavorite(/web/Article.aspx, Dream .NET)”>加入收藏</a>
</td>
</tr>
<tr>
<td width=”97″>
    <a href=”/web/Note/notes.aspx?function=all” target=”_blank”>GuestBook </a>
</td>
<td><a href=”/web/bbs/bbs.aspx”>BBS</a>
</td>
<td><a href=”/web/Article/ViewColumn.aspx?Colid=22″ target=”_blank”>PowerBuilder</a></td>
<td width=”51″></td>
<td><a href=”/web/Article/ViewColumn.aspx?Colid=24″ target=”_blank”> Novel</a></td>
<td></td>
<td><A href=”#” onclick=”javascript:window.external.addFavorite(/web/Article.aspx, Dream .NET)”>
    </A>
</td>
<td>
    <A href=”mailto:web-network@163.com?subject=About Dream .NET Web System”>联系我们</A></td>
</tr>
<tr>
<td width=”150px”>
<a href=”/web/Article/postArticle.aspx”><img src=”http://www.knowsky.com//web/images/post.gif” border=”0″ alt=”【发表文章】” />【发表文章】</a>
</td>
<td width=”200px” colspan=”2″>
<a href=”/web/Article/postArticle.aspx”><img src=”http://www.knowsky.com//web/images/up.gif” border=”0″  alt=”【上传文章】” />【上传文章】</a>
</td> </tr>
</table>
<table width=”800px” border=”0″ cellpadding=”0″ cellspacing=”0″>
<xsl:apply-templates />
<tr>
<td align=”center”><a href=”javascript:window.print()”><img src=”http://www.knowsky.com//web/images/print.jpg” alt=【打印此文】 border=”0″ /></a>
     <a href=”javascript:window.close();”><img src=”http://www.knowsky.com//web/images/close.jpg” alt=【关闭窗口】 border=”0″ /></a>
</td>
</tr>
</table>
<table width=”800px” border=”0″ cellpadding=”0″ cellspacing=”0″>
    <tr>
    <td valign=”top”>
    <hr size=”1″ class=”hrc” color=”blue”></hr>
    <table align=”center” cellpadding=”0″ cellspacing=”0″ ID=”Table1″>
    <tr>
    <td>
    <a href=”/web/about.htm”>网站简介</a> | <a href=”/web/partner.htm”>合伙伙伴</a> | <a href=”/web/map.htm”>
    网站地图</a> | <a href=”/web/contract.aspx”>联系方式</a><br></br>
    </td>
    </tr>
</table>
</td>
</tr>
</table>
</body>
</html>
</xsl:template>
<xsl:template match=”Articles”>
<xsl:apply-templates />
</xsl:template>
<xsl:template match=”Article”>
<tr>
<td height=”25″ align=”left”>
您当前所在位置为:<A href=”/web/default.aspx”>首页</A>—&gt;
<A href=”/web/Article/default.aspx”>
文章系统</A>—&gt;
<xsl:element name=”a”>
<xsl:attribute name=”href”>
/web/Article/viewArticle.aspx?ColID=<xsl:value-of select=”ColumnID” />
<!–
<xsl:choose>
<xsl:when test=”ColumnID=19″>
/web/Article/viewArticle.aspx?ColID=19
</xsl:when>
<xsl:when test=”ColumnID=5″>
/web/Article/viewArticle.aspx?ColID=5
</xsl:when>
<xsl:otherwise>
/web/Article/viewArticle.aspx?ColID=0
</xsl:otherwise>
</xsl:choose>
–>
</xsl:attribute>
<xsl:attribute name=”title”>
<xsl:value-of select=”ColumnName” />
</xsl:attribute>
<xsl:value-of select=”ColumnName” />
</xsl:element>
—&gt;<xsl:value-of select=”Title” /></td>
</tr>
<tr>
    <td height=”25″ align=”center”>标题:<xsl:value-of select=”Title” />
    [点击数:<xsl:value-of select=”Dots” />]</td>
</tr>
<tr>
    <td height=”25″ valign=”top” align=”center”>作者:<xsl:value-of select=”Author” />
    [<xsl:value-of select=”PostDateTime” />]</td>
</tr>
<tr>
    <td height=”25″ valign=”top” align=”center”>最近修改者:<xsl:value-of select=”Editor” />
    [<xsl:value-of select=”EditDateTime” />]</td>
</tr>
<tr>
    <td height=”25″ valign=”top” align=”center” class=”WithBreaks”>概述:<xsl:value-of select=”Abstract” /></td>
</tr>
<tr>
    <td height=”25″ valign=”top” align=”center”>正文如下:</td>
</tr>
<tr>
    <td><pre><xsl:value-of select=”Content” /></pre></td>
</tr>
<xsl:apply-templates select=”/Articles/Article/Remarks” />
</xsl:template>
<xsl:template match=”Remarks”>
<tr><td>
<table width=”800px” border=”0″ cellpadding=”0″ cellspacing=”0″>
<th align=”left”><h3>Feedback</h3></th>
<xsl:for-each select=”Remark”>
<div class=”post”>           
<tr>
   <div class=”postTitle”>
   <td>
   回复人：<b>
   <font color=”#3366CC”>
   <xsl:value-of select=”@PostUserName” />
   (<xsl:value-of select=”PostUserNickName” />)
   </font>
   </b>
   </td>
   <td align=”right”>
   <font color=”#000000″>
   <xsl:value-of select=”@PostDateTime” />
   </font>  
   第<font color=”red”><xsl:number value=”position()” format=”1″/></font>楼
   </td>
   </div>
</tr>
<tr>
<td colspan=”2″>
<div class=”postText”>
<xsl:value-of select=”Content” />
</div>               
</td>
</tr>
</div>
</xsl:for-each>
</table></td></tr>
</xsl:template>
</xsl:stylesheet>

赞(0)
版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com 特别注意：本站所有转载文章言论不代表本站观点！ 本站所提供的图片等素材，版权归原作者所有，如需使用，请与原作者联系。未经允许不得转载：IDC资讯中心 » xslt的简单使用[xml–>html] _xsl教程
分享到： 更多 (0)

相关推荐

热门标签

ldquo (1370)win (1324)活动 (1166)ios (1162)rdquo (818)微信 (747)iphone (728)小米 (722)windows (706)手机 (698)酷跑 (686)飞车 (540)天天 (492)qq (491)网站 (457)全民 (442)discuz (408)充值 (389)安装 (368)更新 (321)华为 (300)浏览器 (292)支付宝 (289)三星 (266)note (264)教程 (262)预览版 (261)小编 (258)越狱 (254)linux (248)

热门文章

分类目录