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

📄 planqueryresult.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,
    java.util.Iterator,
    java.text.SimpleDateFormat,java.util.Locale,
    java.util.Date,
    java.util.ArrayList,
    com.tongtu.util.Page;" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
Page pages=(Page)request.getAttribute("page");
int pagenum=0;
 String pagen=(String)request.getAttribute("pagenum");
 String rows=(String)request.getAttribute("rowCount");
 if (pagen!=null) pagenum=Integer.parseInt(pagen);
 int userInt = 0; //当前页记录数
 int posInt  = 1; //开始位置
 int rowCount = 0;
 if (rows!= null) rowCount = Integer.parseInt(rows);
   if (page != null){
       List userList=pages.getList();
       userInt = userList.size();
     } 
 QueryStr qs = (QueryStr)session.getAttribute("queryStr") ;
 String [] showStr = qs.getResultStr();
 String str = "";
 for (int i = 0; i < showStr.length;i++){
    str += showStr[i]+";";
 }
 
                
%>

<!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>
</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">
     <form name="planForm" aciotn="del.do">
	      <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="outputTable.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">
            <%if (str.indexOf("1") != -1){ %>
            <td width="2" height="20" align="center" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap>项目名称
               <a href="showQueryResult.do?typeId=8">
            <img src="<%if (qs.getRoadType() == 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
               <%} %>
             <%if (str.indexOf("2") != -1){ %>
            <td width="2" height="20" align="center" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap>项目类型
                <a href="showQueryResult.do?typeId=9">
            <img src="<%if (qs.getJhType() == 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
            <%} %>
              <td width="2" align="center" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td width="80" align="left" bgcolor="#F2F4F6" class="bk" nowrap>市名
                  <a href="showQueryResult.do?typeId=12">
            <img src="<%if (qs.getCityType() == 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
    
            <td width="2" align="center" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td width="80" align="left" bgcolor="#F2F4F6" class="bk" nowrap>县区名
            
             <%if (str.indexOf("3") != -1){ %>
            <td width="2" height="20" align="center" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap>建制村名称
                <a href="showQueryResult.do?typeId=11">
            <img src="<%if (qs.getCunType() == 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
            <%} %>
             <%if (str.indexOf("4") != -1){ %>
            <td width="2" height="20" align="center" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap>建制村类型</td> <%} %>
              <%if (str.indexOf("5") != -1){ %>
            <td width="2" height="20" align="center" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap>乡镇名称
                <a href="showQueryResult.do?typeId=10">
            <img src="<%if (qs.getTownType() == 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
            <%} %>
               <%if (str.indexOf("6") != -1){ %>
            <td width="2" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap>建设里程
            <a href="showQueryResult.do?typeId=1">
            <img src="<%if (qs.getMileType() == 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
       
            <%} %>
                 <%if (str.indexOf("7") != -1){ %>
            <td width="2" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap>计划路基宽度
            <a href="showQueryResult.do?typeId=2">
            <img src="<%if (qs.getLjkdType() == 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
       
            <%} %>
            <%if (str.indexOf("8") != -1){ %>
            <td width="2" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap>计划路面宽度
            <a href="showQueryResult.do?typeId=3">
            <img src="<%if (qs.getLmkdType() == 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
       
               <%} %>
            <%if (str.indexOf("9") != -1){ %>
            <td width="2" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap>计划路面类型</td>
            
                 <%} %>
            <%if (str.indexOf("A") != -1){ %>
            <td width="2" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap> 计划总投资 
            <a href="showQueryResult.do?typeId=4">
            <img src="<%if (qs.getInvestType() == 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
       
               <%} %>
            <%if (str.indexOf("B") != -1){ %>
            <td width="2" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap> 上级补助资金
              <a href="showQueryResult.do?typeId=5">
            <img src="<%if (qs.getProType()== 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
                 <%} %>
            <%if (str.indexOf("C") != -1){ %>
            <td width="2" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap>开工时间
            <a href="showQueryResult.do?typeId=6">
            <img src="<%if (qs.getStartType() == 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
                <%} %>
            <%if (str.indexOf("D") != -1){ %>
            <td width="2" bgcolor="#F2F4F6" class="bk"><img src="pic/sep_title.gif" width="2" height="21" /></td>
            <td  align="left" bgcolor="#F2F4F6" class="bk" nowrap>完工时间
            <a href="showQueryResult.do?typeId=7">
            <img src="<%if (qs.getEndType() == 1){ %>pic/jiantou.gif <%}else {%>pic/jiantou1.gif <%} %>" width="12" height="7" border="0"/></a></td>
              <%} %>
            </tr>
            
                <%
             PlanDetail  plan = new PlanDetail();
             if (page != null){
              List planList=pages.getList();
              String planType = "";
              userInt = planList.size();
              
                for (int i = 0; i < planList.size();i++){

⌨️ 快捷键说明

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