用js创建Access库和表
conn = new ActiveXObject("adox.catalog")
conn.create("provider=microsoft.jet.oledb.4.0;data source=" + location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"")+"xzn.mdb");
conn.close()conn = connect(dbpath+"xzn.mdb");
conn.Execute("drop table test2"); // 删除表
conn.Execute("create table data ("
+ "id double primary key,"
+ "cote long,"
+ "author varchar(20),"
+ "title varchar(100),"
+ "content memo,"
+ "type varchar(4),"
+ "soruce varchar(50) )");
conn.Close();
conn = new ActiveXObject("adox.catalog")
conn.create("provider=microsoft.jet.oledb.4.0;data source=" + location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"")+"xzn.mdb");
conn.close()conn = connect(dbpath+"xzn.mdb");
conn.Execute("drop table test2"); // 删除表
conn.Execute("create table data ("
+ "id double primary key,"
+ "cote long,"
+ "author varchar(20),"
+ "title varchar(100),"
+ "content memo,"
+ "type varchar(4),"
+ "soruce varchar(50) )");
conn.Close();
解决方案 »
- 请问 ext Grid 如何实现 无刷新 读取数据 ??
- Jquery,如何去掉文本框中重复的数组数值
- A页面里JS如何跳转到B页面让,B页面里用document.referrer能获取上个页面地址
- JS实现简单拖拽
- 求助,一个JS获取最上端URL的问题。
- JS如何判断网页是HTML4.0还是XHTML1.0
- 从一个已有数组中向另外一个空白数组添加元素
- ÂÒÊÀ¶ùÅ®(下载中...) 谁能告诉我它的中文是什么呀??????????????
- 如何用javascrip实现动态的往html画表格
- 哪位老兄可以帮忙解码下面这段js的,不胜感激,可用送分30
- 请教一个javascript效果。
- javascript 实现一个 小函数
用js创建库和表var dbpath = location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,""); // 设置路径/**
* 函数: connect
* 功能: 连接 Access 数据库
* 返回连接
* 要求数据库文件在本文档一起
*/
function connect(db_name) {
var dbc = new ActiveXObject("ADODB.Connection");
var dbcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +db_name;
// var dbcon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" + db_name;
dbc.Open(dbcon);
return dbc;
}/**
* 功能: 执行SQL指令
*/
function query(db_name,sql) {
var conn = connect(db_name); // 连接数据库
conn.Execute(sql);
conn.Close();
}/**
* 函数: addslashes
* 功能: 按数据库期望转义特殊字符
* 返回转移后的字符串
*/
function addslashes(s) {
return s.replace(/'/g,"''");
}/**
* 创建数据库
*/
conn = new ActiveXObject("adox.catalog")
conn.create("provider=microsoft.jet.oledb.4.0;data source=" + dbpath+"xzn.mdb");
conn.close()/**
* 在数据库中建表
*/
conn = connect(dbpath+"xzn.mdb");
conn.Execute("drop table test2"); // 删除表
conn.Execute("create table data ("
+ "id double primary key,"
+ "cote long,"
+ "author varchar(20),"
+ "title varchar(100),"
+ "content memo,"
+ "type varchar(4),"
+ "soruce varchar(50) )");
conn.Close();