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. */ // 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(); }// 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 }