import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class MDBDriverTest { public static void main(String[] args) { String str_Query = "Select * From mbr01"; System.out.println("start"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println("main(String[]) - Driver load success!"); Connection con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=MDBファイルのフルパス/test01.mdb;uid=;pwd="); System.out.println("main(String[]) - ODBC connect success"); PreparedStatement psmt = null; ResultSet rs = null; try{ psmt = con.prepareStatement(str_Query); rs = psmt.executeQuery(); }catch(Exception ex){ ex.printStackTrace(); try{ con.close(); }catch(Exception eex){ } } while(rs.next()){ System.out.println(rs.getString("mbrName")); } con.close(); System.out.println("main(String[]) - ODBC disconnected."); } catch (ClassNotFoundException e) { System.out.println("main(String[]) - Driver load fail."); } catch (SQLException e) { System.out.println("main(String[]) - ODBC connect fail."); } System.out.println("end"); } }