<%@ Language=JavaScript codepage=936 %> <% //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; " +"Password=password; Initial Catalog=meizz"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="select user_kind from tbRightSet where user_id='"+ Account +"'"; rs.open(sql, conn); if (!rs.EOF) { sysUserKind = (rs("user_kind")+"").replace(/^\s+|\s+$/, ""); } rs.close(); rs = null; conn.close(); conn = null; %>
var oConn = new ActiveXObject("ADODB.Connection"); var sConnStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=your.mdb"; oConn.Open(sConnStr); var oRs = new ActiveXObject("ADODB.Recordset"); oRs.Open("select * from yourTable",oConn,1,1); data = new Array(); var i=0; while(!oRs.EOF){ var row = new Array(); for(var j=0;j<oRs.Fields.Count;j++){ row[j]=oRs(j).Value; } data[i]=row;//把字段值读到数组里. i++; oRs.MoveNext(); } oRs.Close(); oRs = null;
<%
//用 JavaScript 写服务器端连接数据库的代码示例
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; "
+"Password=password; Initial Catalog=meizz"); var rs = new ActiveXObject("ADODB.Recordset");
var sql="select user_kind from tbRightSet where user_id='"+ Account +"'"; rs.open(sql, conn);
if (!rs.EOF)
{
sysUserKind = (rs("user_kind")+"").replace(/^\s+|\s+$/, "");
}
rs.close(); rs = null; conn.close(); conn = null;
%>
var sConnStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=your.mdb";
oConn.Open(sConnStr); var oRs = new ActiveXObject("ADODB.Recordset");
oRs.Open("select * from yourTable",oConn,1,1);
data = new Array();
var i=0;
while(!oRs.EOF){
var row = new Array();
for(var j=0;j<oRs.Fields.Count;j++){
row[j]=oRs(j).Value;
}
data[i]=row;//把字段值读到数组里.
i++;
oRs.MoveNext();
}
oRs.Close();
oRs = null;