<%@ page contentType="text/html; charset=GBK" %>
<html>
<head>
<title>
结账
</title>
</head>
<body bgcolor="#FFFFFF">
<%@ page import="buyList.buyList"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="db" scope="page" class="opendb.opendb"/>
<%
String name=request.getParameter("name");
byte[] tmpbyte=name.getBytes("ISO8859_1");
name=new String(tmpbyte);
String total=request.getParameter("total");
//保存订单order
String sql="insert into order6(name,total) values ('"+name+"','"+total+"')";
ResultSet rs=db.executeQuery(sql);
sql="select orderId from order6 where name='"+name+"' order by orderId desc";
rs=db.executeQuery(sql);
rs.next();
String orderId=rs.getString("orderId");
rs.close();
//保存到detail
Vector shop=(Vector)session.getValue("shop");
for(int i=0;i<shop.size();i++)
{
//从购物车中读取数据
buyList myList=(buyList)shop.elementAt(i);
sql="insert into detail(orderId,goodId,quantity) values('"+orderId+"','"+myList.pid+"','"+myList.number+"')";
String sql2="insert process(orderId,quantify)values('"+orderId+"','"+myList.number+"')";
rs=db.executeQuery(sql);
ResultSet rs2=db.executeQuery(sql2);
}
session.invalidate();
%>
<p><%=name%>先生(小姐):</p>
<p>您的订单清单已经写入我们的数据库中!你总共需要支付<br>
人民币<%=total%>元。我们将在收到汇款后发货。</p><form name="formname" method="post" action="">
<jsp:useBean id="db1" scope="page" class="opendb.opendb"/>
<%
String prosql="select quantify from process where orderId='"+orderId+"'";
ResultSet prors=db1.executeQuery(prosql);
prors.next();
String qua=prors.getString("quantify");
prors.close();
%><table width="750" border="0">
<tr>
<td colspan="4">
<div align="center">结果如下</div>
</td>
</tr>
<tr>
<td width="145">
<div align="right">数量:</div>
</td>
<td width="228">
<input type="text" name="quantify" value='<%=qua%>' size="20">
</td>
</tr>
</table>
<p> </p>
<p> </p>
</form>
</body>
<script language="javascript">
setTimeout("formname.submit();",1000);//一秒钟提交一次并在页首扫描数据库;
</script>
</html>
<html>
<head>
<title>
结账
</title>
</head>
<body bgcolor="#FFFFFF">
<%@ page import="buyList.buyList"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="db" scope="page" class="opendb.opendb"/>
<%
String name=request.getParameter("name");
byte[] tmpbyte=name.getBytes("ISO8859_1");
name=new String(tmpbyte);
String total=request.getParameter("total");
//保存订单order
String sql="insert into order6(name,total) values ('"+name+"','"+total+"')";
ResultSet rs=db.executeQuery(sql);
sql="select orderId from order6 where name='"+name+"' order by orderId desc";
rs=db.executeQuery(sql);
rs.next();
String orderId=rs.getString("orderId");
rs.close();
//保存到detail
Vector shop=(Vector)session.getValue("shop");
for(int i=0;i<shop.size();i++)
{
//从购物车中读取数据
buyList myList=(buyList)shop.elementAt(i);
sql="insert into detail(orderId,goodId,quantity) values('"+orderId+"','"+myList.pid+"','"+myList.number+"')";
String sql2="insert process(orderId,quantify)values('"+orderId+"','"+myList.number+"')";
rs=db.executeQuery(sql);
ResultSet rs2=db.executeQuery(sql2);
}
session.invalidate();
%>
<p><%=name%>先生(小姐):</p>
<p>您的订单清单已经写入我们的数据库中!你总共需要支付<br>
人民币<%=total%>元。我们将在收到汇款后发货。</p><form name="formname" method="post" action="">
<jsp:useBean id="db1" scope="page" class="opendb.opendb"/>
<%
String prosql="select quantify from process where orderId='"+orderId+"'";
ResultSet prors=db1.executeQuery(prosql);
prors.next();
String qua=prors.getString("quantify");
prors.close();
%><table width="750" border="0">
<tr>
<td colspan="4">
<div align="center">结果如下</div>
</td>
</tr>
<tr>
<td width="145">
<div align="right">数量:</div>
</td>
<td width="228">
<input type="text" name="quantify" value='<%=qua%>' size="20">
</td>
</tr>
</table>
<p> </p>
<p> </p>
</form>
</body>
<script language="javascript">
setTimeout("formname.submit();",1000);//一秒钟提交一次并在页首扫描数据库;
</script>
</html>
解决方案 »
- 偶尔出现:forward() not allowed after buffer has committed.
- 一个有关图像的问题
- <jsp:useBean id="" class = "question"/>
- 请高手指点小弟一个关于点击button忘数据库登陆的问题。
- oracle的服务端、客户端分别是什么意思?
- 跪求:网页链接看过的显示灰色问题
- 我的打印页面为什么不打印?哪位高手帮忙看看.只有在弹出页面按一次刷新,它才弹出打印框.
- servlat访问数据库的问题,帮我看看那,谢谢
- 怎样使用post方式提交打开一个新页面.(解决了立即给分)
- 判断一个记录集RS是否为空的语句怎么写?
- 对frame窗口传参的问题
- 传递Checkbox的值???
运行时第一次是对的,刷新后就没有值了String sql2="insert process(orderId,quantify)values('"+orderId+"','"+myList.number+"')";
ResultSet rs2=db.executeQuery(sql2);
对process的操作是其他应用程序写入的,我的任务是监控这个表,有纪录写入process时,我立即将它读出,就是要不断读出新写入process的纪录
为了方便,这里我自己写入了