home.jsp

spring+sybase数据库处理连接的范例

<%@ include file="../../common/includes.jsp" %>

<script type="text/javascript">
<!--
  function go(country) {
    var url = "<c:url value="/main/detail.htm"/>?code=" + country;
    window.location = url;
  }
//-->
</script>
<script type="text/javascript" src="<c:url value="/js/countries.js"/>"></script>

<fmt:message key="lnk.countries.main" var="lnk"/>
<h2><fmt:message key="countries.main.title"/></h2>
  <form action="" method="POST">
	<table class="stripe ruler">
        <thead>
	  <tr class="title">
	    <th><a href="<c:url value="/${lnk}"><c:param name="sort.property" value="name"/></c:url>"><fmt:message key="name"/></a></th>
	    <th><a href="<c:url value="/${lnk}"><c:param name="sort.property" value="code"/></c:url>"><fmt:message key="code"/></a></th>
	  </tr>
	  <tr class="title">
	    <td><fmt:message key="filter"/>:
	      <input type="text" name="filter.name" value="<c:out value="${countries.filter.name}"/>"
	      onchange="document.forms[0].submit()" />
	    </td>
	    <td><fmt:message key="filter"/>:
          <select name="filter.code" onChange="document.forms[0].submit()">
            <option></option>
            <c:forTokens items="A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,W,X,Y,Z" delims="," var="crtcode">
              <option 
                <c:if test="${countries.filter.code == crtcode}">selected </c:if>
                value="<c:out value="${crtcode}"/>"><c:out value="${crtcode}"/>
              </option>
            </c:forTokens>
           </select>
	    </td>
	  </tr>
        </thead>
        <tbody>
	  <c:forEach items="${countries.pageList}" var="cntry">
	    <tr onclick="go('<c:out value="${cntry.code}"/>')"> 
	      <td><c:out value="${cntry.name}"/></td>
	      <td><c:out value="${cntry.code}"/></td>
	    </tr>
	  </c:forEach>
        </tbody>
	</table>

    <hr/>

    <div class="pagernav">
      <c:if test="${countries.pageCount > 1}">
          <a href="<c:url value="/${lnk}"><c:param name="page" value="0"/></c:url>">1</a>
          &nbsp;...&nbsp;
          <c:forEach begin="${countries.firstLinkedPage}" end="${countries.lastLinkedPage}" var="crtpg">
            <c:choose>
              <c:when test="${crtpg == countries.page}">
                <strong><c:out value="${crtpg + 1}"/></strong>
              </c:when>
              <c:otherwise>
                <a href="<c:url value="/${lnk}"><c:param name="page" value="${crtpg}"/></c:url>"><c:out value="${crtpg + 1}"/></a>
              </c:otherwise>
            </c:choose>
          </c:forEach>
          &nbsp;...&nbsp;
          <a href="<c:url value="/${lnk}"><c:param name="page" value="${countries.pageCount - 1}"/></c:url>"><c:out value="${countries.pageCount}"/></a>
	    <fmt:message key="psize" var="ps"/>
      </c:if>
    </div>
    <div class="psize">
        <select name="pageSize" onChange="document.forms[0].submit()">
          <c:forTokens items="5,10,15,20,30,40,80" delims="," var="crtps">
            <option 
              <c:if test="${countries.pageSize == crtps}">selected </c:if>
              value="<c:out value="${crtps}"/>"><c:out value="${crtps} ${ps}"/>
            </option>
          </c:forTokens>
        </select>
    </div>

	<div>-=+=-</div>
    
    <div class="pager">
      <table>
        <tr>
          <td align="left" width="33%">
            <fmt:message key="pg.pages">
              <fmt:param value="${countries.page + 1}"/>
              <fmt:param value="${countries.pageCount}"/>
            </fmt:message>
          </td>
          <td align="center" width="34%">
            <fmt:formatDate value="${countries.refreshDate}" type="both" dateStyle="short" timeStyle="medium"/>
          </td>
          <td align="right" width="33%">
            <fmt:message key="pg.records">
              <fmt:param value="${countries.firstElementOnPage + 1}"/>
              <fmt:param value="${countries.lastElementOnPage + 1}"/>
              <fmt:param value="${countries.nrOfElements}"/>
            </fmt:message>
          </td>
        </tr>
      </table>
    </div>
    
    <hr/>
    
    <fmt:message key="sort.crt"/>
    <c:out value="${countries.sort.property}"/>
    <c:choose>
      <c:when test="${countries.sort.ascending}"><fmt:message key="ascending"/></c:when>
      <c:otherwise><fmt:message key="descending"/></c:otherwise>
    </c:choose>

  </form>

<script type="text/javascript">
<!--
window.onload = function() {
  tableruler();
  tablestripe();
}
//-->
</script>