主题：jsp连接MYSQL出错
magicfying
[专家分：10] 发布于 2006-04-09 02:24:00
源代码如下:(在用ACCESS数据库时是成功的,改MYSQL就出错啦)
<html>
<title>添加信息</title>
<body>
<%@page contentType="text/html;charset=GB2312" import="java.sql.*"%>
<%
Class.forName("org.gjt.mm.mysql.Driver");//student数据库
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306:student","","");//不知道这句错了没有
Statement smt=con.createStatement();
String sql=null;
sql="insert into login(user_name,user_id,password)values('magic','4004','111111')";
smt.executeUpdate(sql);
con.close();
%>
</body>
</html>
沙发
magicfying [专家分：10] 发布于 2006-04-09 02:21:00
出错提示:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: org.gjt.mm.Driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.acceptInsertUserTable_jsp._jspService(acceptInsertUserTable_jsp.java:142)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.ClassNotFoundException: org.gjt.mm.Driver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1340)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:150)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:71)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:164)
org.apache.jsp.acceptInsertUserTable_jsp._jspService(acceptInsertUserTable_jsp.java:107)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
[em10][em10]
您所在位置：