importjava.sql.*;publicclassJDBCText{publicstaticvoidmain(String[]args){Stringdriver="com.MySQL.jdbc.Driver";Stringurl="jdbc:MySQL://127.0.0.1:3306/scutcs";Stringuser="ro...
import java.sql.*;
public class JDBCText
{
public static void main(String[] args)
{
String driver="com.MySQL.jdbc.Driver";
String url="jdbc:MySQL://127.0.0.1:3306/scutcs";
String user = "root";
String password = "123456";
try
{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
Statement statement = conn.createStatement();
String sql = "select * from select_text";
ResultSet rs = statement.executeQuery(sql);
System.out.println("-----------------");
System.out.println("执行结果如下所示:");
System.out.println("-----------------");
System.out.println(" 学号" + "\t" + " 姓名");
System.out.println("-----------------");
String name = null;
while(rs.next()) {
name = rs.getString("sname");
System.out.println(rs.getString("sno") + "\t" + name);
}
rs.close();
conn.close();
}
catch(ClassNotFoundException e) {
System.out.println("Sorry,can`t find the Driver!");
e.printStackTrace();
}
catch(SQLException e) {
e.printStackTrace();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
报错内容提示找不到java.lang.ClassNotFoundException: com.MySQL.jdbc.Driver
我把mysql-connector-java-5.1.7-bin.jar放在C:\Program Files (x86)\Java\jdk1.7.0_21\jre\lib\ext用的编译软件是EditPlus,在CLASSPATH中也吧上面的路径复制上去了,还是不行,该怎么办才能解决
展开