只用html+javascript能连接数据库sqlserver吗答案是不能 除非又一个动态的程序如asp asp.net php 等 做为Proxy来读取sqlserver
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;
做为Proxy来读取sqlserver
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;