Here's the work codes I copied from intnet:
public static final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
public static final String DATABASE = "jdbc
dbc
RIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\\Edu\\Java\\Forum\\DataConnection.mdb";
public static final String USERNAME = "admin";
public static final String PASSWORD = "";
public static void main(String [] args)
{
try
{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, username, password);
if (conn != null)
{
DatabaseMetaData meta = conn.getMetaData();
String productName = meta.getDatabaseProductName();
String productVersion = meta.getDatabaseProductVersion();
conn.close();
System.out.println("Driver : " + driver);
System.out.println("Database: " + url);
System.out.println("Username: " + username);
System.out.println("Password: " + password);
System.out.println("Product : " + productName);
System.out.println("Version : " + productVersion);
}
else
{
System.out.println("Database connection was null");
}
}
catch (ClassNotFoundException e)
{
System.err.println("Couldn't load JDBC driver class");
e.printStackTrace();
}
catch (SQLException e)
{
System.err.println("SQL state: " + e.getSQLState());
System.err.println("SQL error: " + e.getErrorCode());
e.printStackTrace();
}
catch (Exception e)
{
e.printStackTrace();
}