jsp连接数据库老是出错，请高手指点~~~~

无民 · 发表于 2009-9-15 01:55:43

我是新手，刚写了页面测试，用的是eclipse+lomboz+tomcat+mysql，结果老是报错，也添加了mysql-connector-java-5.1.6-bin.jar，也设置了系统变量，还是没用，有谁帮帮忙啊~~~错误信息如下：
type Exception report

message

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

exception

org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.driver
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.shiyan_jsp._jspService(shiyan_jsp.java:123)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

java.lang.ClassNotFoundException: com.mysql.jdbc.driver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:128)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:66)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:169)
org.apache.jsp.shiyan_jsp._jspService(shiyan_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

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

程序如下：<%@ page language="java" contentType="text/html; charset=gb2312" import="java.sql.*" errorPage=""
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<%
String product_name="";
Float price;
String description="";
Connection con=null;
Statement sm=null;
ResultSet rs=null;

Class.forName("com.mysql.jdbc.driver").newInstance();
String url="jdbc:mysql://localhost/mydb";
con=DriverManager.getConnection(url,"root","74515965");
sm=con.createStatement();
rs=sm.executeQuery("select * from product");

%>
<body>
<table width="80%" align="center">
<tr>
<td class="title"> 用户注册登录系统==<span class="title1">产品展示</span>==</td>

</tr>
</table>
<hr align="center" width="75%" color="#990000" size="1"/>
<table width="80%" align="center">
<tr><td height="5" colspan="2"></td></tr>
<%
while(rs.next()){
product_name=rs.getString("PRODUCT_NAME");
price=rs.getFloat("PRICE");
description=rs.getString("DESCRIPTION");
%>
<tr>
<td> 产品名称:<%=product_name%></td><td width="40%"> 报价:<span style="color:#FF0000; font-style:italic;"><%=price%></span></td>
</tr>
<tr>
<td colspan="2"> 描述：<%=description%></td>
</tr>
<tr><td height="5" colspan="2"><hr size="3" width="10%"/></td></tr>
<%
}

%>
</table>
<div align="center" class="tail" >2006==本公司版权所有</div>
</body>
</html>

融化冰河 · 发表于 2010-3-12 21:05:05

如果一定要用500以上的字来解释“晦涩”这个词，那么LZ是做到了的。

		自动登录	找回密码
密码			注册