Java with IntelliJ Ideas How to connect to Microsoft access database
Java with IntelliJ Ideas How to connect to Ms access database.
1.create database in microsoft access
2.download ucanaccess driver at https://sourceforge.net/projects/ucan...
3.add ucanaccess driver to project
4.create connection string to database
this is my simple example:
public class MyConnnection {
public static Connection connect(){
Connection connection;
try {
connection= DriverManager.getConnection("jdbc:ucanaccess://database path and nameWithExtension");
if(connection!=null){
System.out.println("Database connected");
}
return connection;
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
public static void main(String[] arg){
MyConnnection.connect();
}
}