JS访问SQL Server数据库,代码如下:
测试js访问数据库var conn,rs;
function InitDB()
{
conn = null;
rs = null;
conn = new ActiveXObject("ADODB.Connection");
rs = new ActiveXObject("ADODB.Recordset");
connstr = "Driver={SQL Server}; Server=(local); Database=pubs; UID=sa; PWD=";
}
function testdb()
{
conn.Open(connstr);
sqlstr = "select * from authors";
if(sqlstr == "")
{
alert("SQL查询语句不能为空");
return;
}
rs.open(sqlstr,conn);
alert(rs.Fields("au_lname").Value);
rs.close();
conn.close();
}
This is my JSP page.
代码都很简单,不注释了