<?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	= "GFX030"
	title	= "DB異常検知"
	date	= "2017/05/17"
	author	= "T.OTA"
	text	= ""
	version	= "001"
/>

<jsp:directive.include file="sqlValues.jsp" />

<form method="POST" action="forward.jsp" target="RESULT" onClick="timeSet();">
<table>
  <tr>
	<!-- テーブル名:ﾃｽﾄ用に初期値GF47を設定 -->
	<og:select name="TABLE_NAME" value="{@TABLE_NAME}" must="true" defaultVal="GF47">
		<og:option value="" lbl="" />
		<!-- 項目が一つの queryOption では、ラベルリソースが使用されます。 -->
		<og:queryOption dbid="{@FROM_DBID}" addKey="true" quotCheck="false">
			{@TABLES}
		</og:queryOption>
	</og:select>
	<!-- カラム名１ -->
	<og:select name="COLUMN_NAME1" eventColumn="TABLE_NAME" eventURL="eventColumn_COLUMN_NUMBER.jsp" must="true" />
	<!-- カラム名２ -->
	<og:select name="COLUMN_NAME2" eventColumn="TABLE_NAME" eventURL="eventColumn_COLUMN_NUMBER.jsp" must="true" />
  </tr>
</table>

<og:queryButton />

<og:hidden keys="NUMBER_COLUMNS" vals="{@NUMBER_COLUMNS}" />
</form>

<script type="text/javascript">
	$(function(){
		// ﾃｽﾄ用：ｶﾗﾑ名1,ｶﾗﾑ名2の初期値設定
		$("#COLUMN_NAME1").val("SISYUTU");
		$("#COLUMN_NAME2").val("SEISEKI");
	});
</script>

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