data.js 所有操作js代码 var xmlHttp; var xmlContent; //ajax请求后返回保存的数据 var key = ""; var id = ""; //---------------------样式设置------------------// var divid = "selectData" //说明第4步 var txtValueID = "selectValue"; //说时第2步 var fieldNames = new Array(3); //单击某行取值是,每列值前添加一个该值列名 var isShowFieldNames = true; //取值时,是否要显示列名 true为显示,false不显示 fieldNames[0]="编号:"; fieldNames[1]="用户名:"; fieldNames[2]="密码:"; var pageSize = 10; //每页显示行数 var onmouseoverBG = "#DDFFEC"; //鼠标移上去该行的背景颜色 var onmouseoutBG = "#ffffff"; //鼠标离开后该行的背景颜色 //表头列名根据需要修改 var tableHead = ""; tableHead += "
编号
"; tableHead += "
用户名
"; tableHead += "
密码
"; tableHead += ""; //数据绑定字段名,修改DATAFLD里的的字段名 var dataFiled = "
"; dataFiled += "
"; dataFiled += "
"; var RequestFile = "getXml1.aspx"; //请求页面 //-------------------外部调用--------------------------// //显示选择 //productID是下拉框ID,请根据需要修改 function show() { $(divid).style.display = '' $(divid).style.position="absolute" $(divid).style.backgroundColor="#FFFFFF" key = ""; id = productID.options[productID.selectedIndex].value; RequestXML(); } //分类改变时隐藏 function changeID() { hide(); } //---------------------内部方法,一般不用修改---------------------------// //选择某行的值,显示到文本框 function getCurrentRowData(tr) { var tds = tr.getElementsByTagName("td") //得到所有列 var result=""; for(var i = 0; i { if(isShowFieldNames){result += fieldNames[i]}; if(i != tds.length -1 )//是否是最后一列 { result += tr.getElementsByTagName("div")[i].firstChild.nodeValue + ","; //得到第i列的值 + "," } else { result += tr.getElementsByTagName("div")[i].firstChild.nodeValue; //得到第i列的值 } } $(txtValueID).value = result; hide(); } //显示内容 function ShowData() { var data = $(divid); var content = "
" data.innerHTML = content; GetPages(); } //得到总页 function GetPages() { var rowCount = $("data_souce").getElementsByTagName("Table"); //得到所有table节点,得到总记录数 $("pages").innerHTML = Math.ceil(rowCount.length / pageSize); $("compart").innerHTML = "/"; if(rowCount.length == 0) { $("resultxml").innerHTML = "找不到相关数据"; } } //首页时得到当前页 function firstPage() { $("page").innerHTML = 1; } //上页时得到当前页 function previousPage() { if($("page").innerHTML != "1") { $("page").innerHTML = parseInt($("page").innerHTML) - 1; } } //下页时得到当前页 function nextPage() { if($("page").innerHTML != $("pages").innerHTML) { $("page").innerHTML = parseInt($("page").innerHTML) + 1; } } //尾页时得到当前页 function lastPage() { $("page").innerHTML = $("pages").innerHTML; } //翻页操作 function GotoPage(page) { switch(page) { case "first": { datas.firstPage(); firstPage(); break; } case "previous": { datas.previousPage(); previousPage(); break; } case "next": { datas.nextPage(); nextPage(); break; } case "last": { datas.lastPage(); lastPage(); break; } } } //搜索 function Search() { key = $("key").value; if(key == "") { alert("请输入搜索关键字"); return; } RequestXML(); } //根据ID得到对象 function $(id) { return document.getElementById(id); } //隐藏选择 function hide() { $(divid).style.display ="none"; } //创建XMLHttpRequest function CreateXMLHttpRequest() { if(window.ActiveXObject) { xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); } else if(window.XMLHttpRequest) { xmlHttp = new XMLHttpRequest(); } } //请求 function RequestXML() { var url = RequestFile + "?id=" + id + "&key=" + key; CreateXMLHttpRequest(); xmlHttp.open("get",url); xmlHttp.onreadystatechange = GetXMLResult; xmlHttp.send(null); } //接收 function GetXMLResult() { if(xmlHttp.readyState == 4) { if(xmlHttp.status == 200) { xmlContent = xmlHttp.responseText; ShowData(); } } else { $(divid).innerHTML = "正在读取数据中"; } } getXml.aspx 服务端数据源 private void Page_Load(object sender, System.EventArgs e) { Response.Write(GetData()); Response.End(); } private string GetData() { string id = Request.QueryString["id"]; string key = Request.QueryString["key"]; string sql = "select * from T_user where F_id = " + id; if (key.Length > 0){sql += " and F_id like '%" + key + "%'or F_passWord like '%" + key + "%' or F_userName like '%" + key + "%'";} StringBuilder sb = new StringBuilder(); sb.Append(""); SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=sa;database=WebTest"); conn.Open(); SqlDataAdapter da = new SqlDataAdapter(sql,conn); DataSet ds = new DataSet(); da.Fill(ds); conn.Close(); sb.Append(ds.GetXml()); return sb.ToString(); }
Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn