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

📄 maker21.jsp~17~

📁 jsp数据库开发实例精粹全书原代码 无解压缩密码 包括 书店
💻 JSP~17~
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.util.*"%>
<%@ page import="zhaobiao.db.*,zhaobiao.date.*"%>
<%

  long page1=1;
  if(request.getParameter("page1")!=null)
    page1 = Long.parseLong(request.getParameter("page1").trim());

  long mkid=1;
  if(request.getParameter("mkid")!=null)
    mkid= Long.parseLong(request.getParameter("mkid").trim());

  long pagemax=10;
  long count;
  MakerManager makerm=new MakerManager();
  Set set1=new TreeSet();
  Basic basic=new Basic();
  Maker mk=new Maker();

  mk=basic.getMaker(mkid);
  count=makerm.getPPMListCount(mkid);
  set1=makerm.getPPMProjectList(page1,pagemax,mkid);

%>
<html>
<head>
<title>xxx</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="style.css" type="text/css">
<script language="JavaScript">
<!--
function MM_popupMsg(msg) { //v1.0
  alert(msg);
}

function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<center>
<table width="776" border="0" cellspacing="0" cellpadding="0" height="103">

  <tr>
      <td height="65"> <a href="index.jsp"><img src="images/zhaobiao_01.jpg" width="777"  height="89" align="absbottom" border="0"></a></td>
  </tr>
  </table>
 <a href="product1.jsp">产品信息</a> <a href="project1.jsp">项目信息</a> <a  href="maker1.jsp">厂商信息</a><br>
<table width="774" border="0" cellspacing="0" cellpadding="0">
  <tr>
      <td colspan="2" align="center" height="79">
        <table width="100%" border="0" cellspacing="0" cellpadding="1" align="center">
        <tr bgcolor="0092B8">
          <td>
            <table width="100%" border="0" cellspacing="0" cellpadding="1"  bgcolor="#FFFFFF">
              <tr align="center">
                  <td height="110">
                    <table width="764" border="0" cellspacing="1" cellpadding="0"  height="70">
                      <tr align="center" bgcolor="E1D1B7">
                        <td height="1" align="center" colspan="4" width="758"><b><a  href="maker1.jsp">厂商信息</a>---
<%=mk.getMaker_name()%>厂商参与项目的信息</b></td>
                      </tr>
                      <tr bgcolor="F6F2E6">
                        <td height="23" align="center" width="232"><font color="#CC0033">
                          项目名称</font></td>
                        <td align="center" width="198" height="23"><font color="#CC0033">项目中投标产品
                          </font></td>
                        <td align="center" width="165" height="23"><font color="#CC0033">是否中标</font></td>
                        <td align="center" width="151" height="23"><font color="#CC0033">项目总造价</font></td>
                        </tr>
        <%
          if(!set1.isEmpty())
          {
            Object[] array;
            array=set1.toArray();
            out.print("arraysize="+array.length);
            for(int i=0;i<array.length;i++)
            {
              Project pj=new Project();
              pj=(Project)array[i];
              Vector ppmlist=new Vector();
              ppmlist=makerm.getPPMProductList(pj.getProject_id(),mkid);

            out.println("ppmlist.size="+ppmlist.size());
            Product pd1=new Product();
             PPM ppm1=new PPM();
             ppm1=(PPM)ppmlist.get(0);
             pd1=basic.getProduct(ppm1.getProduct_id());

             ppm1=makerm.getPPMList(pj.getProject_id(),pd1.getProduct_id(),mkid);

%>
                     <tr bgcolor="F6F2E6">
                       <td height="69" align="center" width="232" rowspan="<%=ppmlist.size()%>"> <a href="project2.jsp?pjid=<%=pj.getProject_id()%>">
<%=pj.getProject_name()%></a></td>
                       <td align="center" width="198" height="23"><a href="project4.jsp?pjid=<%=pj.getProject_id()%>&pdid=<%=pd1.getProduct_id()%>">
<%=pd1.getProduct_name()%>
</a></td>
                       <td align="center" width="165" height="23"><font color="#CC0033">
<%
if(ppm1.isZhongbiao())
 out.print("中标");
else
 out.print("未中标");
%>
</font></td>
                       <td align="center" width="151" height="23"><%=pj.getProject_cost()%></td>
                       </tr>


<%
 if(ppmlist.size()>1)
 {

   for(int j=1;j<ppmlist.size();j++)
   {
     Product pd=new Product();
     PPM ppm=new PPM();
     ppm=(PPM)ppmlist.get(j);
     pd=basic.getProduct(ppm.getProduct_id());

%>
                     <tr bgcolor="F6F2E6">
                       <td align="center" width="198" height="23">
                       <a href="project4.jsp?pjid=<%=pj.getProject_id()%>&pdid=<%=pd.getProduct_id()%>"><%=pd.getProduct_name()%></a></td>
                       <td align="center" width="165" height="23"><font color="#CC0033">
<%
if(ppm.isZhongbiao())
 out.print("中标");
else
 out.print("未中标");
%>
</font></td>
                       <td align="center" width="151" height="23"><%=pj.getProject_cost()%></td>
                       </tr>




        <%
      }
 }
      makerm.freeCon();

          }
          }
          basic.freeCon();

     %>

                    </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
<center>
  <tr align="right">
    <td colspan="2"><a href="#"  onClick="MM_openBrWindow('send_pop.shtml','','width=300,height=250')"><br>
      <br>
      </a> </td>
  </tr>
</table>
  <form method="POST" action="search1.jsp">
  关键字:
  <input type="text" name="keys">
  <select name="searchid">
  <option selected value=0>所有</option>
    <option value=1>项目</option>
    <option value=2>厂商</option>
    <option value=3>产品</option>
  </select>
  <input type="submit" name="submit" value="搜索">
</form>
<table width="774" border="0" cellspacing="0" cellpadding="0">
  <tr align="center" valign="top">
    <td height="20"><u>首 页</u> 上一页<img src="images/aleft.gif" width="18" height="16"  border="0" align="absbottom"> 
      <input type="text" name="textfield" size="2" value="01">
      页  <img src="images/aright.gif" width="18" height="16" border="0"  align="absbottom">下一页 <u>最后一页</u></td>
  </tr>
</table>
<p>&nbsp; </p>
</center>
</body>
</html>

⌨️ 快捷键说明

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