Java in Ms access

Jaz sem se enkrat (že par let nazaj) uspešno povezal prek odbc driverjev. Primer sem pa našel na tem naslovu - knjiga Thinking in Enterprise Java. Povsem legalno si jo lahko dowloadaš. Poglej poglavje "conecting to database", kjer je primer za povezavo prek odbc driverjev.

tuki je en primer
mors pa v control panel/data sources (odbc ) / system DNS nastimat tako bazo
ce znas vsaj mal jave in SQL je koda ocitna

import java.sql.*;

public class Neki {

  public static void main(String args[]) {
    int att1,att2;
    try {
      //Register driver
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
      //Establish a connection to given database URL
      Connection con = DriverManager.getConnection("jdbc:odbc:test","","");       //test je ime baze
      //Create a Statement object for sending SQL statements to the database
      Statement stmt = con.createStatement();
      //Execute SQL:
      stmt.execute("SELECT * FROM tabela");       //tabela je ime tabele v bazi
      //Get results from executed SQL
      ResultSet results = stmt.getResultSet();
      while (results.next()) {
        att1=results.getString("att1"); //att1 je ime atributa v tabeli tabela
        att2=results.getInt("att2"); //att2 je ime atributa v tabeli tabela
        System.out.println(att1+" "+att2);
      }
      //Close the connection
      con.close();
    } catch(Exception e)  { 
      System.out.println(e);
    }
  }
}