用简易Ajax框架实现"无刷新用户验证"【原创】

如果您有任何意见,请留下您宝贵的意见以便告知
操作环境:Visual Studio.Net2003
操作系统:window Xp SP2

就上次分析的简易Ajax框架一篇没能给你带来什么，再或者Ajax加减乘除运算也没能告诉你什么，只能告诉你，或者是对Ajax的更进一步理解，现在用那个框架实现无刷新的用户验证，希望能给你带来点什么 

//客户端登录页面 Login.aspx ;代码如下

< HTML >
     < HEAD >
         < title > HelloWorld </ title >
         < meta name = " GENERATOR "  Content = " Microsoft Visual Studio .NET 7.1 " >
         < meta name = " CODE_LANGUAGE "  Content = " C# " >
         < meta name = " vs_defaultClientScript "  content = " JavaScript " >
         < meta name = " vs_targetSchema "  content = " http://schemas.microsoft.com/intellisense/ie5 " >
         < script language = " jscript "  src = " ../Javascript/CallBackObject.js " ></ script >
         < script language = " jscript " >
        function createRequest()
        {
            var name  =  escape(document.getElementById( " name " ).value);
            var pass  =  escape(document.getElementById( " pwd " ).value);
            var cbo  =   new  CallBackObject();
            cbo.OnComplete  =  Cbo_Complete;
            cbo.onError  =  Cbo_Error;
            cbo.DoCallBack( " Ajax.aspx?name= " + name + " &password= " + pass);                        
        }


        function Cbo_Complete(responseText, responseXML)
        {
            alert(responseText);
        }


        function Cbo_Error(status, statusText, responseText)
        {
            alert(responseText);
        }
         </ script >
     </ HEAD >
     < body >
         < form id = " Form1 "  method = " post "  runat = " server " >
             < asp:Label id = " lblUsername "  runat = " server "  Width = " 70 " > UserName: </ asp:Label >< INPUT id = " name "  style = " WIDTH: 192px; HEIGHT: 22px "  type = " text "  size = " 26 " >
             < br >
             < asp:Label id = " lblPassword "  runat = " server "  Width = " 70px " > Password: </ asp:Label >< INPUT id = " pwd "  style = " WIDTH: 192px; HEIGHT: 22px "  type = " text "  size = " 26 " >
             < br >
             < input type = " button "  value = " Login! "  onclick = " createRequest() "  style = " WIDTH: 128px; HEIGHT: 24px " >
         </ form >
     </ body >
</ HTML >

代码解释：<script language="jscript" src="../Javascript/CallBackObject.js"></script>  CallBackObject.js 就是前面提到的简易Ajax框架，再这就不提供了，详细请看另篇 简易Ajax框架解释【原创】

Login.aspx.cs 页面不需要什么，主要在客户端提交

服务器处理页面：AJAX.asp.cs

using  System;
using  System.Collections;
using  System.ComponentModel;
using  System.Data;
using  System.Drawing;
using  System.Web;
using  System.Web.SessionState;
using  System.Web.UI;
using  System.Web.UI.WebControls;
using  System.Web.UI.HtmlControls;
using  System.Data.SqlClient;

namespace  AjaxFrmClass
{
     ///   <summary>
     ///  AjaxTest 的摘要说明。
     ///   </summary>
     public   class  AjaxTest : System.Web.UI.Page
    {
         private   void  Page_Load( object  sender, System.EventArgs e)
        {
             // show();
             #region  用户登陆
             switch (LoginVerify())
            {
                 case   " 1 " :
                    HttpContext.Current.Response.Clear();
                    HttpContext.Current.Response.Write( " 密码不正确 " );
                    HttpContext.Current.Response.Flush();
                    HttpContext.Current.Response.End();
                    
                     break ;
                 case   " 2 " :
                    HttpContext.Current.Response.Clear();
                    HttpContext.Current.Response.Write( " 用户名不存在 " );
                    HttpContext.Current.Response.Flush();
                    HttpContext.Current.Response.End();
                     break ;
                 default :
                    
                     break ;
            }
             #endregion
        }


         #region  输入地用户名进行判断
         ///   <summary>
         ///  对用户输入的用户名和密码进行有效性验证
         ///   </summary>
         ///   <returns></returns>
         public   string  LoginVerify()
        {
             try
            {

                 string  strName  =  HttpContext.Current.Request.QueryString[ " name " ];
                 string  strPwd  =  HttpContext.Current.Request.QueryString[ " password " ];

                SqlParameter  MyParameter =   new  SqlParameter();
                SqlCommand  cmd  =   new  SqlCommand();
                SqlConnection con  =   new  SqlConnection( " uid=sa;pwd=1234;database=pubs " );
                cmd.CommandType  =  CommandType.StoredProcedure;
                cmd.CommandText  =   " SP_User_Login " ;
                cmd.Connection   =  con;
                
                
                MyParameter  =  cmd.Parameters.Add( " @RETURN_VALUE " ,SqlDbType.Int);
                MyParameter.Direction  =  ParameterDirection.ReturnValue;
                cmd.Parameters.Add( " @name " ,strName);
                cmd.Parameters.Add( " @pwd " , strPwd);
                con.Open();
                cmd.ExecuteNonQuery();
                 return  cmd.Parameters[ " @RETURN_VALUE " ].Value.ToString(); 
            }
             catch (Exception errExce)
            {
                 return  errExce.Message.ToString();
            }
             finally
            {
                
            }
        }
         #endregion

         #region  Web 窗体设计器生成的代码
         override   protected   void  OnInit(EventArgs e)
        {
             //
             //  CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
             //
            InitializeComponent();
             base .OnInit(e);
        }
        
         ///   <summary>
         ///  设计器支持所需的方法 - 不要使用代码编辑器修改
         ///  此方法的内容。
         ///   </summary>
         private   void  InitializeComponent()
        {    
             this .Load  +=   new  System.EventHandler( this .Page_Load);

        }
         #endregion
    }
}

 

Ajax.aspx 不需要做处理，此时只需要在服务器端处理即可

完成以上2个页面的操作，基本上算是成功了，就差一个登录的存储过程了 

CREATE PROC SP_User_Login
(
      @name VARCHAR(15),
      @pwd   VARCHAR(15)   
)
AS
      DECLARE @temp_Name VARCHAR(15)
BEGIN
      SELECT  @temp_Name=UserName
      FROM     t_UserLogin
      WHERE   UserName = @name
         AND
              Password  = @pwd
      IF @temp_Name IS NOT NULL
          RETURN 0    --登录成功     
 IF EXISTS (SELECT UserName
            FROM   t_UserLogin
                   WHERE  UserName = @name)
          RETURN 1    --密码不正确
        ELSE
          RETURN 2    --用户名不存在 
END
GO

 

存储过程写完了，Ctrl + F5即可看见效果