XML数据岛测试
+展开
-HTML
<html>
<head>
<meta http-equiv="http-content" content="text/html;charset=gb2312"/>
<title>XML数据岛测试</title>
</head>
<body>
<xml id='ds'>
<rows>
<row><id>2</id><name>name2</name></row>
<row><id>1</id><name>name1</name></row>
<row><id>3</id><name>name3</name></row>
</rows>
</xml>
<script>
var adBSTR = 8;
var adBigInt = 20;
var dsrs=ds.recordset;
var rs=new ActiveXObject("adodb.recordset");
with(rs)
{
//设置rs的类型
cursortype=1;
locktype=3;
//添加列
fields.append("id",adBigInt);
fields.append("name",adBSTR);
}
rs.Open();//打开游标
while(!dsrs.eof)//拷贝数据,数据岛中的recordset不支持sort和filter属性,只要把数据拷贝进入recordset中
{
rs.AddNew();
rs(0)=dsrs(0)
rs(1)=dsrs(1);
rs.Update();
dsrs.movenext();
}
rs.sort="id";//排序
//rs.MoveFirst();
alert(rs(0)+"|"+rs(1));
rs.Close();
rs=null;
</script>
</body>
</html>
<head>
<meta http-equiv="http-content" content="text/html;charset=gb2312"/>
<title>XML数据岛测试</title>
</head>
<body>
<xml id='ds'>
<rows>
<row><id>2</id><name>name2</name></row>
<row><id>1</id><name>name1</name></row>
<row><id>3</id><name>name3</name></row>
</rows>
</xml>
<script>
var adBSTR = 8;
var adBigInt = 20;
var dsrs=ds.recordset;
var rs=new ActiveXObject("adodb.recordset");
with(rs)
{
//设置rs的类型
cursortype=1;
locktype=3;
//添加列
fields.append("id",adBigInt);
fields.append("name",adBSTR);
}
rs.Open();//打开游标
while(!dsrs.eof)//拷贝数据,数据岛中的recordset不支持sort和filter属性,只要把数据拷贝进入recordset中
{
rs.AddNew();
rs(0)=dsrs(0)
rs(1)=dsrs(1);
rs.Update();
dsrs.movenext();
}
rs.sort="id";//排序
//rs.MoveFirst();
alert(rs(0)+"|"+rs(1));
rs.Close();
rs=null;
</script>
</body>
</html>
加支付宝好友偷能量挖...
原创文章,转载请注明出处:XML数据岛测试