JS访问SQL Server数据库，代码如下：
<!--jsSql.jsp-->
<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<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=(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();
}
</script>
<body onLoad="InitDB()">
This is my JSP page. <br>
<input type="button" value="submit" onClick="testdb()">
</body>
</html>
代码都很简单，不注释了
发表于 @ 2007年05月17日 15:22:00|评论(loading...)|编辑