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(); }
Kenyataan:
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn