此处包含以下三种情况:
1、单行数据一个表格;
2、多少行数据多少个表格;
3、一个表格多行数据
//1.联动到Access数据库的一个方法(最多只有一行数据时);
function loadData(LibleName,divName) {
var conn = new ActiveXObject("ADODB.Connection");
var connStr = "DBQ=" + serverMapPath("Template.mdb")
+ ";DRIVER={Microsoft Access Driver (*.mdb)};"
conn.Open(connStr);
var rs = new ActiveXObject("ADODB.Recordset");
var sql = "select * from " + LibleName;
rs.open(sql, conn);
theInput = null;
var Lible;
while (!rs.EOF) {
var equals;
var feildName = "";
var value = "";
var inputs = document.getElementsByTagName("input");
var textAreas = document.getElementsByTagName("textarea");
for(var z=0;rs.fields.count>z;z++){
feildName = rs(z).Name;
value = (rs.Fields(feildName).Value);
if (value == null)
value = "";
for (var i = 0; i < inputs.length; i++) {
var input = inputs[i];
if(feildName==input.id){
value = ConvertSpecialCharFromXML(value);
input.value=value;
input.className='text2';
}
}