userlogon.asp

网易论坛 发表新贴子

<!--#include file="opendb.asp"-->
<%
  
  username=trim(request.Form("username"))
  pwd=trim(request.Form("password"))
  
  
  strSQL = "Select * from UserInf Where UserName="&"'"&username&"'" &" AND Password="&"'"&pwd&"'" 
  
  rst.CursorType=3

  rst.open strSQL
  
  if rst.RecordCount>0 then
  session("UserName")=rst("UserName")
  session("ID")=rst("ID")
%>

<script language="javascript">
 alert("OK,Logo is right!");
 window.location="index.asp"
</script>
<%else%>
<script language="javascript">
  alert("Wrong:The name or the password is wrong!");
  window.location="userlogon.htm";
</script>> 
<%end if%> 
<!--#include file="closedb.asp"-->