超市管理项目-6 收银员(销售员)功能实现类

1.收银结算(数据库中存在触发器，所以不需要修改商品表和会员表)

 //收银结算
    @Override
    public void cashierSettlement() {
        //修改库存表
        Sell_Info sell_info = new Sell_Info();
        //获取商品编号
        String sql = "insert into sell_info values(?,?,?,?,?)";
        System.out.println("请输入商品编号：");
        sell_info.setS_c_number(sc.nextInt());
        System.out.println("请输入售出数量：");
        sell_info.setS_quantity(sc.nextInt());
        //销售时间
        sell_info.setS_time(new java.util.Date());
        //销售人员编号
        sell_info.setS_e_number(JDBCUntil.number);
        //会员编号
        System.out.println("是否是会员：(y/n)");
        if ("y".equals(sc.next())){
            System.out.println("请输入会员编号：");
            sell_info.setS_vip_number(sc.next());
        }else {
            sell_info.setS_vip_number(null);
        }
        JDBCUntil.updates(sql,sell_info.getS_c_number(),
                sell_info.getS_quantity(),sell_info.getS_time(),
                sell_info.getS_e_number(),sell_info.getS_vip_number());
    }

2.查询会员积分

 //查询积分
    @Override
    public void cashierSelect() {
        String vips = "vip";
        System.out.println("1.查询全部会员 2.查询单个会员");
        int i = sc.nextInt();
        switch (i){
            case 1:
                String sqls = "select * from vip ";
                List vip = JDBCUntil.select(sq