checkpasswordguanliyuan.asp

留言版,可留言,管理留言,添加,删除留言

<style type="text/css">
<!--
body {
	background-image: url(378dd52436369d064d088d10.jpg);
}
-->
</style>
<%

   id=trim(request.form("id"))
   password=trim(request.Form("password"))
   if (id=""or password="")then
   
	   response.Write"<p align=center>用户名或密码不能为空，请检查</p>"
	   response.Write"<p align=center><a href=guanliyuanpassword.asp>返回</a></p>"
	   response.End
   
   
  else  dim id,password
	id=Request("id")
	password=request("password")
	
	dim checksql
	set rs=server.CreateObject("ADODB.RecordSet")
	set conn=server.createobject("ADODB.CONNECTION")
	connstr = "DBQ=" + server.mappath("database1.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
	conn.Open connstr
	checksql="select * from guanliyuan where id='"&id&"' and password='"&password&"'"
	set rs=conn.execute(checksql)

  
   if rs.eof then
      response.Write"<p align=center>用户名或密码不正确，请检查</p>"
	  response.Write"<p align=center><a href=guanliyuanpassword.asp>返回</a></p>"
	  
   else
      response.Write"<h1><font color=red>欢迎您成功登陆管理员网站</font></h1>"
	  rs.close
	  set rs=nothing
	  response.Write"<p align=center><a href=managemessage.asp>进入留言板管理界面</a></p>"
   end if
   end if
   %>


 </html>