gertjan

package pizzaitalia;
import javax.swing.*;
import java.sql.*;

/**
 *
 * @author  Gertjan
 */
public class ToevoegenVerkoop extends javax.swing.JFrame {
    private static final ToevoegenVerkoop verkoopvoegtoe = new ToevoegenVerkoop();
    public JFrame myCaller;
    private Connection db;

    public ToevoegenVerkoop() {
        loadDriver();
        connectDatabase();
        initComponents();
        getbestelling();
        
    }
    
    public static ToevoegenVerkoop getInstance(){
        return verkoopvoegtoe;
    }
    
    /** Creates new form ToevoegenVerkoop */
    
    
    /** 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.
     */
    // <editor-fold defaultstate="collapsed" desc=" Generated Code ">                          
    private void initComponents() {
        jPanel1 = new javax.swing.JPanel();
        jPanel2 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jComboBox1 = new javax.swing.JComboBox();
        jLabel2 = new javax.swing.JLabel();
        jComboBox2 = new javax.swing.JComboBox();
        jLabel3 = new javax.swing.JLabel();
        jButton2 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        jPanel1.setBackground(new java.awt.Color(255, 255, 255));
        jPanel2.setBackground(new java.awt.Color(204, 0, 0));
        jLabel1.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel1.setForeground(new java.awt.Color(255, 255, 255));
        jLabel1.setText("Toevoegen Verkopen");

        org.jdesktop.layout.GroupLayout jPanel2Layout = new org.jdesktop.layout.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel2Layout.createSequentialGroup()
                .addContainerGap()
                .add(jLabel1)
                .addContainerGap(323, Short.MAX_VALUE))
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel2Layout.createSequentialGroup()
                .addContainerGap()
                .add(jLabel1)
                .addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jLabel2.setText("Nr van bestelling");

        jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jLabel3.setText("werknemer");

        jButton2.setText("opslaan");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel1Layout = new org.jdesktop.layout.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .add(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jLabel2)
                    .add(jLabel3, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 58, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .add(96, 96, 96)
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING, false)
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, jComboBox2, 0, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .add(org.jdesktop.layout.GroupLayout.TRAILING, jComboBox1, 0, 121, Short.MAX_VALUE))
                .add(42, 42, 42)
                .add(jButton2)
                .add(46, 46, 46))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel1Layout.createSequentialGroup()
                .add(jPanel2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .add(42, 42, 42)
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel2)
                    .add(jComboBox1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .add(28, 28, 28)
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jComboBox2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel3)
                    .add(jButton2))
                .addContainerGap(27, Short.MAX_VALUE))
        );

        org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        pack();
    }// </editor-fold>                        

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
// TODO add your handling code here:
        voegverkoopToe();
    }                                        
     private void voegverkoopToe() {
        
        if(!bestellingBestaat()) {
            try
            {
               Double idb = new Double(jComboBox1.getSelectedItem());
               int idbestel = idb.intValue();
               
              
                
                
              Statement query = db.createStatement();
              
              String sql ="INSERT INTO Verkoop (bestellingid,personeelid)" + "VALUES ('" + jComboBox1.getSelectedItem() + "','" + jComboBox1.getSelectedItem() + "')";
             query.executeUpdate(sql);
              
            } //END try() TO WRITE RECORD

            //CATCH NUMBER FORMAT EXCEPTION FOR PRICE FIELD
            

            //CATCH ANY EXCEPTIONS WRITING TO FILE
            catch (SQLException io)
            { 
                JOptionPane.showMessageDialog(null,"\nERROR WRITING FILE\n"+ io.toString());
            }//END IO catch()
        } 
    }
    
    private boolean bestellingBestaat() {
      try
      {
          Statement query = db.createStatement();
          String sql = "SELECT * FROM Bestelling WHERE status =4;";
          ResultSet queryRS = query.executeQuery(sql);
          if(queryRS.next()) {
            return true;
          } else {
            return false;
          }
      }//END try
      catch (SQLException io)
      {
            JOptionPane.showMessageDialog(null,"\nOeps\n"+ io.toString());
            return false;
      }//END catch
    }
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new ToevoegenVerkoop().setVisible(true);
            }
        });
    }
     public void getbestelling()
    {
      //TRY TO READ DB
      try
      {
          jComboBox1.removeAllItems();
          Statement query = db.createStatement();
          ResultSet queryRS=query.executeQuery("SELECT * FROM Bestelling WHERE status= 4");
          
          //EXECUTE AN SQL STATEMENT TO RETURN A RESULT SET
          while(queryRS.next())
          {
                jComboBox1.addItem(queryRS.getString("id"));
          }//END while
       
      }//END try
      catch (SQLException io)
      {
            JOptionPane.showMessageDialog(null,"\nERROR READING FILE\n"+ io.toString());
      }//END catch

    }
     private void loadDriver()
    {
      //TRY LOADING SUN DRIVER
      try
      {
        //LOAD SUN DRIVER
        Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
      }//END try

      //DRIVER NOT FOUND, REPORT ERROR
      catch (ClassNotFoundException err)
      {
        System.out.println("Could not load driver ");
        System.exit(1);
      }//END catch
    }//END loadDriver()
    
    
    //Database verbinding maken
    private void connectDatabase()
    {
        try
        {
            //CONNECT TO DATABASE
            String dir = System.getProperty("user.dir");
            String dbFile = "Pizza Hut.mdb";
            String protocol ="jdbc";
            String subProtocol = "odbc";
            String subName = "Driver={Microsoft Access Driver (*.mdb)} ;DBQ=" + dir + "/" + dbFile;
            String URL = protocol + ":" + subProtocol + ":" + subName;
            db = DriverManager.getConnection(URL);
        }//END try
        catch(SQLException error)
        {
          System.err.println("Error connecting to database: " + error.toString());
        }//END catch
  }//END connectDatabase()
    // Variables declaration - do not modify                     
    private javax.swing.JButton jButton2;
    private javax.swing.JComboBox jComboBox1;
    private javax.swing.JComboBox jComboBox2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    // End of variables declaration                   
    
}