请教jsp连接sql server2000的问题

hengshan 2005-04-20 09:54:08

我用下面的代码连接数据库，出现问题，可是我又不知道怎么办，请教高手帮忙啊

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<html>
<body>
<% Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" );
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=SPJ";
//pubs为数据库的名字
String user="chzx";
String password="280978693";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from SPJ";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
你的第一个字段内容为：<%=rs.getString(1) %>
你的第二个字段内容为：<%=rs.getString(2) %>
<%}%>
<% out.print("数据库操作成功，恭喜你"); %>
<% rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
错误信息：

type Exception report

message

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

exception

javax.servlet.ServletException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.testsqlserver_jsp._jspService(testsqlserver_jsp.java:87)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

root cause

java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1383)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1230)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:184)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:110)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:141)
org.apache.jsp.testsqlserver_jsp._jspService(testsqlserver_jsp.java:47)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

note The full stack trace of the root cause is available in the Tomcat logs.

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

Apache Tomcat/5.0.19

...全文

161 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

cpl3113 2005-04-26

打赏
举报

哥们，好歹你把驱动引进来呀
<%@ page import="com.microsoft.jdbc.sqlserver.SQLServerDriver" %>

halfsea 2005-04-26

打赏
举报

都知道了，没有的说了。

J2EEJ2ME 2005-04-26

打赏
举报

要是用tomcat就把3个jar文件放在common/lib里面
要是用Jbuilder直接放在lib里面

discolt 2005-04-25

打赏
举报

楼上正解

silverend 2005-04-25

打赏
举报

java.lang.ClassNotFoundException:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" );//未成功注册驱动器

在CLASSPATH配置3个驱动程序，并把其JAR包导入*/WEB-INF/lib中

flymoon 2005-04-25