⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 totalresult.jsp

📁 基于Java的地图数据管理软件。使用MySQL数据库管理系统。
💻 JSP
📖 第 1 页 / 共 2 页
字号:
<%@page contentType="text/html; charset=gb2312"%>
<%@ page language="java" import="java.util.*,
    com.tongtu.util.PlanDetail,
    com.tongtu.util.QueryStr,
    com.tongtu.util.CurrentUser,
    com.tongtu.util.Page;" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
List totalList=(List)request.getAttribute("totalList");
List cityList=(List)request.getAttribute("cityList");
List allCountyList=(List)request.getAttribute("allCountyList");
List allTownList=(List)request.getAttribute("allTownList");

 QueryStr qs = (QueryStr)session.getAttribute("totalStr") ;

 CurrentUser cu = new CurrentUser();
 
%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<link href="<%=path%>/css/css.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body,td,th {
	font-size: 12px;
}
-->
</style>
<script language="JavaScript">
function show(i){     
if (i.style.display == "none") {     
  i.style.display = "";     
 }
 else{     
  i.style.display = "none";     
 }     
}      
</script>
</head>

<body>
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="6" height="11"  background="pic/beijing.jpg"><img src="pic/tupian.jpg" width="6" height="11" /></td>
        <td background="pic/beijing.jpg"></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td height="25"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="61%">&nbsp;&nbsp;&gt;&gt;数据统计(按行政区划统计)</td>
        <td width="39%">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td><table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
	      <tr>
        <td height="5" colspan="2" ></td>
      </tr>
      <tr>
        <td height="25" align="left" bgcolor="#73CCF7"> <img src="pic/icon3.gif" width="16" height="16" align="absmiddle" />
        <a href="DownTable.do?table_id=计划统计(按行政区划统计)&tableType=2" title="将计划的统计结果数据导出为Excel表格">导出Excel表格</a> 
          </td>
        <td height="25" align="right" bgcolor="#73CCF7">
          
        </td>
      </tr>
      <tr>
        <td height="1" colspan="2" bgcolor="#666666"></td>
      </tr>
      <tr>
        <td height="164" colspan="2" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td height="5" colspan="19"></td>
          </tr>
          <tr class="z">
              <td width="6" height="20" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
          <td width="100" align="center" bgcolor="#F2F4F6" class="bk" nowrap>城市名称</td>
            <td width="6" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td width="100" align="center" bgcolor="#F2F4F6" class="bk" nowrap>县(区)名称</td>
            <td width="6" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td width="100" align="center" bgcolor="#F2F4F6" class="bk" nowrap>乡镇名称</td>
            <td width="6" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td width="100" align="center" bgcolor="#F2F4F6" class="bk" nowrap>乡镇个数</td>
            <td width="6" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td width="100" align="center" bgcolor="#F2F4F6" class="bk" nowrap>建制村个数</td>
            <td width="6" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td width="100" align="center" bgcolor="#F2F4F6" class="bk" nowrap>建设里程(公里)</td>
            <td width="6" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td width="100" align="center" bgcolor="#F2F4F6" class="bk" nowrap>计划总投资(万元) </td>
            <td width="6" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td width="100" align="center" bgcolor="#F2F4F6" class="bk" nowrap>省市区自筹(万元) </td>
            <td width="6" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td width="120" align="center" bgcolor="#F2F4F6" class="bk" nowrap> 上级补助资金(万元)</td>
              <td width="6" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td width="120" align="center" bgcolor="#F2F4F6" class="bk" nowrap> 实际完成总投资(万元)</td>
            </tr>
                 <%
             PlanDetail  plan = new PlanDetail();
             PlanDetail  countyPlan = new PlanDetail();
             PlanDetail  townPlan = new PlanDetail();
             String indexStr = "";
             if (cityList != null && cityList.size() != 0){
                 int n = 0;
                 for (int i = 0; i < cityList.size();i++){
                   plan = (PlanDetail)cityList.get(i);
                  // if (plan.getCityName().equals("安徽省")) continue;
                   n++;
                   indexStr = n+"";
                   if (n == 11) indexStr = "A";
                   if (n == 12) indexStr = "B";
                   if (n == 13) indexStr = "C";
                   if (n == 14) indexStr = "D";
                   if (n == 15) indexStr = "E";
                   if (n == 16) indexStr = "F";
                   if (n == 17) indexStr = "G";
             %>
           <tr class="z">
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" align="center" nowrap><%if (!plan.getCityName().equals("安徽省")){ %><a href="#" onclick="show(q<%=indexStr%>)"  title="点击展开"><%=plan.getCityName() %></a><%}else{ %><%=plan.getCityName() %><%} %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" align="center" nowrap>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" align="center" nowrap>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" align="center" nowrap><%=plan.getTownCout() %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" align="center" nowrap><%=plan.getVillageCount() %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" align="center" nowrap><%=cu.getRound(plan.getMilemeter(),3) %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" align="center" nowrap><%=cu.getRound(plan.getInvest(),3) %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" align="center" nowrap><%=cu.getRound(plan.getSsqzc(),3) %>&nbsp;</td>
            <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" align="center" nowrap><%=cu.getRound(plan.getProvinceSubsidy(),3) %>&nbsp;</td>
             <td height="25" class="bk">&nbsp;</td>
            <td height="25" class="bk" align="center" nowrap><%=cu.getRound(plan.getSjwctze(),3) %>&nbsp;</td>
          </tr>
                 <tr class="z">
            <td colspan="20" >
			<DIV  id='q<%=indexStr %>' style="DISPLAY: none">
			<table width="100%" height="30"  border="0" cellpadding="0" cellspacing="0" bgcolor="#E8FFE8">
             <% int m = 0;
                for (int j = 0; j < allCountyList.size();j++){
                   countyPlan = (PlanDetail)allCountyList.get(j);
                   if (!countyPlan.getCityName().equals(plan.getCityName()) || countyPlan.getTownName() != null) continue;
                   m ++;
              %>
		    <tr class="z">

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -