我这里没有装ACCESS
就随便从系统里找了一个数据库你看着改改吧 都差不多的
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<script language="javascript">
window.onerror = function(a,b,c) {
alert(a+b+c);
return true;
} function dnary(id,name) {
this.id = id;
this.name = name;
} dnary.prototype.toString = function() {
return this.id+":"+this.name;
} var arr = new Array(); var conn = new ActiveXObject("adodb.connection");
var url = "provider =Microsoft.jet.oledb.4.0; data source=d:\\dnary.mdb";
conn.connectionstring = url;
conn.open(); var rs = new ActiveXObject("adodb.recordset");
rs.open("select * from syntaxes",conn,3);
while (!rs.eof)
{
var dn = new dnary(rs(0).value,rs(1).value);
arr.push(dn);
rs.movenext();
} rs.close();
rs = null;
conn.close();
conn = null; alert(arr);
</script>
</HEAD> <BODY>
</BODY>
</HTML>
就随便从系统里找了一个数据库你看着改改吧 都差不多的
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<script language="javascript">
window.onerror = function(a,b,c) {
alert(a+b+c);
return true;
} function dnary(id,name) {
this.id = id;
this.name = name;
} dnary.prototype.toString = function() {
return this.id+":"+this.name;
} var arr = new Array(); var conn = new ActiveXObject("adodb.connection");
var url = "provider =Microsoft.jet.oledb.4.0; data source=d:\\dnary.mdb";
conn.connectionstring = url;
conn.open(); var rs = new ActiveXObject("adodb.recordset");
rs.open("select * from syntaxes",conn,3);
while (!rs.eof)
{
var dn = new dnary(rs(0).value,rs(1).value);
arr.push(dn);
rs.movenext();
} rs.close();
rs = null;
conn.close();
conn = null; alert(arr);
</script>
</HEAD> <BODY>
</BODY>
</HTML>
<script language="javascript">
function dnary(fhrbm.fhrxm.fhrdh.fhrdz) {
this.fhrbm = fhrbm;
this.fhrxm = frhxm;
this.fhrdh = fhrdh;
this.fhrdz = fhrdz;
} var arr = new Array(); var conn = new ActiveXObject("adodb.connection");
var url = "provider =Microsoft.jet.oledb.4.0; data source=db1.mdb";
conn.connectionstring = url;
conn.open(); var rs = new ActiveXObject("adodb.recordset");
rs.open("select fhrxm,fhrdh,fhrdz from u_ser",conn,3);
while (!rs.eof)
{
var dn = new dnary(rs(0).value,rs(1).value,rs(2).value);
arr.push(dn);
rs.movenext();
} rs.close();
rs = null;
conn.close();
conn = null; alert(arr);
</script>
<INPUT TYPE="text" NAME="fhrbm" onblur="getName();" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<INPUT NAME="fhrxm" TYPE="text" id="fhrxm" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<INPUT TYPE="text" NAME="fhrdh" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<input type="text" name="fhrdz" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
可是你在new 的时候
var dn = new dnary(rs(0).value,rs(1).value,rs(2).value);
只传了三个参数啊
var dn = new dnary(rs(0).value,rs(1).value,rs(2).value,rs(3).value);
索引是从0开始的。
rs.open("select fhrxm,fhrdh,fhrdz from u_ser",conn,3); 改成
rs.open("select fhrbm,fhrxm,fhrdh,fhrdz from u_ser",conn,3);
function dnary(fhrbm.fhrxm.fhrdh.fhrdz) {
this.fhrbm = fhrbm;
this.fhrxm = frhxm;
this.fhrdh = fhrdh;
this.fhrdz = fhrdz;
} var arr = new Array(); var conn = new ActiveXObject("adodb.connection");
var url = "provider =Microsoft.jet.oledb.4.0; data source=db1.mdb";
conn.connectionstring = url;
conn.open(); var rs = new ActiveXObject("adodb.recordset");
rs.open("select fhrbm,fhrxm,fhrdh,fhrdz from u_ser",conn,3);
while (!rs.eof)
{
var dn = new dnary(rs(0).value,rs(1).value,rs(2).value,rs(3).value);
arr.push(dn);
rs.movenext();
} rs.close();
rs = null;
conn.close();
conn = null; alert(arr);
</script>
<INPUT TYPE="text" NAME="fhrbm" onblur="getName();" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<INPUT NAME="fhrxm" TYPE="text" id="fhrxm" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<INPUT TYPE="text" NAME="fhrdh" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<input type="text" name="fhrdz" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9"> no no no 还是不行 取不到数据
有的话不可能不行吧?
你到数据库里把你的SQL语句select fhrbm,fhrxm,fhrdh,fhrdz from u_ser执行一下看看能不能查到数据?
你说不行是查不出数据还是报错啊?
你到数据库里把你的SQL语句select fhrbm,fhrxm,fhrdh,fhrdz from u_ser执行一下看看能不能查到数据?
如果 把你代码 全部复制过来 会出现如下错误此计算机上的安全设置禁止访问其他域的数据源 http://127.0.0.1/ajax/demo3.htm25如果改成
<script language="javascript">
function dnary(fhrbm.fhrxm.fhrdh.fhrdz) {
this.fhrbm = fhrbm;
this.fhrxm = frhxm;
this.fhrdh = fhrdh;
this.fhrdz = fhrdz;
} var arr = new Array(); var conn = new ActiveXObject("adodb.connection");
var url = "provider =Microsoft.jet.oledb.4.0; data source=db1.mdb";
conn.connectionstring = url;
conn.open(); var rs = new ActiveXObject("adodb.recordset");
rs.open("select fhrxm,fhrdh,fhrdz from u_ser",conn,3);
while (!rs.eof)
{
var dn = new dnary(rs(0).value,rs(1).value,rs(2).value);
arr.push(dn);
rs.movenext();
} rs.close();
rs = null;
conn.close();
conn = null; alert(arr);
</script>
<INPUT TYPE="text" NAME="fhrbm" onblur="getName();" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<INPUT NAME="fhrxm" TYPE="text" id="fhrxm" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<INPUT TYPE="text" NAME="fhrdh" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<input type="text" name="fhrdz" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9"> 取不到数据
如果改成
<script language="javascript">
function dnary(fhrbm.fhrxm.fhrdh.fhrdz) {
this.fhrbm = fhrbm;
this.fhrxm = frhxm;
this.fhrdh = fhrdh;
this.fhrdz = fhrdz;
} var arr = new Array(); var conn = new ActiveXObject("adodb.connection");
var url = "provider =Microsoft.jet.oledb.4.0; data source=db1.mdb";
conn.connectionstring = url;
conn.open(); var rs = new ActiveXObject("adodb.recordset");
rs.open("select fhrxm,fhrdh,fhrdz from u_ser",conn,3);
while (!rs.eof)
{
var dn = new dnary(rs(0).value,rs(1).value,rs(2).value);
arr.push(dn);
rs.movenext();
} rs.close();
rs = null;
conn.close();
conn = null; alert(arr);
</script>
<INPUT TYPE="text" NAME="fhrbm" onblur="getName();" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<INPUT NAME="fhrxm" TYPE="text" id="fhrxm" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<INPUT TYPE="text" NAME="fhrdh" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9">
<input type="text" name="fhrdz" onkeydown="javascript:if(event.keyCode==13)event.keyCode=9"> 就取不到数据
ASP还可以直接用scripting.filesystemobject写文件呢而不管权限呢
你在JAVASCRIPT里用scripting.filesystemobject直接写文件试试?
如果设置权限了根本写不了