import java.io.*;
import java.sql.*;public class JdbcTest {
public static void main(String args[]) throws SQLException, InstantiationException, IllegalAccessException{
int i,Noi;
String UserId,UserName,url;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
UserId="admin";
UserName="ICCARD";
url="sun.jdbc.odbc:ICCARD";
Connection ExlCon=DriverManager.getConnection(url,UserId,UserName);
Statement ExlStmt=ExlCon.createStatement();
ResultSet ExlRs = ExlStmt.executeQuery("select UserID,UserName from Users");
System.out.println("Userid UserName");
while (ExlRs.next()){
UserId=ExlRs.getString(1);
UserName=ExlRs.getString(2);
System.out.println(UserId);
}
}
}提示:Connection ExlCon=DriverManager.getConnection(url,UserId,UserName);
出错!
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at JdbcTest.main(JdbcTest.java:18)
import java.sql.*;public class JdbcTest {
public static void main(String args[]) throws SQLException, InstantiationException, IllegalAccessException{
int i,Noi;
String UserId,UserName,url;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
UserId="admin";
UserName="ICCARD";
url="sun.jdbc.odbc:ICCARD";
Connection ExlCon=DriverManager.getConnection(url,UserId,UserName);
Statement ExlStmt=ExlCon.createStatement();
ResultSet ExlRs = ExlStmt.executeQuery("select UserID,UserName from Users");
System.out.println("Userid UserName");
while (ExlRs.next()){
UserId=ExlRs.getString(1);
UserName=ExlRs.getString(2);
System.out.println(UserId);
}
}
}提示:Connection ExlCon=DriverManager.getConnection(url,UserId,UserName);
出错!
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at JdbcTest.main(JdbcTest.java:18)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货