如需温习上一节的内容,请点击下方链接进行页面跳转:
目录
2.购物车商品的删除 (1)点击删除按钮 将当前点击的id传递到do页面 (2)获取session 遍历 利用集合remove进行移除 (3)重新进行保存
5.购物车分页实现list.subList(start,end)
需实现的功能:
1.商品加入购物车
2.购物车商品的删除
(1)点击删除按钮 将当前点击的id传递到do页面
(2)获取session 遍历
利用集合remove进行移除
(3)重新进行保存
3.购物车商品数量的递增或递减
4.单个商品及所有商品总价格的计算
5.购物车分页实现list.subList(start,end)
session购物车脚本:
--创建用户表
create table tb_users
(
userid number(20) primary key,--用户编号
username varchar2(100) not null,--用户名
upassword varchar2(100) not null,--用户密码
urole number(10) default 1--用户权限 0 管理员 1 普通用户(默认)
)
--插入数据
insert into tb_users values(1,'admin','123',0);
insert into tb_users values(2,'zkingzz','123',1);
--创建商品信息表tb_goods
create table tb_goods
(
gid number(20) primary key,--商品编号
gname varchar2(100) not null,--商品名称
gprice number(20) not null,--商品价格
ginfo varchar2(2000) not null,--商品描述
gimage varchar2(100) not null--商品图片路径
)
--插入数据
insert into tb_goods values(1,'mp31',100,'mp31','images/1.jpg') ;
insert into tb_goods values(2,'mp32',1200,'mp32','images/2.jpg') ;
insert into tb_goods values(3,'mp33',100,'mp33','images/3.jpg') ;
insert into tb_goods values(4,'mp34',1600,'mp34','images/4.jpg') ;
insert into tb_goods values(5,'mp35',1500,'mp35','images/5.jpg') ;
insert into tb_goods values(6,'mp36',1400,'mp36','images/6.jpg') ;
insert into tb_goods values(7,'mp37',1700,'mp37','images/7.jpg') ;
insert into tb_goods values(8,'mp38',1300,'mp38','images/8.jpg') ;
insert into tb_goods values(9,'mp39',1500,'mp39','images/9.jpg') ;
insert into tb_goods values(10,'mp310',1600,'mp310','images/10.jpg') ;
insert into tb_goods values(11,'mp311',1600,'mp311','images/11.jpg');
commit;
select * from tb_goods
利用eclipse进行创建包和类:
com.zking.goods.biz:
IGoodsBiz:
package com.zking.goods.biz.impl;
import java.util.List;
import com.zking.goods.biz.IGoodsBiz;
import com.zking.goods.dao.IGoodsDao;
import com.zking.goods.dao.impl.GoodsDaoImpl;
import com.zking.goods.entity.Goods;
public class GoodsBizImpl implements IGoodsBiz {
//实例化数据访问层的dao
IGoodsDao igd = new GoodsDaoImpl();
@Override
public List<Goods> queryGoodsAll() {
return igd.queryGoodsAll();
}
@Override
public Goods getGoodsByCid(int cid) {
return igd.getGoodsByCid(cid);
}
}
com.zking.goods.biz.impl:
GoodsBizImpl:
package com.zking.goods.biz.impl;
import java.util.List;
import com.zking.goods.biz.IGoodsBiz;
import com.zking.goods.dao.IGoodsDao;
import com.zking.goods.dao.impl.GoodsDaoImpl;
import com.zking.goods.entity.Goods;
public class GoodsBizImpl implements IGoodsBiz {
//实例化数据访问层的dao
IGoodsDao igd = new GoodsDaoImpl();
@Override
public List<Goods> queryGoodsAll() {
return igd.queryGoodsAll();
}
@Override
public Goods getGoodsByCid(int cid) {
return igd.getGoodsByCid(cid);
}
}
com.zking.gods.dao:
IGoodsDao:
package com.zking.goods.dao;
import java.util.List;
import com.zking.goods.entity.Goods;
public interface IGoodsDao {
List<Goods> queryGoodsAll();
/**
* 根据商品编号获取对应的信息
*/
Goods getGoodsByCid(int cid);
}
com.zking.goods.dao.impl:
G