jsp通过odbc如何访问SQL server 2000数据库

lipingzhy 2008-01-07 08:48:52

环境
JAVA环境:JDK;
服务器:tomcat;
数据库是:SQL server 2000;

安装路径
jdk安装在:F:\Java\jdk1.5.0_11
jre安装在:F:\Java\jre1.5.0_11
tomcat安装在:C:\Program Files\Apache Software Foundation\Tomcat 6.0
数据库安装在:C:\Program Files\Microsoft SQL Server
jdbc安装在:C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC

环境变量:
classpath:
F:\Java\jdk1.5.0_11\lib\dt.jar;F:\Java\jdk1.5.0_11\lib\tools.jar;,;C:\Program Files\Apache Software Foundation\Tomcat 6.0\common\lib\servlet.jar

Path:F:\Java\jdk1.5.0_11\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32
\Wbem;.;C:\Program Files\Microsoft SQL Server\80\Tools\BINN

TOMCAT_HOME:
C:\Program Files\Apache Software Foundation\Tomcat 6.0

JAVA_HOME:
F:\Java\jdk1.5.0_11

我的数据源名是sstudent user="sa" password="123"

我的程序：
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.net.*"%>
<html>
<body>
<%
try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1){}
try{
Connection con=DriverManager.getConnection("jdbc:odbc:sstudent","sa","123");
Statement state = con.createStatement();
String sql = "select * from ss ";
ResultSet Rs = state.executeQuery(sql);
out.print("<h1><font color=red>"+"学生基本情况表"+"</h1>");
out.print("<font>");
out.print("<table border=2>");
out.print("<tr>");
out.print("<th width=150>"+"学号");
out.print("<th width=150>"+"姓名");
out.print("<th width=150>"+"班级");
out.print("<th width=150>"+"学院");
out.print("<th width=150>"+"性别");
out.print("</tr>");
while (Rs.next())
{
out.print("<tr>");
out.print("<td>"+Rs.getInt(1)+"</td>");
out.print("<td>"+Rs.getString(2)+"</td>");
out.print("<td>"+Rs.getString(3)+"</td>");
out.print("<td>"+Rs.getString(4)+"</td>");
out.print("<td>"+Rs.getString(5)+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
}
catch(SQLExecption ee){}
%>
<br>
</body>
</html>

在Tomcat下运行出现如下错误：

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

An error occurred at line: 7 in the jsp file: /test2.jsp
Generated servlet error:
SQLExecption cannot be resolved to a type

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:565)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:354)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

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

An error occurred at line: 7 in the jsp file: /test2.jsp
Generated servlet error:
SQLExecption cannot be resolved to a type

org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:329)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:314)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

请高手帮我指出问题。我那里出问题了，

...全文