Question

为什么在asp中提交后进行了两次插入操作？

本人在写一个asp的提交页面，就是收集文本框中的数据插入数据库中。可现在有个问题，点击提交按钮后却进行了两次插入操作，老是一次插入两条数据，请问这个问题要怎么解决？

代码如下：
<form name="form1" id="form1" method="post" action="">
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" style="height: 15px">以上意向线路 ：</td>
<td width="70%" style="height: 15px"><label>
<input name="travelname" type="text" id="travelname" size="28" />
</label></td>
</tr>
<tr>
<td style="height: 15px">出行时间：</td>
<td style="height: 15px"><input type="text" name="traveltime" id="traveltime" /></td>
</tr>
<tr>
<td style="height: 15px">出行人数：</td>
<td style="height: 15px"><input name="travelsize" type="text" id="travelsize" size="10" /></td>
</tr>
<tr>
<td style="height: 15px">其他要求：</td>
<td><input name="remark" type="text" id="remark"/></td>
</tr>
<tr>
<td width="30%" height="30" style="height: 15px">您的心理价位 ：</td>
<td><input name="price" type="text" id="price"/>元/每人</td>
</tr>
<tr>
<td style="height: 30px">
<input name="button" type="submit" class="buttonlogin" id="button" value="提交" onClick="document.getElementById('changesForm').value=1;document.getElementById('form1').submit();"/>
</td>
</tr>
</table>
<table width="90%" border="0" cellpadding="0" cellspacing="0">
</table>
</div>
<div style="display:block">
<input type="text" value="<%=change%>" name="changesForm" id = "changesForm">
</div>
</form>
<%
if trim(request.Form("changesForm")) = "1" then
travelname = trim(request.Form("travelname"))
traveltime = trim(request.Form("traveltime"))
traveltime = "to_date('"&traveltime&"','yyyy-mm-dd hh24:mi:ss')"
travelsize = trim(request.Form("travelsize"))
remark = trim(request.Form("remark"))
price = trim(request.Form("price"))

sqlstr = "INSERT INTO CQSSS.TRAVEL_FEEDBACK (ID,PHONENUMBER,TRAVELNAME,TRAVELTIME,TRAVELSIZE,REMARK,PRICE) VALUES (CQSSS.SEC_TRAVEL_FEEDBACK.Nextval,"&phonenumber&",'"&travelname&"',"&traveltime&","&travelsize&",'"&remark&"',"&price&")"

set db = new dbutil
db.conn "cqsss"
db.execUpdate sqlstr

response.write "<script>alert('提交成功');</script>"
end if
%>

Answer 1

把提交页面代码和服务器接受代码分开处理，变成两个ASP文件

这一部分保存为：save.asp
<%
if trim(request.Form("changesForm")) = "1" then
travelname = trim(request.Form("travelname"))
traveltime = trim(request.Form("traveltime"))
traveltime = "to_date('"&traveltime&"','yyyy-mm-dd hh24:mi:ss')"
travelsize = trim(request.Form("travelsize"))
remark = trim(request.Form("remark"))
price = trim(request.Form("price"))

sqlstr = "INSERT INTO CQSSS.TRAVEL_FEEDBACK (ID,PHONENUMBER,TRAVELNAME,TRAVELTIME,TRAVELSIZE,REMARK,PRICE) VALUES (CQSSS.SEC_TRAVEL_FEEDBACK.Nextval,"&phonenumber&",'"&travelname&"',"&traveltime&","&travelsize&",'"&remark&"',"&price&")"

set db = new dbutil
db.conn "cqsss"
db.execUpdate sqlstr

response.write "<script>alert('提交成功');document.location.href='show.asp'</script>"
end if
%>

-------------------------------------------------------------
上面的提交成功力加一个链接返回这里，以下的表单里action="save.asp"
以下的保存为：show.asp

<form name="form1" id="form1" method="post" action="save.asp">
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" style="height: 15px">以上意向线路 ：</td>
<td width="70%" style="height: 15px"><label>
<input name="travelname" type="text" id="travelname" size="28" />
</label></td>
</tr>
<tr>
<td style="height: 15px">出行时间：</td>
<td style="height: 15px"><input type="text" name="traveltime" id="traveltime" /></td>
</tr>
<tr>
<td style="height: 15px">出行人数：</td>
<td style="height: 15px"><input name="travelsize" type="text" id="travelsize" size="10" /></td>
</tr>
<tr>
<td style="height: 15px">其他要求：</td>
<td><input name="remark" type="text" id="remark"/></td>
</tr>
<tr>
<td width="30%" height="30" style="height: 15px">您的心理价位 ：</td>
<td><input name="price" type="text" id="price"/>元/每人</td>
</tr>
<tr>
<td style="height: 30px">
<input name="button" type="submit" class="buttonlogin" id="button" value="提交" onClick="document.getElementById('changesForm').value=1;document.getElementById('form1').submit();"/>
</td>
</tr>
</table>
<table width="90%" border="0" cellpadding="0" cellspacing="0">
</table>
</div>
<div style="display:block">
<input type="text" value="<%=change%>" name="changesForm" id = "changesForm">
</div>
</form>