运行JSP网页后一直显示 No suitable driver found for jdbc:mysql://localhost:3306/lab5
一直找不到问题,求高手帮忙看看。我的JDK 是 1.6.0的
MYSQL 是 5.0.67的
JDBC驱动用的是:mysql-connector-java-5.0.4-bin.jarclasspath中已经设置了mysql-connector-java-5.0.4-bin.jar的路径,就放在java文件下的jdk1.6.0\lib里面,也尝试过把这个驱动直接放在WEB-INF/lib/下,可是一直没有效果。代码如下:<%@ page import="java.io.*,java.util.*,java.sql.*,javax.sql.*,javax.naming.*"%>
<%@ page contentType="text/html;charset=GB2312"%>
<jsp:useBean id="codechang" class="chang.character" scope="session" />
<html>
<head><title>DataSourse Connection Test</title></head>
<body>
<%
String JDriver = "com.mysql.jdbc.Driver";
String conURL="jdbc:mysql://localhost:3306/lab5";
try{
Class.forName(JDriver);
}catch(java.lang.ClassNotFoundException e) {
System.out.println("ForName :" + e.getMessage( ));
}
try{
Connection con=DriverManager.getConnection(conURL,"root","19870122");
out.print("JSP查询结果:");
out.println("<br><br>");
out.print("<table border>");
out.print("<tr>");
out.print("<th width=100>"+"num");
out.print("<th width=100>"+"name");
out.print("<th width=100>"+"score");
out.print("</tr>");
//执行数据库操作 Statement s=con.createStatement();
String query = "select * from stu";
ResultSet rs = s.executeQuery(query);
while (rs.next())
{
out.print("<tr>");
out.print("<td align=center>"+rs.getInt("num")+"</td>");
out.print("<td align=center>"+codechang.getstr(rs.getString("name"))+"</td>");
out.print("<td align=center>"+rs.getInt("score")+"</td>");
out.print("</tr>");
}
s.close( );
con.close( );}catch(Exception e){
out.print("no connection : "+e.getMessage());
}
%>
</body>
</html>
一直找不到问题,求高手帮忙看看。我的JDK 是 1.6.0的
MYSQL 是 5.0.67的
JDBC驱动用的是:mysql-connector-java-5.0.4-bin.jarclasspath中已经设置了mysql-connector-java-5.0.4-bin.jar的路径,就放在java文件下的jdk1.6.0\lib里面,也尝试过把这个驱动直接放在WEB-INF/lib/下,可是一直没有效果。代码如下:<%@ page import="java.io.*,java.util.*,java.sql.*,javax.sql.*,javax.naming.*"%>
<%@ page contentType="text/html;charset=GB2312"%>
<jsp:useBean id="codechang" class="chang.character" scope="session" />
<html>
<head><title>DataSourse Connection Test</title></head>
<body>
<%
String JDriver = "com.mysql.jdbc.Driver";
String conURL="jdbc:mysql://localhost:3306/lab5";
try{
Class.forName(JDriver);
}catch(java.lang.ClassNotFoundException e) {
System.out.println("ForName :" + e.getMessage( ));
}
try{
Connection con=DriverManager.getConnection(conURL,"root","19870122");
out.print("JSP查询结果:");
out.println("<br><br>");
out.print("<table border>");
out.print("<tr>");
out.print("<th width=100>"+"num");
out.print("<th width=100>"+"name");
out.print("<th width=100>"+"score");
out.print("</tr>");
//执行数据库操作 Statement s=con.createStatement();
String query = "select * from stu";
ResultSet rs = s.executeQuery(query);
while (rs.next())
{
out.print("<tr>");
out.print("<td align=center>"+rs.getInt("num")+"</td>");
out.print("<td align=center>"+codechang.getstr(rs.getString("name"))+"</td>");
out.print("<td align=center>"+rs.getInt("score")+"</td>");
out.print("</tr>");
}
s.close( );
con.close( );}catch(Exception e){
out.print("no connection : "+e.getMessage());
}
%>
</body>
</html>
一般这种就是jar位置不对,或者jar不适合。你试试别的mysql的jdbc驱动吧,
然后重启tomcat,这样所有的项目都能用了
或者你用IDE的时候,拷贝到web-inf下面的lib里面然后build path一下,这样
就能加载到这个jar了
这个jar里面就是一下通用的数据库接口,提供你怎么连接数据库的,就像是jdk的api一样