超市管理项目-7 采购员的功能实现类

1.商品补货

//先查询所有商品的id和名字
public void selectGoods(){
        String sqln = "select * from goods";
        List<Goods> goods = JDBCUntil.select(sqln, "goods");
        for (Goods goods1:goods){
            System.out.println("商品编号："+goods1.getGoodsId()+",商品名称："+goods1.getGoodsName());
        }
    }

//商品补货
    @Override
    public void addGoods() {
        selectGoods();
        String sql = "update goods set inventory = inventory+? where c_number=?";
        Goods goods = new Goods();
        System.out.println("请输入要补货的货物编号:");
        goods.setGoodsId(sc.nextInt());
        System.out.println("请输入要进行补货的数量:");
        goods.setGoodsStock(sc.nextInt());
        JDBCUntil.updates(sql,goods.getGoodsStock(),goods.getGoodsId());
        //写入进货单
        String sqls = "insert into add_goods values(?,?,?,?)";
        JDBCUntil.updates(sqls,goods.getGoodsId(),goods.getGoodsStock(),new Date(),JDBCUntil.number);
    }

2.进货单

//进货单
    @Override
    public void buyerUpdate() {
        String sql = "select * from add_goods";
        List addgoods = JDBCUntil.select(sql, "addgoods");
        addgoods.forEach(System.out::println);
    }

3.打卡

@Override
    public void clock_in() {
        System.out.println("1.上班打卡 2.下班打卡 3.2021年4月上班打卡 4.2021年4月下班打卡 5.退出");
        int i = sc.nextInt();
        switch (i){
            case 1:
                JDBCUntil.clockIn();
                break;
            case 2:
                JDBCUntil.clockOut();
                break;
            case 3:
                JDBCUntil.clockIns();
                break;
            case 4:
                JDBCUntil.clockOuts();
                break;
            case 5:
                return;
            default:
                break;
        }
    }

4.采购员的功能实现整体代码

@SuppressWarnings("all")
/**
 * @ClassName BuyerImpl
 * @Description 采购员实现类
 * @Author chenxys
 * @Date 2022/3/11 12:27
 * @Version
 */
public class BuyerImpl implements BuyerDao{
    Scanner sc = new Scanner(System.in);
    public boolean isRun = true;
    //主方法
    public boolean execute(){
        while (JDBCUntil.isIsOk()){
            System.out.println("请输入你要进行的操作：");
            System.out.println("1.进行商品补货 2.查询进货单");
            System.out.println("3.打卡 4.退出");
            int i = sc.nextInt();
            switch (i){
                case 1:
                    addGoods();
                    break;
                case 2:
                    buyerUpdate();
                    break;
                case 3:
                    clock_in();
                    break;
                case 4:
                    return isRun = false;
                default:
                    break;
            }
        }
        return isRun;
    }
    //商品补货
    @Override
    public void addGoods() {
        selectGoods();
        String sql = "update goods set inventory = inventory+? where c_number=?";
        Goods goods = new Goods();
        System.out.println("请输入要补货的货物编号:");
        goods.setGoodsId(sc.nextInt());
        System.out.println("请输入要进行补货的数量:");
        goods.setGoodsStock(sc.nextInt());
        JDBCUntil.updates(sql,goods.getGoodsStock(),goods.getGoodsId());
        //写入进货单
        String sqls = "insert into add_goods values(?,?,?,?)";
        JDBCUntil.updates(sqls,goods.getGoodsId(),goods.getGoodsStock(),new Date(),JDBCUntil.number);
    }
    //进货单
    @Override
    public void buyerUpdate() {
        String sql = "select * from add_goods";
        List addgoods = JDBCUntil.select(sql, "addgoods");
        addgoods.forEach(System.out::println);
    }
    @Override
    public void clock_in() {
        System.out.println("1.上班打卡 2.下班打卡 3.2021年4月上班打卡 4.2021年4月下班打卡 5.退出");
        int i = sc.nextInt();
        switch (i){
            case 1:
                JDBCUntil.clockIn();
                break;
            case 2:
                JDBCUntil.clockOut();
                break;
            case 3:
                JDBCUntil.clockIns();
                break;
            case 4:
                JDBCUntil.clockOuts();
                break;
            case 5:
                return;
            default:
                break;
        }
    }
    public void selectGoods(){
        String sqln = "select * from goods";
        List<Goods> goods = JDBCUntil.select(sqln, "goods");
        for (Goods goods1:goods){
            System.out.println("商品编号："+goods1.getGoodsId()+",商品名称："+goods1.getGoodsName());
        }
    }
}