수안이의 컴퓨터 연구실

Introduction

If your website has several pages with a similar layout it can become a pain to update using an HTML editor. What is needed is a way to automate the page generation from database tables, XML, & XSL files. By separating content and page layout for you website it is much easier to update repetitive content or easily change the style of every page. Simple content can be maintained in a database. Other content can be maintained in XML files. More complex content can be generated using your favorite HTML editor without worrying about the extras that go on the top, bottom and sides of the page. Using a program or script all the pieces can be put together to build a complete website. A batch process can be used to generate the pages to be uploaded to a server where you don't have access to server side scripting or programming. By keeping your content and style sheets modular you will be more prepare for the day when you can move your site to an ASP.NET server. Modular content will be needed when you start thinking about supporting multiple browser types, such as mobile devices and voice.

The Database

To give an idea about the tools which can be used, lets automate the creation of a side-bar menu. In this example the menu will be saved as a complete HTML file. In a real application the resulting HTML or XHTML would be inserted into the page which is being built from multiple sources. The advantage of using XHTML would be the ability to use all the XML tools in .NET for building your page.

Here is the database table which has the content for the menu.

Here is the code for reading the database table and converting it to HTML.

using System; using System.Data; using System.Data.OleDb; using System.IO; using System.Xml; using System.Xml.Xsl; namespace Menu { class CreateMenu { [STAThread] static void Main(string[] args) { string source = @"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";" + @"User ID=Admin;Data Source=C:\web\web.mdb"; string select = "SELECT * FROM MenuItem"; OleDbConnection conn = new OleDbConnection( source ); conn.Open(); OleDbDataAdapter adapter = new OleDbDataAdapter( select, conn ); DataSet ds = new DataSet(); adapter.Fill( ds ); conn.Close(); ds.Tables[0].TableName = "MenuItem"; ds.DataSetName = "Menu"; ds.WriteXml( @"C:\web\MenuText.xml" ); XmlDataDocument doc = new XmlDataDocument( ds ); XslTransform trans = new XslTransform(); trans.Load( @"C:\web\Menu.xsl" ); StreamWriter sw = new StreamWriter( @"C:\web\Menu.html" ); trans.Transform( doc, null, sw ); sw.Close(); } } }</CODE>


This code opens a connection to the database and reads the table into a DataSet.  The TableName and DateSetName are given names which will result in meaningful tags in the XML.  The DataSet is saved as XML using ds.WriteXml in case we want to take a look at it.  The DataSet is converted to an XmlDataDocument so that we can apply the transform to it.  The XSL stylesheet is loaded into the XslTransform object.  A StreamWriter is used by the XslTransform object to write the resulting HTML to a file.


The XML
Here is the XML generated by ds.WriteXml:
<?xml version="1.0" standalone="yes"?>
<Menu>
  <MenuItem>
    <ItemText>Home</ItemText>
    <ItemLink>index.html</ItemLink>
    <ItemType>Item</ItemType>
  </MenuItem>
  <MenuItem>
    <ItemText>-</ItemText>
    <ItemLink>-</ItemLink>
    <ItemType>Space</ItemType>
  </MenuItem>
  <MenuItem>
    <ItemText>Bookstore</ItemText>
    <ItemLink>-</ItemLink>
    <ItemType>H3</ItemType>
  </MenuItem>
  <MenuItem>
    <ItemText>C#</ItemText>
    <ItemLink>csharp.html</ItemLink>
    <ItemType>Item</ItemType>
  </MenuItem>
  <MenuItem>
    <ItemText>.NET</ItemText>
    <ItemLink>dotnet.html</ItemLink>
    <ItemType>Item</ItemType>
  </MenuItem>
  <MenuItem>
    <ItemText>Notebooks</ItemText>
    <ItemLink>-</ItemLink>
    <ItemType>H3</ItemType>
  </MenuItem>
  <MenuItem>
    <ItemText>C#</ItemText>
    <ItemLink>notebooks/csharp/index.html</ItemLink>
    <ItemType>Item</ItemType>
  </MenuItem>
  <MenuItem>
    <ItemText>ATL</ItemText>
    <ItemLink>-</ItemLink>
    <ItemType>H3</ItemType>
  </MenuItem>
  <MenuItem>
    <ItemText>Hello World</ItemText>
    <ItemLink>hello.html</ItemLink>
    <ItemType>Item</ItemType>
  </MenuItem>
  <MenuItem>
    <ItemText>Handling Errors</ItemText>
    <ItemLink>errors.html</ItemLink>
    <ItemType>Item</ItemType>
  </MenuItem>
</Menu>

Here is the XSL used to transform the XML into HTML:
<xsl:stylesheet
version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns="http://www.w3.org/TR/REC-html40">

<xsl:output method="html" indent="yes" />
<xsl:template match="/">
<html>
<body>
<table border="0" cellpadding="2" cellspacing="0" id="menu">
     <xsl:for-each select="Menu/MenuItem">
       <tr>
         <td height="20" nowrap="">
           <xsl:choose>
             <xsl:when test="ItemType='Item'">
               <a>
                 <xsl:attribute name="href">
                 <xsl:value-of select="ItemLink"/>
                 </xsl:attribute>
                 <font size="3">
                   <xsl:value-of select="ItemText"/>
                 </font>
               </a>
             </xsl:when>
             <xsl:when test="ItemType='H3'">
               <center>
                 <font size="4" color="#800000">
                   <b>
                     <xsl:value-of select="ItemText"/>
                   </b>
                 </font>  
               </center>
             </xsl:when>
             <xsl:when test="ItemType='H3'">
               <center>
                 <font size="3">
                   <b>
                     <xsl:value-of select="ItemText"/>
                   </b>
                 </font>  
               </center>
             </xsl:when>
           </xsl:choose> 
         </td>
       </tr>
     </xsl:for-each>
</table>
</body>
</html>
</xsl:template>

</xsl:stylesheet>


The HTML
Here is the resulting HTML:
<html xmlns="http://www.w3.org/TR/REC-html40">
  <body>
    <table border="0" cellpadding="2" cellspacing="0" id="menu">
      <tr>
        <td height="20" nowrap="">
          <a href="index.html">
            <font size="3">Home</font>
          </a>
        </td>
      </tr>
      <tr>
        <td height="20" nowrap="">
        </td>
      </tr>
      <tr>
        <td height="20" nowrap="">
          <center>
            <font size="4" color="#800000">
              <b>Bookstore</b>
            </font>
          </center>
        </td>
      </tr>
      <tr>
        <td height="20" nowrap="">
          <a href="csharp.html">
            <font size="3">C#</font>
          </a>
        </td>
      </tr>
      <tr>
        <td height="20" nowrap="">
          <a href="dotnet.html">
            <font size="3">.NET</font>
          </a>
        </td>
      </tr>
      <tr>
        <td height="20" nowrap="">
          <center>
            <font size="4" color="#800000">
              <b>Notebooks</b>
            </font>
          </center>
        </td>
      </tr>
      <tr>
        <td height="20" nowrap="">
          <a href="notebooks/csharp/index.html">
            <font size="3">C#</font>
          </a>
        </td>
      </tr>
      <tr>
        <td height="20" nowrap="">
          <center>
            <font size="3">
              <b>ATL</b>
            </font>
          </center>
        </td>
      </tr>
      <tr>
        <td height="20" nowrap="">
          <a href="hello.html">
            <font size="3">Hello World</font>
          </a>
        </td>
      </tr>
      <tr>
        <td height="20" nowrap="">
          <a href="errors.html">
            <font size="3">Handling Errors</font>
          </a>
        </td>
      </tr>
    </table>
  </body>
</html>

The ADO.NET and XML support in the .NET framework is a powerful and easy to use combination.  These tools can be used for batch generation of web pages, or used live in ASP.NET."XML" 카테고리의 다른 글
XML Tutorials, References (0)2008/05/01
Processing XML with Java - Elliotte Rusty Harold (0)2008/03/23
Using ADO.NET, XML & XSL to generate HTML (0)2007/04/29
Microsoft.XMLHTTP (0)2007/04/12
스타일시트(stylesheet)를 이용한 xml문서 표시 (0)2007/04/12

일	월	화	수	목	금	토
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	31

수안이의 컴퓨터 연구실

1 Articles, Search for 'XSL'

Using ADO.NET, XML & XSL to generate HTML

Introduction

The Database

The XML

The HTML

Trackback URL : http://www.webdizen.net/blog/trackback/2869

Leave your greetings.

Categories

Notice

Tags

Recent Articles

Recent Comments

Recent Trackbacks

Archive

Calendar

Bookmarks