简单的数据库操作：
<html>
<head>
<meta name="generator" content="microsoft visual studio 6.0">
<title></title>
<script language=javascript>
function connectdb()
{
var conndb = new activexobject("adodb.connection");
conndb.connectionstring="dsn=shbxdatabase;uid=ldbx;pwd=123456;";
conndb.open();
var rs = new activexobject("adodb.recordset");
var tempstr="";
rs.open("select * from wda1",conndb,1,3);
while(!rs.eof)
{
tempstr = tempstr + rs("tname") + "<br/>";
rs.movenext;
}
test.innerhtml=tempstr;
}
</script>
</head>
<body onbeforeunload="return 'ok?'">
<p><div id=test> </div>
<p><input id=button1 type=button value=显示 name=button1 onclick="connectdb()"></p>
</body>
</html>
>>>>>>-------------------------------------
var db="d:\\js\\9t\\db1.mdb";
function opendb(dbname,sql)
{
var opendb =new activexobject("adodb.recordset")
opendb.activeconnection = "dbq="+dbname+";driver={microsoft access driver (*.mdb)};"
opendb.source = sql
opendb.cursortype = 1
opendb.cursorlocation = 2
opendb.locktype = 3
opendb.open()
return opendb
}
var rs=new object();
rs=opendb(db,"select * from 产品 where id="+i);
document.all.xx1.innerhtml=rs("生产厂商").value;
document.all.xx2.innerhtml=rs("产品名称")+"/"+rs("型号");
document.all.xx3.innerhtml=rs("售价");
document.all.xx4.innerhtml=rs("批发");
document.all.xx5.innerhtml=rs("备注");
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---------------------------------------
连接access只能用数据源，操作数据库的方法跟asp之类是一样的。
只不过执行的语句不一样罢了。
如：
string dburl = "sun.jdbc.odbc.jdbcodbcdriver";
string dbconstr = "jdbc:odbc:dnsname";
connection conn = null;
statement stmt = null;
try{
class.forname(dburl);
}catch(classnotfoundexception e){
system.err.println("not found classforname" + e.getmessage());
}
try{
conn = drivermanager.getconnection(dbconstr, "uid", "pwd"); //连接数据库，uid与pwd分别为 用户名及密码（连接数据库的），如果没有既为空
stmt = conn.createstatement();
}catch(exception e){
system.err.println("can't connect the data" + e.getmessage());
}
//以下为操作数据库的
string sql = "select * from tablename[....]";
resultset rs = stmt.executequery(sql); // 返回记录集
string sqlupdate = "update...";
string sqlinsert = "insert into....";
stmt.executeupdate(sqlupdate); //更新记录
stmt.executeupdate(sqlinsert); //插入记录
conn.close();
stmt.close();
以上就是简单的数据库操作！
----------------------------------------->>>>>>>>>>>>>>>>>>>>>>>>>>
