mysql forname_MYsql数据库 jdbc class.forname

连接不上mysql数据库老报错误Class.forName("com.mysql.jdbc.driver").newInstance();这句话无法初始类，驱动包我有考到lib下了publicclassDbconn{privatejava.sql.Connectionconn;pr...

连接不上mysql数据库 老报错误Class.forName("com.mysql.jdbc.driver").newInstance();这句话无法初始类，驱动包我有考到lib下了

public class Dbconn {

private java.sql.Connection conn;

private PreparedStatement pstmt;

private ResultSet rs;

public void init() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException{

Class.forName("com.mysql.jdbc.driver").newInstance();

String url="jdbc:mysql://localhost/school";

conn= DriverManager.getConnection(url,"root","759486");

}

public Dbconn() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException{

init();

pstmt=conn.prepareStatement(null);

}

public int excuteUpdate(String s) throws SQLException {

int status=0;

if (pstmt!=null) {

status=pstmt.executeUpdate(s);

}

return status;

}

public void excutQuery(String s) throws SQLException

{

rs=pstmt.executeQuery(s);

}

试了 大小写都一样的

报错

Stacktraces

java.lang.ClassNotFoundException: com.mysql.jdbc.driver

org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1647)

org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1493)

java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)

java.lang.Class.forName0(Native Method)

java.lang.Class.forName(Class.java:169)

DB.Dbconn.init(Dbconn.java:16)

DB.Dbconn.(Dbconn.java:21)

factory.Sqlfactory.getDbconn(Sqlfactory.java:14)

action.LoginAction.findUser(LoginAction.java:66)

action.LoginAction.chkUser(LoginAction.java:79)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke 谁有MYSQL5.1的驱动包我换个试试

导入了连接包是不是要设置classpath里的变量？

展开