How seasln/dbtech25 works
This repository is a database-technology course exercise set, not one deployed application. Its central insurance workflow ranges from basic Java contract and rate operations (Übung 2), through validating and storing contract coverage in Java (Übung 3), to invoking a PL/SQL reimplementation (Übung 4). A DAO-based alternative separates coverage, contract, and coverage-type access. The tree also includes auction and room JDBC examples. The README documents Übung 1 as SQL practice; its implementation is outside this Java tree. Some service internals are unsampled, so only documented or source-visible links are shown.
Main entry points: VersicherungServiceDao.java DAO Coverage Service · IVersicherungService.java Coverage API · VersicherungService.java Java Coverage Service · AuktionsServiceDao.java Auction DAO Service
Components 20
Insurance Services
- Basic Insurance API
javasrc/de/htwberlin/dbtech/aufgaben/ue02/IVersicherungJdbc.java - Java Data Services
javasrc/de/htwberlin/dbtech/aufgaben/ue02/VersicherungJdbc.java - Coverage API
javasrc/de/htwberlin/dbtech/aufgaben/ue03/IVersicherungService.java - Java Coverage Service
javasrc/de/htwberlin/dbtech/aufgaben/ue03/VersicherungService.java - Coverage Validation
javasrc/de/htwberlin/dbtech/aufgaben/ue03/VersicherungService.java - PL SQL Client
javasrc/de/htwberlin/dbtech/aufgaben/ue04/VersicherungServicePlSql.java
DAO Alternative
- DAO Coverage Service
javasrc/de/htwberlin/dbtech/aufgaben/dao/VersicherungServiceDao.java - Coverage DAO
javasrc/de/htwberlin/dbtech/aufgaben/dao/DeckungDao.java - Contract DAO
javasrc/de/htwberlin/dbtech/aufgaben/dao/VertragDao.java - Coverage Type DAO
javasrc/de/htwberlin/dbtech/aufgaben/dao/DeckungsartDao.java
Database Layer
- Insurance Database
- PL SQL Procedure
JDBC Examples
- Auction Service
javasrc/de/htwberlin/dbtech/bsp/auktion/AuktionsService.java - Auction DAO Service
javasrc/de/htwberlin/dbtech/bsp/auktion/AuktionsServiceDao.java - Offer Finder
javasrc/de/htwberlin/dbtech/bsp/auktion/AngebotFinder.java - Bid Record
javasrc/de/htwberlin/dbtech/bsp/auktion/Gebot.java - Room Lookup
javasrc/de/htwberlin/dbtech/bsp/raum/RaumService.java
Other components
- Learner
- Auction Client
- Room Client
Connections 26
- Learner → Basic Insurance API: uses
- Basic Insurance API → Java Data Services: implemented by
- Java Data Services → Insurance Database: reads and writes
- Learner → Coverage API: uses
- Coverage API → Java Coverage Service: implemented by
- Java Coverage Service → Coverage Validation: validates coverage
- Java Coverage Service → Insurance Database: queries and inserts
- Coverage API → DAO Coverage Service: implemented by
- DAO Coverage Service → Coverage DAO: inserts coverage
- DAO Coverage Service → Contract DAO: checks contract rules
- DAO Coverage Service → Coverage Type DAO: checks coverage type
- Coverage DAO → Insurance Database: writes
- Contract DAO → Insurance Database: queries
- Coverage Type DAO → Insurance Database: queries
- Learner → PL SQL Client: uses
- PL SQL Client → PL SQL Procedure: calls procedure
- PL SQL Procedure → Insurance Database: validates and stores
- Auction Client → Auction Service: submits bid
- Auction Service → Insurance Database: checks and stores bid
- Auction Client → Auction DAO Service: submits bid
- Auction DAO Service → Offer Finder: finds offer
- Auction DAO Service → Bid Record: creates bid
- Offer Finder → Insurance Database: reads offer
- Bid Record → Insurance Database: inserts bid
- Room Client → Room Lookup: requests seats
- Room Lookup → Insurance Database: reads seat count