Java Tutorial/Database/Access
Create a connection to MS Access database
<source lang="java">
import java.sql.Connection; import java.sql.DriverManager; public class Main {
// private static final String URL = "jdbc:odbc:TestDB"; private static final String USERNAME = "admin"; private static final String PASSWORD = "welcome"; private static final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver"; private static final String URL = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Database\\testdb.mdb;}"; public static void main(String[] args) throws Exception { Class.forName(DRIVER); Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD); connection.close(); }
}</source>
Using DSN-less connection
<source lang="java">
import java.sql.Connection; import java.sql.DriverManager; public class Main {
public static void main(String[] argv) throws Exception { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String myDB = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/data.MDB"; Connection conn = DriverManager.getConnection(myDB, "", ""); }
}</source>