曾經(jīng)看到過一種最簡單的連接access數(shù)據(jù)庫的方法,居然不需要配置數(shù)據(jù)源,也不
需要安裝驅(qū)動.今天看到網(wǎng)上有人問,就寫下來了
======================================================================
import java.sql.*;
public class ToAccess {
public static void main(String args[]) {
try {
String url = "jdbc:odbc:driver={Microsoft
Access Driver (*.mdb)};DBQ=D:\\bookshop.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection
(url);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select *
from books");
while (rs.next()) {
System.out.println("The book's name
is:" + rs.getString("book"));
System.out.println("The author is: " +
rs.getString("author"));
}
rs.close();
stmt.close();
conn.close();
} catch(Exception e) {
System.out.println(e.getMessage());
}
}
}