开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Applet > 查看源码
searchPro.jsp
资源名称：shop.rar　[点击查看]
上传用户：yatiankong
上传日期：2014-05-16
资源大小：5604k
文件大小：15k
源码类别：

Applet

开发平台：

Java

searchPro.jsp：源码内容
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  2. <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.lang.*" errorPage="" %>
  3. <jsp:useBean id="productinfoBeans" class="MyFly.Bean.productinfoBeans" scope="request"/>
  4. <jsp:useBean id="productinfoBean" class="MyFly.Bean.productinfoBean" scope="request"/>
  5. <jsp:useBean id="useclassBeans" class="MyFly.Bean.useclassBeans" scope="request"/>
  6. <jsp:useBean id="characterclassBeans" class="MyFly.Bean.characterclassBeans" scope="request"/>
  7. <%@ include file="top.jsp" %>
  8. <script language="javascript" src="js/showimg.js"></script>
  9. <HTML xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE></TITLE>
  10. <META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK 
  11. href="image/buyok_shop.css" type=text/css rel=stylesheet>
  12. <LINK 
  13. href="image/buyok_shop.css" type=text/css rel=stylesheet><LINK 
  14. href="image/table.css" type=text/css rel=stylesheet><LINK 
  15. href="image/buyok_shop.css" type=text/css rel=stylesheet>
  16. <STYLE type=text/css>.STYLE4 {
  17. FONT-WEIGHT: bold; FONT-SIZE: 14px; COLOR: #0072a8; TEXT-DECORATION: underline
  18. }
  19. .lei1 {
  20. FONT-SIZE: 13px
  21. }
  22. .STYLE5 {
  23. FONT-WEIGHT: bold; FONT-SIZE: 14px; COLOR: #0099cc
  24. }
  25. .red1 {
  26. COLOR: #ff0000
  27. }
  28. </STYLE>
  29. <script language="javascript">
  30. function openScript(url,name, width, height){
  31. var Win = window.open(url,name,'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
  32. }
  33. </script>
  34. <%
  35.    request.setCharacterEncoding("gb2312");
  36.    String pageSize="5";
  37.    String pageNum=request.getParameter("pageNum");
  38.    String str="select * from productinfo where 1=1";
  39.    //String protype="searchPro";
  40.   //String KeyWords=new String(request.getParameter("keywords").getBytes("8859_1")); //取得子类get用
  41.    String name_key=request.getParameter("name_key");//图书名
  42.    String writer_key=request.getParameter("writer_key");//作者
  43.    String code_key=request.getParameter("code_key");//条形码
  44.    String cbs_key=request.getParameter("cbs_key");//出版社
  45.    String jg1_key=request.getParameter("jg1_key");
  46.    String jg2_key=request.getParameter("jg2_key");//价格
  47.    String paixu=request.getParameter("paixu");//排序
  48.   if(name_key.equals("")&&writer_key.equals("")&&code_key.equals("")&&cbs_key.equals("")&&jg1_key.equals("")&&jg2_key.equals(""))
  49.    {  
  50.      out.println("<Script language=JavaScript>alert('请填写搜索的某一项或多项内容');JavaScript:history.back();</Script>");
  51.    }
  52.    if(name_key!=null&&!name_key.equals(""))
  53. str=str+" and productName like '%"+name_key+"%'";
  54. //System.out.print(str);  
  55.      if(writer_key!=null&&!writer_key.equals(""))
  56.       str=str+" and author='"+writer_key+"'";
  57.    if(code_key!=null&&!code_key.equals(""))
  58.      str=str+" and productID='"+code_key+"'";
  59.   if(cbs_key!=null&&!cbs_key.equals(""))
  60.             str=str+" and publish='"+cbs_key+"'";
  61. if(jg1_key!=null&&!jg1_key.equals("")&&jg2_key!=null&&!jg2_key.equals(""))
  62.   str=str+" and preferPrice BETWEEN '"+jg1_key+"' and '"+jg2_key+"'";
  63.   if(paixu.equals("1"))
  64.   {
  65.     str=str+" order by shangData desc";
  66.   }
  67.   else
  68.   {
  69.     str=str+" order by preferPrice desc";
  70.   }
  71.  // System.out.print(str); 
  72.    productinfoBeans.setPageSize(Integer.parseInt(pageSize));  
  73.    productinfoBeans.setPageNum(pageNum);
  74.            productinfoBeans.RowCount(str);
  75.            productinfoBeans.searchPro(str);
  76.            int num=productinfoBeans.getItems();
  77.            int pageCount=productinfoBeans.getPageCount(); 
  79. %>
  80. <LINK href="image/table.css" type=text/css rel=stylesheet>
  81. <META content="MSHTML 6.00.2900.3086" name=GENERATOR></HEAD>
  82. <BODY><LINK href="image/buyok_shop.css" type=text/css 
  83. rel=stylesheet>
  84. <STYLE type=text/css>BODY {
  85. MARGIN: 0px
  86. }
  87. .STYLE1 {
  88. COLOR: #ff3300
  89. }
  90. .STYLE2 {
  91. COLOR: #ff0000
  92. }
  93. </STYLE>
  95. <LINK href="image/buyok_shop.css" type=text/css rel=stylesheet>
  96. <TABLE class=grayline cellSpacing=0 cellPadding=0 width=760 align=center 
  97. border=0>
  98.   <TBODY>
  99.   <TR>
  100.     <TD class=right vAlign=top align=left width=210 height=239 rowSpan=2>
  101.       <STYLE type=text/css>.STYLE4 {
  102. FONT-WEIGHT: bold; FONT-SIZE: 14px; COLOR: #0072a8; TEXT-DECORATION: underline
  103. }
  104. .STYLE5 {
  105. FONT-WEIGHT: bold; FONT-SIZE: 14px; COLOR: #0099cc
  106. }
  107. </STYLE>
  108.       <LINK href="image/buyok_shop.css" type=text/css 
  109.       rel=stylesheet>
  110.       <TABLE height=263 cellSpacing=0 cellPadding=0 width=200 align=left 
  111.       border=0>
  112.         <TBODY>
  113.         <TR>
  114.           <TD width=206 height=31><IMG height=50 
  115.             src="image/lei.gif" width=200></TD></TR>
  116.         <TR>
  117.           <TD vAlign=top align=middle height=189>
  118.             <TABLE height=226 cellSpacing=0 cellPadding=0 width=190 align=center 
  119.             background=image/leftlist_bg.jpg border=0>
  120.               <TBODY>
  121.               <TR>
  122.                 <TD vAlign=top align=middle 
  123.                 background=image/leftlist_bg.jpg bgColor=#ebebeb 
  124.                 height=189><TABLE cellSpacing=0 cellPadding=0 width="88%" 
  125.                         bgColor=#fafafa border=0>
  126.                   <TBODY>
  127.                     <TR>
  128.                       <TD background=image/erbook.com.htm 
  129.                             height=11>
  130.                         <TABLE height=9 cellSpacing=0 cellPadding=0 
  131.                               width="100%" align=center border=0>
  132.                           <TBODY>
  133.                             <TR>
  134.                               <TD   bgColor=#ffffff></TD>
  135.                             </TR>
  136.                           </TBODY>
  137.                       </TABLE></TD>
  138.                     </TR>
  139.                     <%
  140.  characterclassBeans.getQuery("-1");
  141. for(int i_c=0; i_c<characterclassBeans.getItems(); i_c++)//第一层循环读出大类
  142.     {
  143.   
  144. %>
  145.                     <TR>
  146.                       <TD style="PADDING-LEFT: 20px" 
  147.                             background=image/erbook.com.htm 
  148.                               height=23><IMG height=9 
  149.                               src="image/bit05.gif" width=8 
  150.                               align=absMiddle> <A class=lei1 
  151.                               onclick=javascript:ShowFLT(<%=(i_c+1)%>) 
  152.                               href="javascript:void(null)"><%=characterclassBeans.getCharacterName(i_c)%></A> </TD>
  153.                     </TR>
  154.                     <TR id=LM<%=(i_c+1)%> style="DISPLAY: none">
  155.                       <TD>
  156.                         <TABLE cellSpacing=2 cellPadding=0 width="100%" 
  157.                               border=0>
  158.                           <TBODY>
  159.                             <%
  160. int j_u=characterclassBeans.getCharacterID(i_c);
  161. int num1=useclassBeans.getQuerycha(j_u);
  162.  for(int i_q=0; i_q<num1; i_q++)
  163.  {
  164. %>
  165.                             <TR>
  166.                               <TD style="PADDING-LEFT: 40px" height=23> <IMG height=7 src="image/bit06.gif" width=8 align=absMiddle> <A  href="prosort.jsp?proType=<%=java.net.URLEncoder.encode(useclassBeans.getUseclassName(i_q),"utf-8")%>
  167. &pageNum=1&proNum=<%=useclassBeans.getUseclassID(i_q)%>"  target=_blank><%=useclassBeans.getUseclassName(i_q)%></A> </TD>
  168.                             </TR>
  169.                             <%}
  170. %>
  171.                           </TBODY>
  172.                       </TABLE></TD>
  173.                     </TR>
  174.                     <%}
  175. %>
  176.                     <TR id=LM18 style="DISPLAY: none">
  177.                       <TD>&nbsp; </TD>
  178.                     </TR>
  179.                   </TBODY>
  180.                 </TABLE>
  181.                 <SCRIPT language=javascript id=clientEventHandlersJS>
  182. <!--
  183. var number=3;
  185. function LMYC() {
  186. var lbmc;
  187. //var treePic;
  188.     for (i=1;i<=number;i++) {
  189.         lbmc = eval('LM' + i);
  190.         //treePic = eval('treePic'+i);
  191.         //treePic.src = 'images/file.gif';
  192.         lbmc.style.display = 'none';
  193.     }
  194. }
  195.  
  196. function ShowFLT(i) {
  197.     lbmc = eval('LM' + i);
  198.     //treePic = eval('treePic' + i)
  199.     if (lbmc.style.display == 'none') {
  200.         LMYC();
  201.         //treePic.src = 'images/nofile.gif';
  202.         lbmc.style.display = '';
  203.     }
  204.     else {
  205.         //treePic.src = 'images/file.gif';
  206.         lbmc.style.display = 'none';
  207.     }
  208. }
  209. //-->
  210.       </SCRIPT>
  217. </TD>
  218.               </TR></TBODY></TABLE><IMG 
  219.             height=9 src="image/leftlist_bottom.gif" 
  220.         width=190></TD></TR></TBODY></TABLE></TD>
  221.     <TD vAlign=top align=left width=550>
  222.       <TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
  223.         <TBODY>
  224.         <TR>
  225.           <TD><IMG height=201 src="image/tops.gif" 
  226.           width=550></TD></TR></TBODY></TABLE>
  227.       <DIV align=center>
  228.       <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  229.         <TBODY>
  230.         <TR>
  231.           <TD height=25><IMG height=11 src="image/jt_2.gif" 
  232.             width=11 align=absMiddle>  <strong>当前位置：</strong><a href="index.jsp">首页</a><strong>—&gt; </strong>高级搜索结果 <FONT 
  233.             class=orge size=2><B></FONT></TD>
  234.         </TR>
  235.         <TR>
  236.           <TD background=image/bgline.gif 
  237.       height=1></TD></TR></TBODY></TABLE>
  238.   <%
  239.   if(num==-1)
  240.   {
  241.   out.print("<table width="485" height="145"  border="0" align="center" cellpadding="0" cellspacing="0">");
  242.   out.print("<tr><td>对不起暂时没有您要的图书，请试试<font color="red">高级查询</font></td></tr>");
  243.   out.print("</table>");
  244.   }
  245.   else
  246.   {
  247.   for(int i=0;i<num;i++)
  248.   {
  249.   %>
  250.       <table width="485" height="145"  border="0" align="center" cellpadding="0" cellspacing="0">
  251.         <tr>
  252.           <td><img src="image/bg_top.jpg" width="485" height="14"></td>
  253.         </tr>
  254.         <tr>
  255.           <td height="128" align="left" valign="top" background="image/bg_line.jpg"><table width="100%"  border="0" align="center" cellpadding="0" cellspacing="0">
  256.               <tr>
  257.                 <td width="170"  align="center" valign="top"><table width="116" height="136"  border="0" cellpadding="0" cellspacing="0">
  258.                     <tr>
  259.                       <td align="center" valign="middle" background="image/bg.jpg"> 
  260.   <a href="listbook.jsp?proNum=<%=productinfoBeans.getProductID(i).replace('#', ',')%>">
  261.   <%  
  262.   String proNum1=productinfoBeans.getProductID(i);
  263.   String proNum2=proNum1.replace(',','#');
  264.     productinfoBean.getNew(proNum2);
  265. String num1=productinfoBeans.getProductID(i).replace('#', '1');
  267. %>
  268. <img src="product_image/<%=productinfoBeans.getMinPicture(i)%>"  onMouseOver="showBigImg('<%=productinfoBean.getMaxPicture()%>',<%=num%>,event);" onMouseOut="mouseout('<%=productinfoBeans.getMinPicture(i)%>',event)" width="93" height="112" border="0"></a>
  270.   </td>
  271.                     </tr>
  272.                 </table></td>
  273.                 <td width="65%" align="left" valign="top"><table width=100% border=0 cellpadding="0" cellspacing="0" style="table-layout:fixed;word-break:break-all">
  274.                     <tr>
  275.                       <td height=20 width=77>【书&nbsp; 名】</td>
  276.                       <td width="228" height="25"><%=productinfoBeans.getProductName(i)%></td>
  277.                     </tr>
  278.                     <tr>
  279.                       <td height=20>【作 &nbsp;者】</td>
  280.                       <td height="20"><%=productinfoBeans.getAuthor(i)%> </td>
  281.                     </tr>
  282.                     <tr>
  283.                       <td height="20" valign=middle>【出版社】</td>
  284.                       <td height="20"><%=productinfoBeans.getPublish(i)%></td>
  285.                     </tr>
  286.                     <tr>
  287.                       <td height="20" valign=middle>【上架日期】</td>
  288.                       <td height="20" ><%=productinfoBeans.getShangData(i)%></td>
  289.                     </tr>
  290.                     <tr>
  291.                       <td width=77 height="20" valign=middle>【商品价格】</td>
  292.                       <td height="20" >原价：<%=productinfoBeans.getMarketPrice(i)%>&nbsp;&nbsp;&nbsp;会员价：<span class="red1">￥<a class="font"><%=productinfoBeans.getPreferPrice(i)%></a></span></td>
  293.                     </tr>
  294.                     <tr>
  295.                       <td height="35" colspan=2 align=center><a href="listbook.jsp?proNum=<%=productinfoBeans.getProductID(i).replace('#', ',')%>"><img src=image/xiangxi.jpg alt=详细了解 width="102" height="32" border=0 align="left"></a> <span  style='cursor:hand' onClick="openScript('purchasecart.jsp?bookid=<%=productinfoBeans.getProductID(i).replace('#', ',')%>','pur',650,300);"><img src=image/buynow.jpg alt=千寻万觅，要的就是她 width="90" height="32" border=0></span> <span  style='cursor:hand' onclick="openScript('UserCenter/collection.jsp?bookid=<%=productinfoBeans.getProductID(i).replace('#', ',')%>','collection',650,300);"> <img src=image/favnow.jpg alt=好东东，收藏起来先 width="90" height="32" border=0></span> </td>
  296.                     </tr>
  297.                 </table></td>
  298.               </tr>
  299.           </table></td>
  300.         </tr>
  301.         <tr>
  302.           <td><img src="image/bg_bt.jpg" width="485" height="14"></td>
  303.         </tr>
  304.       </table>
  305.   <%}}%>
  306.       </DIV></TD></TR>
  307.   <TR>
  308.     <TD vAlign=top align=left>
  309.       <TABLE cellSpacing=0 cellPadding=0 width="100%" align=center 
  310.       bgColor=#ffffff border=0>
  311.         <TBODY>
  312.         <TR>
  313.           <TD height=10>
  314.             <HR id=hr width="100%" SIZE=1>
  315.           </TD></TR>
  316.            <tr><!-- 放分页代码-->
  317.                
  318.                    
  319.   <div align="right"><a href="searchPro.jsp?pageNum=1&name_key=<%=name_key%>&writer_key=<%=writer_key%>&code_key=<%=code_key%>&cbs_key=<%=cbs_key%>&jg1_key=<%=jg1_key%>&jg2_key=<%=jg2_key%>&paixu=<%=paixu%>"></a> 
  321.                        <% 
  322. if(Integer.parseInt(pageNum) > 1)
  323.    {
  324. %>
  325.                <a href="searchPro.jsp?pageNum=<%=Integer.parseInt(pageNum)-1%>&name_key=<%=name_key%>&writer_key=<%=writer_key%>&code_key=<%=code_key%>&cbs_key=<%=cbs_key%>&jg1_key=<%=jg1_key%>&jg2_key=<%=jg2_key%>&paixu=<%=paixu%>">上一页</a> &nbsp;
  326.                        <%
  327. }
  328. %>
  330.                        <% 
  331. if(Integer.parseInt(pageNum) < pageCount)
  332.    {
  333. %>
  334.                <a href="searchPro.jsp?pageNum=<%=Integer.parseInt(pageNum)+1%>&name_key=<%=name_key%>&writer_key=<%=writer_key%>&code_key=<%=code_key%>&cbs_key=<%=cbs_key%>&jg1_key=<%=jg1_key%>&jg2_key=<%=jg2_key%>&paixu=<%=paixu%>">下一页</a> &nbsp;
  335.                        <%
  336. }
  337. %>
  339.                        <a href="searchPro.jsp?pageNum=<%=pageCount%>&name_key=<%=name_key%>&writer_key=<%=writer_key%>&code_key=<%=code_key%>&cbs_key=<%=cbs_key%>&jg1_key=<%=jg1_key%>&jg2_key=<%=jg2_key%>&paixu=<%=paixu%>">尾页</a> 
  341. 页次：<STRONG><FONT 
  342.                   color=red><%=Integer.parseInt(pageNum)%></FONT>/<%=pageCount%></STRONG>页 &nbsp;</div>
  343.             
  344.             </tr></TBODY></TABLE></TD></TR></TBODY></TABLE>
  346. <%@ include file="foot.jsp" %>
  347. </BODY></HTML>