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上, 不知道怎么回事,各位兄弟指教,在线等
解决方案 »
- CardLayout下怎么设置每行每列的按钮大小为一个数值
- ThreadLocal的initialValue方法是怎样保证同步的
- 列车售票系统,打印车票应该用什么技术好呢?
- 跪求!!!Hibernate中的一些概念 在线等!!!!!!!!!!!!!!!
- 新人求助!oracle jdbc连接问题,万望各位大人指点一下!
- 跪求 Java 编写的 考试系统 有偿!
- 新手入门?
- 大家好!!!谁有java的基础书,我在网上下的都不能用!!!!
- 谁能告诉我这段话到底说明了什么问题。先给30分,准备加到60分。
- About JBuilder4
- 分不多了半夜一问,Collection集合框架的问下周
- 关于继承与构造方法的问题?大家帮帮忙!
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());
}
}
}可是想知道为什么,因为许多书上都是这么写的,为什么自己系统上就不行了呢?非常加入这么多异常处理呢?