62,046
社区成员
发帖
与我相关
我的任务
分享
<head runat="server">
<title></title>
<link href="StyleSheet.css" rel="Stylesheet" type="text/css"/>
<script src="yanzheng.js" language="JavaScript" type="text/javascript"></script><%--调用写异步ajax的JS文件--%>
</head>
<body>
<form id="form1" runat="server">
<div class="message">
<table>
<tr>
<td class="Writing" align="right"><asp:Label ID="Label1" class="LabelClass" runat="server" Text="昵称:"></asp:Label></td>
<td class="Box"><input id="w_name" class="TextBoxStyle"
onkeyup="CheckUserName(this.value)"/></td> <%--这里放一个input获取用户输入--%> <td><div id="msg"></div></td><%--这里放一个DIV显示ajax处理回调后的结果--%
</tr>
</table>
</div>
</form>
</body>
var xmlHttp;
//声明XMLHttpRequest对象
function createXMLHttpRequest() {
if (window.ActiveXObject) {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
else if (window.XMLHttpRequest) {
xmlHttp = new XMLHttpRequest();
}
}
//处理发送请求
function CheckUserName() {
createXMLHttpRequest();
var strName = document.getElementById("w_name").value;
var url = "Handler.ashx?strUserName=" + strName;
xmlHttp.open("GET", url, true);
xmlHttp.onreadystatechange = ShowResult;
xmlHttp.send(null);
}
//处理回调
function ShowResult() {
if (xmlHttp.readyState == 4) {
if (xmlHttp.status == 200) {
var bRet = xmlHttp.responseText;
if (bRet == "0") {
msg.innerHTML = '用户名存在!';
msg.style.color = 'green';
}
else if (bRet == "1") {
msg.innerHTML = '用户名长度必须在3到15之间!';
msg.style.color = 'red';
}
else {
msg.innerHTML = '用户名不存在!';
msg.style.color = 'red';
}
}
}
}
<%@ WebHandler Language="C#" Class="Handler" %>
using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
public class Handler : IHttpHandler {
public void ProcessRequest (HttpContext context) {
context.Response.ContentType = "text/plain";
string flag = string.Empty;
string strUsername = context.Request.QueryString[0];
if (!IsValidUsername(strUsername))
{
flag = "1";
}
else if (!IsUsernameExist(strUsername))
{
flag = "2";
}
else
{
flag = "0";
}
context.Response.Write(flag);
}
private bool IsUsernameExist(string strUsername)//匹配数据库中的数据
{
bool bRet = false;
string sqltr = "Data Source=CHUNCHUN;Database=tb_newss;User ID=sa;Password=123321";
string oo = "select * from Table_1 where name='" + strUsername + "'";
SqlConnection con = new SqlConnection(sqltr);
con.Open();
SqlCommand dbCommand = new SqlCommand(oo, con);
dbCommand.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(oo, con);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count == 0)
{
return bRet;
}
else
{ return true; }
}
private bool IsValidUsername(string strUsername)//正则表达式
{
//return (System.Text.RegularExpressions.Regex.IsMatch(strUsername, @"^(\w{3,15})$"));
return (System.Text.RegularExpressions.Regex.IsMatch(strUsername, @"^[\u4e00-\u9fa5]{1,}$"));
}
public bool IsReusable {
get {
return false;
}
}
}
var strName = escape(document.getElementById("w_name").value);
escape是JS用来编码的函数。