WebServices with CXF - Our Database

Too many times I tried to look for some good examples for my padawans, but as always, incomplete stuff or not really clear. Anyway, that's why I'm going to develop a small app using a bunch of useful things, and one of these it's going to be Apache CXF The first and most important step is what kind of problem I'm going to solve using the app? Well, let's create a scenario: I have a small Database on MySQL 5.1.37. this is my schema: +---------------------+ | Tables_in_bookstore | +---------------------+ | author | | author_book | | book | | editor | +---------------------+ mysql> desc author; +-------------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+-------------------+----------------+ | author_id | int(11) | NO | PRI | NULL | auto_increment | | create_date | timestamp | NO | | CURRENT_TIMESTAMP | | | email | varchar(100) | YES | | NULL | | | name | varchar(100) | NO | | NULL | | +-------------+--------------+------+-----+-------------------+----------------+ mysql> desc author_book; +-----------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------+------+-----+---------+-------+ | book_id | int(11) | NO | PRI | NULL | | | author_id | int(11) | NO | PRI | NULL | | +-----------+---------+------+-----+---------+-------+ mysql> desc book; +-------------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+-------------------+----------------+ | book_id | int(11) | NO | PRI | NULL | auto_increment | | create_date | timestamp | NO | | CURRENT_TIMESTAMP | | | title | varchar(200) | NO | | NULL | | | editor_id | int(11) | YES | MUL | NULL | | +-------------+--------------+------+-----+-------------------+----------------+ mysql> desc editor; +-------------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+-------------------+----------------+ | editor_id | int(11) | NO | PRI | NULL | auto_increment | | create_date | timestamp | NO | | CURRENT_TIMESTAMP | | | title | varchar(200) | NO | | NULL | | | url | varchar(255) | YES | | NULL | | +-------------+--------------+------+-----+-------------------+----------------+

As you noticed the relations are like this:

AUTHOR --< AUTHOR_BOOK >-- BOOK >-- EDITOR