cart.java~57~

只是一网站项目不错的可以看看的不看会后悔啊

package com.hygj.sunqi.j2ee.model;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
import java.io.*;
import java.util.*;
import java.sql.*;

public class Cart {
  //私有成员变量
  private ArrayList myCart = new ArrayList();
  private Connection conn=null;
  private Statement stmt=null;
  private ResultSet rs=null;
  private String classForName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=HYGJ";
  public Cart() {
  }
  //数据库连接
  public int conn(String userName,String passWd){
    String password = "";
    try{
      Class.forName(classForName);
      conn = DriverManager.getConnection(url,"sa","qaz123");
      stmt = conn.createStatement();
      String sql = "select userPwd from users where userName='"+userName+"'";
      rs = stmt.executeQuery(sql);
      while(rs.next()){
        password = rs.getString("userPwd");
      }

      stmt.close();
      conn.close();
      rs.close();
      if(passWd.equals(password)){
        System.out.println("登录成功");
        return 3;
      }else{
        System.out.println("登录失败");
        return 2;
      }

    }catch(Exception e){
      System.out.println(e.getMessage());
      return 0;
    }
  }
  //添加产品
  public void addProduct(Product parProduct){
    myCart.add(parProduct);
    System.out.println("你购买的物品是"+parProduct.getProductName()+",物品的价格为"+parProduct.getProductPrice());
  }
  //删除产品
  public void removeProduct(Product parProduct){
    int num = 0;
    int j = 0;//记录删除的次数
    if((num = myCart.size())!= 0){
      for(int i = 0; i < num; i++){
      Product temp = (Product)myCart.get(i);
      if(temp.getProductName().equals(parProduct.getProductName())
         && (temp.getProductPrice() == parProduct.getProductPrice())){
        myCart.remove(i);
        j++;
        break;
      }
    }
   }
   if(j == 0){
     System.out.println("没有你要删除的物品!");
   }else{
     System.out.println("你总共删除了"+j+"样物品!");
   }
  }
  //结算
  public float getTotalPrice(){
    float sum = 0;
    for(int i = 0;i < myCart.size();i++){
      Product temp = (Product)myCart.get(i);
      sum = sum + temp.getProductPrice();
    }
    return sum;
  }
  //列出所有产品
  public void listProduct(){
    System.out.println("你总共买了"+myCart.size()+"样物品");
    //System.out.println("你所买的物品及其价格为:");
    for(int i = 0; i < myCart.size(); i++){
    Product proInfo =(Product) myCart.get(i);
    System.out.print("你所买的第"+(i+1)+"样物品为:"+proInfo.getProductName()+",");
    System.out.println("价格为:"+proInfo.getProductPrice()+"元");
    }
  }
  //列出有多少个商品
  public int getNum(){
    int number = myCart.size();
    return number;
  }
  //入口函数
  public static void main(String[] args){
    System.out.println("欢迎登陆麒麟购物系统:");
    Cart cart1 = new Cart();
    String selInfo = "";
    String productInfo = "";
    String productInfo2 = "";
    float productInfo3 = 0;
    int selInfo1 = 0;
    //循环
    while (true) {
      System.out.println("1.购物");
      System.out.println("2.删除");
      System.out.println("3.结算");
      System.out.println("4.列出物品");
      System.out.println("5.退出");
      BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
      try{
         selInfo= br.readLine();
      }catch(Exception e){
        System.out.println(e.getMessage());
      }
      try{
        selInfo1 = Integer.parseInt(selInfo);
      }catch(Exception ec){
        System.out.println("请输入整数!");
        continue;
        //System.out.println("kd");
        //System.out.println(ec.getMessage());
      }
      //判断选择1,2,3,4,5,其它的都重新输入
      if(selInfo1 == 1 || selInfo1 == 2 || selInfo1 == 3 || selInfo1 == 4 || selInfo1 == 5){
        switch (selInfo1) {
        case 1:
          System.out.println("请输入产品的名称与价格:(以逗号分隔)");
          try{
            productInfo = br.readLine();
            int flag1 = productInfo.indexOf(",");
            //判断输入是否以逗号分隔,否则重新输入
            if(flag1 < 0){
              System.out.println("请以逗号分隔!!!");
              break;
            }else{
              String[] productInfoArr = productInfo.split(",");
              //判断逗号后是否输入的是数字
              try{
                productInfo3 = Float.parseFloat(productInfoArr[1]);
              }catch(Exception ed){
                System.out.println("逗号后请输入数字,谢谢合作!!!");
                break;
                //System.out.println(ed.getMessage());
              }
              Product product = new Product(productInfoArr[0],productInfo3);
              cart1.addProduct(product);
              break;
            }
          }
          catch (Exception ea) {
            System.out.println(ea.getMessage());
            break;
          }

          case 2:
            int number1 = cart1.getNum();
            if(number1 == 0){
              System.out.println("你没有物品可以删除!");
              break;
            }else{
              System.out.println("请输入要删除的产品信息:(以逗号分隔)");
          try{
            productInfo2 = br.readLine();
            int flag1 = productInfo2.indexOf(",");
            //判断输入是否以逗号分隔,否则重新输入
            if (flag1 < 0) {
              System.out.println("请以逗号分隔!!!");
              break;
            }
            else {
              String[] productInfoArr = productInfo2.split(",");
              //判断逗号后是否输入的是数字
              try {
                productInfo3 = Float.parseFloat(productInfoArr[1]);
              }
              catch (Exception ed) {
                System.out.println("逗号后请输入数字,谢谢合作!!!");
                break;
                //System.out.println(ed.getMessage());
              }
            }
          }
          catch (Exception eb) {
            System.out.println(eb.getMessage());
            break;
          }
          String[] productInfoArr2 = productInfo2.split(",");
          Product product2 = new Product(productInfoArr2[0],
                                         Float.parseFloat(productInfoArr2[1]));
          cart1.removeProduct(product2);
          break;
        }
        case 3:
          String userName = "";
          int number2 = cart1.getNum();
          if(number2 == 0){
            System.out.println("你没有物品可以结算!");
            break;
          }else{
            System.out.println("请输入你的用户名及密码:(以逗号分隔)");
            try{
              userName = br.readLine();
            }catch(Exception ee){
              System.out.println(ee.getMessage());
              break;
            }

            System.out.println(userName.indexOf(",")+" "+userName.length());
            if(userName.indexOf(",") < 0&&userName.indexOf(",")==(userName.length()-1)){
              System.out.println("你输入的格式不正确,请以逗号分隔!");
              break;
            }else{
              String[] user = userName.split(",");
              int flag2 = cart1.conn(user[0],user[1]);//flag2判断是否连接成功标志
              //System.out.println(user[0]+"+"+user[1]);
              //System.out.println("flag2="+flag2);
              if(flag2 ==3){
                System.out.println("你所买的产品的总价钱共计为:" + cart1.getTotalPrice()+"元");
                break;
              }
            }
          }
          break;
        case 4:
          cart1.listProduct();
          break;
        case 5:
          System.out.println("谢谢使用!");
          return;
      }

      }else{
        System.out.println("你输入的格式不正确,只能输入1,2,3,4,5!!!");
        }
    }
  }

}