EJB-EAD- Overview chương trình quản lý sách SessionBean + TMS

Source Code

B1) Thiet ke database
create table authors (
	id int primary key auto_increment,
	author_name varchar(50),
	birthday date,
	address varchar(200),
	nickname varchar(50)
);

create table books (
	id int primary key auto_increment,
	book_name varchar(250),
	price float,
	delivered_date date,
	factory varchar(50),
	author_id int
);

alter table books
add constraint fk_author_id foreign key (author_id) references authors (id);

B2) Tao cau truc du an + jdbc mysql driver
B3) Gen entity (ORM)