Javascript-处理mdb数据库
用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 = document.getElementsByTagName("textarea");
?? //rs.fields.count为字段名称的总数；
????? for(var z=0;rs.fields.count>z;z++){
?? //filedName为字段名称；
???????? filedName = rs(z).Name;
?? //mdb中各字段内存储的值；
???????? valueCell = (rs.Fields(filedName).Value);
???????? if (valueCell == null){
???? valueCell = "";
?? }
?? for (var i = 0; i < inputs.length; i++) {
????? var inputCell = inputs[i];???
????? if(filedName==inputCell.id){
????? inputCell.value=valueCell;
???}
?? }
?? for (var j = 0; j < textAreas.length; j++){
???????????? var textAreaCell = textAreas[j];
???????????? if (filedName == textAreas.id){
????????????????? textAreaCell.value = valueCell;
???????????? }?
???????? }
????? }
????? rs.moveNext();
?? }
?? rs.close;
?? rs = null;
}
?
//获取mdb数据库中的数据到html-方法2-两个字段名称-一个ID，一个name；
function Show(tableName) {
?var str =tableName;
?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 "+str+" order by id";
?rs.open(sql, conn);
?theInput = null;
?while (!rs.EOF) {
??var htmlID = "";
??var value = "";
??//mdb中的ID是正整数，html中的ID由四位数字组成，位数不够的用0不足；
??//如mdb中的‘1’，html中是‘0001’；
??htmlID = rs.Fields("id").value;
??if(htmlID.length==1){
???? htmlID = '000'+htmlID;
??}else if(htmlID.length==2){
???? htmlID='00'+htmlID;
??}else if(s.length==3){
???? htmlID='0'+htmlID;
??}
??try
??{
???theInput = document.getElementById(htmlID);
???if (theInput !== null){
????value = (rs.Fields("name").Value);
?????? if (theInput.type == "text"){
?????theInput.value = value;
????}
????if (theInput.type == "textarea") {
?????theInput.value = value;
????}
????if (theInput.type == "radio"){
?????if (value == "√"){theInput.checked = true}
?????if (value == "□"){theInput.checked = false}
????}
????if (theInput.type == "checkbox"){
?????if (value == "√"){theInput.checked = true}
?????if (value == "□"){theInput.checked = false}
????}
????if (theInput.name == "select") {
?????for(j = 0; j< theInput.length ; j++){
??????if (theInput.options[j].value == value) {
???????theInput.options[j].selected = true;
??????}
?????}
????}
????//name是值为‘uu’的处理；
????if(theInput.className == "uu"){
?????? theInput.innerHTML = value;
????}
???}
??}
??catch(E)
??{
??}
??rs.moveNext();
?}
?conn.close();
?conn = null;
}
?
//把html中填写的内容更新到数据库；
function update(str) {
?? var conn = new ActiveXObject("ADODB.Connection");
?? var connStr = "DBQ=" + serverMapPath("Database.mdb") + ";DRIVER={Microsoft Access Driver (*.mdb)};"
?? conn.Open(connStr);
??
?? InputList = document.getElementsByTagName("input");
?? TheInput = null;
?? for(i = 0; i < InputList.length; i++) {
????? TheInput = InputList[i];
?? var TheInputId = TheInput.id;
?? TheInputId = parseInt(TheInputId,10);
?? if(!isNaN(TheInputId)){
???????? if (TheInput !== null){
????? //radio单选框的处理
????? if (TheInput.type == "radio"){
????var sql = "delete from "+ str +" where id = '"+ TheInputId+"'";
????conn.execute(sql);
?????? if (TheInput.checked == true){
?????? var sql = "insert into "+ str +" values("+ TheInputId +",'" + "√" + "')";
?????? conn.execute(sql);
?????? }
?????? if (TheInput.checked == false){
?????? var sql = "insert into "+ str +" values("+ TheInputId +",'" + "□" + "')";
?????? conn.execute(sql);
?????? }
????? }
???//checkbox复选框的处理；
????? if (TheInput.type == "checkbox"){
???????? var sql = "delete from "+ str +" where id = '"+ TheInputId+"'";
????? conn.execute(sql);
????? if (TheInput.checked == true){
???????? var sql = "insert into "+ str +" values("+ TheInputId +",'" + "√" + "')";
???????? conn.execute(sql);
????? }
????? if (TheInput.checked == false){
???????? var sql = "insert into "+ str +" values("+ TheInputId +",'" + "□" + "')";
???????? conn.execute(sql);
????? }
????? }
???//一般文本输入框处理
???if (TheInput.type == "text") {
????if (TheInput.value !== null){
?????var sql = "delete from "+ str +" where id = '"+ TheInputId+"'";
?????conn.execute(sql);
?????var sql = "insert into " + str + " values(" + TheInputId + ",'" + TheInput.value + "')";
?????conn.execute(sql);
????}
???}
???//隐藏域的处理
???if (TheInput.type == "hidden") {
????if (TheInput.value !== null){
?????var sql = "delete from "+ str +" where id = '"+ TheInputId+"'";
?????conn.execute(sql);
????? sql = "insert into " + str + " values(" + TheInputId + ",'" + TheInput.value + "')";
?????conn.execute(sql);
????}
???}
???????? }
????? }
?? }
?? //textarea多行文本框；
?? InputList = document.getElementsByTagName("textarea");
?? TheInput = null;
?? for(i = 0; i < InputList.length; i++) {
????? TheInput = InputList[i];
????? var TheInputId = TheInput.id;
????? TheInputId = parseInt(TheInputId,10);
????? if(!isNaN(TheInputId)){
???????? if (TheInput !== null){
??????????? if (TheInput.text !== null){
?????????????? var sql = "delete from "+ str +" where id = '"+ TheInputId+"'";
?????????????? conn.execute(sql);
?????????????? var sql = "insert into "+ str +" values("+ TheInputId +",'" + TheInput.value + "')";
?????????????? conn.execute(sql);
??????????? }
???????? }
????? }
?? }
??
?? //select下拉框的处理
?? InputList = document.getElementsByTagName("select");
?? TheInput = null;
?? for(i = 0; i < InputList.length; i++) {
????? TheInput = InputList[i];
????? var TheInputId = TheInput.id;
????? TheInputId = parseInt(TheInputId,10);
????? if(!isNaN(TheInputId)){
???????? if (TheInput !== null){
???if (TheInput.name == "select") {
????var sql = "delete from "+ str +" where id = '"+ TheInputId+"'";
????conn.execute(sql);
????for(j = 0; j< TheInput.length; j++){
?????if (TheInput.options[j].selected) {
??????var sql = "insert into "+ str +" values("+ TheInputId +",'" + TheInput.options[j].value + "')";
??????conn.execute(sql);
?????}
????}
???}
???????? }
????? }
?? }
?? conn.close();
?? conn = null;
}
