用js操作mdb数据库的一些操作,包括数据的读取和存储;
html页面信息
mdb数据库表一
mdb数据库表二
具体代码如下:
//获得fileName的路径;
function serverMapPath(fileName) {
var syspath = location.href; //file:///c:/Documents%20and%20Settings/Administrator/桌面/新建文件夹/handle-mdb.html
alert(syspath)
syspath = syspath.toLowerCase();
myPosition = syspath.lastIndexOf("/");
syspath = syspath.substring(0, parseInt(myPosition) + 1);
syspath = syspath.replace("file:///", "");
syspath = syspath.replace(new RegExp("%20", "gm"), " ");
syspath = syspath + fileName; //c:/documents and settings/administrator/桌面/新建文件夹/Database.mdb;
alert(syspath)
return syspath.toString();
}
//获取mdb数据库中的数据到html-方法1-多字段名称;
function loadData(LibleName) {
var conn = new ActiveXObject("ADODB.Connection");
var connStr = "DBQ=" + serverMapPath("Database.mdb") + ";DRIVER={Microsoft Access Driver (*.mdb)};"
//打开数据库;
conn.Open(connStr);
var rs = new ActiveXObject("ADODB.Recordset");
var sql = "select * from " + LibleName;
//打开记录集;
rs.open(sql, conn);
while (!rs.EOF) {
var feildName = "";
var valueCell = "";
var inputs = document.getElementsByTagName("input");
var textAreas &