图书管理程序（一）

本级程序所用的数据表结构： # -------------------------------------------------------- # # 数据表的结构 'author' # CREATE TABLE author ( ;;;author_id int(6) DEFAULT '0' NOT NULL auto_increment, ;;;first_name varchar(20) binary NOT NULL, ;;;last_name varchar(20) NOT NULL, ;;;address varchar(100) binary NOT NULL, ;;;zipcode varchar(10) NOT NULL, ;;;telephone varchar(10) NOT NULL, ;;;email varchar(50) NOT NULL, ;;;comment varchar(255) NOT NULL, ;;;PRIMARY KEY (author_id), ;;;KEY first_name (first_name), ;;;KEY last_name (last_name), ;;;KEY address (address), ;;;KEY zipcode (zipcode), ;;;KEY email (email) ); # -------------------------------------------------------- # # 数据表的结构 'books' # CREATE TABLE books ( ;;;books_id int(6) DEFAULT '0' NOT NULL auto_increment, ;;;books_name varchar(100) binary NOT NULL, ;;;publisher_id varchar(6) NOT NULL, ;;;date_pub datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, ;;;type varchar(6) NOT NULL, ;;;pages varchar(4) NOT NULL, ;;;price float(6,2) DEFAULT '0.00' NOT NULL, ;;;comment varchar(255) binary NOT NULL, ;;;ISBN varchar(25) NOT NULL, ;;;PRIMARY KEY (books_id), ;;;KEY name (books_name), ;;;KEY publisher (publisher_id), ;;;KEY date_pub (date_pub), ;;;KEY price (price), ;;;KEY pages (pages), ;;;KEY type (type), ;;;KEY ISBN (ISBN) ); # -------------------------------------------------------- # # 数据表的结构 'books_author' # CREATE TABLE books_author ( ;;;id int(6) DEFAULT '0' NOT NULL auto_increment, ;;;books_id varchar(6) NOT NULL, ;;;author_id varchar(6) NOT NULL, ;;;author_type varchar(6) NOT NULL, ;;;PRIMARY KEY (id) ); # -------------------------------------------------------- # # 数据表的结构 'publisher' # CREATE TABLE publisher ( ;;;publisher_id int(6) DEFAULT '0' NOT NULL auto_increment, ;;;publisher_name varchar(100) binary NOT NULL, ;;;address varchar(100) NOT NULL, ;;;zipcode varchar(10) NOT NULL, ;;;telephone varchar(10) NOT NULL, ;;;telefax varchar(10) NOT NULL, ;;;email varchar(50) NOT NULL, ;;;PRIMARY KEY (publisher_id), ;;;KEY name (publisher_name), ;;;KEY address (address), ;;;KEY email (email) );