js 局部刷新數據庫數據

js code:

None.gif < script type = " text/javascript " >
None.gif
// <![CDATA[
ExpandedBlockStart.gifContractedBlock.gif
     function  fLoadXml(url, show) dot.gif {
InBlock.gif    
//var drp1 = document.getElementById("TextBox1");
InBlock.gif
    var ClassID="1";//drp1.options[drp1.selectedIndex].value;
InBlock.gif
    
InBlock.gif    
var oHttpReq = new ActiveXObject("MSXML2.XMLHTTP");
InBlock.gif  
var oDoc = new ActiveXObject("microsoft.xmldom");
InBlock.gif  oHttpReq.open(
"POST""data.aspx?ClassID="+ClassID, false); 
InBlock.gif  
//
InBlock.gif
  //调用读取小类数据的页面,将大类
InBlock.gif
  // 编号值传递过去
InBlock.gif
  oHttpReq.send("");
InBlock.gif  
//result = oHttpReq.responseText;
InBlock.gif
  
ExpandedSubBlockStart.gifContractedSubBlock.gif        
switch(fCkDom2())dot.gif{
InBlock.gif            
case 1:
InBlock.gif                
var xml=document.implementation.createDocument('','',null);
ExpandedSubBlockStart.gifContractedSubBlock.gif                    xml.onload 
= function()dot.gif{show(xml, url);}
InBlock.gif                    xml.load(url);
InBlock.gif                
break;
InBlock.gif            
case 2
InBlock.gif                
var xml=new ActiveXObject('microsoft.xmldom');
ExpandedSubBlockStart.gifContractedSubBlock.gif                    xml.onreadystatechange
=function()dot.gif{
ExpandedSubBlockStart.gifContractedSubBlock.gif                        
if(xml.readyState==4)dot.gif{
InBlock.gif                            show(xml, url);
ExpandedSubBlockEnd.gif                        }

ExpandedSubBlockEnd.gif                    }
 
InBlock.gif                    xml.load(url);
InBlock.gif                
break;
InBlock.gif            
default: document.write('unknown');
ExpandedSubBlockEnd.gif        }

InBlock.gif        
ExpandedSubBlockStart.gifContractedSubBlock.gif        
function fCkDom2()dot.gif{
InBlock.gif            
if(document.implementation&&document.implementation.createDocument)return 1;
InBlock.gif            
else if(window.ActiveXObject) return 2;
InBlock.gif            
else return 0;
ExpandedSubBlockEnd.gif        }

ExpandedBlockEnd.gif    }

None.gif    
ExpandedBlockStart.gifContractedBlock.gif    
function  fShowXml(xml, url) dot.gif {
InBlock.gif  
// var drp2 = document.getElementById("TextBox1");
InBlock.gif
    //alert(drp2);
InBlock.gif
 
InBlock.gif        
//alert('ok');
InBlock.gif
        var elements=xml.getElementsByTagName('Table');
ExpandedSubBlockStart.gifContractedSubBlock.gif            
for(var i=0; i<elements.length; i++)dot.gif{
InBlock.gif                
ExpandedSubBlockStart.gifContractedSubBlock.gif                
for(var j=0; j<elements[i].childNodes.length; j++)dot.gif{
ExpandedSubBlockStart.gifContractedSubBlock.gif                    
if(elements[i].childNodes[j].nodeType==1)dot.gif{
InBlock.gif                        
var eSub=elements[i].childNodes[j]
InBlock.gif                    
InBlock.gif                        
var content;
InBlock.gif            
ExpandedSubBlockStart.gifContractedSubBlock.gif                            
trydot.gif{
InBlock.gif                                content
=eSub.firstChild.data;//.fontcolor('blue');
ExpandedSubBlockStart.gifContractedSubBlock.gif
                            }
 catch(e)dot.gif{
InBlock.gif                                content
='empty';
ExpandedSubBlockEnd.gif                            }

InBlock.gif                    
InBlock.gif                    
//将小类的类名和编号赋予DropDownList2
InBlock.gif
                 
InBlock.gif                     
//var newOption = document.createElement("OPTION");
InBlock.gif
                     // newOption.text=content;
InBlock.gif
                     
InBlock.gif                      
//newOption.value=content;
InBlock.gif
                      
InBlock.gif                      
//drp2.options.add(newOption);
InBlock.gif
                      //alert(content);
InBlock.gif
                      DIV1.innerHTML =content;
ExpandedSubBlockEnd.gif                    }

ExpandedSubBlockEnd.gif                }
  
ExpandedSubBlockEnd.gif            }

ExpandedBlockEnd.gif    }

None.gif
// ]]>οnlοad="fLoadXml('xml.xml', fShowXml);"οnlοad="fLoadXml('xml.xml', fShowXml);"
None.gif
         </ script >
None.gif        
< script language = " javascript " >
None.gif
function  getMessage()
None.gif
None.gif
// window.alert("ok!");
None.gif//
var timer=setInterval("fLoadXml('xml.xml', fShowXml);",2000)
None.gif//
window.setTimeout("opencontent()", 5000);
None.gif//
window.setTimeout("fLoadXml('xml.xml', fShowXml);",1000);//1秒钟后执行,且只执行一次
None.gif//
window.setInterval("fLoadXml('xml.xml', fShowXml);",10000);//不停的执行,每隔5秒
None.gif//
window.onload =getMessage();//οnlοad="getMessage()"
ExpandedBlockStart.gifContractedBlock.gif
dot.gif {
InBlock.gifwindow.alert(
"ok!");
InBlock.giffLoadXml(
"xml.xml", fShowXml);
ExpandedBlockEnd.gif}

None.gif
// var timer=setTimeout("getMessage()",2000)
None.gif
window.setInterval( " getMessage() " , 10000 );
None.gif
None.gif        
</ script >

調用:
其中fLoadXml("xml.xml", fShowXml) xml.xml是一個xml的文檔

<body οnlοad="getMessage()">
DIV1是一個div的id
data.aspx
private void Page_Load(object sender, System.EventArgs e)
  {
   // Put user code to initialize the page here
    
      SqlConnection   con   =   new   SqlConnection("server=(local);uid=sa;pwd=breakin;database=E_Quotation");  
      SqlDataAdapter   da   =   new   SqlDataAdapter("select name from t where pid='007'",con);  
      DataSet   ds   =   new   DataSet();  
      da.Fill(ds);  
    ds.WriteXml(Server.MapPath("xml.xml"));
  }



 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值