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

<og:head headType="query" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "09_DBVIEW"
	title	= "DB表示"
	date	= "2016/01/08"
	author	= "Kazuhiko.Hasegawa"
	text	= ""
	version	= "001"
/>

<form method="GET" action="menu.jsp" target="MENU" >
	<table>
		<tr>
			<td>
				<og:column name="FROM_DBID" codeKeyVal="{@DBID_INFO}" td="false" onChange="renew('menu.jsp','MENU');" />
				<og:select name="NO_DISP" td="false" onChange="renew('menu.jsp','MENU');" >
					<og:option value=""           lbl="" />
					<og:option value="TABLE_NAME" lbl="No Tbl" />
				</og:select>
				<og:select name="ZERO" td="false" onChange="renew('menu.jsp','MENU');" >
					<og:option value=""  lbl=""      />
					<og:option value="0" lbl="&gt;0" />
				</og:select>
				<og:link lbl="Top Menu" href="{@NVL.TOP_INDX @SYS.JSP}" target="_top" useGamenId="false" >
					<img src="{@SYS.JSP_IMG}/back.png" />
				</og:link>
			</td>
		</tr>
		<tr>
			<td>
				<og:column name="SYSTEM_ID" defaultVal="{@LAST.SYSTEM_ID}" size="3" lbl="sysID" td="no" />
				<og:column name="TABLE_NAME"  size="5" lbl="Tbl"   td="no" aimai="V*"/>
				<og:column name="COLUMN_NAME" size="5" lbl="Clm"   td="no" aimai="V*"/>
				<og:text><input type="image" src="{@SYS.JSP_IMG}/seartch.gif" /></og:text>
			</td>
		</tr>
	</table>
	<og:hidden name="command" value="NEW" />
</form>

<og:equals val1="{@COLUMN_NAME}" val2="{@COLUMN_NAME}" >
	<jsp:directive.include file="menuColumns.jsp" />
</og:equals>

<og:equals val1="{@COLUMN_NAME}" nullCheck="true"  >
	<jsp:directive.include file="menuTables.jsp" />
</og:equals>

<!-- ViewLinkTag は、指定のカラムにリンクを張ります。keysと、valsに、URLエンコードする値を設定します。 -->
<!-- 子要素の LinkTag は、単独でも使用できます。[カラム名] で、検索結果の各行毎の値を使用できます。 -->
<og:viewLink command="{@command}">
	<og:link column="NAME_JA" href="index2.jsp" useGamenId="false" target="CONT2"
		keys="SYSTEM_ID,TABLE_NAME,FROM_DBID"
		vals="{@SYSTEM_ID},[TABLE_NAME],{@FROM_DBID}" />
</og:viewLink>

<og:view
	viewFormType = "HTMLTable"
	command		= "{@command}"
	scope		= "request"
	noDisplay	= "{@NO_DISP}"
	numberType	= "delete"
	noMessage	= "true"
	useSelectedRow="false"
	pageSize	= "100000"
/>

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