<input type=button value=导入 onclick="splitdata()">
</span>
<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,"''");
}
// 复制db1的数据到db2
function movedata(db1,db2,exrp) {
if(! exrp) exrp = "";
conn1 = connect(db1);
conn2 = connect(db2);
rs = conn1.execute("select * from data "+exrp);
while(!rs.eof) {
conn2.execute("insert into data values ("+rs("id").value
+","+rs("cote").value
+",'"+rs("author").value+"'"
+",'"+addslashes(rs("title").value)+"'"
+",'"+addslashes(rs("content").value)+"'"
+",'"+rs("type").value+"'"
+",'"+rs("soruce").value+"'"
+")");
rs.movenext();
}
rs.close();
conn1.close();
conn2.close();
}
</script>
Java Asp PHP .Net XML C/C++ CGI VB Jsp J2ee J2se J2me EJB Servlet Tomcat Resin Struts Weblogic Eclipse ANT GUI JMS Web servise IDEA Webphere Hibernate Spring Jboss Applet Swing Socket Javamail Perl Ajax P2P 安全 模式 框架 测试 开源 游戏
Windows XP Windows 2000 Windows 2003 Windows Me Windows 9.x Linux UNIX 注册表 操作系统 服务器 应用服务器
