JAVA连接ACCESS数据库

来源:百度知道 编辑:UC知道 时间:2024/04/28 06:19:25

曾经看到过一种最简单的连接access数据库的方法,不需要配置数据源,也不需要安装驱动======================================================================
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();
con