Supermarket-Billing-System-Base-JavaFx/Main.java at main · simul49/Supermarket-Billing-System-Base-JavaFx · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103


//package Database;
//
//import java.sql.SQLException;
//
//public class Main {
//    public static void main(String[] args) {
//        Casher casher = new Casher();
//        casher.setCasherId)(1;
//        casher.setName("John Doe");
//
//        CashMachineInfo machine = new CashMachineInfo();
//        machine.setMachineId(101);
//        machine.setLocation("Main Store");
//
//        ProductInfo product = new ProductInfo();
//        product.setProductId(1001);
//        product.setProductName("Product A");
//        product.setPrice(9.99);
//
//        SaleInfo sale = new SaleInfo();
//        sale.setSaleId(1);
//        sale.setCasherId(1);
//        sale.setMachineId(101);
//
//        SaleDetailInfo saleDetail = new SaleDetailInfo();
//        saleDetail.setDetailId(1);
//        saleDetail.setSaleId(1);
//        saleDetail.setProductId(1001);
//        saleDetail.setQuantity(2);
//        saleDetail.setTotalPrice(19.98);
//
//        try {
//            CasherDAO casherDAO = new CasherDAO();
//            casherDAO.addCasher(casher);
//
//            CashMachineInfoDAO machineDAO = new CashMachineInfoDAO();
//            machineDAO.addCashMachineInfo(machine);
//
//            ProductInfoDAO productDAO = new ProductInfoDAO();
//            productDAO.addProductInfo(product);
//
//            SaleInfoDAO saleDAO = new SaleInfoDAO();
//            saleDAO.addSaleInfo(sale);
//
//            SaleDetailInfoDAO saleDetailDAO = new SaleDetailInfoDAO();
//            saleDetailDAO.addSaleDetailInfo(saleDetail);
//        } catch (SQLException e) {
//            e.printStackTrace();
//        }
//    }
//}


package Database;
import java.sql.SQLException;

public class Main {
    public static void main(String[] args) {
        Casher casher = new Casher();
        casher.setName("Mr Java"); // No need to set casherId

        CashMachineInfo machine = new CashMachineInfo();
        machine.setLocation(" Java Store"); // No need to set machineId

        ProductInfo product = new ProductInfo();
        product.setProductName("Product  Java Fx");
        product.setPrice(9.99); // No need to set productId

        SaleInfo sale = new SaleInfo();
        // saleId will be auto-incremented
        sale.setCasherId(1); // Must exist in Casher table
        sale.setMachineId(101); // Must exist in CashMachineInfo table

        SaleDetailInfo saleDetail = new SaleDetailInfo();
        // detailId will be auto-incremented
        saleDetail.setSaleId(1); // Must exist in SaleInfo table
        saleDetail.setProductId(1001); // Must exist in ProductInfo table
        saleDetail.setQuantity(2);
        saleDetail.setTotalPrice(19.98);

        try {
            CasherDAO casherDAO = new CasherDAO();
            casherDAO.addCasher(casher);

            CashMachineInfoDAO machineDAO = new CashMachineInfoDAO();
            machineDAO.addCashMachineInfo(machine);

            ProductInfoDAO productDAO = new ProductInfoDAO();
            productDAO.addProductInfo(product);

            SaleInfoDAO saleDAO = new SaleInfoDAO();
            saleDAO.addSaleInfo(sale);

            SaleDetailInfoDAO saleDetailDAO = new SaleDetailInfoDAO();
            saleDetailDAO.addSaleDetailInfo(saleDetail);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}