asp.net实现无刷新用户验证的简单例子

最新推荐文章于 2018-05-22 10:29:00 发布

ssqjd

最新推荐文章于 2018-05-22 10:29:00 发布

阅读量730

点赞数

文章标签： asp.net function javascript string server security

本文链接：https://blog.csdn.net/ssqjd/article/details/1893325

版权

html代码:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<script type="text/javascript" language="javascript">
        var xmlHttp = null;
        function createXMLHTTP()
        {
            var arrSignatures=["MSXML2.XMLHTTP.5.0","MSXML2.XMLHTTP.4.0","MSXML2.XMLHTTP.3.0","MSXML2.XMLHTTP","Microsoft.XMLHTTP"];
            for(var i=0;i<arrSignatures.length;i++)
            try
            {
                var oRequest=new ActiveXObject(arrSignatures[i]);
                return oRequest;
            }
            catch(oError)
            {

            }
            throw new Error("MSXML is not installed on your system.");
        }
        function CheckUser()
        {
            xmlHttp=createXMLHTTP();
            var Text1 = document.getElementById("Text1");
            var url = "chkuser.aspx?User=" + Text1.value;
            xmlHttp.open("GET",url,true);
            xmlHttp.onreadystatechange = OnHandler;
            xmlHttp.send(null);
        }
        function OnHandler()
        {
            if(xmlHttp.readyState == 4)
            {
                var isValid = xmlHttp.responseText;
                var exists = document.getElementById("exsits");
                exists.innerHTML = isValid.substring(0,8);
            }
        }
</script>

chkuser.aspx页面代码:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class chkuser : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string username = Request.QueryString["User"].ToString();
        checkuser(username);
    }
    protected void checkuser(string username)
    {
        SqlConnection con=new SqlConnection("Data Source=QJD-91554EB2B63//SQLEXPRESS;Initial Catalog=test;Integrated Security=True");
        con.Open();
        SqlCommand cmd = new SqlCommand("select count(*) from UserInfo where userName='"+username+"'", con);
        int count=Convert.ToInt32(cmd.ExecuteScalar());
        if (count <= 0)
        {
            Response.Write("用户不存在");
        }
        else
        {
            Response.Write("用户已经存在");
        }
    }
}