dd.jsp

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

<table width="500" border="0" align="center" cellpadding="0" cellspacing="0" class="defaulttext">
  <tr> 
    <td width="40" height="20"><div align="center"><font color="#990000">序号</font></div></td>
    <td width="80"><div align="center"><font color="#990000">定单号</font></div></td>
    <td width="220"><div align="center"></div></td>
    <td width="60"><div align="center"><font color="#990000">定单状态</font></div></td>
    <td colspan="2"><div align="center"><font color="#990000">定单操作</font></div>
      <div align="center"></div></td>
  </tr>
  <tr> 
    <td height="1" bgcolor="#E3E2E2" colspan="6"></td>
  </tr>
  <%
  sql="select * from dingdan where buyid='"+member+"' and send='"+"0"+"'";
  rs=data.executeQuery(sql);
  int i=0;
  int did=0;
  String censor_yes="";  
  String preordainShop="";
  while(rs.next())
  {
  i++;
  did=rs.getInt("dingdanid");
  censor_yes=rs.getString("censor_yes");
  if(censor_yes.compareTo("0")==0)
  { censor_yes="<font color='#0000FF'>未审核</font>"; }
  else{ censor_yes="<font color='#FF0000'>已审核</font>"; }
  preordainShop=rs.getString("preordainShop");
  %>
  <tr> 
    <td width="40" height="20"><div align="center"><%=i%></div></td>
    <td width="80"><div align="center">
	<%if(preordainShop.equals("0")){%>
	<a href="javascript:look(<%=did%>)"><%=did%></a>
	<%}else{%>
	<a href="javascript:see(<%=did%>)"><%=did%></a>
	<%}%></div></td>
    <td width="220">.......................................</td>
    <td width="60"><div align="center"><%=censor_yes%></div></td>
    <td width="60"><div align="center">
	<%if(preordainShop.equals("0")){%>
	<a href="canceldd.jsp?id=<%=did%>">取消定单</a>
	<%}else{%>
	<a href="deldingdan.jsp?id=<%=did%>">取消定单</a>
	<%}%></div></td>
    <td width="40"><div align="center"><a href="javascript:feedback(<%=did%>)">投诉</a></div></td>
  </tr>
    <tr> 
    <td height="1" bgcolor="#E3E2E2" colspan="6"></td>
  </tr>
  <%}if(i==0){%>
  <div align="center" class="defaulttext"><font color="#FF0000">您尚未发出定单</font></div>
  <%}%>
</table>