📄 seedd.jsp

📁 用JSP写的一个在线购物网站的代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
String id=request.getParameter("action");
%>
<style type="text/css">
<!-- @import url(images/css.css); -->
</style>
<body leftmargin="0" topmargin="0">
<%
String sql="select * from preordain where dingdanid='"+id+"'";
ResultSet rs=data.executeQuery(sql);
rs.next();
String warename=rs.getString("warename");
int number=rs.getInt("number");
String condition=rs.getString("condition");
int price=rs.getInt("price");
int yx=rs.getInt("yx");
String yxdate=rs.getString("yxdate");
String mode=rs.getString("mode");
String pic=rs.getString("pic");
rs.close();
%>
<table align="center" width="400" cellpadding="0" cellspacing="0" border="0" bgcolor="#63bce6">
<tr>
<td height="15"></td>
</tr>
</table>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="80"><div align="right">定单号:</div></td>
<td width="120"><div align="center"><font color="#FF0000"><%=id%></font></div></td>
<td width="80" height="20"><div align="right">商品名:</div></td>
<td width="120"><div align="center"><font color="#FF0000"><%=warename%></font></div></td>
</tr>
 <tr> 
    <td height="1" bgcolor="#E3E2E2" colspan="6"></td>
  </tr>
<tr>
<td height="20"><div align="right">数量:</div></td>
<td><div align="center"><font color="#FF0000"><%=number%></font></div></td>
<td><div align="right">价格条件:</div></td>
<td><div align="center"><%=condition%><font color="#FF0000"><%=price%></font>元</div></td>
</tr>
 <tr> 
    <td height="1" bgcolor="#E3E2E2" colspan="6"></td>
  </tr>
<tr>
<td height="20"><div align="right">有效期:</div></td>
<td><div align="center"><font color="#FF0000"><%=yx%></font><%=yxdate%></div></td>
<td><div align="right">交易方式:</div></td>
<td><div align="center"><font color="#FF0000"><%=mode%></font></div></td>
</tr>
  <tr> 
    <td height="1" bgcolor="#E3E2E2" colspan="6"></td>
  </tr>
  	  <%
	  sql="select * from dingdan where dingdanid='"+id+"'";
	  rs=data.executeQuery(sql);
	  if(rs.next())
	  {
	   String explain=rs.getString("explain");
	   if(explain.equals(""))
	   { explain="无说明"; }
	   String relapse=rs.getString("relapse");
	   if(relapse==null)
	   { relapse="无回复"; }	   
	   String preordainShop=rs.getString("preordainShop");
	   if(preordainShop.equals("0"))
	   { preordainShop="购买"; }
	   else{ preordainShop="预定"; }
	   String feedback=rs.getString("feedback");
	   if(feedback==null)
	   { feedback="无投诉"; }
	   String actiontime=rs.getString("actiontime").substring(0,16);
	   %>
 <tr>
 <td height="20"><div align="right">预定时间:</div></td>
 <td colspan="3"><div align="center"><%=actiontime%></div></td>
 </tr>
   <tr> 
    <td height="1" bgcolor="#E3E2E2" colspan="6"></td>
  </tr>
 <tr>
 <td colspan="4" height="20"><div align="center">参考图片</div></td>
 </tr>
    <tr> 
    <td height="1" bgcolor="#E3E2E2" colspan="6"></td>
  </tr>
 <tr>
 <td colspan="4" height="120">
 <%if(pic.equals("")){%>
 <div align="center"><font color="#FF0000">无参考图片</font></div>
 <%}else{%>
 <div align="center"><img src="upload/<%=pic%>" width="100" height="80" border="0"></div>
 <%}%>
 </td>
 </tr>
</table>
</td>
</tr>
</table>
<br><br><br>
   	  <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" class="defaulttext">
	  <tr>
	  <td height="20" bgcolor="#63bce6"><div align="center"><font color="#FF0000">定单说明</font></div></td>
	  </tr>
	   <tr bgcolor="#FFFFFF">
	   <td width="400"><div align="center"><%=explain%></div></td>
	   </tr>	 
	  </table>
	  <table width="400" align="center" cellpadding="0" cellspacing="1" border="0" bgcolor="#CCCCCC" class="defaulttext">
	  <tr>
	  <td height="20" bgcolor="#63bce6"><div align="center"><font color="#FF0000">定单回复</font></div></td>
	  </tr>
	  <tr bgcolor="#FFFFFF">
	  <td width="100%"><div align="center"><%=relapse%></div></td>
	  </tr>
	  </table>
	  <table width="400" align="center" cellpadding="0" cellspacing="1" border="0" bgcolor="#CCCCCC" class="defaulttext">
	  <tr>
	  <td height="20" bgcolor="#63bce6"><div align="center"><font color="#FF0000">定单投诉</font></div></td>
	  </tr>
	  <tr bgcolor="#FFFFFF">
	  <td width="100%"><div align="center"><%=feedback%></div></td>
	  </tr>
	  </table>
      <table width="96%">
	  <tr>
	  <td height="30"></td>
	  </tr>
	  </table>
	  <%}%>
	  </td>
   </tr>
</table>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -