连接的代码如下,请教如何把rs(0)这一列的内容用document.write()的方法输出? <script language=javascript> var conn=new ActiveXObject("adodb.connection"); conn.open("provider=Microsoft.Jet.OLEDB.4.0; Data Source=conn.mdb"); var rs=new ActiveXObject("adodb.recordset"); rs.open("select * from student",conn,1,1); document.write(rs(0)+"<br>"); rs.close(); rs=null; conn.close(); conn=null; </script>
连接的代码如下,rs(0)是自动编写的id号,第一行第一个是1,第二行第一个是2,第三行第一个是3,以此类推。请教如何把rs(0)这一列的内容用document.write()的方法输出? <script language=javascript> var conn=new ActiveXObject("adodb.connection"); conn.open("provider=Microsoft.Jet.OLEDB.4.0; Data Source=conn.mdb"); var rs=new ActiveXObject("adodb.recordset"); rs.open("select * from student",conn,1,1); document.write(rs(0)+"<br>"); rs.close(); rs=null; conn.close(); conn=null; </script>
这个很难吗?var con=new ActiveXObject ("ADODB.Connection"); con.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; Password=sa; Initial Catalog=bank" ); var rs = new ActiveXObject("ADODB.Recordset"); var sql="select * from dept";//部门表,有主键did,名称dname等字段 rs.open(sql,con); var mas=document.getElementById("mas");//下拉框,id是mas while(!rs.EOF){ var opt=new Option(rs("dname"),rs("did"));//显示的名称,value的值 mas.options.add(opt); rs.moveNext(); } rs.close(); con.close();
$.ajax( {
type : "post",
url : url,
data : data,
dataType : "json",
async : false,
success : function(res) {
alert(res.errormsg);
for(var i=0;i<res.data.length;i++){
$("#select").append("<option>"+res.data[i].name+"</option>")
}
});
要做hta程序,不能搞后台那套啊,纯粹的javascript真的没办法?
因为是hta的单机程序,不搞在线
连接的代码如下,请教如何把rs(0)这一列的内容用document.write()的方法输出?
<script language=javascript>
var conn=new ActiveXObject("adodb.connection");
conn.open("provider=Microsoft.Jet.OLEDB.4.0; Data Source=conn.mdb");
var rs=new ActiveXObject("adodb.recordset");
rs.open("select * from student",conn,1,1);
document.write(rs(0)+"<br>");
rs.close();
rs=null;
conn.close();
conn=null;
</script>
<script language=javascript>
var conn=new ActiveXObject("adodb.connection");
conn.open("provider=Microsoft.Jet.OLEDB.4.0; Data Source=conn.mdb");
var rs=new ActiveXObject("adodb.recordset");
rs.open("select * from student",conn,1,1);
document.write(rs(0)+"<br>");
rs.close();
rs=null;
conn.close();
conn=null;
</script>
con.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; Password=sa; Initial Catalog=bank" );
var rs = new ActiveXObject("ADODB.Recordset");
var sql="select * from dept";//部门表,有主键did,名称dname等字段
rs.open(sql,con);
var mas=document.getElementById("mas");//下拉框,id是mas
while(!rs.EOF){
var opt=new Option(rs("dname"),rs("did"));//显示的名称,value的值
mas.options.add(opt);
rs.moveNext();
}
rs.close();
con.close();