stati_year.jsp

《jsp案例开发》这本书的源代码。包括源代码和相关的具体配置操作步骤。非常不错

      <TR>
        <TD colSpan=3 align="center" valign="top"><br> <table width="600" border="1" cellspacing="1" bordercolor="#666666">
            <tr bgcolor="#FAFAFA">
              <td valign="top">
              <table width="600" border="0" cellspacing="0" cellpadding="2">
        <form name="form1" method="post" action="stati_y_1.jsp" OnSubmit="return checkinput()">
                  <tr>
                    <td colspan="3" height="15" bgcolor="#666666"><font class="strongw">按年度查询</font></td>
                  </tr>
<tr bgcolor="#fafafa">
                       <td> <font class="strong" >　按年度查询：</font>

                                  <select name="years">
                                  <option value="-1">--请选择--</option>
              <%
for(int y=1980;y<=2050;y++)
{
%>
<option value="<%=y%>"><%=y%></option>
<%}%>
                                  </select>

                         &nbsp;&nbsp; &nbsp;&nbsp; <input type="submit" name="Submit" value="查 询" class="file" >

                       </td>

                     </tr>

      </form>
    <form name="form2" method="post" action="stati_y_2.jsp" >
<tr bgcolor="#fafafa">
<td>
&nbsp;&nbsp;&nbsp;&nbsp;<select name="devtype">
<option value="-1">设备类型</option>
<option value="1">VTS备件</option>
  <option value="2">航标设备及备件</option>
  <option value="3">AIS系统及备件</option>
  <option value="4">测绘设备及备件</option>
  <option value="5">其他</option>
</select>
&nbsp;&nbsp;&nbsp;&nbsp;<select name="manu">
<option value="-1">厂商名称</option>
<%
Vector mname = new Vector();
  Collection collect1=new ArrayList();
       Context ctxc = new InitialContext();
       Object refc = ctxc.lookup("OtherController");
       OtherControllerHome otherControllerHome = (OtherControllerHome) PortableRemoteObject.narrow(refc, OtherControllerHome.class);
       OtherController otherController = otherControllerHome.create();
       collect1 = otherController.getManuAll();
       Iterator i1 = collect1.iterator();
       while(i1.hasNext())
       {
      ManufactureJBean manuj = new ManufactureJBean();
      manuj=(ManufactureJBean)i1.next();
      mname.addElement(manuj.name);
       }

       for(int l=0;l<mname.size()-1;l++)
         for(int k=l+1;k<mname.size();k++)
               {
           if(mname.elementAt(l).equals(mname.elementAt(k)))
             {
                   mname.remove(k);
                   k--;
                }
           }
%>
<%
  for(int l=0;l<mname.size();l++)
  {
  %>
<option value="<%=mname.elementAt(l)%>"><%=mname.elementAt(l)%></option>
  <%}%>
</select>
<%
if(user.userAccess.intValue()==9){
%>
&nbsp;&nbsp;&nbsp;&nbsp;<select name="haiqu">
<option value="-1">海区名称</option>
<option value="北方海区">北方海区</option>
<option value="东海海区">东海海区</option>
<option value="南海海区">南海海区</option>
<option value="海南海事局">海南海事局</option>
</select>
<%}%>
&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="Submit" value="查 询" class="file" >
</td>
</tr>
    </form>
                </table>



                <table class=title cellspacing=1 cellpadding=2 width="100%" border=0>
                <form name="form5" method="post" action="">
                  <tr bgcolor="#666666">
                    <td colspan="7"> <font class="strongw"> 设备列表 </font> </td>
                  </tr>
                  <tr align=middle>

                    <td width="10%"><strong><font  class="strong">设备名称</font></strong></td>
                    <td width="15%"><strong><font  class="strong">设备型号</font></strong></td>
                    <td width="15%"><strong><font  class="strong">设备类型</font></strong></td>
                    <td width="20%"><strong><font  class="strong">所属厂商</font></strong></td>
                    <td width="15%"><strong><font  class="strong">所属合同</font></strong></td>
                    <td width="10%"><strong><font  class="strong">所属项目</font></strong></td>
                    <td width="15%"><strong><font  class="strong">所属海区</font></strong></td>
                  </tr>
                  <%

                    for(m=1;m<=pagesize;m++){
                        if(rs.hasNext()){
                            eqj=(EquipmentJBean)rs.next();
                            eqd = new EquipmentDetailsStruct();
                       eqd = eqController.getEqdetailsByDeviceid(eqj.getDeviceid());


                        if(m%2==0){
                       %>
                       <tr align=middle bgcolor="#e0e0e0">
                       <%
                         }else
                       {
                       %>
                       <tr align=middle bgcolor="#fafafa">
                       <%
                       }
                       %>
<td><a href="eqdetails.jsp?deviceid=<%=eqj.getDeviceid()%>" target="_blank"><%=eqd.getName()%></a></td>
<td><a href="eqdetails.jsp?deviceid=<%=eqj.getDeviceid()%>" target="_blank"><%=eqd.getModel()%></a></td>

<%
String a="";
if(eqd.getType().intValue()==1)
  a="VTS备件";
if(eqd.getType().intValue()==2)
  a="航标设备及备件";
if(eqd.getType().intValue()==3)
  a="AIS系统及备件";
if(eqd.getType().intValue()==4)
  a="测绘设备及备件";
if(eqd.getType().intValue()==5)
  a="其他";
%>
<td><%=a%></td>
<%
a = "";
if(eqd.getCompany()!=null)
  a=eqd.getCompany();
%>
<td><a href="manudetails.jsp?manuname=<%=a%>" target="_blank"><%=a%></a></td>


<%
String temp=eqj.getContractid();
boolean tag = false;
  Context conctx = new InitialContext();
              //look up jndi name
             Object conref = conctx.lookup("ContractController");
              //cast to Home interface
              ContractControllerHome contractControllerHome = (ContractControllerHome) PortableRemoteObject.narrow(conref, ContractControllerHome.class);
              ContractController conController = contractControllerHome.create();
            ContractJBean cjb = new ContractJBean();
            Collection cjc = new ArrayList();
            cjc=conController.getByContractId(eqj.getContractid());
            Iterator cji = cjc.iterator();
            if(cji.hasNext())
            {
            tag=true;
            cjb = (ContractJBean)cji.next();
            if(cjb.contractname!=null)
            {temp=cjb.contractname;}
            }
%>
<%
if(tag){
%>
<td><a href="contractlist.jsp?contractid=<%=cjb.getContractId()%>" target="_blank"><%=temp%></a></td>
<%}
else{
%>
<td><%=temp%></td>
<%}%>
<%
if(tag)
{
%>
<td><a href="itemdet.jsp?itemname=<%=cjb.itemname%>" target="_blank"><%=cjb.itemname%></a></td>
<%}
else{
%>
<td></td>
<%}%>
<td><%=eqd.getDistrict()%></td>
</tr>

                  <%

                        }
                    }
              if(count!=0){

                 %>


                  <tr bgcolor="#e0e0e0">
                    <td colspan="7">
                  <%
                    if(pages!=1){
                      %>
                     <a href="stati_year.jsp?pages=<%=(pages-1)%>"><img src="../../images/prev.gif" width="40" height="12" border="0"></a>
                    <%}else{
                    %>
                    <a href="stati_year.jsp?pages=1"> <img src="../../images/prev.gif" width="40" height="12" border="0"></a>
                    <%
                    }
                    %>
                   &nbsp;&nbsp;&nbsp;<a href="stati_year.jsp?pages=1">第一页</a>&nbsp;&nbsp;&nbsp;<a href="stati_year.jsp?pages=<%=pagecount%>">最后一页</a>&nbsp;&nbsp;&nbsp;
                    <%if(pages!=pagecount) {
                    %>
                    <a href="stati_year.jsp?pages=<%=(pages+1)%>"> <img src="../../images/next.gif" width="40" height="12" border="0"></a>
                    <%}else{%>
                    <a href="stati_year.jsp?pages=<%=pagecount%>"> <img src="../../images/next.gif" width="40" height="12" border="0"></a>
                    <%
                      }

                    %>
                   &nbsp;第<%=pages%>页&nbsp;共<%=count%>条信息&nbsp;分<%=pagecount%>页显示</td>
                  </tr>
                  <%}else{%>
                 <tr align=center bgcolor="#e0e0e0">
                 <td colspan="7">没有满足条件的记录！</td>
                 </tr>
                   <%}%>

                </form>
              </table>
            </tr>
          </table>
          <p><img src="../../images/msalogo.gif" width="272" height="50">
          <table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td height="3"><img src="a.gif" width="1" height="1"></td>
            </tr>
            <tr>
              <td background="../../MacOS/hr.gif"><img src="../../MacOS/hr.gif" width="1" height="2"></td>
            </tr>
            <tr>
              <td height="3"><img src="a.gif" width="1" height="1"></td>
            </tr>
          </table>
          <table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td> <div align="right"><a href="../../help.htm" target="blank" style="cursor:help" title="使用帮助"><img src="../../MacOS/help.gif" width="16" height="16" border="0">HELP</a></div></td>
            </tr>
          </table></TD>
      </TR>
      <TR>
        <TD><IMG height=7 src="../../MacOS/leftbottom.gif" width=6></TD>
        <TD background=../../MacOS/bottom.gif colSpan=3><IMG height=7
      src="../../MacOS/bottom.gif" width=1></TD>
        <TD><IMG height=7 src="../../MacOS/rightbottom.gif"
width=7></TD>
      </TR>
    </TABLE>
    <BR>
    <TABLE cellSpacing=1 cellPadding=2 width="300" border=0>
      <TBODY>
        <TR>
          <TD align=center><FONT class=footer>Orient Super Net NMIE-OFFICE System 1.0
            </FONT></TD>
        </TR>
      </TBODY>
    </TABLE>
</DIV>
</BODY></HTML>
<%}}%>