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

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Jsp/Servlet > 查看源码
shop.jsp
资源名称：JSP-OA.rar　[点击查看]
上传用户：jhtang88
上传日期：2014-01-27
资源大小：28528k
文件大小：20k
源码类别：

Jsp/Servlet

开发平台：

Java

shop.jsp：源码内容
  1. <%@ page contentType="text/html; charset=utf-8"%>
  2. <%@ page import="java.util.*"%>
  3. <%@ page import="cn.js.fan.util.*"%>
  4. <%@ page import="cn.js.fan.db.*"%>
  5. <%@ page import="cn.js.fan.web.*"%>
  6. <%@ page import="cn.js.fan.module.nav.*"%>
  7. <%@ page import="com.redmoon.forum.plugin.auction.*"%>
  8. <%@ page import="com.redmoon.forum.plugin.info.*"%>
  9. <%@ page import="com.redmoon.forum.MsgDb"%>
  10. <%@ page import="com.redmoon.forum.person.UserDb"%>
  11. <%@ page import="cn.js.fan.module.guestbook.*"%>
  12. <%
  13. int id = -1;
  14. try {
  15. id = ParamUtil.getInt(request, "id");
  16. }
  17. catch (Exception e) {
  18. }
  19. AuctionShopDb as = new AuctionShopDb();
  20. String userName = "";
  21. if (id!=-1)
  22. userName = StrUtil.getNullString(as.getShopUserNameById(id));
  24. if (userName.equals(""))
  25. userName = ParamUtil.get(request, "userName");
  26. if (userName.equals("")) {
  27. out.print(SkinUtil.makeErrMsg(request, "对不起，缺少参数！"));
  28. return;
  29. }
  31. as = as.getAuctionShopDb(userName);
  32. if (as==null || !as.isLoaded()) {
  33. out.print(cn.js.fan.web.SkinUtil.makeInfo(request, AuctionSkin.LoadString(request, "info_not_exist")));
  34. return;
  35. }
  36. if (!as.isValid()) {
  37. out.print(cn.js.fan.web.SkinUtil.makeInfo(request, AuctionSkin.LoadString(request, "info_invalid")));
  38. return;
  39. }
  40. MsgDb md = new MsgDb();
  42. UserDb user = new UserDb();
  43. user = user.getUser(userName);
  44. %>
  45. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  46. <HTML>
  47. <HEAD>
  48. <TITLE><%=as.getShopName()%>-<%=Global.AppName%>社区专卖店</TITLE>
  49. <META http-equiv=Content-Type content="text/html; charset=utf-8">
  50. <script language="JavaScript">
  51. function openWin(url,width,height)
  52. {
  53.   var newwin = window.open(url,"_blank","toolbar=no,location=no,directories=no,status=no,menubar=no,top=50,left=120,width="+width+",height="+height);
  54. }
  55. </script>
  56. <META content="MSHTML 6.00.2600.0" name=GENERATOR>
  57. </HEAD>
  58. <LINK href="shopskin/<%=as.getSkinCode()%>/skin.css" type=text/css rel=stylesheet>
  59. <BODY>
  60. <table width="98%"  border="0" align="center" cellpadding="0" cellspacing="0" class="banner">
  61.   <tr>
  62.     <td height="23" colspan="2" valign="top"><table width="100%"  border="0" cellpadding="0" cellspacing="0" class="topnav_table">
  63.         <tr>
  64.           <td width="7%" height="23">&nbsp;</td>
  65.           <td width="21%" align="center" class="topnav_td"><%=as.getShopName()%></td>
  66.           <td width="17%" align="center"><a href="shopdesc.jsp?userName=<%=StrUtil.UrlEncode(userName)%>" class="link_topnav">【店铺介绍】</a></td>
  67.           <td width="55%">&nbsp;</td>
  68.         </tr>
  69.       </table></td>
  70.   </tr>
  71.   <tr>
  72.     <td width="50%"><div class="shopInfo">
  73.         <table width="100%"  border="0" align="center" cellpadding="0" cellspacing="0">
  74.           <tr>
  75.             <td width="45%" rowspan="6" align="center"><%
  76. String logo = StrUtil.getNullStr(as.getLogo());
  77. if (!logo.equals("")) {
  78. String w = "";
  79. if (as.getLogoWidth()>as.LOGO_NO_WIDTH)
  80. w = "width=" + as.getLogoWidth();
  81.       %>
  82.               <img src="<%=request.getContextPath() + "/" + logo%>" <%=w%>>
  83.               <%}
  84. %>            </td>
  85.             <td width="20%"><span>店&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;长:</span></td>
  86.             <td width="35%"><%=userName%></td>
  87.           </tr>
  88.           <tr>
  89.             <td><span>信&nbsp;&nbsp;用&nbsp;&nbsp;值:</span></td>
  90.             <td><%=user.getCredit()%></td>
  91.           </tr>
  92.           <tr>
  93.             <td><span>开店时间:</span></td>
  94.             <td><%=DateUtil.format(as.getOpenDate(), "yy-MM-dd")%></td>
  95.           </tr>
  96.           <tr>
  97.             <td><span>地&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;址:</span></td>
  98.             <td><%=as.getAddress()%></td>
  99.           </tr>
  100.           <tr>
  101.             <td><span>域&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;名:</span></td>
  102.             <td><a href="http://<%=as.getId()%>.zjrj.cn">http://<%=as.getId()%>.zjrj.cn</a></td>
  103.           </tr>
  104.           <tr>
  105.             <td>&nbsp;</td>
  106.             <td><a href="javascript:openWin('<%=request.getContextPath()%>/message/send.jsp?receiver=<%=userName%>',320,260)">站内消息</a>&nbsp;&nbsp;<a href="manager/index.jsp?userName=<%=StrUtil.UrlEncode(userName)%>">管理店铺</a> </td>
  107.           </tr>
  108.         </table>
  109.       </div></td>
  110.     <td width="50%" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="1" class="announce_bg">
  111.         <tr>
  112.           <td width="100%" colspan="2" class="">&nbsp;</td>
  113.         </tr>
  114.       </table>
  115.       <table width="100%" border="0" cellpadding="0" cellspacing="1">
  116.         <tr>
  117.           <td height="21" colspan="2" valign="middle" class="notice_title_td"><span class="text_14_bold">本店消息</span></td>
  118.         </tr>
  119.         <tr>
  120.           <td height="13" colspan="2"><hr size="1" class="notice_hr"></td>
  121.         </tr>
  122.         <%
  123. InfoDb idb = new InfoDb();
  124. Iterator idbir = idb.list(0, 4, userName).iterator();
  125. while (idbir.hasNext()) {
  126. idb = (InfoDb)idbir.next();
  127. md = md.getMsgDb(idb.getId());
  128. %>
  129.         <tr>
  130.           <td width="83%" height="22">【<%=idb.getTypeName()%>】<span class="dirItem"><a href="../../showtopic.jsp?rootid=<%=md.getId()%>" target=_blank><%=md.getTitle()%></a></span></td>
  131.           <td width="17%" height="22"><%=DateUtil.format(idb.getAddDate(), "yy-MM-dd")%></td>
  132.         </tr>
  133.         <%}%>
  134.       </table></td>
  135.   </tr>
  136. </table>
  137. <table width="98%"  border="0" align="center" class="recommand">
  138.   <tr>
  139.     <td><%
  140. AuctionDb ad = new AuctionDb();
  141. Iterator rcir = ad.listRecommand(userName).iterator();
  142. while (rcir.hasNext()) {
  143. %>
  144.       <table border="0" align="left">
  145.         <tr>
  146.           <td width="139" height="106" align="center" valign="bottom"><%
  147. ad = (AuctionDb) rcir.next();
  148. String fileName = StrUtil.getNullString(ad.getImage());
  149. if (fileName.equals("")) {
  150. md = md.getMsgDb(ad.getMsgRootId());
  151. fileName = StrUtil.getNullString(md.getFileName());
  152. }
  153. if (!fileName.equals("")) {
  154. %>
  155.             <img src="../../<%=fileName%>" width=80>
  156.         <%}else{%>
  157.             <img src="shopskin/default/images/noimg.jpg" width="80" height="105">
  158.         <%}%>
  159. </td>
  160.         </tr>
  161.         <tr>
  162.           <td height="22" align="center"><a href="../../showtopic.jsp?rootid=<%=ad.getMsgRootId()%>" class="link_commodity"><%=ad.getName()%></a></td>
  163.         </tr>
  164.         <tr>
  165.           <td align="center"><%=ad.getSellTypeDesc(request)%>&nbsp;
  166.             <%
  167. AuctionWorthDb aw = new AuctionWorthDb();
  168. long[] ary = aw.getWorthOfAuction(ad.getMsgRootId());
  169. if (ad.getSellType()==ad.SELL_TYPE_AUCTION) {
  170. aw = aw.getAuctionWorthDb((int)ary[0]);
  171. %>
  172.             <span class="text_price"><%=aw.getMoneyName()%><%=aw.getPrice()%>&nbsp;<%=aw.getMoneyDanWei()%></span>
  173.             <%} else {
  174. int len = ary.length;
  175. for (int i=0; i<len; i++) {
  176. aw = aw.getAuctionWorthDb((int)ary[i]);
  177. %>
  178.             &nbsp;<span class="text_price"><%=aw.getMoneyName()%><%=aw.getPrice()%>&nbsp;<%=aw.getMoneyDanWei()%></span><br>
  179.             <%}
  180. }%>
  181.           </td>
  182.         </tr>
  183.       </table>
  184.       <%}%>
  185.     </td>
  186.   </tr>
  187. </table>
  188. <TABLE width=98% border=0 align="center" cellPadding=0 cellSpacing=0 class="main_table_bg">
  189.   <TBODY>
  190.     <TR>
  191.       <TD width="19%" align=middle vAlign=top><TABLE cellSpacing=0 cellPadding=0 width=100% border=0 class="dir_frame">
  192.           <TBODY>
  193.             <TR>
  194.               <TD height=33 valign="top" class=p3><table width="100%"  border="0" cellpadding="0" cellspacing="0" class="dir_title">
  195.                   <tr>
  196.                     <td><span id=dir_title class="text_white_bold">商品目录</span></td>
  197.                   </tr>
  198.                 </table>
  199.                 <table width="99%" height="29"  border="0" cellpadding="0" cellspacing="0">
  200.                   <tr>
  201.                     <td width="11%" class="text_dir_all">&nbsp;</td>
  202.                     <td align="left" class="text_dir_all"><img src="images/default/arrow.gif" width="13" height="12" border="0" align="absmiddle">&nbsp;<span class="dirItem"><a href="shop.jsp?userName=<%=StrUtil.UrlEncode(userName)%>">全部商品</a></span></td>
  203.                   </tr>
  204.                 </table>
  205.                 <%
  206. AuctionShopDirDb asd = new AuctionShopDirDb();
  207. Iterator irdir = asd.list(userName).iterator();
  208. while (irdir.hasNext())
  209. {
  210. asd = (AuctionShopDirDb) irdir.next();
  211. %>
  212.                 <table width=100% border=0 cellspacing=0 cellpadding=0 class="p9">
  213.                   <tr>
  214.                     <td width=11% height=20>&nbsp;</td>
  215.                     <td width=89%><img src="images/default/arrow.gif" width="13" height="12" border="0" align="absmiddle">&nbsp;<span class="dirItem"><a href="?userName=<%=StrUtil.UrlEncode(userName)%>&dirCode=<%=StrUtil.UrlEncode(asd.getCode())%>"><%=asd.getDirName()%></a></span></td>
  216.                   </tr>
  217.                 </table>
  218.                 <% }%>
  219.                 <table width="99%" height="29"  border="0" cellpadding="0" cellspacing="0">
  220.                   <tr>
  221.                     <td width="11%" class="text_dir_all">&nbsp;</td>
  222.                     <td align="left" class="text_dir_all"><img src="images/default/arrow.gif" width="13" height="12" border="0" align="absmiddle">&nbsp;<span class="dirItem"><a href="shop_alipay.jsp?userName=<%=StrUtil.UrlEncode(userName)%>">支付宝交易</a></span></td>
  223.                   </tr>
  224.                 </table></TD>
  225.             </TR>
  226.           </TBODY>
  227.         </TABLE>
  228.         <br>
  229.         <TABLE cellSpacing=0 cellPadding=0 width=100% border=0 class="link_frame">
  230.           <TBODY>
  231.             <TR>
  232.               <TD height=161 valign="top" class=p3><table width="100%"  border="0" cellpadding="0" cellspacing="0" class="dir_title">
  233.                   <tr>
  234.                     <td><span id=dir_title class="text_white_bold">友情链接</span></td>
  235.                   </tr>
  236.                 </table>
  237.                 <%
  238. LinkDb ld = new LinkDb();
  239. String listsql = "select id from " + ld.getTableName() + " where userName=" + StrUtil.sqlstr(userName) + " and kind=" + StrUtil.sqlstr(ld.KIND_SHOP) + " order by sort";
  240. Iterator irlink = ld.list(listsql).iterator();
  241. while (irlink.hasNext())
  242. {
  243. ld = (LinkDb) irlink.next();
  244. %>
  245.                 <table width=100% border=0 cellspacing=0 cellpadding=0 class="p9">
  246.                   <tr>
  247.                     <td width=11% height=20>&nbsp;</td>
  248.                     <td width=89%>&nbsp;<span class="dirItem"><a target="_blank" href="<%=ld.getUrl()%>" title="<%=ld.getTitle()%>"><%=ld.getTitle()%></a></span></td>
  249.                   </tr>
  250.                 </table>
  251.                 <%}%>
  252.               </TD>
  253.             </TR>
  254.           </TBODY>
  255.         </TABLE></TD>
  256.       <TD vAlign=top width=1%>&nbsp;</TD>
  257.       <TD width="80%" vAlign=top><TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 class="p9">
  258.           <TBODY>
  259.             <TR>
  260.               <TD width="431">
  261.             <TR vAlign=top>
  262.               <TD height="251" colspan="2"><table width="100%"  border="0" cellpadding="0" cellspacing="0">
  263.                   <tr>
  264.                     <td width="97" height="22" class="commodity_bar">&nbsp;&nbsp;
  265. <%
  266. String dirCode = ParamUtil.get(request, "dirCode");
  267. String dirName = "全部商品";
  268. if (!dirCode.equals("")) {
  269. asd = asd.getAuctionShopDirDb(userName, dirCode);
  270. if (asd!=null && asd.isLoaded()) {
  271. dirName = asd.getDirName();
  272. }
  273. }
  274. %>
  275. <span class="commodity_title_text"><%=dirName%></span>
  276. </td>
  277.                     <td><table width="100%" border="0" cellpadding="0" cellspacing="0" class="p9">
  278.                         <form name="form_search" method="post" action="search.jsp" onSubmit="">
  279.                           <tr>
  280.                             <td width="57%" align="center">&nbsp;</td>
  281.                             <td width="43%" height="22" align="center"><input value="" name="what" onFocus="" onBlur="" type="text" class="singleboarder" size=16 style="height: 18">
  282.                               <input type="image" value="images/default/search.gif" src="images/default/search.gif" align="middle" width="57" height="16"></td>
  283.                           </tr>
  284.                         </form>
  285.                       </table></td>
  286.                   </tr>
  287.                   <tr>
  288.                     <td height="4" colspan="2" class="commodity_bar_tr"></td>
  289.                   </tr>
  290.                 </table>
  291.                 <%
  292. String sql = "";
  293. if (dirCode.equals(""))
  294. sql = "select msgRootId from " + ad.getTableName() + " where userName="+StrUtil.sqlstr(userName) + " order by beginDate desc";
  295. else
  296. sql = "select msgRootId from " + ad.getTableName() + " where userName="+StrUtil.sqlstr(userName) + " and shopDir=" + StrUtil.sqlstr(dirCode) + " order by beginDate desc";
  298. int pagesize = 20;
  299. Paginator paginator = new Paginator(request);
  301. int total = ad.getObjectCount(sql);
  302. paginator.init(total, pagesize);
  303. int curpage = paginator.getCurPage();
  304. //设置当前页数和总页数
  305. int totalpages = paginator.getTotalPages();
  306. if (totalpages==0)
  307. {
  308. curpage = 1;
  309. totalpages = 1;
  310. }
  311. %>
  312.                 <% if(paginator.getTotal()>0){ %>
  313.                 <table width="91%" border="0" cellspacing="0" cellpadding="0" align="center" class="p9" height="24">
  314.                   <tr>
  315.                     <td width="100%" height="24" valign="bottom"><div align="right">共 <b><%=paginator.getTotal() %></b> 条　每页<b><%=paginator.getPageSize() %></b> 条　<b><%=curpage %>/<%=totalpages %></b> &nbsp;&nbsp;
  316.                         <%
  317.   String querystr = "userName=" + StrUtil.UrlEncode(userName) + "&dirCode=" + StrUtil.UrlEncode(dirCode);
  318.     out.print(paginator.getCurPageBlock("?"+querystr));
  319.   %>
  320.                       </div></td>
  321.                   </tr>
  322.                 </table>
  323.                 <%}%>
  324.                 <table width="100%"  border="0" cellspacing="8">
  325.                   <%
  326. Iterator ir = ad.list(sql, (curpage-1)*pagesize, curpage*pagesize-1).iterator();
  327. int k = 0;
  328. while (ir.hasNext()) {
  329. ad = (AuctionDb) ir.next();
  330. k++;
  331. if (k==1) {%>
  332.                   <tr>
  333.                     <td bgcolor="#FFFFFF"><%}
  334. %>
  335.                       <table width="120" border=0 align="left" class="p9">
  336.                         <tr>
  337.                           <td height=100 align=center valign=bottom><%
  338.   String fileName = StrUtil.getNullString(ad.getImage());
  339.   if (fileName.equals("")) {
  340. md = md.getMsgDb(ad.getMsgRootId());
  341. fileName = StrUtil.getNullString(md.getFileName());
  342.   }
  343.   if (!fileName.equals("")) {
  344.   %>
  345.                             <img src="../../<%=fileName%>" width="80">
  346.                           <%}else{%>
  347.                             <img src="shopskin/default/images/noimg.jpg" width="80" height="105">
  348.                           <%}%>
  349.                           </td>
  350.                         </tr>
  351.                         <tr>
  352.                           <td width="154" height="20" align="center" valign="top">&nbsp; <a href="../../showtopic.jsp?rootid=<%=ad.getMsgRootId()%>" class="link_commodity"><%=ad.getName()%></a></td>
  353.                         </tr>
  354.                         <tr>
  355.                           <td height="40" align="center" valign="top"><%
  356. AuctionWorthDb aw = new AuctionWorthDb();
  357. long[] ary = aw.getWorthOfAuction(ad.getMsgRootId());
  358. if (ad.getSellType()==ad.SELL_TYPE_AUCTION) {
  359. // System.out.println("msgRootId=" + ad.getMsgRootId());
  360. if (ary.length!=0)
  361. aw = aw.getAuctionWorthDb((int)ary[0]);
  362. %>
  363.                             拍卖&nbsp;<%=aw.getMoneyName()%><%=aw.getPrice()%>&nbsp;<%=aw.getMoneyDanWei()%>
  364.                             <%} else {
  365. int len = ary.length;
  366. for (int m=0; m<len; m++) {
  367. aw = aw.getAuctionWorthDb((int)ary[m]);
  368. %>
  369.                             一口价&nbsp;<%=aw.getMoneyName()%><%=aw.getPrice()%>&nbsp;<%=aw.getMoneyDanWei()%><br>
  370.                             <%}
  371. }%>
  372.                           </td>
  373.                         </tr>
  374.                       </table>
  375.                       <%
  376.    if (k==5) {
  377. out.print("</td></tr>");
  378. k = 0;
  379. }
  380.   }%>
  381.                       <%if (k!=0) {%>
  382.                     </td>
  383.                   </tr>
  384.                   <%}%>
  385.                 </table>
  386.                 <table width="100%"  border="0" cellspacing="0" cellpadding="0">
  387.                   <tr>
  388.                     <td>&nbsp;</td>
  389.                   </tr>
  390.                 </table>
  391.                 <jsp:useBean id="msg" scope="page" class="cn.js.fan.module.guestbook.MessageDb"/>
  392.                 
  393.                 <table width="100%"  border="0" cellpadding="8">
  394.                   <tr>
  395.                     <td><table width="100%"  border="0" align="center" cellpadding="0" cellspacing="0">
  396.                         <tr>
  397.                           <td height="2" colspan="2" class="guestbook_bar_tr"></td>
  398.                         </tr>
  399.                         <tr>
  400.                           <td width="153" height="24" class="guestbook_bar">&nbsp;&nbsp;<span class="text_white_bold">本店最新留言</span></td>
  401.                           <td align="right"><a href="guestbook.jsp?shopCode=<%=StrUtil.UrlEncode(userName)%>" class="nav_guestbook">更多留言</a>&nbsp;&nbsp;<a href="guestbook.jsp?shopCode=<%=StrUtil.UrlEncode(userName)%>" class="nav_guestbook">我要留言</a>&nbsp;&nbsp;</td>
  402.                         </tr>
  403.                       </table>
  404.                       <%
  405. sql = "select id from guestbook where shopCode=" + StrUtil.sqlstr(userName) + " order by lydate desc";
  406. Iterator ri = msg.list(sql, 0, 2).iterator();
  407. while (ri.hasNext()) {
  408.   msg = (MessageDb)ri.next();
  409. %>
  410.                       <table width="100%" border="0" align="center" cellpadding="6" cellspacing="0" bgcolor="#FFFFFF" class="tableframe">
  411.                         <tr>
  412.                           <td width="27%" height="22" valign="bottom" class="stable style4">用户：<%=StrUtil.toHtml(msg.getUserName())%>　</td>
  413.                           <td width="73%" height="22" valign="bottom" class="stable style4">留言日期：<%=DateUtil.format(msg.getLydate(), "yy-MM-dd HH:mm:ss")%></td>
  414.                         </tr>
  415.                         <tr valign="top">
  416.                           <td height="83" colspan="2" class="stable"><%=StrUtil.toHtml(msg.getContent())%><br>
  417.                             <%
  418.   String reply = StrUtil.getNullString(msg.getReply());
  419.   if (!reply.equals(""))
  420.   {
  421.   %>
  422.                             <br>
  423.                             <font color="#F09F6F">回复：</font><%=StrUtil.toHtml(reply)%> <br>
  424.                             日期：<%=DateUtil.format(msg.getLydate(), "yy-MM-dd HH:mm:ss")%>
  425.                             <% } %>
  426.                           </td>
  427.                         </tr>
  428.                         <tr valign="top">
  429.                           <td height="1" colspan="2"  bgcolor="#999999"></td>
  430.                         </tr>
  431.                       </table>
  432.                       <%}%></td>
  433.                   </tr>
  434.                 </table>
  435.                 <table width="100%"  border="0" cellspacing="0" cellpadding="0">
  436.                   <tr>
  437.                     <td align="right"></td>
  438.                   </tr>
  439.                 </table></TD>
  440.             </TR>
  441.           </TBODY>
  442.         </TABLE></TD>
  443.     </TR>
  444.   </TBODY>
  445. </TABLE>
  446. <table width="98%"  border="0" align="center">
  447.   <tr>
  448.     <td height="34" align="center"><HR style="height:1px; color:"#999999">
  449.       Copyright 2005 版权所有：<a href="<%=Global.getRootPath()%>" class="link_commodity"><%=Global.AppName%></a><br>
  450.       联系人：<%=as.getContacter()%></td>
  451.   </tr>
  452. </table>
  453. </BODY>
  454. </HTML>