您所在位置：主题：[讨论]高手请进!ASP打印问题
stt1986
[专家分：30] 发布于 2008-08-01 14:59:00
请高手指点!按打印按钮,页面自动刷新,页面上的原有数据消失了,代码究竟错在哪里,如何修改?
代码如下:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<p>
<%
id=trim(request.form("id"))
name=trim(request.form("name"))
price=trim(request.form("price"))
quantity=trim(request.form("quantity"))
publisher=trim(request.form("publisher"))
receiver_name=trim(request.form("receiver_name"))
address=trim(request.form("address"))
paytype=trim(request.form("paytype"))
dim conn,str
set conn=server.createobject("adodb.connection")
conn.open "driver={sql server};Server=(local);UID=sa;PWD=sa;Database=Order"
mysql="select * from od where id='"&id&"'"
set rs=conn.execute(mysql)
if not rs.eof then
response.write "该订单记录已插入！"
else
str="insert into od values('"&id&"','"&name&"','"&price&"','"&quantity&"','"&publisher&"','"&receiver_name&"','"&address&"','"&paytype&"')"
conn.execute(str)
response.write "插入成功！"
conn.close
set str=nothing
set conn=nothing
end if
%>
<form name="form1" method="post" action="">
<div align="right">
<input type="submit" name="Submit" value="打印" onclick="window.print();">
</div>
</form>
<p align="center"><font size="+3" face="华文楷体"><strong>订 单</strong></font>
<p>
<table border="1" align="center" width="500">
<tr>
<td width="117"><div align="center">订单号</div></td><td width="367"><%=id%> </td>
</tr>
<tr>
<td><div align="center">订单名称</div></td><td><%=name%> </td>
</tr>
<tr>
<td><div align="center">价格</div></td><td><%=price%></td>
</tr>
<tr>
<td><div align="center">数量</div></td><td><%=quantity%></td>
</tr>
<tr>
<td><div align="center">出版商</div></td><td><%=publisher%></td>
</tr>
<tr>
<td><div align="center">收货人</div></td><td><%=receiver_name%> </td>
</tr>
<tr>
<td> <div align="center">收货地址</div></td><td><%=address%> </td>
</tr>
<tr>
<td><div align="center">付款方式</div></td><td><%=paytype%> </td>
</tr>
</table>
<p> </p>
</body>
</html>
代码如下:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<p>
<%
id=trim(request.form("id"))
name=trim(request.form("name"))
price=trim(request.form("price"))
quantity=trim(request.form("quantity"))
publisher=trim(request.form("publisher"))
receiver_name=trim(request.form("receiver_name"))
address=trim(request.form("address"))
paytype=trim(request.form("paytype"))
dim conn,str
set conn=server.createobject("adodb.connection")
conn.open "driver={sql server};Server=(local);UID=sa;PWD=sa;Database=Order"
mysql="select * from od where id='"&id&"'"
set rs=conn.execute(mysql)
if not rs.eof then
response.write "该订单记录已插入！"
else
str="insert into od values('"&id&"','"&name&"','"&price&"','"&quantity&"','"&publisher&"','"&receiver_name&"','"&address&"','"&paytype&"')"
conn.execute(str)
response.write "插入成功！"
conn.close
set str=nothing
set conn=nothing
end if
%>
<form name="form1" method="post" action="">
<div align="right">
<input type="submit" name="Submit" value="打印" onclick="window.print();">
</div>
</form>
<p align="center"><font size="+3" face="华文楷体"><strong>订 单</strong></font>
<p>
<table border="1" align="center" width="500">
<tr>
<td width="117"><div align="center">订单号</div></td><td width="367"><%=id%> </td>
</tr>
<tr>
<td><div align="center">订单名称</div></td><td><%=name%> </td>
</tr>
<tr>
<td><div align="center">价格</div></td><td><%=price%></td>
</tr>
<tr>
<td><div align="center">数量</div></td><td><%=quantity%></td>
</tr>
<tr>
<td><div align="center">出版商</div></td><td><%=publisher%></td>
</tr>
<tr>
<td><div align="center">收货人</div></td><td><%=receiver_name%> </td>
</tr>
<tr>
<td> <div align="center">收货地址</div></td><td><%=address%> </td>
</tr>
<tr>
<td><div align="center">付款方式</div></td><td><%=paytype%> </td>
</tr>
</table>
<p> </p>
</body>
</html>
