String url = "jdbc:mysql://localhost:3306/test";
Connection conn;
PrintWriter pw = response.getWriter();
Statement stmt;
try {
Class.forName("com.mysql.jdbc.Driver");
}catch(ClassNotFoundException e) {
pw.println("ClassNotFoundException");
pw.println(e.getMessage());
}
try {
conn = DriverManager.getConnection(url,"root","");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/test
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at servlet.ConnJDBC.doPost(ConnJDBC.java:40)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:864)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665)
at java.lang.Thread.run(Thread.java:662)
Connection conn;
PrintWriter pw = response.getWriter();
Statement stmt;
try {
Class.forName("com.mysql.jdbc.Driver");
}catch(ClassNotFoundException e) {
pw.println("ClassNotFoundException");
pw.println(e.getMessage());
}
try {
conn = DriverManager.getConnection(url,"root","");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/test
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at servlet.ConnJDBC.doPost(ConnJDBC.java:40)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:864)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665)
at java.lang.Thread.run(Thread.java:662)
解决方案 »
- 一个很郁闷的jsp乱码问题,请教!!!
- gxt 帮忙看一下 那个出错 数据库数据怎么拿不到grid中
- struts表单提交的文字在页面中不能正常显示(不是乱码)
- 很奇怪的问题
- 这是什么异常啊??????郁闷死了,过来帮忙看看!连接数据库的。。。。。
- 这个网站www.tianxiaj.com在南京能买多少钱?谢谢
- 要做到跨数据库,是复制分发?? 还是分布式查询??
- frame和frameset问题
- JSP是否能在多标签浏览器实现弹出窗口
- 如何下载zip文件
- tomcat 迁移websphere报错 sessionFactory不能加载 Context initialization failed
- 怎么远程登录LINUX系统上的TOMCAT服务器
import java.sql.ResultSet;public class Test {
public static void main(String[] args) {
String url = "jdbc:mysql://localhost:3306/test";
java.sql.Connection conn = null;
java.sql.Statement statement = null;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("ClassNotFound!");
System.out.println(e.getMessage());
}
try {
conn = DriverManager.getConnection(url, "root", "");
if(conn != null) {
System.out.println("connecte database!");
}
statement = conn.createStatement();
ResultSet rs = statement.executeQuery("select * from student");
while(rs.next()) {
String id = rs.getString(1);
String name = rs.getString("name");
String sex = rs.getString("sex");
int age = rs.getInt(4);
System.out.println(id+"-"+name+"-"+sex+"-"+age);
}
statement.close();
conn.close();
} catch (Exception e) {
// TODO: handle exception
}
}
}这段代码写在了一个java类中,用控制台输出得到正确的结果:
connecte database!
1-deity-f-21
2-yumo-m-23说明数据库驱动类和数据库连接都正常。但是写在servlet中,在jsp中调用就出错。说找不到驱动类。我把驱动类放在了tomcat的lib里,也放在了webapps的我的网站的lib里面一份。在myeclipse的项目中也导入了一份
驱动包你放一个地方就行了,不要到处乱放,放多份反而容易出现jar包冲突的问题。
conn = DriverManager.getConnection(url, "root", "");出错是这一句。
我之前遇到过这个问题,是url、username或密码不对
另外反射是不需要导包的哦