我下载了mysql-connector-java-5.1.7-bin.jar驱动,可是还是连接不上!package com.feiyu;
import java.io.*;import java.sql.*;public class jdbcDemo01 {
private static Connection conn =null;
private static Statement stmt =null;
private static ResultSet rs =null;
public static void main(String[] args) {
try {
Class.forName("com.MySQL.jdbc.Driver");
String url ="jdbc:mysql://127.0.0.1:3306/admin";
String use ="root";
String pwd ="430300";
Connection conn =DriverManager.getConnection(url,use,pwd);
Statement stmt =conn.createStatement();
String sql ="select * from users";
ResultSet rs =stmt.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getInt(2));
System.out.println(rs.getString(1));
// System.out.println(rs.getString(3));
// System.out.println(rs.getString(4));
}
} catch (ClassNotFoundException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
finally{
try {
if(rs!=null){
rs.close();
rs =null;
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
try {
if(stmt!=null){
stmt.close();
stmt =null;
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
try {
if(conn!=null){
conn.close();
conn =null;
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
}
显示错误!--------------------Configuration: <Default>--------------------
java.lang.ClassNotFoundException: com.MySQL.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at com.feiyu.jdbcDemo01.main(jdbcDemo01.java:23)
import java.io.*;import java.sql.*;public class jdbcDemo01 {
private static Connection conn =null;
private static Statement stmt =null;
private static ResultSet rs =null;
public static void main(String[] args) {
try {
Class.forName("com.MySQL.jdbc.Driver");
String url ="jdbc:mysql://127.0.0.1:3306/admin";
String use ="root";
String pwd ="430300";
Connection conn =DriverManager.getConnection(url,use,pwd);
Statement stmt =conn.createStatement();
String sql ="select * from users";
ResultSet rs =stmt.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getInt(2));
System.out.println(rs.getString(1));
// System.out.println(rs.getString(3));
// System.out.println(rs.getString(4));
}
} catch (ClassNotFoundException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
finally{
try {
if(rs!=null){
rs.close();
rs =null;
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
try {
if(stmt!=null){
stmt.close();
stmt =null;
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
try {
if(conn!=null){
conn.close();
conn =null;
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
}
显示错误!--------------------Configuration: <Default>--------------------
java.lang.ClassNotFoundException: com.MySQL.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at com.feiyu.jdbcDemo01.main(jdbcDemo01.java:23)
。。这个,大小写com.mysql.jdbc.Driver