D
Dinobe
Hey,
I would like to make JTable with an AbstractTableModel, but the information
is stored in multiple Access tables.
A brief description:
I have a table in Access called Docent (docentID, naam, voornaam, straat,
pc, gemeente, telefoon, aantalStageUren)
DocentID is the unique key
I have another table in Access called Stage(stageID, titel, omschrijving,
programmeertaal, database, operatingSystem, softwareOmgeving,
hardwareOmgeving, organisatieID)
stage ID is the unique key
A Third table links those two tabels VoorkeurDocentStage(docentID, stageID,
voorkeur, reden)
docentID & stageID for a combined unique key.
I would like to create a JTable with a AbstractTableModel which shows me the
following:
The columnheaders should contain the naam from Docent
The first column can not be used, because the first colums should contain
all the titels from Stage
on the 'crossroads' of a column and a row should appear de voorkeur (a
value) which is Stored in VoorkeurDocentStage
I would like something like this, (screenshot made in Excel)
http://users.pandora.be/Kalmanados/java/AbstractTableModel.jpg
How can this be done?
I'm really desperate!
Thanks in advance
I would like to make JTable with an AbstractTableModel, but the information
is stored in multiple Access tables.
A brief description:
I have a table in Access called Docent (docentID, naam, voornaam, straat,
pc, gemeente, telefoon, aantalStageUren)
DocentID is the unique key
I have another table in Access called Stage(stageID, titel, omschrijving,
programmeertaal, database, operatingSystem, softwareOmgeving,
hardwareOmgeving, organisatieID)
stage ID is the unique key
A Third table links those two tabels VoorkeurDocentStage(docentID, stageID,
voorkeur, reden)
docentID & stageID for a combined unique key.
I would like to create a JTable with a AbstractTableModel which shows me the
following:
The columnheaders should contain the naam from Docent
The first column can not be used, because the first colums should contain
all the titels from Stage
on the 'crossroads' of a column and a row should appear de voorkeur (a
value) which is Stored in VoorkeurDocentStage
I would like something like this, (screenshot made in Excel)
http://users.pandora.be/Kalmanados/java/AbstractTableModel.jpg
How can this be done?
I'm really desperate!
Thanks in advance