import java.sql.*;
//import sun.jdbc.odbc.JdbcOdbcDriver;
class dbtest
{
public static void main(String args[])
{
try{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String myurl = "jdbc:odbc:test";
Connection conn = DriverManager.getConnection(myurl, "", "");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select top 20 * from loadsource");
System.out.println("get resultset\n");
rs.beforeFirst();
while(rs.next())
{
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}
catch(SQLException e)
{
System.out.println(e.toString());
e.printStackTrace();
}
}
}编译的时候正常,可是在运行的时候出现以下错误:
java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at dbtest.main(dbtest.java:11)好象就出在那个forname上, 不知道怎么回事,各位兄弟指教,在线等
//import sun.jdbc.odbc.JdbcOdbcDriver;
class dbtest
{
public static void main(String args[])
{
try{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String myurl = "jdbc:odbc:test";
Connection conn = DriverManager.getConnection(myurl, "", "");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select top 20 * from loadsource");
System.out.println("get resultset\n");
rs.beforeFirst();
while(rs.next())
{
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}
catch(SQLException e)
{
System.out.println(e.toString());
e.printStackTrace();
}
}
}编译的时候正常,可是在运行的时候出现以下错误:
java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at dbtest.main(dbtest.java:11)好象就出在那个forname上, 不知道怎么回事,各位兄弟指教,在线等
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+application.getRealPath("/Data/ReportDemo.mdb");
Connection conn = DriverManager.getConnection(url,"","");
Statement stmtNew=conn.createStatement() ;
编译的时候显示:
dbtest.java:9: unreported exception java.lang.ClassNotFoundExcept
ught or declared to be thrown
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
public class test
{
public static void main(String args[])
{
System.out.println("hello from java");
return;
}
}
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+application.getRealPath("YOUR DAYABASE dir");
Connection conn = DriverManager.getConnection(url,"","");
新手,仅供参考!
import java.sql.*;
class dbtest
{
public static void main(String args[])
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:suyanr";
Connection conn = DriverManager.getConnection(url,"","");
Statement stmt = conn.createStatement() ;
ResultSet rs = stmt.executeQuery("select * from driverinfo");
System.out.println("get resultset\n");
//rs.beforeFirst();
while(rs.next())
{
System.out.println(rs.getString(2));
}
rs.close();
stmt.close();
conn.close();
}
catch(ClassNotFoundException e){
System.out.println(e.toString());
}
catch(SQLException e)
{
System.out.println(e.toString());
}
}
}可是想知道为什么,因为许多书上都是这么写的,为什么自己系统上就不行了呢?非常加入这么多异常处理呢?