今天终于用JSP连接上SQL Server了,不过代码还没研究明白,代码先贴出来,有时间再慢慢消化:
<%
@ page import
=
"
java.lang.*, java.io.*, java.sql.*, java.util.*
"
contentType
=
"
text/html;charset=gb2312
"
%>
< html >
< body >
<%
Class.forName( " com.microsoft.jdbc.sqlserver.SQLServerDriver " ).newInstance();
Connection conn = DriverManager.getConnection( " jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs " , " sa " , " " );
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = " select job_id,job_desc from jobs " ;
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
%>
您的第一个字段内容为:<%=rs.getString(1)%><br>
您的第二个字段内容为:<%=rs.getString(2)%><br>
<% } %>
<% out .print( " 数据库操作成功,恭喜你 " ); %>
<%
rs.close();
stmt.close();
conn.close();
%>
</ body >
</ html >
< html >
< body >
<%
Class.forName( " com.microsoft.jdbc.sqlserver.SQLServerDriver " ).newInstance();
Connection conn = DriverManager.getConnection( " jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs " , " sa " , " " );
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = " select job_id,job_desc from jobs " ;
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
%>
您的第一个字段内容为:<%=rs.getString(1)%><br>
您的第二个字段内容为:<%=rs.getString(2)%><br>
<% } %>
<% out .print( " 数据库操作成功,恭喜你 " ); %>
<%
rs.close();
stmt.close();
conn.close();
%>
</ body >
</ html >
需要先下载JDBC For SqlServer 2000,下载地址:http://www.microsoft.com/downloads/details.aspx?FamilyID=07287b11-0502-461a-b138-2aa54bfdc03a&DisplayLang=en
默认是安装在C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC目录下,把lib目录下的三个包复制到项目的WEB-INF/lib文件夹下,重启服务器,运行代码,应该就可以看到效果了:)