<html>
<head>
</head>
<body>
<script language="JavaScript" >
var name;
var objdbConn = new ActiveXObject("ADODB.Connection");var strdsn = "Driver={SQL Server};SERVER=localhost;DATABASE=XXXX";objdbConn.Open(strdsn);
var objrs = objdbConn.Execute("SELECT * FROM student");var fdCount = objrs.Fields.Count - 1;
if (!objrs.EOF){
while (!objrs.EOF){
name =objrs.Fields(0).Value ;
// document.write(name);
// document.write("<br/>");
document.all.span1.innerHTML+=name+"<br>"
objrs.movenext();
} // document.write(name);
// document.write("?????"); //测试
}
else
document.all.span1.innerHTML="数据库内没有记录!<br/>";
// document.write("数据库内没有记录!<br/>");document.write("?????"); //测试objrs.Close();
objdbConn.Close();
</script>
</body>
<span id="span1"></spane>
</html>
<head>
</head>
<body>
<script language="JavaScript" >
var name;
var objdbConn = new ActiveXObject("ADODB.Connection");var strdsn = "Driver={SQL Server};SERVER=localhost;DATABASE=XXXX";objdbConn.Open(strdsn);
var objrs = objdbConn.Execute("SELECT * FROM student");var fdCount = objrs.Fields.Count - 1;
if (!objrs.EOF){
while (!objrs.EOF){
name =objrs.Fields(0).Value ;
// document.write(name);
// document.write("<br/>");
document.all.span1.innerHTML+=name+"<br>"
objrs.movenext();
} // document.write(name);
// document.write("?????"); //测试
}
else
document.all.span1.innerHTML="数据库内没有记录!<br/>";
// document.write("数据库内没有记录!<br/>");document.write("?????"); //测试objrs.Close();
objdbConn.Close();
</script>
</body>
<span id="span1"></spane>
</html>
<head>
</head>
<body>
<script language="JavaScript" >
var name;
var objdbConn = new ActiveXObject("ADODB.Connection");var strdsn = "Driver={SQL Server};SERVER=localhost;DATABASE=XXXX";objdbConn.Open(strdsn);
var objrs = objdbConn.Execute("SELECT * FROM student");var fdCount = objrs.Fields.Count - 1;
if(!objrs.EOF)
{
objrs.MoveLast();//调到最后一条
document.write(objrs.Fileds(0).value);
}
else
{
doucment.write("没有数据");
}document.write("?????"); //测试objrs.Close();
objdbConn.Close();
</script>
</body>
</html>
没有错误,因为循环里能的能读出来啊
但是改了以后也不行啊.
if (!objrs.EOF){
while (!objrs.EOF){
name =objrs.Fields(0).Value ;
document.write(name);
document.write("<br/>");
objrs.movenext();
} document.write(name);
document.write("?????"); //测试
}
不要用 if 判断..直接用 while 循环就可以了..