Java 与SQL 2005 购物管理系统

package com.operation; import com.entity.*; import com.util.*; import java.sql.*; import java.util.*; public class ShoppingGoods { private Connection con; private PreparedStatement GoodsQuery; private ResultSet result; GoodsBean goodsData=new GoodsBean(); ShoppingCart cart=new ShoppingCart(); List cartList=new ArrayList(); int total=0; //List cart=new ArrayList(); GoodsOperation go=new GoodsOperation(); CustomerOperation co=new CustomerOperation(); Scanner read=new Scanner(System.in); private int i; public void showGoods(){ GoodsOperation go=new GoodsOperation(); List goods=go.getGoods(); for(int i=0;i<goods.size();i++){ GoodsBean gb=new GoodsBean(); gb=(GoodsBean)goods.get(i); gb.Show(); } } public void Shopping(){ System.out.println("购物管理系统 > 购 物 结 算"); go.showGoods(); System.out.print("您是会员吗？输入y/n："); String p=read.next(); if(p.equals("y")) { System.out.print("请输入会员编号："); int no=read.nextInt(); System.out.println("您的信息为："); if(co.getCustomersById(no)) { System.out.print("输入数字任意数字进行购物！否则输入0:"); int a=read.nextInt(); if(a!=0) { go.showGoods(); System.out.print("\n请输入购买商品的编号："); int id=read.nextInt(); goodsData=go.selectGoodsById(id); //把数据库中的信息放入goodsData中 cart.setPrice(goodsData.getPrice()); //把goodsData的价格放进购物车 cart.setId(id); //把id放进购物车 System.out.print("\n请输入购买的数量："); int count=read.nextInt(); cart.setCount(count); total+=goodsData.getPrice()*count; System.out.println("商品单价为："+goodsData.getPrice()); if(go.JugeGoods(id, count)) { cartList.add(cart); System.out.print("\n输入任意数字进行购物，否则输入0:"); a=read.nextInt(); } else{ System.out.println("您没有购买任何商品，谢谢光临！"); returnShopping(); } } else{ System.out.println("您没有购买任何商品，谢谢光临！"); returnShopping(); } System.out.print("您确实要购买吗？y/n:"); String str=read.next(); if(str.equals("y")) { for(int i=0;i<cartList.size();i++) { ShoppingCart cart=(ShoppingCart)cartList.get(i); updateCount(go.getCount(cart.getId())-cart.getCount(),cart.getId()); //更新物品数量 co.UpdataCustomerScroe(cart.getId(), total, go.getGoodsPrice(cart.getId())); //根据总消费更新顾客积分 } go.showGoods(); calPayment(); returnShopping(); //System.out.println("\n商品总价格为："+total); }else{ System.out.println("您没有购买任何商品，谢谢光临！"); returnShopping(); } } else{ System.out.println("您不是会员！"); } } //申请会员 else { System.out.print("您要注册会员吗？y/n："); String r=read.next(); if(r.equals("y")) { co.addCustomers(); System.out.print("输入数字1进行购物！"); int a=read.nextInt(); if(a!=0) { go.showGoods(); System.out.print("请输入您要购买的商品编号："); int id=read.nextInt(); goodsData=go.selectGoodsById(id); //把数据库中的信息放入goodsData中 cart.setPrice(goodsData.getPrice()); //把goodsData的价格放进购物车 cart.setId(id); //把id放进购物车 System.out.print("请输入购买的数量："); int count=read.nextInt(); cart.setCount(count); total+=goodsData.getPrice()*count; System.out.println("商品单价为："+goodsData.getPrice()); if(go.JugeGoods(id, count)) { cartList.add(cart); System.out.print("输入任意数字进行购物，否则输入0："); a=read.nextInt(); } else{ System.out.println("您没有购买任何商品，谢谢光临！"); returnShopping(); } System.out.print("您确实要购买吗？y/n:"); String str=read.next(); if(str.equals("y")) { for(int i=0;i<cartList.size();i++) { ShoppingCart cart=(ShoppingCart)cartList.get(i); updateCount(go.getCount(cart.getId())-cart.getCount(),cart.getId()); //更新物品数量 co.UpdataCustomerScroe(cart.getId(), total, go.getGoodsPrice(cart.getId()));//根据总消费更新顾客积分 } go.showGoods(); //System.out.print("\n商品总价格为："+total); calPayment(); returnShopping(); }else{ System.out.println("您没有购买任何商品，谢谢光临！"); returnShopping(); } }else{ System.out.println("您没有购买任何商品，谢谢光临！"); returnShopping(); } } //普通用户购买 else { System.out.print("\n输入数字1进行购物！"); { int a=read.nextInt(); go.showGoods(); System.out.print("\n请输入购买商品的编号："); int id=read.nextInt(); goodsData=go.selectGoodsById(id); //把数据库中的信息放入goodsData中 cart.setPrice(goodsData.getPrice()); //把goodsData的价格放进购物车 cart.setId(id); //把id放进购物车 System.out.print("\n请输入购买的数量："); int count=read.nextInt(); cart.setCount(count); total+=goodsData.getPrice()*count; System.out.println("商品单价为："+goodsData.getPrice()); if(go.JugeGoods(id, count)) { cartList.add(cart); System.out.println("\n输入任意数字进行购物，否则输入0："); a=read.nextInt(); }else{ System.out.println("您没有购买任何商品，谢谢光临！"); returnShopping(); } System.out.print("您确实要购买吗？y/n:"); String str=read.next(); if(str.equals("y")) { for(int i=0;i<cartList.size();i++) { ShoppingCart cart=(ShoppingCart)cartList.get(i); updateCount(go.getCount(cart.getId())-cart.getCount(),cart.getId());//更新物品数量 co.UpdataCustomerScroe(cart.getId(), total, go.getGoodsPrice(cart.getId()));//根据总消费更新顾客积分 } go.showGoods(); calPayment(); returnShopping(); //System.out.println("\n商品总价格为："+total); }else{ System.out.println("您没有购买任何商品，谢谢光临！"); returnShopping(); } } } } } public void returnShopping(){ System.out.println("请输入数字5返回上级菜单!"); int n=read.nextInt(); boolean exits; do{ if(n==5){ exits=true; Shopping(); }else{ System.out.print("输入错误, 请重新输入字母n返回上一级菜单："); exits = false; } }while(!exits); } public void calPayment(){ System.out.println("购物管理系统 > 购 物 结 算 "); System.out.println("您选择的商品总价为:"+total+"元"); System.out.print("您付了："); int pain=read.nextInt(); if(pain>=total) { System.out.println("您购买的商品 信息为："); cart.Show(); System.out.println("您付了"+pain+"元"+"一共找您:"+(pain-total)+"元,欢迎下次光临！"); returnShopping(); } else { System.out.println("对不起，您所所付的金额不足！"); Shopping(); } } public void updateCount(int count,int id){ con=ConnectionManager.getConnection(); String Sql="Update Goods set amount=? where id=?"; try { GoodsQuery=con.prepareStatement(Sql); GoodsQuery.setInt(1,count); G