javascript如何操作数据库？

我想要asp+javascript操作access的例子！

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

Access数据库.demo.htm<script>
/** 公用变量 **/
var db_name = "data.mdb"; // Access数据库名/**
*作者：徐祖宁(唠叨)
* 函数: connect
* 功能: 连接 Access 数据库
* 返回连接
* 要求数据库文件在本文档一起
*/
function connect() {
var dbc = new ActiveXObject("ADODB.Connection");
var dbcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"$1")+db_name;
dbc.Open(dbcon);
return dbc;
}function gen() {
var conn = connect();
var rs = conn.Execute("select * from baobao where id=1");
var s = rs("name").value;
rs.Close();
conn.Close();
document.open("text/html", "replace");
document.write(s);
document.close();
}
</script>
<body onLoad="gen()">
正在初始化系统，请稍候...
</body>
</html>
操作SQL SERVER   ASP+JavaScript<%@ language=JScript %>
<HTML>
<BODY>
<TITLE>ASP+JSCRIPT</TITLE>
<SCRIPT LANGUAGE="JSCRIPT" RUNAT="Server">
Response.write('<TABLE border="1" cellspacing="0" cellpadding="0">');
var sSQL = 'SELECT * FROM authors';
var oConn= new ActiveXObject("ADODB.Connection");
oConn.Open('Provider=SQLOLEDB;Server=(local);Database=pubs;UID=sa;PWD=;');
var rs = oConn.Execute(sSQL);
var i;
Response.write('<tr>');
for (i = 0; i < rs.Fields.Count - 1; i++)
{
Response.write('<td>' + rs(i).Name + '</td>');
}
Response.write('</tr>'); while (!rs.EOF)
{
  Response.write('<tr>');
  for (i = 0; i < rs.Fields.Count - 1; i++)
  {
    Response.write('<td>' + rs(i).Value + '</td>');
  }
  Response.write('</tr>');
  rs.MoveNext();
}
rs.Close();
oConn.Close();
rs=null;
oConn = null;
Response.write('</TABLE>');
</SCRIPT>
</BODY>
</HTML>
var dbcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"$1")+db_name;
这句后边什么意思？就是="+ location.href.replace(/file:[/]+([A-Z]:.*[/])([^/]+)/,"$1")+db_name；这句！
请问这个source的路径是绝对的还是相对的？？
不好用呀！哥们儿！
郁闷ing……！