注册 登录
编程论坛 J2EE论坛

求解决,jsp连接数据库报错

yh612510 发布于 2015-05-07 14:00, 2670 次点击
HTTP Status 500 - An exception occurred processing JSP page /index.jsp at line 63

type Exception report

message An exception occurred processing JSP page /index.jsp at line 63

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

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 63

60:          String password = "sa";  
61:          String url="jdbc:sqlserver://localhost:1433;DatabaseName="+dateBaseName;
62:         
63:          Connection conn=DriverManager.getConnection(url,username,password);   
64:         
65:          System.out.println("鏁版嵁搴撹繛鎺�锛�);  
66:     


Stacktrace:
    org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:567)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:454)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause

javax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;DatabaseName=School
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:908)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:837)
    org.apache.jsp.index_jsp._jspService(index_jsp.java:176)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:431)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

[ 本帖最后由 yh612510 于 2015-5-7 14:02 编辑 ]
2 回复
#2
qwe8851677592015-06-05 15:20
检查一下你的加载SQL驱动的语语句正确不,然后看一下连接SQL
的jar包有没有放到相应的位置,如果还不行,你看下是不是jar包的版本不对,下载一个正确的版本。
#3
yzeniu2015-07-22 15:53
回复 楼主 yh612510
报错500的问题解决没,我也碰到了同样的问题,我们互相交流
1