最近忙着一些事情至今才上传books.sql文件的数据库代码和BookStore3的源代码:
BookStore3的源代码下载:http://dl.dbank.com/c0kvcgz24h
BookStore3的books.sql数据库代码如下:
create database books;
use books;
create table users(
id int auto_increment primary key,
username varchar(20),
password varchar(20)
)engine=InnoDB default charset=gbk;
insert into users values(null,'piaoqi13','123');
create table books(
id varchar(20) primary key,
bookname varchar(30),
publish varchar(50),
author varchar(30),
price float
)engine=InnoDB default charset=gbk;
insert into books values('1','javaEE','大连东软信息学院出版社','李绪成',98);
insert into books values('2','javaweb','大连东软信息学院出版社','陈鹏',89);
insert into books values('3','struts2','传智播客教育传媒','黎活明',700);
insert into books values('4','hibernate','传智播客教育传媒','黎活明',700);
insert into books values('5','spring','尚学堂教育传媒','王勇',700);
insert into books values('6','oracle','neusoft','刘蕾',77);
insert into books values('7','android','neusoft','董宗然',56);
insert into books values('8','网站设计与制作','大连东软信息学院出版社','郭巧丽',65);
create table orders2(
orderid int auto_increment primary key,
username varchar(20),
bookid varchar(20),
amount int,
checked boolean
)engine=InnoDB default charset=gbk;
2011.05.08下午。
王超。
战败的军人,只有一条路可走。