Question

j关于java 连接SQL数据库问题

请问数据库为什么会连接失败加载成功的驱动程序的名字是 ：class sun.jdbc.odbc.JdbcOdbcDriver数据库连接失败java.sql.SQLException: No suitable driver found for jdbc:mysql:my1 at java.sql.DriverManager.getConnection(DriverManager.java:602) at java.sql.DriverManager.getConnection(DriverManager.java:207) at dbconnection.main(dbconnection.java:14)

Answer 1

驱动类加载错了
public class DBUtil {

private static final String URL = "jdbc:mysql://192.168.0.50:3306/webspider?characterEncoding=utf-8";

private static final String USER = "root";
private static final String PWD = "dataThinker";
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {

e.printStackTrace();
}
}

public static Connection getConnection() {
Connection conn = null;
try {
conn = DriverManager.getConnection(URL, USER, PWD);
} catch (SQLException e) {

e.printStackTrace();
}
return conn;
}

public static Statement getStatement(Connection conn) {
Statement st = null;
try {
st = conn.createStatement();
} catch (SQLException e) {

e.printStackTrace();
}
return st;
}

public static PreparedStatement getPreparedStatement(Connection conn,
String sql) {
PreparedStatement ps = null;
try {
ps = conn.prepareStatement(sql);
} catch (SQLException e) {

e.printStackTrace();
}
return ps;
}

public static ResultSet getResultSet(PreparedStatement ps) {
ResultSet rs = null;
try {
rs = ps.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}

public static void closeConnection(Connection conn) {
try {
if (conn != null && !conn.isClosed()) {
conn.close();
}
} catch (SQLException e) {

e.printStackTrace();
}
}

public static void closeStatement(Statement st) {
if (st != null) {
try {
st.close();
} catch (SQLException e) {

e.printStackTrace();
}
}
}

public static void closePreparedStatement(PreparedStatement ps) {
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {

e.printStackTrace();
}
}
}

public static void closeResultSet(ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {

e.printStackTrace();
}
}
}

}

Answer 2

你应该是用过windows的ODBC数据源配置的链接，然后在java里面调用这个ODBC数据源来连接数据库的吧？不太清楚你在程序里如何初始化数据库链接的，给你一个参考看看有没有帮助：
String sDsn = "你在ODBC数据源那配置里面配置的名称";
String sUsr = "数据库用户名";
String sPwd = "数据库密码";
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection cn = DriverManager.getConnection( "jdbc:odbc:" + sDsn, sUsr, sPwd );

Answer 3

驱动不对。应该是mysql 的jdbc 驱动。到这里下载 http://dev.mysql.com/downloads/connector/j/5.1.html