下载到mysql-connector-java-5.1.12-bin.jar后放在D盘,在环境变量里添加了classpath="D:\Program Files\Java\jdk1.6.0_19\lib",还是出现ClassNotFoundException异常,代码和异常如下:import java.sql.*;
import java.util.Vector; public class test
{
public static void main (String[] args)
{
Vector<String> results = new Vector<String>();
Connection con = null;
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","5647382910");
try{
Statement st = con.createStatement();
ResultSet rs = (ResultSet) st.executeQuery("SELECT * FROM staff");
while (rs.next()) {
String numb = rs.getString("name");
results.addElement(numb); }
st.close();
con.close();
}
catch (SQLException s){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
} 运行出现异常: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
import java.util.Vector; public class test
{
public static void main (String[] args)
{
Vector<String> results = new Vector<String>();
Connection con = null;
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","5647382910");
try{
Statement st = con.createStatement();
ResultSet rs = (ResultSet) st.executeQuery("SELECT * FROM staff");
while (rs.next()) {
String numb = rs.getString("name");
results.addElement(numb); }
st.close();
con.close();
}
catch (SQLException s){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
} 运行出现异常: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货