<?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"
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<og:head headType="result" />
<og:comment
	system   = "**:エンジン共通"
	pgid     = "01_ADMIN"
	title    = "Admin管理"
	date     = "2015/06/08"
	author   = "K.HASEGAWA"
	text     = "ZZZZ"
	version  = "001"
/>

<!-- DBConfig.xml を取得します。  -->
<og:dbConfigEditor command="GET" type="DBID" />

<!-- DBConfig.xml から、キー(dbidKey)を取得し、Mapオブジェクトにセットします。  -->
<og:value command="SETTBL" action="ALL_MAPOBJ" key="url" value="dbidKey" />

<!-- 取得したキー(dbidKey)を順番に取り出します。  -->
<c:forEach items="${url}" var="idKey" varStatus="status" >
	<c:out value="${idKey.key}" />　　　<c:out value="${idKey.value}" /><br />

	<og:equals val1="${idKey.key}" val2="oracle" contains="true" debug="true">
		<!-- DB検索 SQL文記述 debug="true" でSQL文を確認できます。-->
		<og:query command="NEW" debug="{@debug}" maxRowCount="0" scope="request" dbid="{@idKey.value}">
			<!-- 先頭のカラム名が、"WRITABLE" の場合、'true' or '1' で、書き込み許可が与えら,'2' でチェック済みになります。-->
			select distinct A.SYSTEM_ID, A.CONTXT_PATH
				, B.PARAM AS "OS_INFO"      
				, C.PARAM AS "SERVER_INFO"  
				, D.PARAM AS "SERVLET_INFO" 
				, E.PARAM AS "JDK_INFO"     
				, F.PARAM AS "REAL_PATH"    
				, G.PARAM AS "ENGINE_INFO"  
				, H.PARAM AS "STARTING_TIME"  
			from GE12 A
					inner join GE12 B on A.SYSTEM_ID = B.SYSTEM_ID and A.CONTXT_PATH = B.CONTXT_PATH and B.PARAM_ID = 'OS_INFO'
					inner join GE12 C on A.SYSTEM_ID = C.SYSTEM_ID and A.CONTXT_PATH = C.CONTXT_PATH and C.PARAM_ID = 'SERVER_INFO'
					inner join GE12 D on A.SYSTEM_ID = D.SYSTEM_ID and A.CONTXT_PATH = D.CONTXT_PATH and D.PARAM_ID = 'SERVLET_INFO'
					inner join GE12 E on A.SYSTEM_ID = E.SYSTEM_ID and A.CONTXT_PATH = E.CONTXT_PATH and E.PARAM_ID = 'JDK_INFO'
					inner join GE12 F on A.SYSTEM_ID = F.SYSTEM_ID and A.CONTXT_PATH = F.CONTXT_PATH and F.PARAM_ID = 'REAL_PATH'
					inner join GE12 G on A.SYSTEM_ID = G.SYSTEM_ID and A.CONTXT_PATH = G.CONTXT_PATH and G.PARAM_ID = 'ENGINE_INFO'
					inner join GE12 H on A.SYSTEM_ID = H.SYSTEM_ID and A.CONTXT_PATH = H.CONTXT_PATH and H.PARAM_ID = 'STARTING_TIME'
			order by A.SYSTEM_ID, A.CONTXT_PATH
		</og:query>

		<og:view
			viewFormType = "HTMLTable"
			command		= "NEW"
			scope		= "request"
			useScrollBar= "false"
			writable	= "false"
			checked		= "{@checked}"
			startNo		= "{@startNo}"
			pageSize	= "{@pageSize}"
		/>
	</og:equals>
</c:forEach>

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