2020年4月17日金曜日

Use XSL as Model of MVC

This is a sample of xslt which transform xml to sql.
I confirmed its result by using this link
https://www.freeformatter.com/xsl-transformer.html#ad-output

XSL having basic function and selection method of XPath.
It is possible to build Logic of Translation from GUI values to SQL.

Followings are the example.

XML
<Models>
  <model_1>
    <table>TBL_SAMPLE</table>
    <param_1>101</param_1>
    <param_2>102</param_2>
  </model_1>
</Models>

XSL
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:transform xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
    <xsl:output method="text" doctype-public="XSLT-compat" omit-xml-declaration="yes" encoding="UTF-8" indent="yes" />
    <xsl:template match="//model_1">
        SELECT *
        FROM <xsl:value-of select="table" />
        WHERE p1 = <xsl:value-of select="param_1" />
        AND   p2 = '<xsl:value-of select="param_2" />'
    </xsl:template>
</xsl:transform>

Result
SELECT * FROM TBL_SAMPLE WHERE p1 = 101 AND p2 = '102'



0 件のコメント: