<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:og="hybs-taglib.tld"
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<og:head headType="result" />
<jsp:directive.include file="/jsp/custom/result_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "DOC09"
	title	= "XML出力"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<og:columnCheck
	command   = "{@command}"
/>

<og:equals val1="{@VERNO}" nullCheck="true">
	<og:value command="SQL">
		SELECT VERNO FROM GF21 GROUP BY VERNO ORDER BY 1 DESC
	</og:value>
</og:equals>

<table>

<!-- GF21 作成 -->
<tr><td>Output XML Data</td><td>(GF21 XML File)</td><td width="10px"></td><td class="S9">
<og:query command="{@command}" debug="{@debug}" maxRowCount="0" displayMsg="MSG0033">
		select	VERNO,PRE_FIX,TAGNAME,SEQ,TAGCLASS,TEICLASS,BODYCONTENT,FGJ
		from	GF21
		where	VERNO = '{@VERNO}'
		and		FGJ = '1'
		order by PRE_FIX, TAGNAME
</og:query>

<og:writeTable
	fileURL        = "{@USER.ID}"
	filename       = "GF21.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GF21" />
	<og:writeTableParam key="First" >
		delete from GF21 where VERNO = '{@VERNO}'
	</og:writeTableParam>
</og:writeTable>

</td></tr>

<!-- GF22 作成 -->
<tr><td>Output XML Data</td><td>(GF22 XML File)</td><td width="10px"></td><td class="S9">
<og:query command="{@command}" debug="{@debug}" maxRowCount="0" displayMsg="MSG0033">
		select	VERNO,PRE_FIX,TAGNAME,VALUENAME,SEQ,TAGCLASS,REQUIRED,RTEXPRVALUE,VAL_TYPE,FGJ
		from	GF22
		where	VERNO = '{@VERNO}'
		and		FGJ = '1'
		order by PRE_FIX, TAGNAME, VALUENAME
</og:query>

<og:writeTable
	fileURL        = "{@USER.ID}"
	filename       = "GF22.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GF22" />
	<og:writeTableParam key="First" >
		delete from GF22 where VERNO = '{@VERNO}'
	</og:writeTableParam>
</og:writeTable>

</td></tr>

<!-- GF23 作成 -->
<tr><td>Output XML Data</td><td>(GF23 XML File)</td><td width="10px"></td><td class="S9">
<og:query command="{@command}" debug="{@debug}" maxRowCount="0" displayMsg="MSG0033">
		select	VERNO,TAGCLASS,HTMLEXT,DESCRIPTION,CONTENTS,FORM_SAMPLE,FGJ
		from	GF23
		where	VERNO = '{@VERNO}'
		and		FGJ = '1'
		order by TAGCLASS
</og:query>

<og:writeTable
	fileURL        = "{@USER.ID}"
	filename       = "GF23.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GF23" />
	<og:writeTableParam key="First" >
		delete from GF23 where VERNO = '{@VERNO}'
	</og:writeTableParam>
</og:writeTable>

</td></tr>

<!-- GF24 作成 -->
<tr><td>Output XML Data</td><td>(GF24 XML File)</td><td width="10px"></td><td class="S9">
<og:query command="{@command}" debug="{@debug}" maxRowCount="0" displayMsg="MSG0033">
		select	VERNO,TAGCLASS,VALUENAME,HTMLEXT,VALUESMPL,DESCRIPTION,CONTENTS,FGJ
		from	GF24
		where	VERNO = '{@VERNO}'
		and		FGJ = '1'
		order by TAGCLASS,VALUENAME
</og:query>

<og:writeTable
	fileURL        = "{@USER.ID}"
	filename       = "GF24.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GF24" />
	<og:writeTableParam key="First" >
		delete from GF24 where VERNO = '{@VERNO}'
	</og:writeTableParam>
</og:writeTable>

</td></tr>

<!-- GF25 作成 -->
<tr><td>Output XML Data</td><td>(GF25 XML File)</td><td width="10px"></td><td class="S9">
<og:query command="{@command}" debug="{@debug}" maxRowCount="0" displayMsg="MSG0033">
		select	VERNO,ATTCLASS,SEQ,ATTKEY,VALUENAME,DESCRIPTION,CONTENTS,FORM_SAMPLE,FGJ
		from	GF25
		where	VERNO = '{@VERNO}'
		and		FGJ = '1'
		order by ATTCLASS,ATTKEY
</og:query>

<og:writeTable
	fileURL        = "{@USER.ID}"
	filename       = "GF25.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GF25" />
	<og:writeTableParam key="First" >
		delete from GF25 where VERNO = '{@VERNO}'
	</og:writeTableParam>
</og:writeTable>

</td></tr>

</table>

<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
