:( jsp连接mysql数据库错误！
在JSP+Tomcat3.3.1+Mysql环境中，连接数据库时出错，急！！！
class设置:
classpath=.;%JAVA_HOME%\bin;%JAVA_HOME%\jre\bin;d:\tomcat3.3.1\lib;
jdbc文件位置：
d:\tomcat3.3.1\lib\mm.mysql-2.0.14-bin.jar
jsp代码：
...
java.lang.String strCon;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
sqlCon= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/cwt");
...
错误信息：
Error: 500
Location: /myweb/cwt/manager/techadd.jsp
Internal Servlet Error:
javax.servlet.ServletException: org.gjt.mm.mysql.Driver
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:460)
at cwt.manager.techadd_3._jspService(techadd_3.java:218)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:574)
at org.apache.tomcat.core.Handler.invoke(Handler.java:322)
at org.apache.tomcat.core.Handler.service(Handler.java:235)
at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:485)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:917)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:176)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:516)
at java.lang.Thread.run(Thread.java:536)
Root cause:
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at org.apache.tomcat.util.depend.DependClassLoader.loadClassInternal1(DependClassLoader.java:186)
at org.apache.tomcat.util.depend.DependClassLoader12$1.run(DependClassLoader12.java:92)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.tomcat.util.depend.DependClassLoader12.loadClass(DependClassLoader12.java:90)
at java.lang.ClassLoader.loadClass(ClassLoader.java:262)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:322)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:130)
at cwt.manager.techadd_3._jspService(techadd_3.java:77)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:574)
at org.apache.tomcat.core.Handler.invoke(Handler.java:322)
at org.apache.tomcat.core.Handler.service(Handler.java:235)
at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:485)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:917)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:176)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:516)
at java.lang.Thread.run(Thread.java:536)
问题点数：50、回复次数：4Top
1 楼flowercat（小强）回复于 2002-12-03 15:02:43 得分 10
Class.forName("org.gjt.mm.mysql.Driver");
Connection sqlCon= DriverManager.getConnection("jdbc:mysql://localhost:3306/cwt",username,passwd);
默认情况下Mysql的端口是3306.Top
2 楼www203（水户洋平）回复于 2002-12-04 11:33:06 得分 10
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
sqlCon== DriverManager.getConnection("jdbc:mysql://ip:://localhost:3306/cwt?user=你的用户名&password=你的密码&useUnicode=true&characterEncoding=gb2312");
Top
3 楼zxhong（红透半边天）回复于 2002-12-04 11:45:16 得分 10
http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=15371Top
4 楼shixiaoxiang（帅得惊动了党！）回复于 2002-12-04 22:44:54 得分 20
jsp连接MySQL数据库
testmysql.jsp如下：
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"
//testDB为你的数据库名
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功，恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
Top
