Homework 7 JDBC

Task

2. For database with departments and students create DAOs, transformers and services with all CRUD operations. Write a few additional methods (e.g. get all departments, get student by id). Write method for department deletion, taking to account the fact that you need to transfer all students from that department to another one. Check if your program and database properly works with Cyrillic alphabet.

3. Perform execution of a few query in one transaction.

4. Write program that read all meta data from a database (e.g. list of tables, parameters, list of cols for each table and so on)

5.* Try to create universal transformer using generics, reflections and annotations.