Connectivity with Access without DSN
There are two ways to connect java application with the access database.
Java is mostly used with Oracle, mysql, or DB2 database. So you can learn this topic only for knowledge.
Example to Connect Java Application with access without DSN
In this example, we are going to connect the java program with the access database. In such case, we have created the login table in the access database. There is only one column in the table named name. Let's get all the name of the login table.
Example to Connect Java Application with access with DSN
Connectivity with type1 driver is not considered good. To connect java application with type1 driver, create DSN first, here we are assuming your dsn name is mydsn.