ajax簡單登入

來源:互聯網
上載者:User
js部分(default.aspx)
<script>
var xmlHttp;
      function CreateXMLHttpRequest()
      {
        if(window.XMLHttpRequest)
        {
              xmlHttp =new XMLHttpRequest();
        }else if(window.ActiveXObject)
        {
           xmlHttp = new ActiveXObject("Microsoft.XMLHTTP") ;
        }
      }      
function login()
{
    CreateXMLHttpRequest();   //建立組建
    var name=document.getElementById("<%=txtName.ClientID %>").value;
    var password=document.getElementById("<%=txtPwd.ClientID %>").value;
    var url="Login.aspx?name="+name+"&password="+password;
    xmlHttp.open("get",url,true); //初始化資料
    xmlHttp.onreadystatechange=iscallback; //設定回呼函數
    xmlHttp.send(null);
}
function iscallback()
{
    if(xmlHttp.readyState==4&& xmlHttp.status==200 && xmlHttp.responseText=="true")
    {
        document.getElementById("txtmsg").value="success";
    }
    else
        document.getElementById("txtmsg").value="fail";
}
</script>

//body 部分(default.aspx)
<body>
    <form id="form1" runat="server">
    <div>
        username:&nbsp;
        <asp:TextBox ID="txtName" runat="server"></asp:TextBox><br />
        passowrd: &nbsp;<asp:TextBox ID="txtPwd" runat="server"></asp:TextBox><br />
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;
        <input id="Button2" onclick="login()" type="button" value="login" />&nbsp;<br />
        &nbsp;
        <input id="txtmsg" type="text" /></div>
    </form>
</body>

//處理部分(Login.aspx.cs)
protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string name = Request.QueryString["name"];
            string pwd = Request.QueryString["password"];
            if (name != "" || name != "null" || pwd != "" || pwd != "null")
            {

                int result = geruser(name, pwd);
                if (result > 0)
                {
                    Response.Write("true");
                    Response.End();
                }
            }
        }
    }
    public static string conStr = @"Server=(local);DataBase=TengDa;Trusted_Connection=Yes";
    public static SqlConnection connection;
    public static SqlConnection getConnection
    {
        get
        {
            if (connection == null)
            {
                connection = new SqlConnection(conStr);
                connection.Open();
            }
            else if (connection.State == System.Data.ConnectionState.Closed)
            {
                connection.Open();
            }
            else if (connection.State == System.Data.ConnectionState.Broken)
            {
                connection.Close();
                connection.Open();
            }
            return connection;
        }
    }
    //
    public static int geruser(string name, string pwd)
    {
        string sql = "select * from Role where RoleName='" + name + "' and RoleRemark='" + pwd + "'";
        SqlCommand cmd = new SqlCommand(sql, getConnection);
        return Convert.ToInt32(cmd.ExecuteScalar());
    }

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.