《j2ee经典实例详解》的源代码。原书无附带光盘。介绍的是一个在线银行系统的例子。绝对难得
源代码在线查看: create.sql
-- create tables for CMP roster application drop table league; drop table player; drop table team; drop table team_player; commit; create table league ( id VARCHAR(8) CONSTRAINT pk_league PRIMARY KEY, name VARCHAR(24), sport VARCHAR(24)); commit; create table player ( id VARCHAR(8) CONSTRAINT pk_player PRIMARY KEY, name VARCHAR(24), position VARCHAR(24), salary VARCHAR(24)); commit; create table team ( id VARCHAR(8) CONSTRAINT pk_team PRIMARY KEY, name VARCHAR(24), city VARCHAR(24), league_id VARCHAR(8), CONSTRAINT fk_league_id FOREIGN KEY (league_id) REFERENCES league(id)); commit; create table team_player ( player_id VARCHAR(8), team_id VARCHAR(8), CONSTRAINT fk_player_id FOREIGN KEY (player_id) REFERENCES player(id), CONSTRAINT fk_team_id FOREIGN KEY (team_id) REFERENCES team(id)); commit; exit;