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

📄 search_all.jsp~64~

📁 jsp数据库开发实例精粹全书原代码 无解压缩密码 包括 书店
💻 JSP~64~
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.util.*"%>
<%@ page import="zhaobiao.db.*,zhaobiao.date.*"%>
<%!
    String getStr(String str)
    {
            try
            {
                       String temp=new String(str.getBytes("ISO8859_1"));
                    return temp;
            }
            catch(Exception e)
            {
                    return null;
            }
        }
%>
<%
Search search=new Search();
Vector list=new Vector();
Vector list1=new Vector();
Vector list2=new Vector();
Basic basic=new Basic();
basic.freeCon();
String keys=null;
 if(request.getParameter("keys")!=null)
 keys=getStr(request.getParameter("keys").trim());
list=search.searchProject(1,1000000,keys);
list1=search.searchMaker(keys);
list2=search.searchProduct(keys);
search.freeCon();
  %>
<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 checknull()
  {

   var a=document.form1.keys.value;
     if(a=="")
       {
        alert("关键字不能为空!");
         return false;
       }
       else
  return true;

}
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="740" border="3" cellspacing="0" cellpadding="0" >
<tr>

<table width="700" border="0" cellspacing="0" cellpadding="0" height="103">

  <tr>
      <td height="65"> <a href="index.jsp"><img src="images/zhaobiao_01.jpg" width="700" 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="700" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td colspan="2" align="center">
      <table width="700" border="0" cellspacing="0" cellpadding="1" align="center">
        <tr bgcolor="0092B8">
          <td>
            <table width="700" border="0" cellspacing="0" cellpadding="1" bgcolor="#FFFFFF">
              <tr align="center">
                <td>
                    <table width="700" border="0" cellspacing="1" cellpadding="0">
                      <tr align="center" bgcolor="E1D1B7">
                       <td height="25" align="center" colspan="13" width="758"><b>查询到的项目列表</b></td>
                      </tr>
                      <tr bgcolor="F6F2E6">
                        <td height="20" align="center" width="104"><font color="#CC0033">
                          项目名称</font></td>
                        <td align="center" width="97"><font color="#CC0033">项目时间</font></td>
                        <td align="center" width="160"><font color="#CC0033">项目负责单位</font></td>
                        <td align="center" width="86"><font color="#CC0033">项目总造价</font></td>
                        <td align="center" width="295"><font color="#CC0033">项目介绍</font></td>
                      </tr>
<% ;
   for(int i=0;i<list.size();i++)
   {
   Project pj=new Project();
   pj=(Project)list.get(i);
%>
                      <tr bgcolor="F6F2E6" align="center">
                        <td height="25" width="104">
                          <p>
<a href="project2.jsp?pjid=<%=pj.getProject_id()%>"><%=pj.getProject_name()%></a></p>
                        </td>
                        <td width="97"><%if(pj.getProject_time()!=null)out.println(pj.getProject_time());%></td>
                        <td width="160"><%if(pj.getProject_company()!=null)out.println(pj.getProject_company());%></td>
                       <td width="86"><%if(pj.getProject_cost()!=null)out.println(pj.getProject_cost());%></td>
  </center>
                        <td width="295">
                          <p align="left"><%if(pj.getProject_content()!=null)out.println(basic.cnvtBr(pj.getProject_content()));%></td>
                      </tr>
<center>
 <%}
%>

                    </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr align="right">
    <td colspan="2"><br>
      <br>
       </td>
  </tr>

      </table>
      <%////////////////////////////////////////////%>
        <table width="700" border="0" cellspacing="0" cellpadding="1" align="center">
        <tr bgcolor="0092B8">
          <td>
            <table width="700" border="0" cellspacing="0" cellpadding="1" bgcolor="#FFFFFF">
              <tr align="center">
                  <td>
                    <table width="700" border="0" cellspacing="1" cellpadding="0">
                      <tr align="center" bgcolor="E1D1B7">
                        <td height="25" align="center" colspan="7" width="758"><b>查询到的厂商信息</b></td>
                      </tr>
                      <tr bgcolor="F6F2E6">

                        <td height="25" align="center" width="126"><font color="#FF0000">
                          投标厂商名称</font></td>
                        <td align="center" width="141"><font color="#FF0000">总部地址</font></td>
                        <td align="center" width="87"><font color="#FF0000">注册时间</font></td>
                        <td align="center" width="142"><font color="#FF0000">注册地址</font></td>
                        <td align="center" width="76"><font color="#FF0000">注册资金</font></td>
                        <td align="center" width="74"><font color="#FF0000">法人姓名</font></td>
                        <td align="center" width="88"><font color="#FF0000">详细信息</font></td>
                      </tr>
 <%
  if(list1!=null)
  {
    for(int i=0;i<list1.size();i++)
    {
      Maker mk=new Maker();
      mk=(Maker)list1.elementAt(i);
%>
                      <tr bgcolor="F6F2E6" align="center">
                        <td height="25" width="126">
                          <p><a href="maker2.jsp?mkid=<%=mk.getMaker_id()%>"><%=mk.getMaker_name()%></a></p>
                        </td>
                        <td width="141"><%if(mk.getMaker_address()!=null)out.println(mk.getMaker_address());%></td>
                        <td width="87"><%if(mk.getMaker_cr_time()!=null)out.println(mk.getMaker_cr_time());%></td>
                        <td width="142"><%if(mk.getMaker_cr_address()!=null)out.println(mk.getMaker_cr_address());%></td>
                        <td width="76"><%if(mk.getMaker_cr_cost()!=null)out.println(mk.getMaker_cr_cost());%></td>
                        <td width="74"><%if(mk.getMaker_fr_name()!=null)out.println(mk.getMaker_fr_name());%></td>
                        <td width="88"><a href="makerinfo.jsp?mkid=<%=mk.getMaker_id()%>" target="_blank">详细信息</a></td>
                      </tr>
            <%}}%>

                    </table>
                  </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>

<table>

                     <tr align="right">
                         <td colspan="2"><br>
                           <br>
                            </td>
  </tr>
    <%//////////////////////////////////%>
      <table width="700" border="0" cellspacing="0" cellpadding="1" align="center">
       <tr bgcolor="0092B8">
         <td>
           <table width="700" border="0" cellspacing="0" cellpadding="1" bgcolor="#FFFFFF">
             <tr align="center">
               <td>
                   <table width="700" border="0" cellspacing="1" cellpadding="0">
                     <tr align="center" bgcolor="E1D1B7">
                       <td height="25" align="center" colspan="13"><b><a href="product1.jsp">查询到的产品信息</a></b></td>
                     </tr>
                     <tr bgcolor="F6F2E6" align="center">
                       <td height="25" width="15%" align="left">
                         <p>查询到的产品信息</p>
                       </td>
                       <td colspan="4" align="left">
               <%
                if(list2!=null)
                {
                  for(int i=0;i<list2.size();i++)
                  {
                    Product pd=new Product();
                    pd=(Product)list2.get(i);
%>

 <%=i+1%>.<a href="product3.jsp?pdid=<%=pd.getProduct_id()%>"><%=pd.getProduct_name()%></a><br>
                         <br>
       <%}}
%>                    </td>
                     </tr>
                   </table>
               </td>
             </tr>
           </table>
         </td>
       </tr>
      </table>
    <%////////////////////////////////%>
  <tr align="right">
    <td colspan="2"><a href="#" onClick="MM_openBrWindow('send_pop.shtml','','width=300,height=250')"><br>
      <br>
      </a> </td>
  </tr>
  </center>
<p align="center">
                           <form  name="form1" method="POST" action="search1.jsp" onsubmit="return checknull()">
                            关键字:
                            <input type="text" name="keys" value="<%=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="搜索">

</tr>
</table>
</form>
</body>

⌨️ 快捷键说明

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