请大家帮忙看看这段代码错误在那?
请大家帮忙看看这段代码错误在那?
我是想实现在A代码中用户输入自己的注册资料,然后在B中实现把用户输入的内容让用户确认,最后用递交按钮实现存入数据库
现可是现在只能能实现从A到B,可是递交到C的出错:是HTTP500内部服务器错误
谢谢!
A:注册页面
<table width="46%" border="1" align="center">
<form name="frmreg" method="post" action="register1.asp">
<tr>
<td width="20%">
<div align="center">学生证号</div>
</td>
<td width="32%">
<div align="center">
<input type="text" name="xszh" size="16" maxlength="9">
</div>
</td>
<td width="48%">
<div align="center">此处输入的学生证号是唯一的</div>
</td>
</tr>
<tr>
<td width="20%">
<div align="center">姓名</div>
</td>
<td width="32%">
<div align="center">
<input type="text" name="txtname" size="16" maxlength="8">
</div>
</td>
<td width="48%">
<div align="center"> </div>
</td>
</tr>
<tr>
<td width="20%">
<div align="center">性别</div>
</td>
<td width="32%">
<input type="radio" name="sex" value="男" checked>
男
<input type="radio" name="sex" value="女">
女 </td>
<td width="48%"> </td>
</tr>
<tr>
<td width="20%">
<div align="center">密码</div>
</td>
<td width="32%">
<div align="center">
<input type="password" name="txtpass1" size="16" maxlength="12">
</div>
</td>
<td width="48%">
<div align="center">你的密码长度在6-12位之间</div>
</td>
</tr>
<tr>
<td width="20%">
<div align="center">验证密码</div>
</td>
<td width="32%">
<div align="center">
<input type="password" name="txtpass2" size="16" maxlength="12">
</div>
</td>
<td width="48%">
<div align="center">和上面的密码保持一致</div>
</td>
</tr>
<tr>
<td width="20%">
<div align="center">班级</div>
</td>
<td width="32%">
<div align="center">
<select name="txtclass" size=1>
<option value="初一(1)班" selected>初一(1)班</option>
<option value="初一(2)班">初一(2)班</option>
<option value="初一(3)班">初一(3)班</option>
<option value="初一(4)班">初一(4)班</option>
<option value="初一(5)班">初一(5)班</option>
<option value="初一(6)班">初一(6)班</option>
</select>
</div>
</td>
<td width="48%">
<div align="center"> </div>
</td>
</tr>
<tr>
<td width="20%">
<div align="center">机号</div>
</td>
<td width="32%">
<div align="center">
<input type="text" name="jihao" size="16" maxlength="2">
</div>
</td>
<td width="48%">
<div align="center"> </div>
</td>
</tr>
<tr>
<td width="20%">
<div align="center">登记时间</div>
</td>
<td width="32%">
<div align="center">
<input type="text" name="txttime" size="16" maxlength="16" value="<%=now%>">
</div>
</td>
<td width="48%">
<div align="center"> </div>
</td>
</tr>
<tr>
<td colspan="3" height="15">
<div align="center">
<input type="button" value="注册" onclick=checkdata>
<input type="reset" name="reset" value="重写">
</div>
</td>
</tr>
</form></table>
B:验证页面
<%
set conn=server.createobject("ADODB.CONNECTION")
connstr="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("info.mdb")
conn.open connstr
set rst=server.createobject("adodb.recordset")
str="select * from stuinfo where xszh="&request.form("xszh")&""
rst.open str,conn,1,3%>
<%if not rst.eof then
response.write "抱歉,你的学生证号已经被注册"
response.write "请和管理员联系或者重新<A HREF='register.asp'>注册</A>"
response.end
%>
<%else%>
<div align="center">王淦昌中学学生登记<br>
以下是你输入的信息:请确认--然后点击递交按钮
<TABLE>
<TR><TD>学生证号</TD><TD><%response.write request.form("xszh")%></TD></TR>
<TR><TD>姓名</TD><TD><%response.write request.form("txtname")%></TD></TR>
<TR><TD>性别</TD><TD><%response.write request.form("sex")%></TD></TR>
<TR><TD>密码</TD><TD><%response.write request.form("txtpass1")%></TD></TR>
<TR><TD>班级</TD><TD><%response.write request.form("txtclass")%></TD></TR>
<TR><TD>机号</TD><TD><%response.write request.form("jihao")%></TD></TR>
<TR><TD>登记时间</TD><TD><%response.write request.form("txttime")%></TD></TR>
</TABLE>
<form name="form1" method="post" action="registerok.asp">
<input type="hidden" name="xszh" value=<%request.form("xszh")%>>
<input type="hidden" name="txtname" value=<%request.form("txtname")%>>
<input type="hidden" name="sex" value=<%request.form("sex")%>>
<input type="hidden" name="txtpass" value=<%request.form("txtpass1")%>>
<input type="hidden" name="txtclass" value=<%request.form("txtclass")%>>
<input type="hidden" name="jihao" value=<%request.form("jihao")%>>
<input type="hidden" name="txttime" value=<%request.form("txttime")%>>
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
</div>
</form>
<%end if%>
C:送交数据库的页面
<%
set conn=server.createobject("ADODB.CONNECTION")
connstr="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("info.mdb")
conn.open connstr
set rst=server.createobject("adodb.recordset")
rst.open "stuinfo",conn,1,2
%>
<%rst.addnew
rst("xszh")=request.form("xszh")
rst("txtname")=request.form("txtname")
rst("sex")=request.form("sex")
rst("txtpass")=request.form("txtpass1")
rst("txtclass")=request.form("txtclass")
rst("jihao")=request.form("jihao")
rst("txttime")=request.form("txttime")
rst.movenext
%>
你的注册已经完成,谢谢你的合作<br>你现在可以<a href="index.asp">登陆</a>了