Beispiel #1
0
  private void GenerateAdminNoActionPerformed(
      java.awt.event.ActionEvent evt) { // GEN-FIRST:event_GenerateAdminNoActionPerformed

    int IntAdminNo = 0;
    String prodID;

    try {
      Class.forName("com.mysql.jdbc.Driver");
      Connection con =
          DriverManager.getConnection("jdbc:mysql://localhost:3306/VunaFeeds", "root", "");
      Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
      ResultSet rs = stmt.executeQuery("Select * from product where Status = 'Active'");
      if (rs.last()) {
        String adminNo = rs.getString("ProductID");
        IntAdminNo = Integer.valueOf(adminNo);
        System.out.println(IntAdminNo);
        IntAdminNo++;
        prodID = String.valueOf(IntAdminNo);
        ProductID.setText(prodID);
      } else {
        IntAdminNo = 1;
        prodID = String.valueOf(IntAdminNo);
        ProductID.setText(prodID);
      }

      ProductID.setEditable(false);
    } catch (SQLException e) {

      System.out.println("2 Error : " + e);
      JOptionPane.showMessageDialog(null, "Oops!! An error occured. \n " + e);
    } catch (Exception ex) {
      System.out.println("Error 1:" + ex);
      JOptionPane.showMessageDialog(null, "Oops!! An error occured. \n" + ex);
    }
  } // GEN-LAST:event_GenerateAdminNoActionPerformed
Beispiel #2
0
  /**
   * This method is called from within the constructor to initialize the form. WARNING: Do NOT
   * modify this code. The content of this method is always regenerated by the Form Editor.
   */
  @SuppressWarnings("unchecked")
  // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
  private void initComponents() {

    jPanel1 = new javax.swing.JPanel();
    jLabel1 = new javax.swing.JLabel();
    jLabel3 = new javax.swing.JLabel();
    jLabel4 = new javax.swing.JLabel();
    jLabel5 = new javax.swing.JLabel();
    ProductID = new javax.swing.JFormattedTextField();
    productName = new javax.swing.JTextField();
    admit = new javax.swing.JButton();
    DisplayDate = new javax.swing.JLabel();
    GenerateAdminNo = new javax.swing.JButton();
    jScrollPane1 = new javax.swing.JScrollPane();
    descript = new javax.swing.JTextPane();

    setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
    setTitle("Product");

    jPanel1.setBackground(new java.awt.Color(255, 255, 255));

    jLabel1.setBackground(new java.awt.Color(110, 189, 235));
    jLabel1.setFont(new java.awt.Font("Cambria", 1, 24));
    jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
    jLabel1.setText("Product");
    jLabel1.setOpaque(true);

    jLabel3.setText("Product ID:");

    jLabel4.setText("Product Name");

    jLabel5.setText("Description:");

    ProductID.setFormatterFactory(
        new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.NumberFormatter()));

    admit.setBackground(new java.awt.Color(255, 255, 255));
    admit.setText("Save");
    admit.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(110, 189, 235), 2, true));
    admit.addActionListener(
        new java.awt.event.ActionListener() {
          public void actionPerformed(java.awt.event.ActionEvent evt) {
            admitActionPerformed(evt);
          }
        });

    GenerateAdminNo.setBackground(new java.awt.Color(255, 255, 255));
    GenerateAdminNo.setText("Generate");
    GenerateAdminNo.setBorder(
        new javax.swing.border.LineBorder(new java.awt.Color(110, 189, 235), 2, true));
    GenerateAdminNo.addActionListener(
        new java.awt.event.ActionListener() {
          public void actionPerformed(java.awt.event.ActionEvent evt) {
            GenerateAdminNoActionPerformed(evt);
          }
        });

    jScrollPane1.setViewportView(descript);

    javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
    jPanel1.setLayout(jPanel1Layout);
    jPanel1Layout.setHorizontalGroup(
        jPanel1Layout
            .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(
                jPanel1Layout
                    .createSequentialGroup()
                    .addContainerGap()
                    .addGroup(
                        jPanel1Layout
                            .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(
                                DisplayDate,
                                javax.swing.GroupLayout.Alignment.TRAILING,
                                javax.swing.GroupLayout.PREFERRED_SIZE,
                                182,
                                javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(
                                jLabel1,
                                javax.swing.GroupLayout.Alignment.TRAILING,
                                javax.swing.GroupLayout.DEFAULT_SIZE,
                                386,
                                Short.MAX_VALUE)
                            .addGroup(
                                jPanel1Layout
                                    .createSequentialGroup()
                                    .addGroup(
                                        jPanel1Layout
                                            .createParallelGroup(
                                                javax.swing.GroupLayout.Alignment.LEADING)
                                            .addComponent(
                                                jLabel3,
                                                javax.swing.GroupLayout.DEFAULT_SIZE,
                                                70,
                                                Short.MAX_VALUE)
                                            .addComponent(
                                                jLabel4,
                                                javax.swing.GroupLayout.DEFAULT_SIZE,
                                                70,
                                                Short.MAX_VALUE)
                                            .addComponent(
                                                jLabel5,
                                                javax.swing.GroupLayout.DEFAULT_SIZE,
                                                70,
                                                Short.MAX_VALUE))
                                    .addPreferredGap(
                                        javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addGroup(
                                        jPanel1Layout
                                            .createParallelGroup(
                                                javax.swing.GroupLayout.Alignment.LEADING)
                                            .addComponent(
                                                productName,
                                                javax.swing.GroupLayout.DEFAULT_SIZE,
                                                188,
                                                Short.MAX_VALUE)
                                            .addComponent(
                                                ProductID,
                                                javax.swing.GroupLayout.DEFAULT_SIZE,
                                                188,
                                                Short.MAX_VALUE)
                                            .addComponent(
                                                jScrollPane1,
                                                javax.swing.GroupLayout.DEFAULT_SIZE,
                                                188,
                                                Short.MAX_VALUE))
                                    .addGap(30, 30, 30)
                                    .addGroup(
                                        jPanel1Layout
                                            .createParallelGroup(
                                                javax.swing.GroupLayout.Alignment.TRAILING)
                                            .addComponent(
                                                admit,
                                                javax.swing.GroupLayout.DEFAULT_SIZE,
                                                94,
                                                Short.MAX_VALUE)
                                            .addComponent(
                                                GenerateAdminNo,
                                                javax.swing.GroupLayout.PREFERRED_SIZE,
                                                94,
                                                javax.swing.GroupLayout.PREFERRED_SIZE))))
                    .addContainerGap()));
    jPanel1Layout.setVerticalGroup(
        jPanel1Layout
            .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(
                jPanel1Layout
                    .createSequentialGroup()
                    .addComponent(
                        jLabel1,
                        javax.swing.GroupLayout.PREFERRED_SIZE,
                        53,
                        javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGap(18, 18, 18)
                    .addComponent(
                        DisplayDate,
                        javax.swing.GroupLayout.PREFERRED_SIZE,
                        29,
                        javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(
                        javax.swing.LayoutStyle.ComponentPlacement.RELATED, 36, Short.MAX_VALUE)
                    .addGroup(
                        jPanel1Layout
                            .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel3)
                            .addComponent(
                                ProductID,
                                javax.swing.GroupLayout.PREFERRED_SIZE,
                                javax.swing.GroupLayout.DEFAULT_SIZE,
                                javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(
                                GenerateAdminNo,
                                javax.swing.GroupLayout.PREFERRED_SIZE,
                                31,
                                javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGap(18, 18, 18)
                    .addGroup(
                        jPanel1Layout
                            .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(
                                jLabel4,
                                javax.swing.GroupLayout.PREFERRED_SIZE,
                                14,
                                javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(
                                productName,
                                javax.swing.GroupLayout.PREFERRED_SIZE,
                                javax.swing.GroupLayout.DEFAULT_SIZE,
                                javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGap(18, 18, 18)
                    .addGroup(
                        jPanel1Layout
                            .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addGroup(
                                jPanel1Layout
                                    .createSequentialGroup()
                                    .addComponent(jLabel5)
                                    .addGap(83, 83, 83)
                                    .addComponent(
                                        admit,
                                        javax.swing.GroupLayout.PREFERRED_SIZE,
                                        30,
                                        javax.swing.GroupLayout.PREFERRED_SIZE))
                            .addComponent(
                                jScrollPane1,
                                javax.swing.GroupLayout.PREFERRED_SIZE,
                                127,
                                javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGap(21, 21, 21)));

    javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(
        layout
            .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(
                jPanel1,
                javax.swing.GroupLayout.Alignment.TRAILING,
                javax.swing.GroupLayout.DEFAULT_SIZE,
                javax.swing.GroupLayout.DEFAULT_SIZE,
                Short.MAX_VALUE));
    layout.setVerticalGroup(
        layout
            .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(
                jPanel1,
                javax.swing.GroupLayout.DEFAULT_SIZE,
                javax.swing.GroupLayout.DEFAULT_SIZE,
                Short.MAX_VALUE));

    pack();
  } // </editor-fold>//GEN-END:initComponents
Beispiel #3
0
  private void admitActionPerformed(
      java.awt.event.ActionEvent evt) { // GEN-FIRST:event_admitActionPerformed

    // String  = purchase.getText();
    String name = productName.getText();
    String id = ProductID.getText();
    String desc = descript.getText();

    if (desc.isEmpty()) {
      desc = "N/A";
    }

    if (name.length() == 0 || id.length() == 0 || desc.length() == 0) {
      JOptionPane.showMessageDialog(null, "Please fill all fields");
    } else {
      try {

        String editS = HomePage.toEdit;

        Class.forName("com.mysql.jdbc.Driver");
        Connection con =
            DriverManager.getConnection("jdbc:mysql://localhost:3306/VunaFeeds", "root", "");

        if (editS.equalsIgnoreCase("Null")) {
          PreparedStatement psmt =
              con.prepareStatement(
                  "INSERT into product(productID,productName,description) values (?,?,?)");
          psmt.setString(1, id);
          psmt.setString(2, name);
          psmt.setString(3, desc);

          PreparedStatement psmt1 =
              con.prepareStatement(
                  "INSERT into new_Stock(productID,Date,units,direction,status,current) values (?,?,?,?,?,?)");
          psmt1.setString(1, id);
          psmt1.setString(2, dateForDB);
          psmt1.setString(3, "0");
          psmt1.setString(4, "In");
          psmt1.setString(5, "Current");
          psmt1.setString(6, "0");

          psmt.executeUpdate();
          psmt1.executeUpdate();

        } else if (editS.equalsIgnoreCase("EditProduct")) {
          PreparedStatement psmt =
              con.prepareStatement(
                  "UPDATE product set productname = '"
                      + name
                      + "' , description  = '"
                      + desc
                      + "' where ProductID = "
                      + id
                      + "");
          psmt.executeUpdate();
        }

        JOptionPane.showMessageDialog(null, "Product Saved");
        this.dispose();
        HomePage.toEdit = " ";
        Product win = new Product();
        win.setVisible(true);

      } catch (SQLException e) {

        System.out.println("2 Error : " + e);
        JOptionPane.showMessageDialog(null, "Oops!! An error occured. \n " + e);
      } catch (Exception ex) {
        System.out.println("Error 1:" + ex);
        JOptionPane.showMessageDialog(null, "Oops!! An error occured. \n" + ex);
      }
    }
    // TODO add your handling code here:
  } // GEN-LAST:event_admitActionPerformed