JavaScript ºÍJSP Á¬½ÓSqlServer Êý¾Ý¿â

µÚÒ»ÖÖ JavaScriptÁ¬½ÓÊý¾Ý¿â£º
<mce:script language="JavaScript"><!--
// ´´½¨Êý¾Ý¿â¶ÔÏó
var objdbConn = new ActiveXObject("ADODB.Connection");
// DSN×Ö·û´®
var strdsn = "Driver={SQL Server};SERVER=192.168.0.210;UID=xhb;PWD=xhb;DATABASE=books";
// ´ò¿ªÊý¾ÝÔ´
objdbConn.Open(strdsn);
// Ö´ÐÐSQLµÄÊý¾Ý¿â²éѯ
var objrs = objdbConn.Execute("SELECT * from book");
// »ñÈ¡×Ö¶ÎÊýÄ¿
var fdCount = objrs.Fields.Count - 1;
// ¼ì²éÊÇ·ñÓмǼ
if (!objrs.EOF){
document.write("<table border=1><tr>");
// ÏÔʾÊý¾Ý¿âµÄ×Ö¶ÎÃû³Æ
for (var i=0; i <= fdCount; i++)
document.write("<td><b>" + objrs.Fields(i).Name + "</b></td>");
document.write("</tr>");
// ÏÔʾÊý¾Ý¿âÄÚÈÝ
while (!objrs.EOF){
document.write("<tr>");
// ÏÔʾÿ±Ê¼Ç¼µÄ×Ö¶Î
for (i=0; i <= fdCount; i++)
document.write("<td valign='top'>" + objrs.Fields(i).Value + "</td>");
document.write("</tr>");
objrs.moveNext(); // ÒƵ½ÏÂÒ»±Ê¼Ç¼
}
document.write("</table>");
}
else
document.write("Êý¾Ý¿âÄÚûÓмǼ!<br>");
objrs.Close(); // ¹Ø±Õ¼Ç¼¼¯ºÏ
objdbConn.Close(); // ¹Ø±ÕÊý¾Ý¿âÁ´½Ó
// --></mce:script>
µÚ¶þÖÖ£ºJSP Á¬½ÓÊý¾Ý¿â
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//pubsΪÄãµÄÊý¾Ý¿âµÄ
String user="sa";
String password="";
Connection conn=
DriverManager.getConnection(url,user,password);
Statement
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
Resul