showplan.jsp

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

                       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">
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><a href="planEdit.do?planId=<%=plan.getPlanId() %>"><%=plan.getRoadName() %></a></td>
            
                <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=planType %>&nbsp;</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>
        
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getTownName() %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getVillageName() %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=villageType%>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getMilemeter() %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getRoadbedWidth() %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getRoadSurfaceWidth() %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=roadType%>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getInvest() %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" nowrap><%=plan.getProvinceSubsidy() %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
          </tr>
            <%} }%>
      
        </table></td>
      </tr>
          <td height="25" bgcolor="#73CCF7"><table width="100%" height="26"  border="0" cellpadding="0" cellspacing="0">
   
       <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="showPlan.do?start=0" title="第一页">首页</a>
              &nbsp;&nbsp;|&nbsp;&nbsp;
             <%}else{%>
            首页
              &nbsp;&nbsp;|&nbsp;&nbsp;
             <%}%>
             <%
              if(pages!=null&&pages.isPreviousPageAvailable()){
		      %>
		    <a href="showPlan.do?start=<%=previousPage%>" title="上一页">上一页</a>
		     &nbsp;&nbsp;|&nbsp;&nbsp;
		     <%}
              if(nextPageStart<pagenum){
		     %>
		    <a href="showPlan.do?start=<%=nextPageStart%>" title="下一页">下一页</a>
		    &nbsp;&nbsp;|&nbsp;&nbsp;
		    <%}
              int lastStart = rowCount*(numPages-1);
              if(currentPage<numPages&&lastStart>0){
            %>
		    <a href="showPlan.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>
        
          页&nbsp;</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>
</body>
<script language="JavaScript">
function pagesubmit()
{ 
  var start=document.all.pageselect.value;
  //alert(start);
  window.location.href="showPlan.do?start="+start;
}
</script>
</form>
</html>