📄 shop_alipay.jsp
字号:
<td width=89%><img src="images/default/arrow.gif" width="13" height="12" border="0" align="absmiddle"> <span class="dirItem"><a href="?userName=<%=StrUtil.UrlEncode(userName)%>&dirCode=<%=StrUtil.UrlEncode(asd.getCode())%>"><%=asd.getDirName()%></a></span></td>
</tr>
</table>
<% }%>
<table width="99%" height="29" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="11%" class="text_dir_all"> </td>
<td align="left" class="text_dir_all"><img src="images/default/arrow.gif" width="13" height="12" border="0" align="absmiddle"> <span class="dirItem"><a href="shop_alipay.jsp?userName=<%=StrUtil.UrlEncode(userName)%>">支付宝交易</a></span></td>
</tr>
</table></TD>
</TR>
</TBODY>
</TABLE>
<br>
<TABLE cellSpacing=0 cellPadding=0 width=100% border=0 class="link_frame">
<TBODY>
<TR>
<TD height=161 valign="top" class=p3><table width="100%" border="0" cellpadding="0" cellspacing="0" class="dir_title">
<tr>
<td><span id=dir_title class="text_white_bold">友情链接</span></td>
</tr>
</table>
<%
LinkDb ld = new LinkDb();
String listsql = "select id from " + ld.getTableName() + " where userName=" + StrUtil.sqlstr(userName) + " and kind=" + StrUtil.sqlstr(ld.KIND_SHOP) + " order by sort";
Iterator irlink = ld.list(listsql).iterator();
while (irlink.hasNext())
{
ld = (LinkDb) irlink.next();
%>
<table width=100% border=0 cellspacing=0 cellpadding=0 class="p9">
<tr>
<td width=11% height=20> </td>
<td width=89%> <span class="dirItem"><a target="_blank" href="<%=ld.getUrl()%>" title="<%=ld.getTitle()%>"><%=ld.getTitle()%></a></span></td>
</tr>
</table>
<%}%>
</TD>
</TR>
</TBODY>
</TABLE></TD>
<TD vAlign=top width=1%> </TD>
<TD width="80%" vAlign=top><TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 class="p9">
<TBODY>
<TR>
<TD width="431">
<TR vAlign=top>
<TD height="251" colspan="2"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="97" height="22" class="commodity_bar">
<%
String dirName = "支付宝交易";
%>
<span class="commodity_title_text"><%=dirName%></span>
</td>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0" class="p9">
<form name="form_search" method="post" action="?op=search" onSubmit="">
<tr>
<td width="54%" align="center"> </td>
<td width="46%" height="22" align="center">
<input name="userName" value="<%=userName%>" type=hidden>
本店支付宝
<input value="" name="what" onFocus="" onBlur="" type="text" class="singleboarder" size=16 style="height: 18">
<input type="image" value="images/default/search.gif" src="images/default/search.gif" align="middle" width="57" height="16"></td>
</tr>
</form>
</table></td>
</tr>
<tr>
<td height="4" colspan="2" class="commodity_bar_tr"></td>
</tr>
</table>
<%
AlipayDb ali = new AlipayDb();
String sql = "select msgRootId from " + ali.getTableName() + " a, sq_thread t where t.id=a.msgRootId and t.name="+StrUtil.sqlstr(userName) + " order by t.lydate desc";
String op = ParamUtil.get(request, "op");
String what = ParamUtil.get(request, "what");
if (op.equals("search")) {
sql = "select msgRootId from " + ali.getTableName() + " a, sq_thread t where t.id=a.msgRootId and t.name="+StrUtil.sqlstr(userName) + " and a.alipay_subject like " + StrUtil.sqlstr("%" + what + "%") + " order by t.lydate desc";
}
int pagesize = 20;
Paginator paginator = new Paginator(request);
int curpage = paginator.getCurPage();
ListResult lr = ali.listResult(sql, curpage, pagesize);
Iterator ir = lr.getResult().iterator();
int total = lr.getTotal();
paginator.init(total, pagesize);
//设置当前页数和总页数
int totalpages = paginator.getTotalPages();
if (totalpages==0)
{
curpage = 1;
totalpages = 1;
}
%>
<% if(paginator.getTotal()>0){ %>
<table width="91%" border="0" cellspacing="0" cellpadding="0" align="center" class="p9" height="24">
<tr>
<td width="100%" height="24" valign="bottom"><div align="right">共 <b><%=paginator.getTotal() %></b> 条 每页<b><%=paginator.getPageSize() %></b> 条 <b><%=curpage %>/<%=totalpages %></b>
<%
String querystr = "userName=" + StrUtil.UrlEncode(userName) + "&op=" + op + "&what=" + StrUtil.UrlEncode(what);
out.print(paginator.getCurPageBlock("?"+querystr));
%>
</div></td>
</tr>
</table>
<%}%>
<table width="100%" border="0" cellspacing="8">
<%
int k = 0;
while (ir.hasNext()) {
ali = (AlipayDb) ir.next();
k++;
if (k==1) {%>
<tr>
<td bgcolor="#FFFFFF"><%}
%>
<table width="120" border=0 align="left" class="p9">
<tr>
<td width="154" height="24" align="center" valign="top"> <a href="../../showtopic.jsp?rootid=<%=ali.getMsgRootId()%>" class="link_commodity"><%=ali.getSubject()%></a></td>
</tr>
<tr>
<td height="40" align="center">邮递：<%=ali.getTransportDesc(request)%></td>
</tr>
<tr>
<td height="40" align="center">
价格：<%=ali.getPrice()%>
元</td>
</tr>
</table>
<%
if (k==5) {
out.print("</td></tr>");
k = 0;
}
}%>
<%if (k!=0) {%>
</td>
</tr>
<%}%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<jsp:useBean id="msg" scope="page" class="cn.js.fan.module.guestbook.MessageDb"/>
<table width="100%" border="0" cellpadding="8">
<tr>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="2" colspan="2" class="guestbook_bar_tr"></td>
</tr>
<tr>
<td width="153" height="24" class="guestbook_bar"> <span class="text_white_bold">本店最新留言</span></td>
<td align="right"><a href="guestbook.jsp?shopCode=<%=StrUtil.UrlEncode(userName)%>" class="nav_guestbook">更多留言</a> <a href="guestbook.jsp?shopCode=<%=StrUtil.UrlEncode(userName)%>" class="nav_guestbook">我要留言</a> </td>
</tr>
</table>
<%
sql = "select id from guestbook where shopCode=" + StrUtil.sqlstr(userName) + " order by lydate desc";
Iterator ri = msg.list(sql, 0, 2).iterator();
while (ri.hasNext()) {
msg = (MessageDb)ri.next();
%>
<table width="100%" border="0" align="center" cellpadding="6" cellspacing="0" bgcolor="#FFFFFF" class="tableframe">
<tr>
<td width="27%" height="22" valign="bottom" class="stable style4">用户：<%=StrUtil.toHtml(msg.getUserName())%> </td>
<td width="73%" height="22" valign="bottom" class="stable style4">留言日期：<%=DateUtil.format(msg.getLydate(), "yy-MM-dd HH:mm:ss")%></td>
</tr>
<tr valign="top">
<td height="83" colspan="2" class="stable"><%=StrUtil.toHtml(msg.getContent())%><br>
<%
String reply = StrUtil.getNullString(msg.getReply());
if (!reply.equals(""))
{
%>
<br>
<font color="#F09F6F">回复：</font><%=StrUtil.toHtml(reply)%> <br>
日期：<%=DateUtil.format(msg.getLydate(), "yy-MM-dd HH:mm:ss")%>
<% } %>
</td>
</tr>
<tr valign="top">
<td height="1" colspan="2" bgcolor="#999999"></td>
</tr>
</table>
<%}%></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right"></td>
</tr>
</table></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE>
<table width="98%" border="0" align="center">
<tr>
<td height="34" align="center"><HR style="height:1px; color:"#999999">
Copyright 2005 版权所有：<a href="http://<%=Global.server%>" class="link_commodity"><%=Global.AppName%></a></td>
</tr>
</table>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -