btnmw-was-app/Apps/MWUI/jsp/rekon/dbConnection_list.jsp

<%@ include file="../common/header.jsp"%>
<%
	if (seq==0){
		seq = (Integer) request.getAttribute("databaseConnection_start");  
	}
%>
      
<script type="text/javascript" language="javascript">
<!--
		function page(start, count){
			document.forms.databaseConnection.start.value=start;
			document.forms.databaseConnection.count.value=count;

			document.forms.databaseConnection.action.value="list";
			document.forms.databaseConnection.submit();
			doDisable(document.forms.databaseConnection, "button");
		}


		function doChangePage(count){
			document.forms.databaseConnection.start.value= (document.forms.databaseConnection.startx.value-1)*20;
			if(document.forms.databaseConnection.start.value=="NaN") document.forms.databaseConnection.start.value = 0;
			document.forms.databaseConnection.count.value=count;

			document.forms.databaseConnection.action.value="list";
			document.forms.databaseConnection.submit();
			doDisable(document.forms.databaseConnection, "button");
		}

		function doCreate(){
			document.forms.databaseConnection.action.value="create";
			document.forms.databaseConnection.submit();
			doDisable(document.forms.databaseConnection, "button");
		}

		function fillIndex(val){
			document.forms.databaseConnection.startx.value = val.value;
		}
	

		function doDetail(dbconnectionPk){
			document.forms.databaseConnection.dbconnectionPk.value=dbconnectionPk;
			document.forms.databaseConnection.action.value="detail";
			document.forms.databaseConnection.submit();
		}

		function doFilter(){
			document.forms.databaseConnection.action.value="list";
			document.forms.databaseConnection.submit();
			doDisable(document.forms.databaseConnection, "button");
		}

		function doReset(){
			document.forms.databaseConnection.databaseConnection_dsn_filter.value="";
			document.forms.databaseConnection.databaseConnection_jdbcDriver_filter.value="";
			document.forms.databaseConnection.databaseConnection_jdbcUrl_filter.value="";
			
			document.forms.databaseConnection.clear.value="true";
			document.forms.databaseConnection.action.value="list";
			document.forms.databaseConnection.submit();
			doDisable(document.forms.databaseConnection, "button");
		}

		function doOrder(field, type){
			document.forms.databaseConnection.databaseConnection_fieldOrder.value=field;
			document.forms.databaseConnection.databaseConnection_orderType.value=type;

			document.forms.databaseConnection.action.value="list";
			document.forms.databaseConnection.submit();
			doDisable(document.forms.status, "button");
		}
	-->
</script>
<!-- CONTENT -->
<form name="databaseConnection" method="post" action="databaseConnection.do">
<input type="hidden" name="start" value="">
<input type="hidden" name="startx" value="">
<input type="hidden" name="action" value="">
<input type="hidden" name="count" value="">
<input type="hidden" name="clear" value="">
<input type="hidden" name="dbconnectionPk" value="">
<input type="hidden" name="databaseConnection_fieldOrder" value="<bean:write name="databaseConnection_fieldOrder"/>">
<input type="hidden" name="databaseConnection_orderType" 	value="<bean:write name="databaseConnection_orderType"/>">
<input type="hidden" name="focus_field" value=""/>

<!--td width="80%" valign="top"-->
	<table width="100%" border="0" align="center" cellpadding="2" cellspacing="4"> 
	  <tr>
		<td class="titleHeader"><bean:message key="project.databaseConnection.key"/> - LIST</td>
	  </tr>
	  <tr>
		<td><%@ include file="../common/paging.jsp"%> 
		</td> 
	</tr> 
	</table> 
 	<table width="100%" border="0" cellspacing="1" cellpadding="1"> 
		<tr>
			<td width="5%" class="titleField"><div align="center">#</div></td>
			<td align="left" height="10" valign="top" class="titleField"><bean:message key="databaseConnection.dsn.key" /> 
				<logic:equal name="databaseConnection_fieldOrder" value="dsn">
					<logic:equal name="databaseConnection_orderType" value="ASC">
						<a href="#" onclick="doOrder('dsn', 'DESC');"><img src="./images/arrow_down.gif" border="0"></a>
					</logic:equal>
					<logic:equal name="databaseConnection_orderType" value="DESC">
						<a href="#" onclick="doOrder('dsn', 'ASC');"><img src="./images/arrow_up.gif" border="0"></a>
					</logic:equal>
				</logic:equal> 
				<logic:notEqual name="databaseConnection_fieldOrder" value="dsn">
					<a href="#" onclick="doOrder('dsn', 'ASC');"><img src="./images/arrow.gif" border="0"></a>
				</logic:notEqual>
			</td>
			<td align="left" height="10" valign="top" class="titleField"><bean:message key="databaseConnection.jdbcdriver.key" /> 
				<logic:equal name="databaseConnection_fieldOrder" value="jdbcDriver">
					<logic:equal name="databaseConnection_orderType" value="ASC">
						<a href="#" onclick="doOrder('jdbcDriver', 'DESC');"><img src="./images/arrow_down.gif" border="0"></a>
					</logic:equal>
					<logic:equal name="databaseConnection_orderType" value="DESC">
						<a href="#" onclick="doOrder('jdbcDriver', 'ASC');"><img src="./images/arrow_up.gif" border="0"></a>
					</logic:equal>
				</logic:equal> 
				<logic:notEqual name="databaseConnection_fieldOrder" value="jdbcDriver">
					<a href="#" onclick="doOrder('jdbcDriver', 'ASC');"><img src="./images/arrow.gif" border="0"></a>
				</logic:notEqual>
			</td>
				<td align="left" height="10" valign="top" class="titleField"><bean:message key="databaseConnection.jdbcurl.key" /> 
				<logic:equal name="databaseConnection_fieldOrder" value="jdbcUrl">
					<logic:equal name="databaseConnection_orderType" value="ASC">
						<a href="#" onclick="doOrder('jdbcUrl', 'DESC');"><img src="./images/arrow_down.gif" border="0"></a>
					</logic:equal>
					<logic:equal name="databaseConnection_orderType" value="DESC">
						<a href="#" onclick="doOrder('jdbcUrl', 'ASC');"><img src="./images/arrow_up.gif" border="0"></a>
					</logic:equal>
				</logic:equal> 
				<logic:notEqual name="databaseConnection_fieldOrder" value="jdbcUrl">
					<a href="#" onclick="doOrder('jdbcUrl', 'ASC');"><img src="./images/arrow.gif" border="0"></a>
				</logic:notEqual>
			</td>
			<td width="5%" class="titleField">&nbsp;</td>
		</tr>	
		<logic:notEmpty name="databaseConnectionList">
			<logic:iterate id="element" name="databaseConnectionList" scope="request" indexId="index">
			<% 
				sequence++;
				String bgcolor = "FFFFFF";
				if(sequence%2 == 0){
					bgcolor = "EDEDE8";
				}
			%>
				<tr bgcolor="<% out.print(bgcolor); %>" onmouseover="mOvr(this);"  onmouseout="mOut(this, '<% out.print(bgcolor); %>');">
				<td align="center" class="celBorder"><%=++seq%>&nbsp;</td>
					<td align="left" class="celBorder">
						&nbsp;<bean:write name="element" property="dsn"/>
					</td>
					<td align="left" class="celBorder">
						&nbsp;<bean:write name="element" property="jdbcDriver"/>
					</td>
					<td align="left" class="celBorder">
						&nbsp;<bean:write name="element" property="jdbcUrl"/>
					</td>
					<td align="center" class="celBorder" ><a href="#" ><img src="./images/detail.gif" border="0" onclick="doDetail('<bean:write name="element" property="dbconnectionPk"/>');" alt="see detail"/></a>
				</td>
				</tr>
			</logic:iterate>
		</logic:notEmpty>
	</TABLE> 
	
   	<table width="100%" border="0" align="center" cellpadding="2" cellspacing="4"> 
		<tr> 
			<td class="search"><bean:message key="project.search.key" /></td>
        </tr> 
    </table>
    <table width="100%" border="0" cellspacing="1" cellpadding="2">
 	   <tr>
			<td width="20%"><b><bean:message key="databaseConnection.dsn.key"/></b></td>
			<td width="1%">:</td>
			<td width="29%">
			<label> 
				<input type="text" name="databaseConnection_dsn_filter" value="<logic:notEmpty name="databaseConnection_dsn_filter"><bean:write name="databaseConnection_dsn_filter"/></logic:notEmpty>">
			</label>
			</td>
		</tr>
		<tr>
			<td width="20%"><b><bean:message key="databaseConnection.jdbcdriver.key"/></b></td>
			<td width="1%">:</td>
			<td width="29%">
			<label> 
				<input type="text" name="databaseConnection_jdbcDriver_filter" value="<logic:notEmpty name="databaseConnection_jdbcDriver_filter"><bean:write name="databaseConnection_jdbcDriver_filter"/></logic:notEmpty>">
			</label>
			</td>
		</tr>
		<tr>
			<td width="20%"><b><bean:message key="databaseConnection.jdbcurl.key"/></b></td>
			<td width="1%">:</td>
			<td width="29%">
			<label> 
				<input type="text" name="databaseConnection_jdbcUrl_filter" value="<logic:notEmpty name="databaseConnection_jdbcUrl_filter"><bean:write name="databaseConnection_jdbcUrl_filter"/></logic:notEmpty>">
			</label>
			</td>
		</tr>
		<tr>
		<tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td colspan="3" align="left">
			<input type="button" size="50" maxlength="25" value="<bean:message key="button.reset"/>" onclick="doReset();"/>
			&nbsp;&nbsp;
			<input type="button" value="<bean:message key="button.search"/>" onclick="doFilter();"/>
		  </td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>	  
    </table>
 </td>
 </form>
<!-- END CONTENT -->   
<logic:notEmpty name="focus"><bean:write name="focus" filter="false"/></logic:notEmpty> 
<%@ include file="../common/footer.jsp"%>