もどる JDBC経由でmdbファイルへ接続
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCConnect {
public static void main(String[] agrs) {
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = ("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=db.mdb");
String user = "";
String password = "";
Connection connection = null;
Statement statement = null;
ResultSet result = null;
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
connection = DriverManager.getConnection(url, user, password);
statement = connection.createStatement();
result = statement.executeQuery("SELECT TEXT FROM DATA");
while (result.next()) {
System.out.println(result.getString(1));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (result != null) {
try {
result.close();
} catch (Exception e) {
e.printStackTrace();
}
}
if (statement != null) {
try {
statement.close();
} catch (Exception e) {
e.printStackTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
}