transform xml to html with through xslt

[email protected] · December 22nd, 2015, 12:29 AM

Good Day,
I am unable to transform below xml to html format.

Input XML

<?xml version="1.0" encoding="UTF-8"?>
<L7j:jdbcQueryResult xmlns:L7j="http://ns.l7tech.com/2012/08/jdbc-query-result">
<L7j:row>
<L7j:col name="name" type="java.lang.String">Test-1</L7j:col>
<L7j:col name="comment" ><![CDATA[NULL]]></L7j:col><L7j:col name="version" type="java.lang.Integer">23</L7j:col></L7j:row>
<L7j:row><L7j:col name="name" type="java.lang.String">Test-2</L7j:col><L7j:col name="comment" ><![CDATA[NULL]]></L7j:col><L7j:col name="version" type="java.lang.Integer">18</L7j:col></L7j:row>
</L7j:jdbcQueryResult>

OutPut :Format in HTML

Example:In HTML table format

Name version comment
----------------------------------
Test-1 23 null
Test-2 18 text-233

It will be great if any one can provide me xsl ,how to transform?

Thanks in advance
Vishwas

samjudson · December 22nd, 2015, 03:57 AM

Top post in this forum gives some great hints and tips on making a great post:

Hints for a good XSLT post

Specifically - what have you tried so far - what does your XSLT look like.

Also read the bit about namespaces, as you are using them.

Sam

mhkay · December 22nd, 2015, 05:25 AM

To add what Sam says, we're happy to help if we know what your problem is, but we're not here to do your job for you.

[email protected] · December 22nd, 2015, 10:57 PM

#samjudson:Thanks

#mhkay:
I am not asking you to do my job.I will solve this issue my self.
Thanks ur response.

samjudson · December 23rd, 2015, 11:22 AM

Quote:

It will be great if any one can provide me xsl ,how to transform?

You did just ask for the XSLT, without showing us what you've tried before, implying you want us to do the work for you.

If you want us to help you we need to know what you know so far, where you might be making mistakes or not fully understanding something.

[email protected] · December 27th, 2015, 10:12 PM

Hi Sam,
Please find below my code:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:L7j="http://ns.l7tech.com/2012/08/jdbc-query-result">
 
<xsl:template match="/">
  <html>
  <body>
  <h2>My CD Collection</h2>
  <table border="1">
    <tr bgcolor="#9acd32">
      <th>Name</th>
      <th>Comment</th>
      <th>Version</th>
    </tr>
    <xsl:for-each select="L7j:jdbcQueryResult/L7j:row/L7j:col">
    
 
        <tr>
<xsl:if test="@name ='name'">  
            <td><xsl:value-of select="."/></td>
         
</xsl:if>  
  <xsl:if test="@name ='comment'">  
            <td><xsl:value-of select="."/></td>
         
</xsl:if>  
<xsl:if test="@name ='version'">  
            <td><xsl:value-of select="."/></td>
         
</xsl:if>  
           
  
</tr>
    </xsl:for-each>
  </table>
  </body>
  </html>
</xsl:template>
 
</xsl:stylesheet>

Input xml is:
<?xml version="1.0" encoding="UTF-8"?>
<L7j:jdbcQueryResult xmlns:L7j="http://ns.l7tech.com...bc-query-result">
<L7j:row>
<L7j:col name="name" type="java.lang.String">Policy for service #0b8bab6913cc588557b6973e94d1bfdd, WSTrustSoapService</L7j:col>
<L7j:col name="comment" ><![CDATA[NULL]]></L7j:col><L7j:col name="version" type="java.lang.Integer">18</L7j:col></L7j:row>

<L7j:row><L7j:col name="name" type="java.lang.String">Policy for service #0b8bab6913cc588557b6973e94d5893d, UUPRStub</L7j:col><L7j:col name="comment" ><![CDATA[NULL]]></L7j:col><L7j:col name="version" type="java.lang.Integer">16</L7j:col></L7j:row><L7j:row><L7j:col name="name" type="java.lang.String">Policy for service #0b8bab6913cc588557b6973e94d7900f, smstest</L7j:col><L7j:col name="comment" ><![CDATA[NULL]]></L7j:col><L7j:col name="version" type="java.lang.Integer">6</L7j:col></L7j:row>

</L7j:jdbcQueryResult>

expecting outPut:

Name comment version
----------------------------------------

test test123 23

[email protected] · January 11th, 2016, 04:33 AM

Hi Sam,
Did you get the chance to check my code.