【JSP开源代码栏目提醒】:网学会员,鉴于大家对JSP开源代码十分关注,论文会员在此为大家搜集整理了“formtxt.jsp”一文,供大家参考学习!
<%@ include file="../conn.jsp"%>
<% String sql;
String Num=request.getParameter("Num");
String Nam=request.getParameter("Nam");
sql="Select * from scott.订单内容 where 订单号='" +Num+ "'";
ResultSet rs=stmt.executeQuery(sql);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>订单内容</title>
</head>
<body topmargin="0" leftmargin="0">
<table border="0" cellpadding="0" cellspacing="0" width="353" height="236">
<tr>
<td width="20" rowspan="4" height="96"></td>
<td width="233" height="24"></td>
<td width="110" height="99" rowspan="4"><img border="0" src="PE02097_.wmf" width="125" height="99"></td>
</tr>
<tr>
<td width="233" height="26"> <font size="3" face="方正姚体" color="#000080">订单号码: <%=Num%></font></td>
</tr>
<tr>
<td width="233" height="21"> <font size="3" face="方正姚体" color="#000080">用户帐号: <%=Nam%></font></td>
</tr>
<tr>
<td width="233" height="28"></td>
</tr>
<tr>
<td width="363" colspan="3" height="9">
<table border="1" cellpadding="0" cellspacing="0" width="100%" bordercolorlight="#FFFFFF" bordercolordark="#808080">
<tr>
<td width="197" bgcolor="#C0C0C0" align="center"><font face="方正姚体" size="3">商品名称</font></td>
<td width="83" bgcolor="#C0C0C0" align="center"><font face="方正姚体" size="3">价格</font></td>
<td width="71" bgcolor="#C0C0C0" align="center"><font face="方正姚体" size="3">数量</font></td>
</tr>
<% while(rs.next()) { %>
<tr>
<td width="197"><font size="2"><%=rs.getString("商品")%></font></td>
<td width="83">
<p align="center"><font size="2"><%=rs.getString("价格")%></font></td>
<td width="71">
<p align="center"><font size="2"><%=rs.getString("数量")%></font></td>
</tr>
<%}
rs.close();
sql="Select sum(价格) as countall from scott.订单内容 where 订单号='" +Num+ "'";
rs=stmt.executeQuery(sql);
if(rs.next()) {
%> <tr>
<td colspan="3">
<p align="right"><font face="方正姚体">订单总价为:<font color="#FF0000"><%=rs.getString("countall")%></font><font color="#000000">元</font></font>
</td>
</tr>
<%}%>
</table>
</td>
</tr>
<%rs.close();
sql="Select * from scott.客户信息 where 账号='" +Nam+ "'";
rs=stmt.executeQuery(sql);
if(rs.next()) {
%>
<tr>
<td width="363" colspan="3" height="19" valign="top">
<p align="right">
</td>
</tr>
<tr>
<td width="363" colspan="3" height="55">
<table border="1" cellpadding="0" cellspacing="0" width="100%" bordercolorlight="#FFFFFF" bordercolordark="#808080">
<tr>
<td width="73" align="center" bgcolor="#C0C0C0"><font size="2"></font></td>
<td width="109"><font size="2"><%=rs.getString("")%></font></td>
<td width="74" align="center" bgcolor="#C0C0C0"><font size="2">电话</font></td>
<td width="101"><font size="2"><%=rs.getString("电话")%></font></td>
</tr>
<tr>
<td width="72" align="center" bgcolor="#C0C0C0"><font size="2">地址</font></td>
<td width="281" colspan="3"><font size="2"><%=rs.getString("住址")%></font></td>
</tr>
<tr>
<td width="72" align="center" bgcolor="#C0C0C0"><font size="2">邮件</font></td>
<td width="281" colspan="3"><font size="2"><%=rs.getString("妹儿")%></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="363" colspan="3" height="21">
</td>
</tr>
<tr>
<td width="363" colspan="3" height="36"><form name="DONE" action="Doit.jsp" method="POST"><input name="OP" type="hidden"><input name="NumBer" type="hidden">
<table border="1" cellpadding="0" cellspacing="0" width="100%" bordercolorlight="#FFFFFF" bordercolordark="#808080" height="31">
<tr>
<td width="71%" height="19"> <font size="2">1、如果订单不合法,请将其作废。</font></td>
<td width="29%" bgcolor="#C0C0C0" height="19">—〉<font size="2" color="blue"><a href style="CURSOR:hand" onClick="DONE.OP.value=1; DONE.NumBer.value='<%=Num%>'; DONE.submit()">作废</a></font></td>
</tr>
<tr>
<td width="71%" height="8"><font size="2"> 2、如果已将定购物品寄出,请选此项。</font></td>
<td width="29%" bgcolor="#C0C0C0" height="8">—〉<font size="2" color="blue"><a href style="CURSOR:hand" onClick="DONE.OP.value=2; DONE.NumBer.value='<%=Num%>'; DONE.submit()">完成</a></font></td>
</tr>
<tr>
<td width="71%" height="8"><font size="2"> 3、如果暂时不做处理,请选择关闭。</font></td>
<td width="29%" bgcolor="#C0C0C0" height="8">—〉<font size="2" color="blue"><a href style="CURSOR:hand" onClick="window.close()">关闭</a></font></td>
</tr>
</table></form>
</td>
</tr>
</table>
<% }%>
</body>
</html>
上一篇:
formtxs.jsp
下一篇:
电咖汽车入选2018独角兽企业榜百强 发布“天际”品牌将推高估值