资源描述
这是本人在学校时照老师的要求做的最简单的ajax功能，不好勿喷。这代码主要分为html代码和cs后台代码，和数据库连接的功能我就没发数据库了，都是简单的数据库。（基于C# 的ajax功能实现代码。），仅供参考。
1、地区信息查询
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script type="text/javascript" language="javascript">
var XMLHttpRequest;
var requestType = "";
function getXMLHttpRequest() {
if (window.ActiveXObject) {
XMLHttpRequest = new ActiveXObject("Microsoft.XMLHTTP");
}
else if (window.XMLHttpRequest) {
XMLHttpRequest = new XMLHttpRequest();
} }
function sendRquest(request) {
requestType = request;
getXMLHttpRequest();
XMLHttpRequest.onreadystatechange = stateChange;
XMLHttpRequest.open("GET", "XMLFile2.xml");
XMLHttpRequest.send(null); }
function stateChange() {
if (XMLHttpRequest.readyState == 4) {
if (XMLHttpRequest.status == 200) {
if (requestType == "north") {
listNorthStates(); }
else if (requestType == "all") {
listAllStates(); }
else if (requestType == "south") {
listSouthStates();}
else if (requestType == "east") {
listEastStates(); }
else if (requestType == "west") {
listWestStates(); } } } }
var northStates;
var southStates;
var eastStates;
var westStates;
var allStates;
function listNorthStates() {
var xmlDOC = XMLHttpRequest.responseXML;
var northNode = xmlDOC.getElementsByTagName("north")[0];
northStates = northNode.getElementsByTagName("state");
output("北À¡À部?州Y名?", northStates); }
function listSouthStates() {
var xmlDOC = XMLHttpRequest.responseXML;
var southNode = xmlDOC.getElementsByTagName("south")[0];
southStates = southNode.getElementsByTagName("state");
output("南?部?州Y名?", southStates); }
function listEastStates() {
var xmlDOC = XMLHttpRequest.responseXML;
var eastStates = xmlDOC.getElementsByTagName("east")[0];
eastStates = eastNode.getElementsByTagName("state");
output("东?部?州Y名?", eastStates); }
function listWestStates() {
var xmlDOC = XMLHttpRequest.responseXML;
var westStates = xmlDOC.getElementsByTagName("west")[0];
westStates = westNode.getElementsByTagName("state");
output("西¡Â部?州Y名?", westStates); }
function listAllStates() {
var xmlDOC = XMLHttpRequest.responseXML;
allStates = xmlDOC.getElementsByTagName("state");
output("所¨´有®D州Y名?", allStates); }
function output(title, states) {
var out = title;
var currentSate = null;
for (var i = 0; i < states.length; i++) {
currentState = states[i];
out = out + "\n- " + currentState.childNodes[0].nodeValue; }
alert(out);}
</script><
/head>
<body><
h1>显?示º?美¨¤国¨²的Ì?州Y名?</h1>
<p>
<input id="Button1" type="button" value="查¨¦看¡ä美¨¤国¨²所¨´有®D州Y名?" onclick="sendRquest('all')"
style="color: #FF0000; background-color: #00FFFF" /></p>
<p>
<input id="Button2" type="button" value="查¨¦看¡ä美¨¤国¨²北À¡À部?州Y名?"
onclick="sendRquest('north')"
style="color: #FF0000; background-color: #00FFFF" /></p>
<p> </p>
<p> </p>
<p> </p>
</body></html>
2、信息增删改查
Html页面
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script type ="text/javascript">
var xmlHttp;
var name;
var num;
var Bclass;
var deleteID;
function createXMLHttpRequest() {
if (window.ActiveXObject) {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
else if (window.XMLHttpRequest) {
xmlHttp = new XMLHttpRequest(); } }
function addEmployee() {
name = document.getElementById("name").value;
num = document.getElementById("num").value;
Bclass = document.getElementById("Bclass").value;
if (name == "" || num == "" || Bclass == "") {
return; }
var url = "zsgc.aspx?" + createAddQueryString(name, num, Bclass, "ffstudent"); +"&ts=" + new Date().getTime();
createXMLHttpRequest();
xmlHttp.onreadystatechange = handleAddStatechange;
xmlHttp.open("GET", encodeURI(url), true);
xmlHttp.send(null);
}
function delEmployee() {
num = document.getElementById("num").value;
if (num == "") {
return; }
var url = "zsgc.aspx?" + createDelQueryString(num, "delstuent"); +"&ts=" + new Date().getTime();
createXMLHttpRequest();
xmlHttp.onreadystatechange = handleAddStatechange;
xmlHttp.open("GET", encodeURI(url), true);
xmlHttp.send(null); }
function cxEmployee() { num = document.getElementById("num").value;
action = "cxstudent";
if (num == "") {
return; }
var url = "zsgc.aspx?" + createcxQueryString(num, action); +"&ts=" + new Date().getTime();
createXMLHttpRequest();
xmlHttp.onreadystatechange = handleAddStatechange;
xmlHttp.open("GET", encodeURI(url), true);
xmlHttp.send(null); }
function createAddQueryString(name, num, Bclass, action) {
var queryString = "name=" + name
+ "&num=" + num
+ "&Bclass=" + Bclass
+ "&action=" + action;
return queryString;
}
function createDelQueryString(num, action) {
var queryString = "num=" + num
+ "&action=" + action;
return queryString; }
function createcxQueryString(num, action) {
var queryString = "num=" + num
+ "&action=" + action;
return queryString; }
function handleAddStatechange() {
if (xmlHttp.readyState == 4) {
if (xmlHttp.status == 200) {
alert(xmlHttp.responseText);
clearInputBoxes(); }
else {
alert("Error while adding employee."); } } }
function clearInputBoxes() {
document.getElementById("name").value = "";
document.getElementById("num").value = "";
document.getElementById("Bclass").value = ""; }
</script></head><body background="img/3.jpg">
<h1> 学¡ì生¦¨²信?息¡é</h1>
<table ><tr><td>姓?名?：êo</td><td>
<input id="name" type="text" /></td><td>学¡ì号?：êo</td><td>
<input id="num" type="text" /></td><td>班㨤级?：êo</td><td>
<input id="Bclass" type="text" /></td></tr><tr>
<td colspan ="2" align="center">
<input id="Button1" type="button" value="添¬¨ª加¨®" onclick="addEmployee();" /></td>
<td colspan ="2" align="center">
<input id="Button2" type="button" value="删¦?除y" onclick ="delEmployee();" /></td>
<td colspan ="2" align="center">
<input id="Button3" type="button" value="查¨¦询¡¥" onclick="cxEmployee();"/></td></tr>
</table>
</body>
</html>
Cs后台代码.
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class zsgc : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string str = "Data Source=.;Initial Catalog=Student;Integrated Security=True";
SqlConnection coon = new SqlConnection(str);
SqlCommand cmd = new SqlCommand();
try {
coon.Open();
string action = Request["action"].ToString();
string num = Request["num"].ToString();
if (action == "ffstudent")
{ string Bclass = Request["Bclass"].ToString();
string name = Request["name"].ToString();
SqlParameter[] par ={
new SqlParameter("@name",name),
new SqlParameter ("@num",num),
new SqlParameter ("@Bclass",Bclass ) };
cmd.Connection = coon;
cmd.CommandText = "ffstudent";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(par);
int i = cmd.ExecuteNonQuery();
if (i > 0) {
Response.Write("添¬¨ª加¨®成¨¦功|！ê?"); }
else {
Response.Write("添¬¨ª加¨®失º¡ì败㨹！ê?");} }
else if (action == "delstuent"){
SqlParameter[] par ={
new SqlParameter ("@num",num) };
cmd.Connection = coon;
cmd.CommandText = "delstuent";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(par);
int i = cmd.ExecuteNonQuery();
if (i > 0){
Response.Write("删¦?除y成¨¦功|！ê?");}
else{
Response.Write("删¦?除y失º¡ì败㨹！ê?"); }}
else if (action == "cxstudent"){
DataTable dt = new DataTable();
SqlParameter[] par ={
new SqlParameter ("@num",num) };
cmd.Connection = coon;
cmd.CommandText = "cxstudent";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(par);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
string str1 = "";
for (int i = 0; i < dt.Rows.Count; i++) {
str1 += dt.Rows[i][0].ToString() + ":" + dt.Rows[i][1].ToString() + ":" + dt.Rows[i][2].ToString(); }
Response.Write(str1); }
coon.Close(); }
catch (Exception e1)
{
Response.Write(e1.ToString());}}}
3、注册
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>无T标À¨º题¬a页°3</title>
<script type="text/javascript">
var xmlHttp;
function vilidation() {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
var name = document.getElementById("Txt1");
if (name.value != "") {
xmlHttp.open("Post", "zhuce.aspx?name=" + name.value);
xmlHttp.onreadystatechange = OnMessageBack;
xmlHttp.send(null);}
else {alert("用®?户¡ì名?不?能¨¹为a空?！ê?");}}
function OnMessageBack() {
if (xmlHttp.readystate == 4 && xmlHttp.status == 200) {
alert(document.write(xmlHttp.responsetext)); } }
</script>
</head>
<body background="img/3.jpg">
<p style="color: #00FF00">
用®?户¡ì注Á¡é册¨¢验¨¦证¡è</p><p>
<input id="Txt1" type="text" /><input id="But1" type="button"
value="注Á¡é册¨¢" onclick="vilidation();" /> </p><
/body>
</html>
Cs
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class zhuce : System.Web.UI.Page{
protected void Page_Load(object sender, EventArgs e) {
if (Request["name"] != ""){
string name = this.Request["name"];
string connStr = "Data Source=.;Initial Catalog=User;Integrated Security=True;Pooling=False";
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
string selStr = "select * from dbo.use1 where name='" + name + "'";
SqlCommand com = new SqlCommand(selStr, conn);
SqlDataReader da = com.ExecuteReader();
if (da.Read()){
Response.Write("用®?户¡ì名?已°?存ä?在¨²！ê?！ê?"); } else {
Response.Write("注Á¡é册¨¢成¨¦功|！ê?！ê?");} }}}
4、自动完成
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>自Á?动¡¥完ª¨º成¨¦</title>
<script type="text/javascript">
var xmlHttp;
var completeDiv;
var inputField;
var nameTable;
var nameTableBody;
function createXMLHttpRequest() {
if (window.ActiveXObject) {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); }
else if (window.XMLHttpRequest) {
xmlHttp = new XMLHttpRequest(); } }
function initVars() {
inputField = document.getElementById("names");
nameTable = document.getElementById("name_table");
completeDiv = document.getElementById("popup");
nameTableBody = document.getElementById("name_table_body"); }
function findNames() {
initVars();
if (inputField.value.length > 0) {
createXMLHttpRequest();
var url = "ZDWC.aspx?names=" + escape(inputField.value);
xmlHttp.open("GET", url, true);
xmlHttp.onreadystatechange = callback;
xmlHttp.send(null); } else {
clearNames(); } }
function callback() {
if (xmlHttp.readyState == 4) {
if (xmlHttp.status == 200) {
setNames(xmlHttp.responseXML.getElementsByTagName("name"));
} else if (xmlHttp.status == 1223) {
clearNames(); } }}
function setNames(the_names) {
clearNames();
var size = the_names.length;
setOffsets();
var row, cell, txtNode;
for (var i = 0; i < size; i++) {
var nextNode = the_names[i].firstChild.data;
row = document.createElement("tr");
cell = document.createElement("td");
cell.onmouseout = function() { this.className = 'mouseOver'; };
cell.onmouseover = function() { this.className = 'mouseOut'; };
cell.setAttribute("bgcolor", "#FFFAFA");
cell.setAttribute("border", "0");
cell.onclick = function() { populateName(this); };
txtNode = document.createTextNode(nextNode);
cell.appendChild(txtNode);
row.appendChild(cell);
nameTableBody.appendChild(row); } }
function setOffsets() {
var end = inputField.offsetWidth;
var left = calculateOffsetLeft(inputField);
var top = calculateOffsetTop(inputField) + inputField.offsetHeight;
completeD
展开阅读全文
浙ICP备2021020529号-1 | 浙B2-20240490 
