<script>
var dbpath = location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"$1");
function connect(db_name) {
var dbc = new ActiveXObject("ADODB.Connection");
var dbcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +db_name;
dbc.Open(dbcon);
return dbc;
}
function query(sql) {
var conn = connect(dbpath+"netBook.mdb"); // 毗连数据库
conn.Execute(sql);
conn.Close();
}
function splitData() {
name = document.all.sfile.value;
moveData(name,dbpath+"netBook.mdb","");
query("update data set cote=0 where cote not in (select id from itemlist)");
}
function addslashes(s) {
return s.replace(/'/g,"''");
}