帮忙!!!
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>精品数码网</title>
<style type="text/css">
<!--
.style3 {
color: #FF0000;
font-size: 9pt;
}
.style10 {font-size: 9pt; color: #666666; }
.unnamed1 {
height: 15pt;
width: 25pt;
font-style: normal;
color: #666666;
}
.style11 {
color: #415373;
font-size: 10pt;
}
.biankuang {
border-top: 0px none;
border-right: 1px solid #999999;
border-bottom: 1px solid #999999;
border-left: 1px solid #999999;
}
.style13 {font-size: 10pt}
-->
</style>
</head>
<!--#include file="conn.asp"-->
<script language="javascript">
function checkuu()
{
if (document.form1.username.value=="")
{document.form1.username.focus();
alert ('用户名为空！！');
return false;
}
if (document.form1.password.value=="")
{document.form1.password.focus();
alert('密码为空！！');
return false;
}
if (document.form1.yzm.value=="")
{document.form1.yzm.focus();
alert('验证码为空！！');
return false;
}
}
</script>
<%
if request.form("submit")<>"" then
if request.form("username")<>"" and request.form("password")<>"" and request.form("yzm")<>"" then
set dl=server.createobject("adodb.recordset")
dl.open "select username,password from user where username='"&username&"' and password='"&password&"'",conn,1,3
if dl("username")<> username then
response.write"<script>alert('用户名有误！！');</script>"
elseif dl("password")<>password then
response.write"<script>alert('输入的密码有误！！');</script>"
else
response.redirect "login.asp"
end if
end if
end if
%>
<body>
<!--#include file="head.htm"-->
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="219" align="left" valign="top"> <p><!--#include file="left.asp"--></p></td>
<td width="561" align="left" valign="top"> <p><br>
<br>
</p>
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="18"><img src="images/w.gif"></td>
<td style="color:#415373"><span class="style13">用户登陆</span></td>
</tr>
</table>
<p> </p> <p><br>
</p>
<form action="" method="post" name="form1" id="loginfo">
<table border="0" cellpadding="0" cellspacing="10" bgcolor="#FFFFFF" class="t1">
<tr>
<td width="200" height="22" align="right" ><span class="style10">用户名：</span></td>
<td height="22" colspan="2" ><input name="username" type="text" class="inputstyle" id="username"> </td>
</tr>
<tr>
<td width="200" height="22" align="right" ><span class="style10">密码：</span></td>
<td height="22" colspan="2" ><input name="password" type="password" class="inputstyle" id="password"></td>
</tr>
<tr>
<td width="200" height="22" align="right" ><span class="style10">验证码：</span></td>
<td width="91" height="10" ><input name="yzm" type="text" class="inputstyle" id="yzm" size="8"> </td>
<td width="134" ><%
randomize
n=cint(left(rnd()*1000000000,4))
response.write n
session("yzm")=n
%></td>
</tr>
<td colspan="2" align=right class="STYLE3">
<input name="submit" type="submit" class="unnamed1" id="submit" ONCLICK=" return checkuu();" value="登录">
<input name="Submit" type="reset" class="unnamed1" value="重置">
</td>
<tr width="100%">
<td colspan="2"><div align="right" class="style10"><a href="login.asp">注册</a> <a href="forgetpassword.asp">忘记密码</a></div></td>
</tr>
</table>
</form> </td>
</tr>
</table>
<!--#include file="foot.htm"-->
</body>
</html>
随便输入用户名和密码还在验证码提交后,竟然说我from子句有错误,不会啊,我看过了,没有错误??请高手指点一下,小弟不甚感激!!!!
