<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312" />
<title>我的精品收藏夹</title>
</head>
<script>
/** 公用变量 **/
var db_name = "netBook.mdb"; // Access数据库名/**
* 函数: connect
* 功能: 连接 Access 数据库
* 返回连接
* 要求数据库文件在本文档一起
*/
function connect() {
var dbc = new ActiveXObject("ADODB.Connection");
var dbcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"$1")+db_name;
// var dbcon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" + location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"$1")+db_name;
dbc.Open(dbcon);
return dbc;
}function gen() {
var conn = connect();
var rs = conn.Execute("select * from manage where type='netBook'");
var s = rs("content").value;
rs.Close();
conn.Close();
document.open("text/html", "replace");
document.write(s);
document.close();
}
</script>
<body onLoad="gen()">
正在初始化系统,请稍候...
</body>
</html>以上代码为唠叨大哥的。
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312" />
<title>我的精品收藏夹</title>
</head>
<script>
/** 公用变量 **/
var db_name = "netBook.mdb"; // Access数据库名/**
* 函数: connect
* 功能: 连接 Access 数据库
* 返回连接
* 要求数据库文件在本文档一起
*/
function connect() {
var dbc = new ActiveXObject("ADODB.Connection");
var dbcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"$1")+db_name;
// var dbcon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" + location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"$1")+db_name;
dbc.Open(dbcon);
return dbc;
}function gen() {
var conn = connect();
var rs = conn.Execute("select * from manage where type='netBook'");
var s = rs("content").value;
rs.Close();
conn.Close();
document.open("text/html", "replace");
document.write(s);
document.close();
}
</script>
<body onLoad="gen()">
正在初始化系统,请稍候...
</body>
</html>以上代码为唠叨大哥的。
是一个“JScript + Access的应用,不需要服务器支持”
不是javascript的
conn.Open("Data Source=190.190.200.100,1433;Initial Catalog=pubs;User ID=sa;Password=asdasd;"); var strSQL = "Select * From Data"; var rs = new ActiveXObject("ADODB.Recordset");
rs.CursorType = 3; //adOpenStatic
rs.LockType = 1; //adLockReadOnly
rs.Open(strSQL, conn)
<head>
<title>表格显示数据表记录</title>
</head>
<body>
<h2>表格显示数据表记录</h2>
<hr>
<script language="JavaScript">
// 创建数据库对象
var objdbConn = new ActiveXObject("ADODB.Connection");
// DSN字符串
var strdsn = "Driver={SQL Server};Server=127.0.0.1;Database=study;UID=sa;PWD=";
// 打开数据源
objdbConn.Open(strdsn);
// 执行SQL的数据库查询
var objrs = objdbConn.Execute("select * from student");
// 获取字段数目
var fdCount = objrs.Fields.Count - 1;
// 检查是否有记录
if (!objrs.EOF){
document.write("<table border=1><tr>");
// 显示数据库的字段名称
for (var i=0; i <= fdCount; i++)
document.write("<td><b>" + objrs.Fields(i).Name + "</b></td>");
document.write("</tr>");
// 显示数据库内容
while (!objrs.EOF){
document.write("<tr>");
// 显示每笔记录的字段
for (i=0; i <= fdCount; i++)
document.write("<td valign='top'>" + objrs.Fields(i).Value + "</td>");
document.write("</tr>");
objrs.moveNext(); // 移到下一笔记录
}
document.write("</table>");
}
else
document.write("数据库内没有记录!<br/>");
objrs.Close(); // 关闭记录集合
objdbConn.Close(); // 关闭数据库链接
</script>
</body>
</html>