.NET程序员学Java笔记[4]-JDBC连接Access数据库

package net.io99;

import java.sql.*;

public class TestAccess {

	public static void main(String args[]) throws Exception {
		//连接Access 2007数据库，需要先在“数据源”中的“用户DSN”先添加相应的驱动
		//String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=F:\\JavaTest\\test.accdb";
		//连接Access 2000-2003数据库
        String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=F:\\JavaTest\\test.mdb";
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection conn=DriverManager.getConnection(strurl) ;
        Statement stmt=conn.createStatement();
        ResultSet rs=stmt.executeQuery("select * from table1");
        while(rs.next())
            System.out.println(rs.getString("content"));
        rs.close();
        stmt.close();
        conn.close(); 
	}
}