import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;class jdbcTest {
protected jdbcTest()
{
}
public static void main(String [] args)
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e) {
System.out.println("zheli");
}
try{
String url = "jdbc.odbc.mysql";
Connection con = DriverManager.getConnection(url);
Statement stn = con.createStatement();
ResultSet rs = stn.executeQuery("select * from myfriends");
while(rs.next())
{
System.out.println(rs.getString(1)+"\t");
System.out.println(rs.getString(2)+"\t");
System.out.println(rs.getInt(3)+"\t");
System.out.println(rs.getString(4)+"\t");
System.out.println(rs.getInt(5)+"\t");
System.out.println(" ");
}
rs.close();
stn.close();
con.close();
}
catch (SQLException ce)
{
System.out.println(ce);
} }}为什么报错 no suitable Driver
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;class jdbcTest {
protected jdbcTest()
{
}
public static void main(String [] args)
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e) {
System.out.println("zheli");
}
try{
String url = "jdbc.odbc.mysql";
Connection con = DriverManager.getConnection(url);
Statement stn = con.createStatement();
ResultSet rs = stn.executeQuery("select * from myfriends");
while(rs.next())
{
System.out.println(rs.getString(1)+"\t");
System.out.println(rs.getString(2)+"\t");
System.out.println(rs.getInt(3)+"\t");
System.out.println(rs.getString(4)+"\t");
System.out.println(rs.getInt(5)+"\t");
System.out.println(" ");
}
rs.close();
stn.close();
con.close();
}
catch (SQLException ce)
{
System.out.println(ce);
} }}为什么报错 no suitable Driver
http://download.microsoft.com/download/SQLSVR2000/jdbc/2000/NT45XP/EN-US/setup.exe记得要驱动
刚学java.太简单的太离谱的错误被大家忽略了。不过,还是谢谢大家。