打开页面时,数据库中会自动添加一条空记录,刷新页面也会添加一条空记录,怎么解决?
<!--#include file="conn.asp"-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>数据录入</title>
<script language="javascript">
function good()
{
var d=form1.dwmc.value;
var h=form1.htbh.value;
var g=form1.gmcp.value;
var f=form1.fwqx.value;
if(d=="")
{alert("单位名称不能为空");
form1.dwmc.focus();
}
else if(h=="")
{alert("合同编号不能为空");
form1.htbh.focus();
}
else if (g=="")
{alert("购买产品不能为空");
form1.gmcp.focus();
}
else if (f=="")
{alert("服务期限不能为空");
form1.fwqx.focus();
}
else
{
<% q=request.Form("qu")
dw=request.Form("dwmc")
ht=request.Form("htbh")
gm=request.Form("gmcp")
cp=request.Form("cpsl")
je=request.Form("htje")
fw=request.Form("fwqx")
wg=request.Form("wgsp")
lx=request.Form("lxr")
dh=request.Form("lxdh")
tx=request.Form("txdz")
up="insert into tipht (区域,单位名称,合同编号,购买产品,产品数量,合同金额,服务期限,外购商品,联系人,联系电话,通讯地址) Values ('"&q&"','"&dw&"','"&ht&"','"&gm&"','"&cp&"','"&je&"','"&fw&"','"&wg&"','"&lx&"','"&dh&"','"&tx&"')"
conn.execute(up)
conn.close
set conn=nothing%>;
alert("添加数据成功!");
form1.submit();
}
}
</script>
<link href="style.css" rel="stylesheet">
<style type="text/css">
<!--
.style2 {color: #6666FF}
body {
margin-left: 0px;
margin-top: 0px;
}
.style4 {color: #C60001}
.style5 {
font-size: 10pt;
font-weight: bold;
}
#Layer1 {
position:absolute;
width:451px;
height:211px;
z-index:1;
left: 310px;
top: 250px;
}
.STYLE6 {font-size: 10pt}
.STYLE1 {font-size: 9px}
-->
</style>
</head>
<body>
<%
response.Buffer=true
response.Expires=0
response.ExpiresAbsolute=now()-1
response.CacheControl="no-cache"
%>
<table width="759" align="center" cellspacing="0">
<tr>
<td height="130" colspan="2" background="images2/top.gif" > </td>
</tr>
<tr>
<td height="23" colspan="2" align="right" nowrap background="images/image_02.jpg" bgcolor="#DAE8F3" class="style6">≡ 合同数据录入 ≡ <img src="images/vip.gif" width="12" height="11"> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> 请输入所要录入数据的值:</td><td align="right"><a href="default.asp">⇒返回首页</a></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width="690" border="0" align="center" cellpadding="2" cellspacing="1" class="STYLE6">
<form method="post" name="form1">
<tr align="center">
<td width="16%" height="27" align="right">区域: </td>
<td width="34%" align="left"><input name="qu" type="text" id="qu" height="20"></td>
<td width="16%" align="right">单位名称: </td>
<td width="34%" align="left"><input name="dwmc" type="text" id="dwmc" height="20">
*</td>
</tr>
<tr>
<td align="right">合同编号: </td>
<td align="left"><input name="htbh" type="text" id="htbh" height="20">
*</td>
<td align="right">购买产品: </td>
<td align="left"><textarea name="gmcp" rows="3" id="gmcp" height="50"></textarea>
*</td>
</tr>
<tr>
<td align="right">产品数量: </td>
<td align="left"><input name="cpsl" type="text" id="cpsl" height="20"></td>
<td align="right">合同金额: </td>
<td align="left"><input name="htje" type="text" id="htje" height="20"></td>
</tr>
<tr>
<td align="right">服务期限: </td>
<td align="left" valign="middle"><textarea name="fwqx" rows="3" id="fwqx" height="50"></textarea>
*</td>
<td align="right">外购商品: </td>
<td align="left"><textarea name="wgsp" rows="3" id="wgsp" height="50"></textarea></td>
</tr>
<tr><td align="right">联系人: </td>
<td align="left"><input name="lxr" type="text" id="lxr" height="20"></td>
<td height="20" align="right">联系电话: </td>
<td height="20"><input name="lxdh" type="text" id="lxdh" height="20"></td>
</tr>
<tr>
<td align="right">通讯地址: </td>
<td align="left"><textarea name="txdz" rows="3" id="txdz" height="50"></textarea></td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<tr>
<td colspan="4" align="center"><font color="red">注意:以上带*项必须填写,缺一不可!</font></td>
</tr>
<tr><td colspan="4"> </td></tr>
<tr>
<td colspan="4" align="center"><input name="tj" type="button" value="提交" id="tj" onClick="good()"/>
<input name="cz" type="reset" id="cz" value="重置"> </td>
</tr>
</form>
</table>
</body>
</html>