planqueryresult.jsp

基于Java的地图数据管理软件。使用MySQL数据库管理系统。

                   String villageType = "";
                   plan = (PlanDetail)planList.get(i);
                   //1沟通建制村,2非沟通建制村,3县道土路,4县道砂石路
                   if (plan.getPlanType() == 1) planType = "沟通建制村";
                   if (plan.getPlanType() == 2) planType = "非沟通建制村";
                   if (plan.getPlanType() == 3) planType = "县道土路";
                   if (plan.getPlanType() == 4) planType = "县道砂石路";
                   String [] viStr = plan.getVillageType().split(";");
                   for (int j = 0; viStr != null && j < viStr.length;j++){
                       if (viStr[j].equals("1") ) villageType += " 爱滋病村 ;";
                       if (viStr[j].equals("2") ) villageType += " 民蔟村 ;";
                       if (viStr[j].equals("3") ) villageType += " 干部挂职村 ;";
                       if (viStr[j].equals("4") ) villageType += " 千村百镇示范村 ;";
                          
                   } 
                   if (villageType.length() > 0)
                   villageType  = villageType.substring(0,villageType.length()-2); 
                    String roadType = "";
                   if (plan.getRoadSurfaceType() == 1) roadType = "沥青混凝土路面 ";
                   if (plan.getRoadSurfaceType() == 2) roadType = "水泥混凝土路面";
                   if (plan.getRoadSurfaceType() == 3) roadType = "简易铺装路面";
                   if (plan.getRoadSurfaceType() == 4) roadType = "砂石路面";
                   if (plan.getRoadSurfaceType() == 5) roadType = "石质路面";
                   if (plan.getRoadSurfaceType() == 6) roadType = "渣石路面";
                   if (plan.getRoadSurfaceType() == 7) roadType = "砖铺路面";
                   if (plan.getRoadSurfaceType() == 8) roadType = "无路面";  
                 %>
          <tr class="z">
             <%if (str.indexOf("1") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><a href="planEdit.do?planId=<%=plan.getPlanId() %>"><%=plan.getRoadName() %></a>&nbsp;</td>
              <%} %>
                 <%if (str.indexOf("2") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=planType%></td>
              <%} %>
              
                 <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getCityName() %>&nbsp;</td>
               <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getCountyName() %>&nbsp;</td>
            
                 <%if (str.indexOf("3") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><a href="planEdit.do?planId=<%=plan.getPlanId() %>"><%=plan.getVillageName() %></a>&nbsp;</td>
              <%} %>
                 <%if (str.indexOf("4") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=villageType %>&nbsp;</td>
              <%} %>
                 <%if (str.indexOf("5") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getTownName() %>&nbsp;</td>
              <%} %>
                 <%if (str.indexOf("6") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getMilemeter() %>&nbsp;</td>
              <%} %>
                 <%if (str.indexOf("7") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getRoadbedWidth() %>&nbsp;</td>
              <%} %>
                 <%if (str.indexOf("8") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getRoadSurfaceWidth() %>&nbsp;</td>
              <%} %>
                 <%if (str.indexOf("9") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=roadType %>&nbsp;</td>
              <%} %>
                 <%if (str.indexOf("A") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getInvest() %>&nbsp;</td>
              <%} %>
                 <%if (str.indexOf("B") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getProvinceSubsidy() %>&nbsp;</td>
              <%} %>
                 <%if (str.indexOf("C") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getStartTime() %>&nbsp;</td>
              <%} %>
                 <%if (str.indexOf("D") != -1){ %>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getEndTime() %>&nbsp;</td>
            <%} %>
          </tr>
          <%} }  %>
        </table></td>
      </tr>
  <tr>
          
              <%
          int nextPageStart = 0;
          if (pages!=null) nextPageStart=pages.getStartOfNextPage();
          int previousPage=0;
          if (pages!=null) previousPage=pages.getStartOfPreviousPage();
          int start = 0;
           String startnum=(String)request.getAttribute("start");
           if (startnum!=null) start=Integer.parseInt(startnum);
           if (start != 0 )
             {
             posInt = start;
             userInt = start + userInt;
             }else {
                   userInt = posInt + userInt - 1;
             }
          int currentPage =  (start/rowCount)+1;
      
          int numPages = (int)Math.ceil((double)pagenum/(double)rowCount);
          if(numPages==0){
             currentPage=0;
           }
          %>
           <td height="25" align="left" bgcolor="#73CCF7">         
            <div align="left">&nbsp;共 <%=pagenum %> 条，列出第 <%=posInt %> 至 <%=userInt %> 条 &nbsp; </div></td>
        <td align="right" bgcolor="#73CCF7">
          第<font color="blue"><%=currentPage%></font>页/共<font color="blue"><%=numPages%></font>页&nbsp;&nbsp;|&nbsp;&nbsp;
          <%
             if(currentPage>1){
             
             %>
             <a href="showQueryResult.do?start=0" title="第一页">首页</a>
              &nbsp;&nbsp;|&nbsp;&nbsp;
             <%}else{%>
            首页
              &nbsp;&nbsp;|&nbsp;&nbsp;
             <%}%>
             <%
              if(pages!=null&&pages.isPreviousPageAvailable()){
		      %>
		    <a href="showQueryResult.do?start=<%=previousPage%>" title="上一页">上一页</a>
		     &nbsp;&nbsp;|&nbsp;&nbsp;
		     <%}
              if(nextPageStart<pagenum){
		     %>
		    <a href="showQueryResult.do?start=<%=nextPageStart%>" title="下一页">下一页</a>
		    &nbsp;&nbsp;|&nbsp;&nbsp;
		    <%}
              int lastStart = rowCount*(numPages-1);
              if(currentPage<numPages&&lastStart>0){
            %>
		    <a href="showQueryResult.do?start=<%=lastStart%>" title="最后一页">末页</a>
		    <%}else{%>
		     末页
		    <%}%>
		    转到 第
		    <select name="pageselect" onchange="javascrpt:pagesubmit();" >
		      <%for(int n=1;n<numPages+1;n++){%>
		         <% if(n==currentPage){%>
                  <option  value="<%=(n-1)*rowCount%>" selected><%=n%></option>
               <%}else{%>
                    <option value="<%=((n-1)*rowCount)%>"><%=n%></option>
              <%}}%>
             
            </select>
        
          页</td>
          </tr>
        </table></td>
      </tr>
</table>
<br>
<br>
<br>
<table width="100%" height="55"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="44"><div align="center">主办：安徽省交通厅　&copy;2005-2006版权所有　维护单位：安徽省通途信息技术有限公司
     <br><br>联系电话:<span class="font"><SPAN class=A1>0551--5397484 5397494 </SPAN></span> <br></div></td>
  </tr>
</table>
<script language="JavaScript">
function pagesubmit()
{ 
  var start=document.all.pageselect.value;
  //alert(start);
  window.location.href="showQueryResult.do?start="+start;
}
</script>
</form>
</body>
</html>