Create a connection to MS Access database : Access « Database SQL JDBC « Java






  1. Java
  2. Database SQL JDBC
  3. Access

Create a connection to MS Access database

import java.sql.Connection; import java.sql.DriverManager; publicclass Main { // private static final String URL = "jdbc:odbc:TestDB"; privatestaticfinal String USERNAME = "admin"; privatestaticfinal String PASSWORD = "welcome"; privatestaticfinal String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver"; privatestaticfinal String URL = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\Database\\testdb.mdb;}"; publicstaticvoid main(String[] args) throws Exception { Class.forName(DRIVER); Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD); connection.close(); } }








Related examples in the same category

1.Connect to a database via JDBC-ODBC
close