Contact access database directly without configuring ODBC data sources

CONNECTION CON;

StMT;

Try {

// load JDBC Driver

Class.Forname ("Sun.jdbc.odbc.jdbcodbcdriver");

// Note DBQ write

String url = "jdbc: odbc: driver = {Microsoft Access Driver

(* .mdb)}; DBQ = E: //db1.mdb ";

Con = DriverManager.getConnection (URL, "SA", "");

STMT = con.createstatement ();

String query = "SELECT * FROM FAQ";

ResultSet RS = Stmt.executeQuery (Query);

While (rs.next ())

{

String str = rs.getstring ("name");

Out.print (STR);

}

}

Catch (Exception E) {

E.PrintStackTrace ();

}