JScript连接ADO,显示记录行

发布时间 2023-08-12 21:58:25作者: 小风风的博客

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>
<head>
<title>第一个HTA的例子1111</title>

<meta http-equiv="msthemecompatible" content="yes">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<style>
table {
border-width: 1px;
border-style: solid;
border-color: black;
border-top-style: dashed;
border-bottom-style: dotted;
}
thead th {
border: 1px solid black;
}
</style>
</head>
<script>
function add() {

debugger;
var db = new ActiveXObject("adodb.connection");
var ret = db.Open("Provider=Microsoft.Ace.OLEDB.12.0;Data Source=D:\\db1.accdb");
var CommandText = "select * From [user]";

var rs = db.Execute(CommandText);
while (!rs.EOF) {


var tab1 = document.getElementById("tab1");
var row = document.createElement("tr");
var col1 = document.createElement("td");
var txtUserid = document.createTextNode( rs("userid").Value);
col1.appendChild(txtUserid);
row.appendChild(col1);

var col2 = document.createElement("td");
var txtName = document.createTextNode(rs("name").Value);
col2.appendChild(txtName);

row.appendChild(col2);
tab1.appendChild(row);


rs.MoveNext();
}

rs.Close();

db.Close();


}
</script>
<body>
<center>
HTA
HTMLApplication
HTML应用程序
<button onclick="self.close()"style="font-size:18">离开</button>
</center>
<div>

<input id="id" type="text" />
<br>
<input id="name" type="text" />
<input type="button" value="add" onclick="add();" />

</div>
<table id="tab1" style="border:1px solid black;"></table>
</body>
</html>