netbeans4.1 ,jdk5,winxpsp2
package beans;
import java.sql.*;
/**
*利用javabeans连接access数据库 读取数据库中的信息
*/
/**
*
* @author Administrator
*/
public class linkdb {
/** Creates a new instance of linkdb */
public static void main(String args[]) throws Exception{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\ncldl\\db.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(strurl) ;
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from user");
while(rs.next())
System.out.println(rs.getString("username"));
rs.close();
stmt.close();
conn.close();
}
public linkdb(){
}
} 运行时出现如下提示:
init:
deps-module-jar:
deps-ear-jar:
deps-jar:
Compiling 1 source file to C:\ncldl\build\web\WEB-INF\classes
compile-single:
run-main:
java.lang.NoClassDefFoundError: linkdb
Exception in thread "main"
Java Result: 1
package beans;
import java.sql.*;
/**
*利用javabeans连接access数据库 读取数据库中的信息
*/
/**
*
* @author Administrator
*/
public class linkdb {
/** Creates a new instance of linkdb */
public static void main(String args[]) throws Exception{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\ncldl\\db.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(strurl) ;
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from user");
while(rs.next())
System.out.println(rs.getString("username"));
rs.close();
stmt.close();
conn.close();
}
public linkdb(){
}
} 运行时出现如下提示:
init:
deps-module-jar:
deps-ear-jar:
deps-jar:
Compiling 1 source file to C:\ncldl\build\web\WEB-INF\classes
compile-single:
run-main:
java.lang.NoClassDefFoundError: linkdb
Exception in thread "main"
Java Result: 1
}
改为
public void linkdb(){
}
2楼的,那个是构造函数,不用改,没影响的,问题应该没出在这吧??
我也是初学者,我一般用Access数据库都用jdbc:odbc连接桥,直接用总感觉不大好用,那个驱动写的感觉蛮诡异,嘎嘎:)