核心代码整理.doc

加入购物车： Car car = (Car)request.getSession().getAttribute(car); Commodity commo = (Commodity)request.getSession().getAttribute(commodity); Commodity temp = new Commodity(); temp.setId(commo.getId()); temp.setName(commo.getName()); temp.setPrice(commo.getPrice()); car.getCommoditys().add(temp); for(Commodity c:car.getCommoditys()){ System.out.println(c.getName()); } String sql = insert into car_commodity (car_id,commodity_id) values(+car.getId()+,+commo.getId()+); System.out.println(sql); DBConnect dbc = new DBConnect(); try { dbc.getConnect().createStatement().executeUpdate(sql); } catch (SQLException e) { e.printStackTrace(); } 从购物车中删除商品： Car car = (Car)request.getSession().getAttribute(car); ListCommodity commos = car.getCommoditys(); for(int i = 0;icommos.size();i++){ if(commos.get(i).getId().equals(request.getParameter(id))){ commos.remove(i); } } String id = request.getParameter(id); String sql = select * from car_commodity where commodity_id=+id+ and car_id=+car.getId()+; String sql1 = ; ResultSet rs = null; System.out.println(sql); DBConnect dbc = new DBConnect(); try { rs = dbc.getConnect().createStatement().executeQuery(sql); if(rs.next()){ sql1 = delete from car_commodity where id = +rs.getInt(id); dbc.getConnect().createStatement().executeUpdate(sql1); } } catch (SQLException e) { e.printStackTrace(); } 在购物车中选择商品： var go = $(#go).attr(href); $(#all).click(function(){ if($(#all).attr(checked)){ $(.al).attr(checked,checked); $(#go).attr(href,go+?all=all++money=+money); }else{ $(.al).removeAttr(checked); $(#go).attr(href,go); } var money = 0; $(.al).each(function(){ if($(this).attr(checked)){ money = money + parseInt($(this).val()); } }) $(.money).html(money); }); $(.al).click(function(){ $(#all).removeAttr(checked); var ids = ; var money = 0; $(.al).each(function(){ if($(this).attr(checked)){ money = money + parseInt($(this).val()); if(ids==