javascript读sqlserver数据库信息
Code<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>测试js访问数据库</title>
</head>
<script language="javascript">
var conn,rs;
function InitDB()
{
conn = null;
rs = null;
conn = new ActiveXObject("ADODB.Connection");
rs = new ActiveXObject("ADODB.Recordset");
connstr = "Driver={SQL Server}; Server=192.168.106.38; Database=dbcopy; UID=sa; PWD=19791225";
}
function testdb()
{
conn.Open(connstr);
sqlstr = "select * from Users";
if(sqlstr == "")
{
alert("SQL查询语句不能为空");
return;
}
rs.open(sqlstr,conn);
alert(rs.Fields("username").Value);
rs.close();
conn.close();
}
</script>
<body onLoad="InitDB()">
This is my page. <br>
<input type="button" value="submit" onClick="testdb()">
</body>
</html>
浙公网安备 33010602011771号