以下代码均通过测试
login.htm
<body>
用户名:<input type="text" id="userName"/><br />
密码:  <input type="password" id="password"/><br />
<input type="button" id="login" value="登陆"/>
</body>
<script type="text/javascript">
$(document).ready(function () {
$("#login").live('click', function () {
var username = $("#userName").val();
var pwd = $("#password").val();
$.ajax({
type: "post",
url: "login.ashx",
data: { userName: username, passWord: pwd, state: "login" },
success: function (data) {
if (data == "1") {
alert("登陆成功!!!");
}
else if (data == "0") {
alert("登陆失败!!!");
}
}
});
});
});
</script>
login.ashx.cs:
public class login : IHttpHandler,IRequiresSessionState
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
if (context.Request["state"] == "login")
{
string username = context.Request["userName"].ToString();
string pwd = context.Request["passWord"].ToString();
SqlConnection co = new SqlConnection();
co.ConnectionString = "server=10.132.239.215;uid=10jb;pwd=10jb;database=10110013325";
co.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from Users where User_Name=@Username and User_PWD=@PWD";
cmd.Parameters.AddWithValue("@Username", username);
cmd.Parameters.AddWithValue("@PWD", pwd);
cmd.Connection = co;
SqlDataReader result = cmd.ExecuteReader();
if (result.Read())
{
context.Session["userID"] = result["PKId"].ToString();
context.Response.Write("1");
}
else
{
context.Response.Write("0");
}
result.Close();
co.Close();
}
}
public bool IsReusable
{
get
{
return false;
}
}
}
login.htm
<body>
用户名:<input type="text" id="userName"/><br />
密码:  <input type="password" id="password"/><br />
<input type="button" id="login" value="登陆"/>
</body>
<script type="text/javascript">
$(document).ready(function () {
$("#login").live('click', function () {
var username = $("#userName").val();
var pwd = $("#password").val();
$.ajax({
type: "post",
url: "login.ashx",
data: { userName: username, passWord: pwd, state: "login" },
success: function (data) {
if (data == "1") {
alert("登陆成功!!!");
}
else if (data == "0") {
alert("登陆失败!!!");
}
}
});
});
});
</script>
login.ashx.cs:
public class login : IHttpHandler,IRequiresSessionState
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
if (context.Request["state"] == "login")
{
string username = context.Request["userName"].ToString();
string pwd = context.Request["passWord"].ToString();
SqlConnection co = new SqlConnection();
co.ConnectionString = "server=10.132.239.215;uid=10jb;pwd=10jb;database=10110013325";
co.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from Users where User_Name=@Username and User_PWD=@PWD";
cmd.Parameters.AddWithValue("@Username", username);
cmd.Parameters.AddWithValue("@PWD", pwd);
cmd.Connection = co;
SqlDataReader result = cmd.ExecuteReader();
if (result.Read())
{
context.Session["userID"] = result["PKId"].ToString();
context.Response.Write("1");
}
else
{
context.Response.Write("0");
}
result.Close();
co.Close();
}
}
public bool IsReusable
{
get
{
return false;
}
}
}