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

📄 search_all.jsp~69~

📁 jsp数据库开发实例精粹全书原代码 无解压缩密码 包括 书店
💻 JSP~69~
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.util.*"%>
<%@ page import="zhaobiao.db.*,zhaobiao.data.*"%>
<%!
    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">
<table width="200" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td>

    <center>
      <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>
    </center>
    <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">
                        <center>
                          <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);
%>
                        </center>
                        <tr bgcolor="F6F2E6" align="center">
                          <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>
                          <%}
%>
                        </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>
      <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="搜索">
      </form>
    </table>   </td>
  </tr>
</table>
</body>

⌨️ 快捷键说明

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