2016中超积分:jsp连接sql server2000的问题

来源:百度文库 编辑:高校问答 时间:2024/04/29 10:15:28
JAVA_HOME=D:\JDK1.5

TOMCAT_HOME=D:\tomcat5.5

path=%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;D:\jdk1.5;.;D:\Jdk1.5\bin

classpath=D:\Jdk1.5\bin;.;D:\Jdk1.5\lib;D:\Jdk1.5\lib\dt.jar;D:\Jdk1.5\lib\tools.jar;D:\Tomcat5.5\common\lib\servlet.jar;

代码如下:
<%@ 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=testdatabse";
//pubs为你的数据库的
String user="sa";
String password="123";

Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from userTable";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();

%>
----------------------------------
错误显示:
HTTP Status 500 -
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 6 in the jsp file: /1.jsp
Generated servlet error:
Syntax error on tokens, delete these tokens

--------------------------------

请问这是什么问题
环境:
jdk1.5
Apache Tomcat 5.5
sql server 2000开发版
jdbc for sql server
windows 2000 pro

要连结就要先下SQL的补丁(SP4)
我没下的时候就是连不上
安了就行了