为什么表单提交的记录,写入数据库后重复了?
<!--#include file=conn.asp-->
<%
'去除表单数据中的空格
UserName = Trim (Request.Form("tn"))
UserPass = Trim (Request.Form("passw"))
'用户名、密码、验证码都必须填写
If (UserName="" Or UserPass="") Then
Response.Redirect "contest.asp?errMsg=请完整填写登陆表格"
Response.End()
End If
Dim strSQL, objRS
'检索数据库中是否存在相关记录
strSQL = "SELECT * FROM member WHERE teamname='" & UserName & "'"
strSQL = strSQL & " AND passwd = '" & UserPass & "'"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn, 1, 3, 1
'检索结果为空,表明用户名或者密码错误
If objRS.EOF Then
Response.Redirect "contest.asp?errMsg=用户名或密码错误"
Response.End()
End If
Dim rs
Set rs = Server.CreateObject("ADODB.RecordSet")
'定义sql语句,为插入新闻记录定义记录集
sql="SELECT * FROM teamanswer"
'执行查询
rs.Open sql,objConn, 1, 3
'使用AddNew和Update插入新记录
rs.AddNew
rs("teamname") =UserName
rs("qnum") =Request.Form("qn")
rs("language") =Request.Form("lang")
dim msg
msg=request.Form("ans")
msg=replace(msg,"<"," ")
msg=replace(msg,">"," ")
msg=replace(msg,vbcrlf,"<br>")
msg=replace(msg," "," ")
rs("answer") =msg
'提交更新
rs.Update
'关闭记录集和数据库连接
objRS.Close
rs.Close
Set objRS = Nothing
Set rs=nothing
objConn.Close
Set objConn = Nothing
'转向系统主页面
Response.Redirect "processed.asp"
Response.End()
%>