http://www.diybl.com/course/4_webprogram/ajax/ajaxsl/2008515/116224.html
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ManagerControl.aspx.cs" Inherits="ManagerControl" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<meta http-equiv="content-type" content="text/html; charset=GB2312" />
<title>王子的宫殿</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link rel="stylesheet" type="text/css" href="default.css" />
<script language="javascript" type="text/javascript" src="js/main.js">
</script>
</head>
<body>
<div id="outer">
<div id="upbg" style="left: 0px; top: 0px"></div>
<div id="inner">
<div id="header">
<h1><span>学生作业</span>上传系统<sup>v1.0</sup></h1>
<h2>by 薛晓龙</h2>
</div>
<div id="splash"></div>
<div id="menu" style="left: 0px; top: 0px">
<ul>
<li class="first"><a href="Default.aspx">主页</a></li>
<li><a href="#">作业上传</a></li>
<li><a href="#">作业查看</a></li>
<li><a href="#">资源下载</a></li>
<li><a href="Myinfo.aspx">联系我</a></li>
<li><a href="Manager.aspx">后台管理</a></li>
</ul>
<div id="date">August 1, 2006</div>
</div>
<div id="primarycontent" style="left:0px; top: 0px; width:100%; height:80%">
<div id="contentManager">
<div id="Managercontent" style=" height:500px; text-align:center">
<span id="Loginheader"><a href="ManagerControl.aspx"><img src="images/Reg.gif" alt="免费注册" /></a></span>
<table style="margin-top:30px; height: 172px;">
<tr>
<td class="RegSign">
用户名:
</td>
<td class="RegTd">
<input id="RegName" class="text" type="text" onblur="CheckUserName()" /></td>
<td id="userNError" class="RegError">
</td>
</tr>
<tr>
<td class="RegSign">
密码:</td>
<td class="RegTd">
<input id="RegPw" class="text" type="password" onblur="CheckisNullPw()" /></td>
<td id="PwError" class="RegError">
</td>
</tr>
<tr>
<td class="RegSign">
学号:</td>
<td class="RegTd"><input id="RegNum" class="text" type="text" onblur="CheckisNullNUm()" /></td>
<td id="NumError" class="RegError">
</td>
</tr>
<tr>
<td class="RegSign">
班级:</td>
<td class="RegTd">
<select id="RegClass" class="text" onchange="CheckisNullClass()">
<option selected="selected">——请选择——</option>
<option>地理信息051</option>
<option>地理信息052</option>
</select>
<%-- <input id="RegClass" class="text" type="text" />--%></td>
<td id="ClassError" class="RegError">
</td>
</tr>
<tr>
<td class="RegSign">
</td>
<td class="RegTd">
<img src="images/zhuce.gif" alt="提交" style="cursor:pointer" id="IMG1" language="javascript" onclick="return Register()" /></td>
<td class="RegError">
</td>
</tr>
</table>
<div id="showReginMessage"></div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>
cs文件
--------------------------------------------------------------------------------
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.OleDb;
using System.Text.RegularExpressions;
public partial class CheckRegin : System.Web.UI.Page
{
protected static OleDbConnection conn = new OleDbConnection();
protected static OleDbCommand comm = new OleDbCommand();
protected void Page_Load(object sender, EventArgs e)
{
Response.ContentType = "text/xml";
bool passed = ValiLogin(Request["userName"]);
bool allNotNull = CheckAll(Request["userName"], Request["passWord"], Request["userNum"], Request["userClass"]);
string userName=Request["userName"];
string passWord=Request["passWord"];
string userNum=Request["userNum"];
string userClass=Request["userClass"];
string message = "出错啦,用户名错误或密码错误";
if (passed)
{
message = "此用户不存在,可以注册";
}
else
{
message = "此用户已经存在";
}
string textxml;
textxml = "<response>" + "<passed>" + passed.ToString() + "</passed>" + "<message>" + message + "</message>" + "</response>";
Response.Write(textxml);
}
private bool CheckAll(string userName, string passWord, string userNum, string userClass)
{
bool allNotNull;
if (userName != null && passWord != null && userNum != null && userClass != null)
{
allNotNull = true;
}
else
{
allNotNull = false;
}
return allNotNull;
}
private bool ValiLogin(string userName)
{
bool isPassed = true;
string sqlstr = "select userName from studentInfo where userName = " + "''" + userName + "''";
bool isNull = ExecuteSql(sqlstr);
if (isNull)
{
isPassed = true;
}
else
{
isPassed = false;
}
return isPassed;
}
//进行数据库的连接
private static void openConnection()
{
if (conn.State == ConnectionState.Closed)
{
conn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
comm.Connection = conn;
try
{
conn.Open();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
}
private static void closeConnection()
{
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Dispose();
comm.Dispose();
}
public static bool ExecuteSql(string sqlstr)
{
OleDbDataReader dataR;
bool isNull = true;
try
{
openConnection();
comm.CommandType = CommandType.Text;
comm.CommandText = sqlstr;
dataR = comm.ExecuteReader();
if (dataR.Read())
{
isNull = false;
}
else
{
isNull = true;
}
}
catch (Exception s)
{
throw (s);
}
finally
{
//关闭连接
closeConnection();
}
return isNull;
}
}
js文件
var xmlHttp;
var isNameNull;
var isPwNull;
var isNumNull;
var isClassNull;
var isNull;
function IMG1_onclick() {
CheckIsValid();
}
//验证登陆是否合法
function CheckIsValid()
{
CreatXmlHttpRequest();
var userName=document.getElementById("AdminText");
var passWord=document.getElementById("AdminPasswordText");
var url="CheckLogin.aspx?userName="+escape(userName.value)+"&passWord="+escape(passWord.value);
xmlHttp.open("GET",url,true);
xmlHttp.onreadystatechange=callback;
xmlHttp.send(null);
}
//判断注册名字是否为空
function CheckisNullName()
{
var userName=document.getElementById("RegName");
var messageArea=document.getElementById("userNError");
var fontColor;
if(userName.value!="")
{
isNameNull=false;
}
else
{
fontColor="red";
imgUrl="images/beError.gif";
messageArea.innerHTML="<img src="+imgUrl+"/>"+"<font color="+fontColor+">"+"请认真填写"+"</font>";
isNameNull=true;
}
}
//检查注册密码是否存在
function CheckisNullPw()
{
var passWord=document.getElementById("RegPw");
var messageArea=document.getElementById("PwError");
var fontColor;
if(passWord.value!="")
{
imgUrl="images/MOREok.gif";
messageArea.innerHTML="<img src="+imgUrl+"/>";
isPwNull=false;
}
else
{
fontColor="red";
imgUrl="images/beError.gif";
messageArea.innerHTML="<img src="+imgUrl+"/>"+"<font color="+fontColor+">"+"请认真填写"+"</font>";
isPwNull=true;
}
}
//检查注册学号是否存在
function CheckisNullNUm()
{
var userNum=document.getElementById("RegNum");
var messageArea=document.getElementById("NumError");
var fontColor;
if(userNum.value!="")
{
imgUrl="images/MOREok.gif";
messageArea.innerHTML="<img src="+imgUrl+"/>";
isNumNull=false;
}
else
{
fontColor="red";
imgUrl="images/beError.gif";
messageArea.innerHTML="<img src="+imgUrl+"/>"+"<font color="+fontColor+">"+"请认真填写"+"</font>";
isNumNull=true;
}
}
//检查注册班级是否存在
function CheckisNullClass()
{
var RegClass=document.getElementById("RegClass");
var index=RegClass.selectedIndex;
var messageArea=document.getElementById("ClassError");
var fontColor;
if(index==1||index==2)
{
imgUrl="images/MOREok.gif";
messageArea.innerHTML="<img src="+imgUrl+"/>";
isClassNull=false;
}
else
{
fontColor="red";<
br /> imgUrl="images/beError.gif";
messageArea.innerHTML="<img src="+imgUrl+"/>"+"<font color="+fontColor+">"+"请认真填写"+"</font>";
isClassNull=true;
}
}
//检查注册用户名是否存在
function CheckUserName()
{
CheckisNullName();
if(isNameNull==false)
{
CreatXmlHttpRequest();
var userName=document.getElementById("RegName");
var passWord=document.getElementById("RegPw");
var userNum=document.getElementById("RegNum");
var userClass=document.getElementById("RegClass");
var url="CheckRegin.aspx?userName="+escape(userName.value);
xmlHttp.open("GET",url,true);
xmlHttp.onreadystatechange=callReg;
xmlHttp.send(null);
}
else
{
return;
}
}
//验证是否注册中所有项都非空
function CheckisNull()
{
if(isNameNull==false&&isPwNull==false&&isNumNull==false&&isClassNull==false)
{
isNull=false;
}
else
{
isNull=true;
}
}
//创建XmlHttpRequest
function CreatXmlHttpRequest()
{
try {
xmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e2) {
xmlHttp = false;
}
}
if (!xmlHttp && typeof XMLHttpRequest != ''undefined'') {
xmlHttp = new XMLHttpRequest();
}
}
//验证登陆是否合法的回调函数
function callback()
{
if(xmlHttp.readyState==4)
{
if(xmlHttp.status==200)
{
var mes=xmlHttp.responseXML.getElementsByTagName("message")[0].firstChild.data;
var val=xmlHttp.responseXML.getElementsByTagName("passed")[0].firstChild.data;
setMessage(mes,val);
}
}
}
//验证注册的回调函数
function callReg()
{
if(xmlHttp.readyState==4)
{
if(xmlHttp.status==200)
{
var mes=xmlHttp.responseXML.getElementsByTagName("message")[0].firstChild.data;
var val=xmlHttp.responseXML.getElementsByTagName("passed")[0].firstChild.data;
setRegMessage(mes,val);
}
}
}
//设置登陆验证后的信息提示显示
function setMessage(message,isValid)
{
var messageArea=document.getElementById("showMessage");
var fontColor;
if(isValid =="True")
{
window.location.href="ManagerControl.aspx";
}
else
{
fontColor="red";
imgUrl="images/404.jpg";
messageArea.innerHTML="<img src="+imgUrl+"/>"+"<font color="+fontColor+">"+message+"</font>";
}
}
//设置注册验证后的信息显示
function setRegMessage(message,isValid)
{
var messageArea=document.getElementById("userNError");
var fontColor;
if(isValid =="True")
{
fontColor="green";
imgUrl="images/MOREok.gif";
messageArea.innerHTML="<img src="+imgUrl+"/>"+"<font color="+fontColor+">"+message+"</font>";
}
else
{
fontColor="red";
imgUrl="images/beError.gif";
messageArea.innerHTML="<img src="+imgUrl+"/>"+"<font color="+fontColor+">"+message+"</font>";
}
}
function Register()
{
CheckisNull();
if( isNull==false)
{
CreatXmlHttpRequest();
var userName=document.getElementById("RegName");
var passWord=document.getElementById("RegPw");
var userNum=document.getElementById("RegNum");
var userClass=document.getElementById("RegClass");
var userClassIndex=userClass.selectedIndex;
var url="ReginInfo.aspx?userName="+escape(userName.value)+"&passWord="+escape(passWord.value)+"&userNum="+escape(userNum.value)+"&userClassIndex=&qu
ot;+escape(userClassIndex);
xmlHttp.open("GET",url,true);
xmlHttp.onreadystatechange=RegOk;
xmlHttp.send(null);
}
else
{
return;
}
}
function RegOk()
{
if(xmlHttp.readyState==4)
{
if(xmlHttp.status==200)
{
var mes=xmlHttp.responseXML.getElementsByTagName("message")[0].firstChild.data;
var pas=xmlHttp.responseXML.getElementsByTagName("passed")[0].firstChild.data;
var userName=xmlHttp.responseXML.getElementsByTagName("userName")[0].firstChild.data;
var passWord=xmlHttp.responseXML.getElementsByTagName("passWord")[0].firstChild.data;
var userNum=xmlHttp.responseXML.getElementsByTagName("userNum")[0].firstChild.data;
var userClass=xmlHttp.responseXML.getElementsByTagName("userClass")[0].firstChild.data;
var titletip=xmlHttp.responseXML.getElementsByTagName("titletip")[0].firstChild.data;
setRegOkMessage(mes,pas,userName,passWord,userNum,userClass,titletip);
}
}
}
function setRegOkMessage(message,passed,userName,passWord,userNum,userClass,titletip)
{
var messageArea=document.getElementById("showReginMessage");
var fontColor;
if(passed =="True")
{
fontColor="green";
imgUrl="images/MOREok.gif";
messageArea.innerHTML="<img src="+imgUrl+"/>"+"<font color="+fontColor+">"+message+"用户名:"+userName+"密码:"+passWord+"学号:"+userNum+"班级:"+userClass+"</br>"+"提示信息:"+titletip+"</font>";
countDown();
}
else
{
fontColor="red";
imgUrl="images/beError.gif";
messageArea.innerHTML="<img src="+imgUrl+"/>"+"<font color="+fontColor+">"+message+"</font>";
}
}
function countDown()
{
setTimeout("location=''Manager.aspx''",3000);
}