record.jsp

用JSP写的一个在线购物网站的代码

<table align="center" width="450" cellpadding="0" cellspacing="0" border="0" class="defaulttext">
  <tr>
  <td width="100"><div align="right"><font color="#990000">定单号</font></div></td>
  <td width="200"></td>
  <td width="150"><div align="center"><font color="#990000">提交日期</font></div></td>
  </tr>
  <tr> 
    <td height="1" bgcolor="#E3E2E2" colspan="3"></td>
  </tr>
<%
 sql="select * from dingdan where buyid='"+member+"' and send='"+"1"+"'";
rs=data.executeQuery(sql);
int count=0;
int dingdanid=0;
String relapse="";
String  preordainShop="";
String actiontime="";
while(rs.next())
{
count++;
dingdanid=rs.getInt("dingdanid");
relapse=rs.getString("relapse");
preordainShop=rs.getString("preordainShop");
actiontime=rs.getString("actiontime").substring(0,16);
%>
<tr>
<td width="100"><div align="right">
<%if(preordainShop.equals("0")){%>
<a href="javascript:look(<%=dingdanid%>)"><%=dingdanid%></a>
<%}else{%>
<a href="javascript:see(<%=dingdanid%>)"><%=dingdanid%></a><%}%></div></td>
<td width="200">..............................................</td>
<td width="150"><div align="center"><%=actiontime%></div></td>
</tr>
  <tr> 
    <td height="1" bgcolor="#E3E2E2" colspan="3"></td>
  </tr>
<%}
if(count==0)
{%>
<div align="center" class="defaulttext"><font color="#FF0000">您尚未购买本商场的任何商品</font></div>
<%}%>
</table>