新学jsp连接mysql,按照教程把mysql-connector-java-5.0.4-bin.jar拷贝到了tomcat的lib目录下,也拷贝到了web-inf/lib下面,可是每次执行都报“java.sql.SQLException: No suitable driver found for jdbc.mysql..."错误。具体代码如下:
<%@ page language="java" import="java.sql.*,javax.sql.*" pageEncoding="UTF-8"%>
<%@ page import="com.mysql.jdbc.Driver" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<%
try{
//载入Mysql驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url="";
Connection conn=DriverManager.getConnection("jdbc.mysql://localhost:3306","root","");
Statement state=conn.createStatement();
int result=state.executeUpdate("insert into User(Uname,Upass) values('"+ request.getParameter("uname"
) + "','" + request.getParameter("upass") + "')");
if(result == 1){
out.println("用户注册成功!");
}else{
out.println("用户注册失败!");
}
}catch (SQLException e){
out.println(e);
}
%>
</body>
</html>求问如何解决此问题。
<%@ page language="java" import="java.sql.*,javax.sql.*" pageEncoding="UTF-8"%>
<%@ page import="com.mysql.jdbc.Driver" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<%
try{
//载入Mysql驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url="";
Connection conn=DriverManager.getConnection("jdbc.mysql://localhost:3306","root","");
Statement state=conn.createStatement();
int result=state.executeUpdate("insert into User(Uname,Upass) values('"+ request.getParameter("uname"
) + "','" + request.getParameter("upass") + "')");
if(result == 1){
out.println("用户注册成功!");
}else{
out.println("用户注册失败!");
}
}catch (SQLException e){
out.println(e);
}
%>
</body>
</html>求问如何解决此问题。
jdbc.mysql://localhost:3306/数据库名
是啊。这个有可能。我忽然发现应该找个mysql5.6的jar
不过我这个jar也是从MySQL Tools for 5.0里面找出来的
昨晚发现了,是不细心导致的,把点写成了冒号。应该是jdbc.mysql而不是jdbc:mysql