day59
购物车案例
描述
设计一个书城项目,主要讲解购物车功能,用到session的技术点
实现
数据库的设计
book.db
create database books DEFAULT CHARACTER SET utf8; use books; create table book( bid int primary key auto_increment, name varchar(20) not null unique, img varchar(20), oprice double, nprice double );insert into book values(null, 'thinking in java', '3.png', 199, 188); insert into book values(null, 'Java core', '4.png', 188, 166); insert into book values(null, 'jvm 调优', '5.png', 99, 88); insert into book values(null, '三国演义', '6.png', 66, 55); insert into book values(null, '红楼梦', '7.png', 199, 200); insert into book values(null, '西游记', '8.png', 122, 110); insert into book values(null, '水浒传', '9.png', 199, 188); insert into book values(null, '大话西游', '10.png', 77, 9.9); insert into book values(null, '傅雷家书', '11.png', 88, 33); insert into book values(null, '钢铁是怎样炼成的', '12.png', 199, 188); insert into book values(null, '朝花夕拾', '13.png', 199, 188); insert into book values(null, '茶花女', '14.png', 199, 188); insert into book values(null, '桃花扇', '15.png', 199, 188);