<?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="query" />
<jsp:directive.include file="/jsp/custom/query_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF6250"
	title	= "EXCEL入力"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<form method="POST" action="result.jsp" enctype="multipart/form-data" target="RESULT">
	<table border="0" frame="border" summary="form" >
		<tr>
			<og:input type="file" name="file1" size="50" lbl="MSG0015" colspan="3" />
			<og:input name="file1_NEW"  lbl="MSG0022"   size="10" />
			<og:select name="separator" lbl="MSG0023">
				<og:option value="&#009;" lbl="TAB"  selected="selected"  />
				<og:option value=","      lbl=","  />
			</og:select>
		</tr>
		<tr>
			<og:select name="readerClass" lbl="MSG0024">
				<!-- MSG0028.OPT=Default,Fixed,CSV,XML -->
				<!-- MSG0028.LVL=標準,固定長出力,CSV出力,XML -->
	<!--		<og:option value="Default"	lbl="MSG0028.DEFAULT"/>		-->
	<!--		<og:option value="Fixed"	lbl="Fixed"		/>			-->
				<og:option value="Excel"	lbl="Excel"		/>
				<og:option value="Calc"		lbl="Calc"		/>
				<og:option value="Text"		lbl="Text"		/>
				<og:option value="POI"		lbl="POI"		/>
				<og:option value="AutoReader" lbl="AutoReader"	selected="selected" />
			</og:select>
			<og:select name="encode" lbl="MSG0025">
				<!-- MSG0029.OPT=DEFAULT,MS932,SJIS,JIS,EUC_JP -->
				<og:option value=""              lbl=""              selected="selected" />
				<og:option value="UnicodeLittle" lbl="UnicodeLittle" />
				<og:option value="MS932"         lbl="MS932"         />
				<og:option value="Windows-31J"   lbl="Windows-31J"   />
				<og:option value="UTF-8"         lbl="UTF-8"         />
				<og:option value="ISO-8859-1"    lbl="ISO-8859-1"    />
	<!--		<og:option value="GB2312"        lbl="GB2312"        />		-->
	<!--		<og:option value="GB18030"       lbl="GB18030"       />		-->
				<og:option value="Shift_JIS"     lbl="Shift_JIS"     />
				<og:option value="SJIS"          lbl="SJIS"          />
				<og:option value="JIS"           lbl="JIS"           />
				<og:option value="EUC_JP"        lbl="EUC_JP"        />
			</og:select>
			<og:column name="useNumber"   codeName="BOOLEAN" defaultVal="true" addNoValue="false" />
			<og:column name="useRenderer" codeName="BOOLEAN" defaultVal="false" addNoValue="false" />
		</tr>
		<tr>
			<og:input name="columns"   size="60" colspan="3" />
			<og:input name="omitNames" size="10"  />
			<og:column name="modifyType" lbl="modifyType" codeName="CDKH" />
		</tr>
		<tr>
			<og:input name="skipRowCount"	size="10" />
			<og:input name="adjustColumns"	size="10" />
			<og:input name="checkColumns"	size="10" />
			<og:input name="nullCheck"		size="10" />
			<og:column name="useStrict" codeName="BOOLEAN" defaultVal="true" addNoValue="false" />	<!-- 7.3.2.0 (2021/03/19) -->
		</tr>
		<tr>
			<og:column name="stopZero"		codeName="BOOLEAN" />
			<og:input  name="nullBreakClm"	size="10" />
			<og:input  name="nullSkipClm"	size="10" />
			<og:column name="useRepeatClms"	codeName="BOOLEAN" />
		</tr>
		<tr>
			<!-- 5.9.8.1 (2016/05/13) , 6.4.6.0 (2016/05/27) -->
			<og:input name="matchKeys1" colspan="7" lbl="matchKeys" >
				<og:input name="matchKeys2" td="false" />
				<og:input name="matchKeys3" td="false" />
				<og:input name="matchKeys4" td="false" />
				<og:input name="matchKeys5" td="false" />
			</og:input>
		</tr>
		<tr>
			<!-- 5.9.8.1 (2016/05/13) , 6.4.6.0 (2016/05/27) -->
			<og:input name="matchVals1" colspan="7" lbl="matchVals" >
				<og:input name="matchVals2" td="false" />
				<og:input name="matchVals3" td="false" />
				<og:input name="matchVals4" td="false" />
				<og:input name="matchVals5" td="false" />
			</og:input>
		</tr>
	</table>

	<og:fieldset lbl="EXCEL Only" >
		<table summary="layout" >
			<tr>
				<og:input name="sheetName"		size="10" />
				<og:input name="sheetNos"		size="10" />
				<og:input name="sheetConstKeys"	size="10" />
				<og:input name="sheetConstAdrs"	size="10" />
			</tr>
		</table>
	</og:fieldset>
	<br />

	<og:fieldset lbl="DirectTableInsert" >
		<table>
		  <tr>
			<td><textarea name="SQL_TEXT" rows="4" cols="60"><!-- --></textarea></td>
			<td>
				<table>
					<tr><og:column name="DBID" codeKeyVal="{@DBID_INFO}" /></tr>
					<tr><og:column name="table"       lbl="table"        /></tr>
					<tr><og:column name="commitBatch" lbl="CommitBatch"  /></tr>
				</table>
			</td>
		  </tr>
		</table>
	</og:fieldset>

	<og:queryButton />
</form>

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