源代码: http://bbs.ntcsoft.com/dispbbs.asp?boardid=21&Id=66
把数据库名和sql语句改一下就行了.
把数据库名和sql语句改一下就行了.
<script language="javascript">
try{
var connection=new ActiveXObject("Adodb.Connection");
var conString= "Driver={SQL Server};SERVER=localhost;UID=sa;PWD=;DATABASE=test";
connection.Open(conString);
var objrs = connection.Execute("select * from infor");
while(!objrs.eof){
document.write(objrs(1)+" "+objrs(2)+" <b r />");
objrs.movenext();
}
}catch(err){
alert("错误"+err);
}
objrs.close;
conection.close;
</script>