package com.osiit.myShop.service;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import java.util.Set;
import com.osiit.myShop.bean.BigClass;
import com.osiit.myShop.bean.Commodity;
import com.osiit.myShop.bean.Review;
import com.osiit.myShop.bean.SmallClass;
import com.osiit.myShop.util.MyJdbc;
public class CommodityService {
public void saveCommodity(Commodity commodity) {
MyJdbc jdbc = new MyJdbc();
String sql = "insert into commodity values ('"
+ commodity.getCommodityName() + "','"
+ commodity.getCommodityComment() + "','"
+ commodity.getCommodityFormat() + "','"
+ commodity.getCommodityUnit() + "',"
+ commodity.getCommodityMarketPrice() + ","
+ commodity.getCommodityMember() + ","
+ commodity.getCommodityVipPrice() + ",'"
+ commodity.getCommodityImage() + "','"
+ commodity.getCommodityCaption() + "',"
+ commodity.getSmallClass().getSmallClassId() + ")";
jdbc.openConn();
jdbc.executeUpdate(sql);
jdbc.closeStAndConn();
}
public List<Commodity> getAllCommodity() {
List<Commodity> list = new ArrayList<Commodity>();
String sql = "select * from commodity";
MyJdbc jdbc = new MyJdbc();
jdbc.openConn();
ResultSet rs = jdbc.excuteQuery(sql);
try {
while (rs.next()) {
String commodityName = rs.getString("commodity_name");
String commodityComment = rs.getString("commodity_comment");
String commodityFormat = rs.getString("commodity_format");
String commodityUnit = rs.getString("commodity_unit");
Float commodityMarketPrice = rs
.getFloat("commodity_market_price");
Float commodityMember = rs.getFloat("commodity_member");
Float commodityVipPrice = rs.getFloat("commodity_vip_price");
String commodityImage = rs.getString("commodity_image");
String commodityCaption = rs.getString("commodity_caption");
Integer commodityId = rs.getInt("commodity_id");
Integer smallClassId = rs.getInt("small_class_id");
Commodity commodityBean = new Commodity();
commodityBean.setCommodityCaption(commodityCaption);
commodityBean.setCommodityComment(commodityComment);
commodityBean.setCommodityFormat(commodityFormat);
commodityBean.setCommodityId(commodityId);
commodityBean.setCommodityImage(commodityImage);
commodityBean.setCommodityMarketPrice(commodityMarketPrice);
commodityBean.setCommodityMember(commodityMember);
commodityBean.setCommodityName(commodityName);
commodityBean.setCommodityUnit(commodityUnit);
commodityBean.setCommodityVipPrice(commodityVipPrice);
SmallClassService smallClassService = new SmallClassService();
SmallClass smallClass = smallClassService
.getOneSmallClass(smallClassId);
smallClass.setSmallClassId(smallClassId);
list.add(commodityBean);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
jdbc.closeStAndConn();
return list;
}
public void deleteCommodity(String commodityIds[]) {
MyJdbc jdbc = new MyJdbc();
jdbc.openConn();
for (String commodityId : commodityIds) {
String sql = "delete from commodity where commodity_id="
+ commodityId;
jdbc.executeUpdate(sql);
}
jdbc.closeStAndConn();
}
public Commodity getOneCommodityById(int commodityId) {
Commodity commodityBean = new Commodity();
String sql = "select * from commodity where commodity_id="
+ commodityId;
MyJdbc jdbc = new MyJdbc();
jdbc.openConn();
ResultSet rs = jdbc.excuteQuery(sql);
try {
while (rs.next()) {
String commodityName = rs.getString("commodity_name");
String commodityComment = rs.getString("commodity_comment");
String commodityFormat = rs.getString("commodity_format");
String commodityUnit = rs.getString("commodity_unit");
Float commodityMarketPrice = rs
.getFloat("commodity_market_price");
Float commodityMember = rs.getFloat("commodity_member");
Float commodityVipPrice = rs.getFloat("commodity_vip_price");
String commodityImage = rs.getString("commodity_image");
String commodityCaption = rs.getString("commodity_caption");
Integer smallClassId = rs.getInt("small_class_id");
commodityBean.setCommodityCaption(commodityCaption);
commodityBean.setCommodityComment(commodityComment);
commodityBean.setCommodityFormat(commodityFormat);
commodityBean.setCommodityId(commodityId);
commodityBean.setCommodityImage(commodityImage);
commodityBean.setCommodityMarketPrice(commodityMarketPrice);
commodityBean.setCommodityMember(commodityMember);
commodityBean.setCommodityName(commodityName);
commodityBean.setCommodityUnit(commodityUnit);
commodityBean.setCommodityVipPrice(commodityVipPrice);
SmallClassService smallClassService = new SmallClassService();
SmallClass smallClass = smallClassService
.getOneSmallClass(smallClassId);
commodityBean.setSmallClass(smallClass);
ReviewService reviewService=new ReviewService();
Set<Review> reviews=reviewService.getAllReviewByCommodityId(commodityId);
commodityBean.setReviews(reviews);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
jdbc.closeStAndConn();
return commodityBean;
}
public void updateCommodity(Commodity commodity) {
MyJdbc jdbc = new MyJdbc();
String sql = "update commodity set commodity_name='"
+ commodity.getCommodityName() + "',commodity_comment='"
+ commodity.getCommodityComment() + "',commodity_format='"
+ commodity.getCommodityFormat() + "',commodity_unit='"
+ commodity.getCommodityUnit() + "',commodity_market_price="
+ commodity.getCommodityMarketPrice() + ",commodity_member="
+ commodity.getCommodityMember() + ",commodity_vip_price="
+ commodity.getCommodityVipPrice() + ",commodity_image='"
+ commodity.getCommodityImage() + "',commodity_caption='"
+ commodity.getCommodityCaption() + "',small_class_id="
+ commodity.getSmallClass().getSmallClassId()
+ " where commodity_id=" + commodity.getCommodityId();
jdbc.openConn();
jdbc.executeUpdate(sql);
jdbc.closeStAndConn();
}
public List<Commodity> getAllCommodityByBigClassId(
Set<SmallClass> smallClasses) {
List<Commodity> list = new ArrayList<Commodity>();
for (SmallClass smallClassBean : smallClasses) {
String sql = "select * from commodity where small_class_id="
+ smallClassBean.getSmallClassId();
MyJdbc jdbc = new MyJdbc();
jdbc.openConn();
ResultSet rs = jdbc.excuteQuery(sql);
try {
while (rs.next()) {
String commodityName = rs.getString("commodity_name");
String commodityComment = rs.getString("commodity_comment");
String commodityFormat = rs.getString("commodity_format");
String commodityUnit = rs.getString("commodity_unit");
Float commodityMarketPrice = rs
.getFloat("commodity_market_price");
Float commodityMember = rs.getFloat("commodity_member");
Float commodityVipPrice = rs
.getFloat("commodity_vip_price");
String commodityImage = rs.getString("commodity_image");
String commodityCaption = rs.getString("commodity_caption");
Integer commodityId = rs.getInt("commodity_id");
Integer smallClassId = rs.getInt("small_class_id");
Commodity commodityBean = new Commodity();
commodityBean.setCommodityCaption(commodityCaption);
commodityBean.setCommodityComment(commodityComment);
commodityBean.setCommodityFormat(commodityFormat);
commodityBean.setCommodityId(commodityId);
commodityBean.setCommodityImage(commodityImage);
commodityBean.setCommodityMarketPrice(commodityMarketPrice);
commodityBean.setCommodityMember(commodityMember);
commodityBean.setCommodityName(commodityName);
commodityBe
jsp版的在线商城sqlserver数据库
3星 · 超过75%的资源 需积分: 9 37 浏览量
2010-08-20
16:50:24
上传
评论
收藏 2.41MB RAR 举报 
jsp版的在线商城sqlserver数据库 （546个子文件） 
CommodityService.class 11KB OrderService.class 11KB CommodityServlet.class 11KB ReviewService.class 8KB OrderServlet.class 8KB UserInfoServlet.class 6KB UserInfoService.class 6KB ReviewServlet.class 6KB RemainService.class 5KB Order.class 5KB FileUploadServlet.class 5KB SmallClassService.class 4KB RemainServlet.class 4KB UserInfo.class 4KB Commodity.class 4KB BigClassService.class 4KB SmallClassServlet.class 4KB BigClassServlet.class 3KB OrderCommodityService.class 3KB Review.class 3KB ReplyServlet.class 3KB Remain.class 3KB WebSet.class 3KB InitServlet.class 3KB ReplyService.class 3KB ReplyReviewService.class 3KB ReplyReviewServlet.class 3KB MyJdbc.class 2KB Dtproperties.class 2KB SmallClass.class 2KB OrderCommodity.class 2KB BigClass.class 2KB Reply.class 2KB Administrator.class 2KB FriendlyUrl.class 2KB DtpropertiesId.class 2KB Bulletin.class 1KB ReplyReview.class 1KB .classpath 738B index.css 21KB header.css 15KB header1.css 15KB css.css 8KB pop.css 5KB css.css 3KB css.css 3KB css.css 2KB manage.css 2KB style.css 2KB style.css 2KB qq.css 473B nbase1.css 442B body.Fix 3KB Head.Fix 54B
serche.gif 90KB 200622122321784974.gif 32KB 200622121482878345.gif 23KB vendor_img.gif 22KB 200621715125096857.gif 21KB 20062212294473168.gif 20KB topbg.gif 9KB zhifu_99bill.gif 8KB vendor_stit02.gif 8KB login_1.gif 8KB p_dtitle01.gif 7KB views.gif 7KB zhifu_westpay.gif 7KB zhifu_nps.gif 7KB test_03.gif 7KB vendor_stit01.gif 6KB boy.gif 6KB zhifu_zhfb.gif 6KB girl.gif 5KB sertop.gif 5KB logo.gif 5KB zhifu_y.gif 5KB loading.gif 5KB zhifu_wangyin.gif 4KB left01.gif 4KB left04.gif 4KB left02.gif 4KB searc.gif 4KB 200610191514657141.gif 3KB left06.gif 3KB left03.gif 3KB index_2.gif 3KB heard.gif 3KB left05.gif 3KB trend.gif 3KB inform.gif 3KB 200610191514657144.gif 3KB login5.gif 3KB p_bg01.gif 3KB alipay_bwrm.gif 3KB alipay.gif 3KB buy1.gif 3KB login4.gif 3KB fav.gif 3KB pdbg01.gif 2KB pdbg01.gif 2KB共 546 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
yjsh13142014-02-13good,课程设计啊
云水丶2015-01-28演示版，代码不全，可以借鉴一下
