jdbc连接问题，很严重，试了很多方法

ZPH2254 2010-08-05 11:42:18

源码：
<%@ page language="java" contentType="text/html; charset=gbk"
pageEncoding="gbk"%>
<%@ page import="java.sql.*"%>
<%
Class.forName("com.mysql.jdbc.Driver");
String ur1 = "jdbc.mysql://localhost:3360/bbs?user=root&password=root";
Connection cnn = DriverManager.getConnection(ur1);
%>
<!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=gbk">
<title>Insert title here</title>
</head>
<body>

</body>
<%cnn.close();%>
</html>

错误：

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

4: <%
5: Class.forName("com.mysql.jdbc.Driver");
6: String ur1 = "jdbc.mysql://localhost:3360/bbs?user=root&password=root";
7: Connection cnn = DriverManager.getConnection(ur1);
8: %>
9: <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
10: <html>

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:517)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:409)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

root cause

javax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc.mysql://localhost:3360/bbs?user=root&password=root
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:898)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:827)
org.apache.jsp.ShowArticalFromEclipse_jsp._jspService(ShowArticalFromEclipse_jsp.java:79)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:73)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:378)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

root cause

java.sql.SQLException: No suitable driver found for jdbc.mysql://localhost:3360/bbs?user=root&password=root
java.sql.DriverManager.getConnection(DriverManager.java:602)
java.sql.DriverManager.getConnection(DriverManager.java:207)
org.apache.jsp.ShowArticalFromEclipse_jsp._jspService(ShowArticalFromEclipse_jsp.java:59)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:73)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:378)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

...全文

141 15 打赏收藏转发到动态举报

写回复

用AI写文章

15 条回复

切换为时间正序

请发表友善的回复…

发表回复

liujun822 2010-08-06

打赏
举报

小了mysql的jar包

king138888 2010-08-06

打赏
举报

同上。。。。。

「已注销」 2010-08-06

打赏
举报

<%
Class.forName("com.mysql.jdbc.Driver");
String ur1 = "jdbc:mysql://localhost:3306/bbs?user=root&password=root";
Connection cnn = DriverManager.getConnection(ur1);
%>
把jar包导入后，绿色部分请对号入座！

「已注销」 2010-08-06

打赏
举报

[Quote=引用 9 楼 closewbq 的回复:]
都看仔细点，端口号是3306不是3360！
[/Quote]
真仔细！~~~

ZPH2254 2010-08-06

打赏
举报

终于找出来了。
应该这样写：
<%
Class.forName("com.mysql.jdbc.Driver");
String ur1 = "jdbc:mysql://localhost:3306/bbs?user=root&password=root";
Connection cnn = DriverManager.getConnection(ur1);
%>
感谢各位

mstchen88 2010-08-06

打赏
举报

你都没有MySql的驱动jar包，位置也要放正确啊

学习Java中 2010-08-06

打赏
举报

String url= "jdbc:mysql://localhost:3306/DATABASE";
String user= "root ";
String password= "root";
Connection con=DriverManager.getConnection(url,user,password);
jar包别忘了