代码马宝军.docx
《代码马宝军.docx》由会员分享，可在线阅读，更多相关《代码马宝军.docx（49页珍藏版）》请在冰豆网上搜索。
代码马宝军
Goods.java
//商品类
packageConsumers;
importMyUtils.CloseDBResource;
importMyUtils.GetResultSet;
importjava.sql.ResultSet;
importjava.util.ArrayList;
importjava.util.List;
/**
*CreatedwithIntelliJIDEA.
*User:
Administrator
*Date:
13-5-17
*Time:
下午4:
52
*TochangethistemplateuseFile|Settings|FileTemplates.
*/
publicclassGoods{
protectedintgoods_id;
protectedStringgoods_name;
protectedStringgoods_miaoshu;
protectedStringgoods_pic;
protectedStringgoods_shichangjia;
protectedStringgoods_tejia;
protectedStringcatelog_id;
protectedStringshangjia_date;
protectedStringbrand;;
protectedStringsexrequest;
protectedStringcommend;
protectedStringsellcount;
protectedStringclickcount;
publicStringgetShangjia_date（）{
returnshangjia_date;
}
publicvoidsetShangjia_date（Stringshangjia_date）{
this.shangjia_date=shangjia_date;
}
publicStringgetBrand（）{
returnbrand;
}
publicvoidsetBrand（Stringbrand）{
this.brand=brand;
}
publicStringgetSexrequest（）{
returnsexrequest;
}
publicvoidsetSexrequest（Stringsexrequest）{
this.sexrequest=sexrequest;
}
publicStringgetCommend（）{
returncommend;
}
publicvoidsetCommend（Stringcommend）{
mend=commend;
}
publicStringgetSellcount（）{
returnsellcount;
}
publicvoidsetSellcount（Stringsellcount）{
this.sellcount=sellcount;
}
publicStringgetClickcount（）{
returnclickcount;
}
publicvoidsetClickcount（Stringclickcount）{
this.clickcount=clickcount;
}
publicintgetGoods_id（）{
returngoods_id;
}
publicvoidsetGoods_id（intgoods_id）{
this.goods_id=goods_id;
}
publicStringgetGoods_name（）{
returngoods_name;
}
publicvoidsetGoods_name（Stringgoods_name）{
this.goods_name=goods_name;
}
publicStringgetGoods_miaoshu（）{
returngoods_miaoshu;
}
publicvoidsetGoods_miaoshu（Stringgoods_miaoshu）{
this.goods_miaoshu=goods_miaoshu;
}
publicStringgetGoods_pic（）{
returngoods_pic;
}
publicvoidsetGoods_pic（Stringgoods_pic）{
this.goods_pic=goods_pic;
}
publicStringgetGoods_shichangjia（）{
returngoods_shichangjia;
}
publicvoidsetGoods_shichangjia（Stringgoods_shichangjia）{
this.goods_shichangjia=goods_shichangjia;
}
publicStringgetGoods_tejia（）{
returngoods_tejia;
}
publicvoidsetGoods_tejia（Stringgoods_tejia）{
this.goods_tejia=goods_tejia;
}
publicStringgetCatelog_id（）{
returncatelog_id;
}
publicvoidsetCatelog_id（Stringcatelog_id）{
this.catelog_id=catelog_id;
}
PublicclassGoodssevletextendsGoods{
publicListgetList（Stringsql）{
ResultSetresultSet=null;
ListgoodsList=newArrayList（）;
GetResultSetgetResultSet=newGetResultSet（）;
try{
resultSet=getResultSet.getResultSet（sql）;
while（resultSet.next（））{
Goodsgoods=newGoods（）;
goods.setGoods_id（Integer.parseInt（resultSet.getString（"goods_id"）））;
goods.setGoods_name（resultSet.getString（"goods_name"））;
goods.setGoods_miaoshu（resultSet.getString（"goods_miaoshu"））;
goods.setGoods_pic（resultSet.getString（"goods_pic"））;
goods.setGoods_shichangjia（resultSet.getString（"goods_shichangjia"））;
goods.setGoods_tejia（resultSet.getString（"goods_tejia"））;
goods.setCatelog_id（resultSet.getString（"catelog_id"））;
goods.setShangjia_date（resultSet.getString（"shangjia_date"））;
goods.setBrand（resultSet.getString（"brand"））;
goods.setSexrequest（resultSet.getString（"sexrequest"））;
goods.setCommend（resultSet.getString（"commend"））;
goods.setSellcount（resultSet.getString（"sellcount"））;
goods.setClickcount（resultSet.getString（"clickcount"））;
goodsList.add（goods）;
}
}catch（Exceptione）{
System.out.println（"Models.Teacher.getTeacherList!
Exception"）;
}finally{
CloseDBResource.close（resultSet,getResultSet.getStatement（）,getResultSet.getConnection（））;
}
returngoodsList;
}
}
Orders.java
//订单类
packageConsumers;
importMyUtils.CloseDBResource;
importMyUtils.GetResultSet;
importjava.sql.ResultSet;
importjava.util.ArrayList;
importjava.util.List;
/**
*CreatedwithIntelliJIDEA.
*User:
Administrator
*Date:
13-5-16
*Time:
下午6:
43
*TochangethistemplateuseFile|Settings|FileTemplates.
*/
publicclassOrderextendsGoods{
privateintorder_id;
privateintuser_id;
privateintgoods_id;
privateStringorder_date;
privateStringorder_zhuangtai;
privateStringorder_jine;
privateStringorder_songhuodizhi;
privateStringorder_fukuangfangshi;
publicintgetOrder_id（）{
returnorder_id;
}
publicvoidsetOrder_id（intorder_id）{
this.order_id=order_id;
}
publicintgetUser_id（）{
returnuser_id;
}
publicvoidsetUser_id（intuser_id）{
this.user_id=user_id;
}
publicintgetGoods_id（）{
returngoods_id;
}
publicvoidsetGoods_id（intgoods_id）{
this.goods_id=goods_id;
}
publicStringgetOrder_date（）{
returnorder_date;
}
publicvoidsetOrder_date（Stringorder_date）{
this.order_date=order_date;
}
publicStringgetOrder_zhuangtai（）{
returnorder_zhuangtai;
}
publicvoidsetOrder_zhuangtai（Stringorder_zhuangtai）{
this.order_zhuangtai=order_zhuangtai;
}
publicStringgetOrder_jine（）{
returnorder_jine;
}
publicvoidsetOrder_jine（Stringorder_jine）{
this.order_jine=order_jine;
}
publicStringgetOrder_songhuodizhi（）{
returnorder_songhuodizhi;
}
publicvoidsetOrder_songhuodizhi（Stringorder_songhuodizhi）{
this.order_songhuodizhi=order_songhuodizhi;
}
publicStringgetOrder_fukuangfangshi（）{
returnorder_fukuangfangshi;
}
publicvoidsetOrder_fukuangfangshi（Stringorder_fukuangfangshi）{
this.order_fukuangfangshi=order_fukuangfangshi;
}
PublicclassOrderservletextendsOrders{
publicListgetList1（Stringsql）{
ResultSetresultSet=null;
ListgoodsList=newArrayList（）;
GetResultSetgetResultSet=newGetResultSet（）;
try{
resultSet=getResultSet.getResultSet（sql）;
while（resultSet.next（））{
Orderorder=newOrder（）;
order.setUser_id（Integer.parseInt（resultSet.getString（"user_id"）））;
order.setOrder_fukuangfangshi（resultSet.getString（"order_fukuangfangshi"））;
order.setOrder_zhuangtai（resultSet.getString（"order_zhuangtai"））;
order.setOrder_jine（resultSet.getString（"order_jine"））;
order.setOrder_songhuodizhi（resultSet.getString（"order_songhuodizhi"））;
order.setGoods_pic（resultSet.getString（"goods_pic"））;
order.setOrder_id（Integer.parseInt（resultSet.getString（"order_id"）））;
order.setOrder_date（resultSet.getString（"order_date"））;
order.setGoods_id（Integer.parseInt（resultSet.getString（"goods_id"）））;
order.setGoods_name（resultSet.getString（"goods_name"））;
order.setGoods_miaoshu（resultSet.getString（"goods_miaoshu"））;
order.setGoods_pic（resultSet.getString（"goods_pic"））;
order.setGoods_shichangjia（resultSet.getString（"goods_shichangjia"））;
order.setGoods_tejia（resultSet.getString（"goods_tejia"））;
order.setCatelog_id（resultSet.getString（"catelog_id"））;
//order.setShangjia_date（（String）resultSet.getString（"shangjia_date"））;
order.setBrand（resultSet.getString（"brand"））;
order.setSexrequest（resultSet.getString（"sexrequest"））;
order.setCommend（resultSet.getString（"commend"））;
order.setSellcount（resultSet.getString（"sellcount"））;
order.setClickcount（resultSet.getString（"clickcount"））;
goodsList.add（order）;
}
}catch（Exceptione）{
System.out.println（"Models.Teacher.getTeacherList!
Exception"）;
}finally{
CloseDBResource.close（resultSet,getResultSet.getStatement（）,getResultSet.getConnection（））;
}
returngoodsList;
}
}
buyService.Java
//处理购买的类
packageConsumers;
importMyUtils.ExecuteDML;
importjavax.servlet.RequestDispatcher;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
/**
*CreatedwithIntelliJIDEA.
*User:
Administrator
*Date:
12-12-19
*Time:
下午6:
43
*TochangethistemplateuseFile|Settings|FileTemplates.
*/
publicclassbuyServiceextendsHttpServlet{
publicvoiddoPost（HttpServletRequestrequest,HttpServletResponseresponse）{
try{
request.setCharacterEncoding（"utf-8"）;
Stringuser_id=（String）request.getSession（）.getAttribute（"user_id"）;
Stringgoods_id=request.getParameter（"goods_id"）;
Stringnumbers1=request.getParameter（"numbers1"）;
Stringnumbers=request.getParameter（"numbers"）;
intnumbers1int=Integer.parseInt（numbers1）;
intnumbersint=Integer.parseInt（numbers）;
//显示确认订单的信息
StringshowBookSql="select*fromt_order";
Stringsql="insertintot_order（book_id,user_id,order_date,order_fukuangfangshi）values（"+goods_id+","+user_id+","+"sysdateorder_fukuangfangshi+）";
Stringsql1="updatet_goodssetnumbers="+（numbersint-numbers1int）+"wheregoods_id="+goods_id;
ExecuteDMLexecuteDML=newExecuteDML（）;
executeDML.executeDmls（sql1）;
booleanisSuccess=executeDML.executeDmls（sql）;
Stringinfo="";
if（isSuccess）{
info="购买成功！
";
}else{
info="购买失败！
";
}
request.setAttribute（"info",info）;
RequestDispatcherrequestDispatcher=request.getRequestDispatcher（"info/ok.jsp"）;
requestDispatcher.forward（request,response）;
}catch（Exceptione）{
System.out.println（"LoginService.Login.doPost（）Exception"）;
}
}
publicvoiddoGet（HttpServletRequestrequest,HttpServletResponseresponse）{
doPost（request,response）;
}
}
ShowOrder.java
//显示订单类
packageConsumers;
importMyUtils.ExecuteDML;
importjavax.servlet.RequestDispatcher;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjava.util.List;
/**
*CreatedwithIntelliJIDEA.
*User:
Administrator
*Date:
13-5-17
*Time:
下午11:
31
*Tochangethistemplateus
升级会员 