#此为asp部分,我在html部分用submit跳转到这个程序,txtUsername也有以它为name命名的input,不明白哪里错了,希望解答可以细节一点,谢谢
<html>
<head>
<script>
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:\Users\Rog\Desktop\test\score.mdb"
sql="INSERT INTO score s_name,s_score"
sql=sql & "s_name,s_score"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("txtUsername") & "',"
sql=sql & "'" & Request.Form("num") & "')"
on error resume next
conn.Execute sql,recaffected
if err<>0 then
Response.Write("No update permissions!")
else
Response.Write("" & recaffected & " record added
")
end if
conn.close
%>
</script>
</head>
</html>