How to connect Java to the Access Database

1. Create a database

2. Configure the data source

Open Control Panel, open administrative tools, open data source (ODBC), select system DSN, click Add, and select Driver do microsoft access ", click Finish and select your database for configuration.

3. Write database connection

Class. forName ("sun. jdbc. odbc. JdbcOdbcDriver");

String url = "jdbc: odbc: Driver = {MicroSoft Access Driver (*. mdb)}; DBQ =" + application. getRealPath ("/Data/ReportDemo. mdb");

Connection conn = DriverManager. getConnection (url, "," ");

Statement stmtNew = conn. createStatement ();