Archief - [PROG][ODBC] Een Access gegevensbestand (database) toegankelijk maken via ODBC.

public class Databank
{

  // JDBC driver name and database URL
  private static final String JDBC_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
  private static final String DATABASE_URL = "jdbc:odbc:MS Access-database;DBQ=project";

  private Connection connection;
  private Statement statement;
  private Databank deDatabank;
  
  
  // constructor connects to database
  public Databank()
  {
     // connect to database books 
     try
     {
        // load database driver class
		Class.forName( JDBC_DRIVER );
			
        // establish connection to database
        setConnection(DriverManager.getConnection( DATABASE_URL ));

        // create Statement for querying database
        setStatement(connection.createStatement());
        
     }
     catch ( SQLException sqlException )
     {
    	 JOptionPane.showMessageDialog( null, sqlException.getMessage(),
    	           "Database Error", JOptionPane.ERROR_MESSAGE );

    	        //System.exit( 1 );
     }
     // detect problems loading database driver
     catch ( ClassNotFoundException classNotFound )
     {
        JOptionPane.showMessageDialog( null, classNotFound.getMessage(),
           "Driver Not Found", JOptionPane.ERROR_MESSAGE );

        //System.exit( 1 );
     }
  }
  
      
	public void closeConnection()
   {
        try
        {
           getStatement().close();
           getConnection().close();
        }

        // handle exceptions closing statement and connection
        catch ( SQLException sqlException )
        {
         JOptionPane.showMessageDialog( null,
            sqlException.getMessage(), "Database Error",
            JOptionPane.ERROR_MESSAGE );
         System.exit( 1 );
      	 }
     }
public Statement getStatement() {
	return statement;
}
public void setStatement(Statement statement) {
	this.statement = statement;
}

public Connection getConnection() {
	return connection;
}

public void setConnection(Connection connection) {
	this.connection = connection;
}

}