Ramen

Inhoud blog
  • emnTekstverbeteringTester :: Voorbereiding :: Deel 3
  • Opmaken van een spellinglijst : emnTekstverbeteringTester :: Voorbereiding
  • emnTekstverbeteringTester Deel 2
  • TekstverbeteringsTester emn :: deel 1 Voorbereiding
  • Open and close Stage and scene. Scenes stored in Hashmap
  • JavaFX FXML voorbeelden | JavaFX FXML examples
  • Eigenschappen voorbeeld uit vorig blog | Properties sample from previous blog
  • Meervoudige fxml bestanden laden | Loading multiple fxml files and controllers
  • Move from one object to another :: JavaFX
  • JavaFX templates
  • JavaFX FXML webbrowser
  • JavaFX ProgressIndicator - ProgessBar
  • Draai scene builder vanuit eclipse - Run scene builder from within eclipse.
  • FXML voorbeeld voor eclipse | FXML sample for eclipse
  • Wapenschild Hamerlinck
  • Wapenschild Hamerlinck
  • Zelf oefeningen maken :: educatie , talen , enquetes
  • ST. PATRICKS DAY PARADE
  • Hulp programma voor het leren van vreemde talen.
  • Javascript :: tekst sorteren op unieke woorden :: sort text
  • Code sorteer tekst : sort text :: javascript
  • onze tuin
  • Aston Ariel op bezoek
  • Hulpprogramma's :: Lezen | RSS - Nieuws
  • Presentationmodel :: buffered model :: RiverLayout
  • Make a separator for RiverLayout:
  • Customize combobox (binding JGoodies):: Riverlayout
  • Test Riverlayout :: sample
  • Project pw Helpdesk
  • LookAndFeel
  • JGoodies binding - RiverLayout
  • JGoodies binding and RiverLayout
  • Enkele JAVA gebonden afkortingen
  • Java Persistence with Hibernate
  • Exel : Woorden vervangen in tekst m.b..v een macro
  • Systray : verwijderen tags taakbalk. Wijzigingen start programma's
  • Scholier kraakt pornofilter van 50 miljoen euro
  • Items Kantorenproject
  • Minimumindeling van het algemeen rekeningstelsel
  • Items Java - eclipse
    Beoordeel dit blog
      Zeer goed
      Goed
      Voldoende
      Nog wat bijwerken
      Nog veel werk aan
     
    Foto
    Foto
    Foto

    rss nieuws

    Europa voor de meeste voorstanders meer en meer een grote teleurstelling
    Zoeken in blog


    Een kijk op....
    06-06-2008
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Presentationmodel :: buffered model :: RiverLayout
    Klik op de afbeelding om de link te volgen







    CustomerBean.java
    Structure

    package samples.s01
       
    CustomerBean.java
       
    PresentationModelBuild.java
       
    CustomerPresentationModel.java
       
    CustomBeanlaunch.java



    ----------------------------------------------------------------
    CustomerBean.java
    -----------------------------------------------------------------

    package samples.s01;

    *
     * Copyright (c) 2008 willems piet pwProTech  All rights reserved.
     *
     * Redistribution and use in source and binary forms, with or without
     * modification, are permitted provided that the following conditions
     * are met:
     *
     *   - Redistributions of source code must retain the above copyright
     *     notice, this list of conditions and the following disclaimer.
     *
     *   - Redistributions in binary form must reproduce the above copyright
     *     notice, this list of conditions and the following disclaimer in the
     *     documentation and/or other materials provided with the distribution.
     *
     */

    import com.jgoodies.binding.beans.Model;

    public class CustomerBean extends Model {
        public static final String NAME_PROPERTY = "name";
        public static final String OCCUPATION_PROPERTY = "occupation";
        private String name;
        private String occupation;

        public String getName() {
            return name;
        }

        public void setName(String name) {
            String oldValue = name;
            this.name = name;
            firePropertyChange(NAME_PROPERTY, oldValue, name);
        }

        public String getOccupation() {
            return occupation;
        }

        public void setOccupation(String occupation) {
            String oldValue = occupation;
            this.occupation = occupation;
            firePropertyChange(OCCUPATION_PROPERTY, oldValue, occupation);
        }

    }


    PresentationModelBuild.java


    package samples.s01;

    *
     * Copyright (c) 2008 willems piet pwProTech  All rights reserved.
     *
     * Redistribution and use in source and binary forms, with or without
     * modification, are permitted provided that the following conditions
     * are met:
     *
     *   - Redistributions of source code must retain the above copyright
     *     notice, this list of conditions and the following disclaimer.
     *
     *   - Redistributions in binary form must reproduce the above copyright
     *     notice, this list of conditions and the following disclaimer in the
     *     documentation and/or other materials provided with the distribution.
     *
     */

    import java.awt.Color;
    import java.awt.Dimension;
    import java.awt.TextField;

    import javax.swing.JButton;
    import javax.swing.JCheckBox;
    import javax.swing.JFrame;
    import javax.swing.JLabel;
    import javax.swing.JPanel;
    import javax.swing.JTextField;

    import se.datadosen.component.RiverLayout;

    import com.jgoodies.binding.adapter.BasicComponentFactory;

    public class PresentationModelBuild extends JPanel {

        static JTextField nameInput,occupationInput;
        static JButton commitButton;
        static JButton resetButton;
        JButton sendButton;
        static CustomerPresentationModel presentationModel;

        public void createComponents() {

            presentationModel = new CustomerPresentationModel(
                    new CustomerBean());

            nameInput = BasicComponentFactory.createTextField(presentationModel
                    .getBufferedModel(CustomerBean.NAME_PROPERTY));
            occupationInput = BasicComponentFactory
                    .createTextField(presentationModel
                            .getBufferedModel(CustomerBean.OCCUPATION_PROPERTY));

            commitButton = new JButton(presentationModel.getCommitAction());
            resetButton = new JButton(presentationModel.getResetAction());
            sendButton = new JButton(presentationModel.getSendAction());
        }

        public void constructGui() {
            JFrame frame = new JFrame();
            JPanel CustomBeanFrm = new JPanel();
            frame.getContentPane().setLayout(new RiverLayout());
            frame.getContentPane().add(CustomBeanFrm);

            CustomBeanFrmGui(CustomBeanFrm);
            commitButton.setEnabled(false);
            commitButton.setEnabled(false);
            frame.pack();
            frame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
            frame.setVisible(true);
        }

        private void CustomBeanFrmGui(JPanel CustomBeanFrm) {
            createComponents();
            CustomBeanFrm.setLayout(new RiverLayout());
            CustomBeanFrm.add("br left", new JLabel("PresentationModel"));
            CustomBeanFrm.add("br hfill", separator(Color.RED));


            CustomBeanFrm.add("br", new JLabel("Name"));
            CustomBeanFrm.add("tab hfill", nameInput);

            CustomBeanFrm.add("br", new JLabel("Occupation"));
            CustomBeanFrm.add("tab hfill", occupationInput);
            CustomBeanFrm.add("br hfill", separator(Color.GRAY));

           
            CustomBeanFrm.add("p br left", resetButton); // The button ins't really located to the left side
            CustomBeanFrm.add("center", sendButton);
            CustomBeanFrm.add("right", commitButton);
            CustomBeanFrm.add("br hfill", separator(Color.GRAY));

        }

        public static void clearForm() {
            commitButton.setEnabled(false);
            nameInput.setText("");
            occupationInput.setText("");

        }

        private static TextField separator(Color c) {
            TextField separator = new TextField();
            separator.setBackground(c);
            separator.setPreferredSize(new Dimension(20, 2));
            return separator;
        }
    }


    CustomerPresentationModel.java


    package samples.s01;

    *
     * Copyright (c) 2008 willems piet pwProTech  All rights reserved.
     *
     * Redistribution and use in source and binary forms, with or without
     * modification, are permitted provided that the following conditions
     * are met:
     *
     *   - Redistributions of source code must retain the above copyright
     *     notice, this list of conditions and the following disclaimer.
     *
     *   - Redistributions in binary form must reproduce the above copyright
     *     notice, this list of conditions and the following disclaimer in the
     *     documentation and/or other materials provided with the distribution.
     *
     */

    import java.awt.event.ActionEvent;
    import javax.swing.AbstractAction;
    import javax.swing.Action;
    import com.jgoodies.binding.PresentationModel;

    public class CustomerPresentationModel extends PresentationModel {

        private static final long serialVersionUID = 1L;
        CommitAction commitAction;
        ResetAction resetAction;
        SendAction sendAction;
        ClearAction clearAction;
        private final CustomerBean customerBean;

        @SuppressWarnings("unchecked")
        public CustomerPresentationModel(CustomerBean customerBean) {
            super(customerBean);
            this.customerBean = customerBean;
            commitAction = new CommitAction();
            resetAction = new ResetAction();
            sendAction = new SendAction();
            clearAction = new ClearAction();

        }

        public Action getCommitAction() {
            return commitAction;
        }

        public Action getSendAction() {
            return sendAction;
        }

        public Action getResetAction() {
            return resetAction;
        }

        public Action getClearAction() {
            return clearAction;
        }
       
        private class CommitAction extends AbstractAction {
            /**
             *
             */
            private static final long serialVersionUID = 1L;

            public CommitAction() {
                super("Commit");
            }

            public void actionPerformed(ActionEvent e) {

                triggerCommit();
                //getBean();
                displayBufferAndBean("COMMIT action:");
                PresentationModelBuild.clearForm();// disable commitbutton

            }
        }

        private class SendAction extends AbstractAction {

            public SendAction() {
                super("Send");
            }

            public void actionPerformed(final ActionEvent e) {

                // getBean();
                if (PresentationModelBuild.resetButton.isEnabled()) {
                    PresentationModelBuild.resetButton.setEnabled(true);
                }

                if (isBuffering()) {
                    PresentationModelBuild.commitButton.setEnabled(true);

                    displayBufferAndBean("SEND Bufferd :true :: Not yet committed");
                } else {
                    PresentationModelBuild.commitButton.setEnabled(false);
                    displayBufferAndBean("SEND Bufferd :true :: yet Committed");
                    //Bufferd still true so by a reset the bufferd values are still available
                }

            }

        }

        private class ResetAction extends AbstractAction {

            public ResetAction() {
                super("Reset");
            }

            public void actionPerformed(ActionEvent e) {

                // release():
                // Removes the PropertyChangeHandler from the observed bean, if the
                // bean is not null. Also removes all listeners from the bean that
                // have been registered with #addBeanPropertyChangeListener before.
                if (isBuffering()) {
                    triggerFlush();
                    resetChanged();
                    System.out.println("RESET action : If changes : Previous restored");
                    PresentationModelBuild.commitButton.setEnabled(false);
                }
            }
        }

        private class ClearAction extends AbstractAction {
            // Not Used

            public ClearAction() {
                super("Clear Form");
            }

            public void actionPerformed(ActionEvent e) {

                PresentationModelBuild.resetButton.setEnabled(false);
                PresentationModelBuild.clearForm();
                System.out.println("clearform");
            }
        }

        private void displayBufferAndBean(String buffering) {
            System.out.println("" + "Result " + buffering + "n"
                    + "-------------------------------------------------n"
                    + "Bufferd values :" + "n"
                    + "Buffered beanvalue name :" + getBufferedValue("name") + "n"
                    + "Buffered beanvalue occupation :"+ getBufferedValue("occupation") + "n"
                    + "" + "n"
                    + "Bean values :" + "n"
                    + "CustomerBean value name :" + customerBean.getName() + "n"
                    + "CustomerBean value occupation :" + customerBean.getOccupation() + "n"
                    + "---------------------------------------------------");
        }
    }



    CustomBeanlaunch.java
    --------------------------------------------------------------------------------------------

    package samples.s01;

    *
     * Copyright (c) 2008 willems piet pwProTech  All rights reserved.
     *
     * Redistribution and use in source and binary forms, with or without
     * modification, are permitted provided that the following conditions
     * are met:
     *
     *   - Redistributions of source code must retain the above copyright
     *     notice, this list of conditions and the following disclaimer.
     *
     *   - Redistributions in binary form must reproduce the above copyright
     *     notice, this list of conditions and the following disclaimer in the
     *     documentation and/or other materials provided with the distribution.
     *
     */

    public class CustomBeanlaunch {

        /**
         * @param args
         */
        public static void main(String[] args) {
            // TODO Auto-generated method stub
            PresentationModelBuild pme = new PresentationModelBuild();
            pme.constructGui();
        }
    }


    RESULTAAT



    Result SEND Bufferd :true :: Not yet committed
    -------------------------------------------------
    Bufferd values :
    Buffered beanvalue name :piet
    Buffered beanvalue occupation :job

    Bean values :
    CustomerBean value name :null
    CustomerBean value occupation :null
    ---------------------------------------------------
    RESET action : If changes : Previous restored
    Result SEND Bufferd :true :: Not yet committed
    -------------------------------------------------
    Bufferd values :
    Buffered beanvalue name :piet
    Buffered beanvalue occupation :job

    Bean values :
    CustomerBean value name :null
    CustomerBean value occupation :null
    ---------------------------------------------------
    Result COMMIT action:
    -------------------------------------------------
    Bufferd values :
    Buffered beanvalue name :piet
    Buffered beanvalue occupation :job

    Bean values :
    CustomerBean value name :piet
    CustomerBean value occupation :job
    ---------------------------------------------------

    Tags :: RiverLayout , JGoodies , Valueholder , bindings, formmodel , model , sample, samples, java

    06-06-2008 om 22:57 geschreven door de makers


    » Reageer (0)
    01-06-2008
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Make a separator for RiverLayout:
    Klik op de afbeelding om de link te volgen








    Make a separator for RiverLayout:

    JFrame frame = new JFrame();
    frame.getContentPane().setLayout(new RiverLayout());
    frame.getContentPane().add("br left",new JLabel("PresentationModel"));
    frame.getContentPane().add("br hfill",separator(Color.RED));
    frame.getContentPane().add("br",comboboxPM);
    frame.getContentPane().add("tab hfill",fieldPM);
    frame.getContentPane().add("br hfill",separator(Color.GRAY));
    frame.getContentPane().add("br left",okButton);
    frame.getContentPane().add("right",revertButton);//DO NOT USE "TAB RIGHT"
    frame.getContentPane().add("br hfill",separator(Color.GRAY));

    ...

     

    private static TextField separator(Color c) {
        TextField separator = new TextField();
        separator.setBackground(c);
        separator.setPreferredSize(new Dimension(20,2));
    return separator;
    }

    01-06-2008 om 00:00 geschreven door de makers


    » Reageer (0)
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Customize combobox (binding JGoodies):: Riverlayout
    Klik op de afbeelding om de link te volgen




    Customized comboboxes :: Riverlayout : JGoodies binding , valueholder



    package samples;

    /*
     * Copyright (c) 2008 - 2008 willems piet pwProTech  All rights reserved.
     *
     * Redistribution and use in source and binary forms, with or without
     * modification, are permitted provided that the following conditions
     * are met:
     *
     *   - Redistributions of source code must retain the above copyright
     *     notice, this list of conditions and the following disclaimer.
     *
     *   - Redistributions in binary form must reproduce the above copyright
     *     notice, this list of conditions and the following disclaimer in the
     *     documentation and/or other materials provided with the distribution.
     *
     *
     * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
     * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
     * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
     * PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE COPYRIGHT OWNER OR
     * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
     * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
     * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
     * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
     * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
     * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
     * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
     */

    import java.awt.Color;
    import java.awt.Dimension;
    import java.awt.Font;
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import java.util.ArrayList;

    import javax.swing.JButton;
    import javax.swing.JComboBox;
    import javax.swing.JFrame;
    import javax.swing.JLabel;
    import javax.swing.JPanel;
    import javax.swing.border.EmptyBorder;

    import se.datadosen.component.RiverLayout;

    import com.jgoodies.binding.adapter.BasicComponentFactory;
    import com.jgoodies.binding.adapter.ComboBoxAdapter;
    import com.jgoodies.binding.value.ValueHolder;
    import com.jgoodies.binding.value.ValueModel;

    public class CustomComboAdapter extends JPanel {
        private String CMD_OK = "cmd.ok"/* NOI18N */;

        private JButton okButton;

        public ComboValueHolder ch, cl; // static

        public CustomComboAdapter() {
            JPanel panel = new JPanel(new RiverLayout());
            panel.setBorder(new EmptyBorder(6, 6, 6, 6));
            riverFormBuilder(panel);
            add(panel);
        }

        private void riverFormBuilder(JPanel panel) {
            ArrayList<String> countries = new ArrayList<String>();
            countries.add("England");
            countries.add("Scotland");
            countries.add("Iereland");
            countries.add("Nedtherlands");
            countries.add("Flanders");

            ArrayList<String> languages = new ArrayList<String>();
            languages.add("Dutch");
            languages.add("English");
            languages.add("Spanish");
            languages.add("German");
            languages.add("Russian");
           
            Dimension d = new Dimension(150, 20);
            Font userfont = new Font("Arial",1,12);
           
            ch = new ComboValueHolder();
            ch.setStartselection("Make selection");
            JComboBox countriesComboBoxes = ch.customComboBox(countries, d,userfont,Color.WHITE);

            cl = new ComboValueHolder();
            cl.setStartselection("Spanish");
            JComboBox combolanguageBox = cl.customComboBox(languages, d,userfont,Color.WHITE);
           
            okButton = new JButton();
            okButton.setText("ok");
            okButton.setActionCommand(CMD_OK);
            okButton.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent event) {
                    // windowAction(event);
                    System.out.println("Combo selection country"
                            + ch.getSelectionHolder().getValue());
                    System.out.println("Combo selection language"
                            + cl.getSelectionHolder().getValue());
                    System.out.println(okButton.getActionCommand());

                }
            });

            panel.add("p", new JLabel("ComboBox Countries:"));
            panel.add("tab hfill", countriesComboBoxes);
            panel.add("tab tab", new JLabel("Selection:"));
            panel.add("tab tab tab hfill", BasicComponentFactory.createTextField(ch
                    .getSelectionHolder()));

            panel.add("p", new JLabel("ComboBox Languages:"));
            panel.add("tab hfill", combolanguageBox);
            panel.add("tab tab", new JLabel("Selection:"));
            panel.add("tab tab tab hfill", BasicComponentFactory.createTextField(cl
                    .getSelectionHolder()));
            panel.add("p hfill", okButton);
        }

        public static void main(String[] a) {
            JFrame f = new JFrame("Custom ComboBox");
            f.setDefaultCloseOperation(2);
            f.add(new CustomComboAdapter());
            f.pack();
            f.setVisible(true);
        }

        public class ComboValueHolder {
            String startselection;

            ValueModel selectionHolder;

            public ValueModel ComboHolder() {
                ValueModel selectionHolder = new ValueHolder(this.startselection);
                setSelectionHolder(selectionHolder);
                return selectionHolder;
            }

            public JComboBox customComboBox(ArrayList countries, Dimension d, Font font, Color color) {

                ComboBoxAdapter comboBoxAdapter = new ComboBoxAdapter(countries,ComboHolder());
                JComboBox comboBox = new JComboBox();
                comboBox.setPreferredSize(d);
                comboBox.setFont(font);
                comboBox.setBackground(color);
                comboBox.setModel(comboBoxAdapter);
                return comboBox;
            }

            public String getStartselection() {
                return startselection;
            }

            public void setStartselection(String startselection) {
                this.startselection = startselection;
            }

            public ValueModel getSelectionHolder() {
                return selectionHolder;
            }

            public void setSelectionHolder(ValueModel selectionHolder) {
                this.selectionHolder = selectionHolder;
            }

        }
    }


    Tags :: RiverLayout , JGoodies , Valueholder , bindings, formmodel , model , sample, samples, java

    01-06-2008 om 00:00 geschreven door de makers


    » Reageer (0)
    29-05-2008
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Test Riverlayout :: sample


     
    Project Test Riverlayout :: working example jgoodies binding remove and load jpanels

    Test RiverLayout :: (pics dir: see bottom)

    Package beans
    1.SingleForm.java
    2.TripleForm.java

    Package forms.masterforms
    1.SingleMasterForm.java
    2.TripleMasterForm.java

    Package se.datadosen
    > Download riverlayout.zip


    Package src
    1.MenuBar.java
    2.OpeningForm.java


    Package testen
    1.RiverLayoutTest.java

     
    CODE:
    SingleForm.java
    package beans;
    /*
    * Copyright (c) 2008 - 2008 willems piet pwProTech All rights reserved.
    *
    * Redistribution and use in source and binary forms, with or without
    * modification, are permitted provided that the following conditions
    * are met:
    *
    * - Redistributions of source code must retain the above copyright
    * notice, this list of conditions and the following disclaimer.
    *
    * - Redistributions in binary form must reproduce the above copyright
    * notice, this list of conditions and the following disclaimer in the
    * documentation and/or other materials provided with the distribution.
    *
    *
    * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
    * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
    * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
    * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
    * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
    * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
    * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
    * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
    * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
    * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
    * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    */
    import com.jgoodies.binding.beans.Model;
    //This configuration is more advanced then the tripleform bean and uses JGoodies beans.model
    public class SingleForm extends Model {
    String name, street, nr, towncity, occupation;
    	public String getName() {
    return name;
    }
    	public void setName(String name) {
    this.name = name;
    }
    	public String getNr() {
    return nr;
    }
    	public void setNr(String nr) {
    this.nr = nr;
    }
    	public String getOccupation() {
    return occupation;
    }
    	public void setOccupation(String occupation) {
    this.occupation = occupation;
    }
    	public String getStreet() {
    return street;
    }
    	public void setStreet(String street) {
    this.street = street;
    }
    	public String getTowncity() {
    return towncity;
    }
    	public void setTowncity(String towncity) {
    this.towncity = towncity;
    }
    }
    
    TripleForm.java
    package beans;
    /*
    * Copyright (c) 2008 - 2008 willems piet pwProTech All rights reserved.
    *
    * Redistribution and use in source and binary forms, with or without
    * modification, are permitted provided that the following conditions
    * are met:
    *
    * - Redistributions of source code must retain the above copyright
    * notice, this list of conditions and the following disclaimer.
    *
    * - Redistributions in binary form must reproduce the above copyright
    * notice, this list of conditions and the following disclaimer in the
    * documentation and/or other materials provided with the distribution.
    *
    *
    * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
    * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
    * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
    * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
    * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
    * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
    * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
    * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
    * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
    * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
    * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    */
    import java.beans.PropertyChangeListener;
    import com.jgoodies.binding.beans.ExtendedPropertyChangeSupport;
    public class TripleForm {
    	//ToDo :: see singlemasterform : extends Model
    	String username, age, comment;
    	boolean menuItemEnabled;
    	private ExtendedPropertyChangeSupport changeSupport = new ExtendedPropertyChangeSupport(
    this);
    	public String getUsername() {
    return username;
    }
    	public void setUsername(String username) {
    String oldValue = username;
    this.username = username;
    changeSupport.firePropertyChange("stringValue", oldValue, username);
    System.out.println(username);
    }
    	public String getAge() {
    return age;
    }
    	public void setAge(String age) {
    String oldValue = age;
    this.age = age;
    changeSupport.firePropertyChange("stringValue", oldValue, age);
    System.out.println(age);
    }
    	public String getComment() {
    return comment;
    }
    	public void setComment(String comment) {
    String oldValue = comment;
    this.comment = comment;
    changeSupport.firePropertyChange("stringValue", oldValue, comment);
    System.out.println(comment);
    }
    	public void addPropertyChangeListener(PropertyChangeListener x) {
    changeSupport.addPropertyChangeListener(x);
    }
    	public void removePropertyChangeListener(PropertyChangeListener x) {
    changeSupport.removePropertyChangeListener(x);
    }
    	public boolean isMenuItemEnabled() {
    return menuItemEnabled;
    }
    	public void setMenuItemEnabled(boolean menuItemEnabled) {
    this.menuItemEnabled = menuItemEnabled;
    }
    }
     
    
    SingleMasterForm.java
    package forms.masterforms;
    /*
    * Copyright (c) 2008 - 2008 willems piet pwProTech All rights reserved.
    *
    * Redistribution and use in source and binary forms, with or without
    * modification, are permitted provided that the following conditions
    * are met:
    *
    * - Redistributions of source code must retain the above copyright
    * notice, this list of conditions and the following disclaimer.
    *
    * - Redistributions in binary form must reproduce the above copyright
    * notice, this list of conditions and the following disclaimer in the
    * documentation and/or other materials provided with the distribution.
    *
    *
    * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
    * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
    * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
    * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
    * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
    * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
    * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
    * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
    * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
    * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
    * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    */
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import javax.swing.JButton;
    import javax.swing.JFrame;
    import javax.swing.JLabel;
    import javax.swing.JMenuItem;
    import javax.swing.JPanel;
    import javax.swing.JTextField;
    import se.datadosen.component.RiverLayout;
    import src.MenuBar;
    import beans.SingleForm;
    import com.jgoodies.binding.adapter.BasicComponentFactory;
    import com.jgoodies.binding.beans.BeanAdapter;
    import com.jgoodies.binding.value.ValueModel;
    import com.jgoodies.forms.factories.Borders;
    public class SingleMasterForm {
    	private String CMD_OK = "cmd.ok"/* NOI18N */;
    	private JButton okButton;
    	public JPanel buildform(final JFrame f, final JMenuItem menuitem) {
    okButton = new JButton();
    okButton.setText("ok");
    okButton.setActionCommand(CMD_OK);
    okButton.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent event) {
    // windowAction(event);
    System.out
    .println("ACTION : BUTTON OK WAS CLICKED and Menu item enabled");
    System.out.println(okButton.getActionCommand());
    menuitem.setEnabled(true);//and close
    MenuBar.FrameClearAction(f);
    }
    });
    		SingleForm bean = new SingleForm();
    BeanAdapter adapter = new BeanAdapter(bean, true);
    		ValueModel nameModel = adapter.getValueModel("name");
    ValueModel streetModel = adapter.getValueModel("street");
    ValueModel nrModel = adapter.getValueModel("nr");
    ValueModel towncityModel = adapter.getValueModel("towncity");
    ValueModel occupationModel = adapter.getValueModel("occupation");
    		JTextField nameinput = BasicComponentFactory.createTextField(nameModel);
    JTextField streetinput = BasicComponentFactory
    .createTextField(streetModel);
    JTextField nrinput = BasicComponentFactory.createTextField(nrModel);
    JTextField towncityinput = BasicComponentFactory
    .createTextField(towncityModel);
    JTextField occupationinput = BasicComponentFactory
    .createTextField(occupationModel);
    		// Panel
    		// SingleMasterForm
    JPanel SingleMasterForm = new JPanel();
    SingleMasterForm.setLayout(new RiverLayout());
    SingleMasterForm.add("right", new JLabel("Single Form demo"));
    SingleMasterForm.add("p left", new JLabel("Name"));
    SingleMasterForm.add("tab hfill", nameinput);
    SingleMasterForm.add("br", new JLabel("Street"));
    SingleMasterForm.add("tab hfill", streetinput);
    SingleMasterForm.add("br vtop", new JLabel("nr"));
    SingleMasterForm.add("tab", nrinput);
    nrinput.setColumns(5);
    SingleMasterForm.add("br vtop", new JLabel("Town/City"));
    SingleMasterForm.add("tab hfill", towncityinput);
    SingleMasterForm.add("br vtop", new JLabel("Occupation"));
    SingleMasterForm.add("tab hfill", occupationinput);
    SingleMasterForm.add("p right", okButton);
    SingleMasterForm.setBorder(Borders.DIALOG_BORDER);
    		return SingleMasterForm;
    }
    }
     
    
    TripleMasterForm.java
    
    package forms.masterforms;
    /*
    * Copyright (c) 2008 - 2008 willems piet pwProTech All rights reserved.
    *
    * Redistribution and use in source and binary forms, with or without
    * modification, are permitted provided that the following conditions
    * are met:
    *
    * - Redistributions of source code must retain the above copyright
    * notice, this list of conditions and the following disclaimer.
    *
    * - Redistributions in binary form must reproduce the above copyright
    * notice, this list of conditions and the following disclaimer in the
    * documentation and/or other materials provided with the distribution.
    *
    *
    * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
    * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
    * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
    * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
    * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
    * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
    * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
    * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
    * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
    * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
    * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    */
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import javax.swing.JButton;
    import javax.swing.JFrame;
    import javax.swing.JLabel;
    import javax.swing.JMenuItem;
    import javax.swing.JPanel;
    import javax.swing.JScrollPane;
    import javax.swing.JSplitPane;
    import javax.swing.JTextArea;
    import javax.swing.JTextField;
    import javax.swing.border.EmptyBorder;
    import se.datadosen.component.RiverLayout;
    import src.MenuBar;
    import beans.TripleForm;
    import com.jgoodies.binding.adapter.BasicComponentFactory;
    import com.jgoodies.binding.beans.BeanAdapter;
    import com.jgoodies.binding.value.ValueModel;
    import com.jgoodies.forms.factories.Borders;
    public class TripleMasterForm extends TripleForm {
    	private String CMD_OK = "cmd.ok"/* NOI18N */;
    	private JButton okButton, ok1Button, ok2Button;
    	public JPanel formRegistration(final JFrame f, final JMenuItem menuitem) {
    okButton = new JButton();
    okButton.setText("ok");
    okButton.setActionCommand(CMD_OK);
    		okButton.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent event) {
    // windowAction(event);
    System.out
    .println("ACTION : BUTTON OK WAS CLICKED and menu item enabled");
    System.out.println(okButton.getActionCommand());
    menuitem.setEnabled(true);//and close
    MenuBar.FrameClearAction(f);
    }
    });
    		ok1Button = new JButton();
    ok1Button.setText("ok 1");
    ok1Button.setActionCommand(CMD_OK);
    ok1Button.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent event) {
    // windowAction(event);
    System.out.println("ACTION : BUTTON 1 OK WAS CLICKED");
    System.out.println(ok1Button.getActionCommand());
    menuitem.setEnabled(true);//and close
    MenuBar.FrameClearAction(f);
    }
    });
    		ok2Button = new JButton(); // we'll need this soon
    ok2Button.setText("ok 2");
    ok2Button.setActionCommand(CMD_OK);
    ok2Button.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent event) {
    // windowAction(event);
    System.out.println("ACTION : BUTTON 2 OK WAS CLICKED");
    System.out.println(ok2Button.getActionCommand());
    menuitem.setEnabled(true);//and close
    MenuBar.FrameClearAction(f);
    }
    });
    		TripleForm bean = new TripleForm();
    BeanAdapter adapter = new BeanAdapter(bean, true);
    		ValueModel nameModel = adapter.getValueModel("username");
    ValueModel ageModel = adapter.getValueModel("age");
    ValueModel commentModel = adapter.getValueModel("comment");
    		JTextField userinput = BasicComponentFactory.createTextField(nameModel);
    JTextField ageinput = BasicComponentFactory.createTextField(ageModel);
    JTextArea commentinput = BasicComponentFactory
    .createTextArea(commentModel);
    		ValueModel nameModel01 = adapter.getValueModel("username");
    ValueModel ageModel01 = adapter.getValueModel("age");
    ValueModel commentModel01 = adapter.getValueModel("comment");
    		JTextField userinput01 = BasicComponentFactory
    .createTextField(nameModel01);
    JTextField ageinput01 = BasicComponentFactory
    .createTextField(ageModel01);
    JTextArea commentinput01 = BasicComponentFactory
    .createTextArea(commentModel01);
    		ValueModel nameModel02 = adapter.getValueModel("username");
    ValueModel ageModel02 = adapter.getValueModel("age");
    ValueModel commentModel02 = adapter.getValueModel("comment");
    		JTextField userinput02 = BasicComponentFactory
    .createTextField(nameModel02);
    JTextField ageinput02 = BasicComponentFactory
    .createTextField(ageModel02);
    JTextArea commentinput02 = BasicComponentFactory
    .createTextArea(commentModel02);
    		// Panel 1 = left + center
    		// left
    JPanel left = new JPanel();
    left.setLayout(new RiverLayout());
    left.add("right", new JLabel("Registration form left"));
    left.add("p left", new JLabel("Name"));
    left.add("tab hfill", userinput);
    left.add("br", new JLabel("Age"));
    ageinput.setColumns(5);
    left.add("tab", ageinput);
    left.add("br vtop", new JLabel("Comment"));
    commentinput.setRows(3);
    left.add("tab hfill vfill", new JScrollPane(commentinput));
    left.add("p right", okButton);
    // added to level the content of the 3 panels
    left.setBorder(Borders.DIALOG_BORDER);
    		// center
    JPanel center = new JPanel();
    center.setLayout(new RiverLayout());
    center.add("right", new JLabel("Registration form center"));
    center.add("p left", new JLabel("Name-center"));
    center.add("tab hfill", userinput01);
    center.add("br", new JLabel("Age-center"));
    ageinput01.setColumns(2);
    center.add("tab", ageinput01);
    center.add("br vtop", new JLabel("Comment-center"));
    center.add("tab hfill vfill", new JScrollPane(commentinput01));
    center.add("p right", ok1Button);
    center.add(left);
    // added to level the content of the 3 panels
    center.setBorder(Borders.DIALOG_BORDER);
    		JSplitPane splitPane = new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,
    left, center);
    JPanel panel1 = new JPanel();
    panel1.setLayout(new RiverLayout());
    splitPane.setBorder(new EmptyBorder(-10, -5, -20, -8));
    //splitPane.setDividerLocation(150);
    //splitPane.setOneTouchExpandable(true);
    splitPane.setDividerSize(3);
    panel1.add("hfill vfill", splitPane);
    		JPanel right = new JPanel();
    right.setLayout(new RiverLayout());
    right.add("right", new JLabel("Registration form right"));
    right.add("p left", new JLabel("Name-right"));
    right.add("tab hfill", userinput02);
    right.add("br", new JLabel("Age-right"));
    ageinput02.setColumns(3);
    right.add("tab", ageinput02);
    right.add("br vtop", new JLabel("Comment-right"));
    right.add("tab hfill vfill", new JScrollPane(commentinput02));
    right.add("p right", ok2Button);
    // added to level the content of the 3 panels
    right.setBorder(new EmptyBorder(6, 0, 6, 0));
    		JSplitPane splitPane0 = new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,
    panel1, right);
    		splitPane0.setBorder(new EmptyBorder(-4, 0, -10, 0));
    splitPane0.setDividerSize(3);
    		//RegistrationMasterForm
    		JPanel masterform = new JPanel();
    masterform.setLayout(new RiverLayout());
    masterform.add("vfill hfill", splitPane0);
    		return masterform;
    }
    }
     
    
    MenuBar.java
    package src;
    /*
    * Copyright (c) 2008 - 2008 willems piet pwProTech All rights reserved.
    *
    * Redistribution and use in source and binary forms, with or without
    * modification, are permitted provided that the following conditions
    * are met:
    *
    * - Redistributions of source code must retain the above copyright
    * notice, this list of conditions and the following disclaimer.
    *
    * - Redistributions in binary form must reproduce the above copyright
    * notice, this list of conditions and the following disclaimer in the
    * documentation and/or other materials provided with the distribution.
    *
    *
    * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
    * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
    * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
    * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
    * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
    * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
    * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
    * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
    * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
    * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
    * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    */
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import java.awt.event.KeyEvent;
    import javax.swing.ImageIcon;
    import javax.swing.JFrame;
    import javax.swing.JLabel;
    import javax.swing.JMenu;
    import javax.swing.JMenuBar;
    import javax.swing.JMenuItem;
    import javax.swing.KeyStroke;
    import se.datadosen.component.RiverLayout;
    import forms.masterforms.SingleMasterForm;
    import forms.masterforms.TripleMasterForm;
    public class MenuBar {
    protected JMenuBar menuBar;
    	public JMenuBar MenuBarRegistration(JFrame frame) {
    //send to where the GUI is created:
    //Call : frame.setJMenuBar( MenuBarRegistration(frame));
    		JMenu menu, submenu;
    JMenuItem menuItem1, menuItem2, menuItem3, menuItem4, menuItem5, menuItem51, menuItem52;
    		//Create the menu bar.
    menuBar = new JMenuBar();
    		//Build the first menu.
    menu = new JMenu("TestMenu 1");
    menu.setMnemonic(KeyEvent.VK_A);
    //menu.getAccessibleContext().setAccessibleDescription(
    // "The only menu in this program that has menu items");
    menuBar.add(menu);
    		//a group of JMenuItems
    menuItem1 = new JMenuItem("Clear test", KeyEvent.VK_T);
    menuItem1.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_1,
    ActionEvent.ALT_MASK));
    menuItem1.setName("een");
    menu.add(menuItem1);
    		//  Text - icon sample
    menuItem2 = new JMenuItem("Single form", new ImageIcon(
    "images/yourpic.gif"));
    		menuItem2.setMnemonic(KeyEvent.VK_B);
    menuItem2.setName("singlemasterform");
    menu.add(menuItem2);
    		menuItem3 = new JMenuItem("Triple form", new ImageIcon(
    "images/yourpic.gif"));
    menuItem3.setMnemonic(KeyEvent.VK_B);
    menuItem3.setName("twee");
    menu.add(menuItem3);
    		menuItem5 = new JMenuItem(new ImageIcon("images/yourpic.gif"));
    //Only icon dample
    menuItem5.setMnemonic(KeyEvent.VK_D);
    menu.add(menuItem3);
    		//a submenu
    menu.addSeparator();
    submenu = new JMenu("Submenu sample");
    submenu.setMnemonic(KeyEvent.VK_S);
    		menuItem51 = new JMenuItem("Submenu item 1 sample");
    menuItem51.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_2,
    ActionEvent.ALT_MASK));
    submenu.add(menuItem51);
    		menuItem52 = new JMenuItem("Submenu item 2 sample");
    submenu.add(menuItem52);
    menu.add(submenu);
    		//Build second menu in the menu bar.
    menu = new JMenu("TestMenu 2");
    menu.setMnemonic(KeyEvent.VK_N);
    menuBar.add(menu);
    		//Adding action listener to menu items
    //------------------------------------
    menuAction(menuItem1, frame);
    menuAction(menuItem2, frame);
    menuAction(menuItem3, frame);
    		menuItem51.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent e) {
    System.out.println("SubmenuItem 1 is pressed");
    }
    });
    menuItem52.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent e) {
    System.out.println("SubmenuItem 2 is pressed");
    }
    });
    		return menuBar;
    	}
    	private void menuAction(final JMenuItem menuItem, final JFrame f) {
    menuItem.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent e) {
    String action = menuItem.getName();
    System.out.println("action" + action);
    if (action.equals("een")) {
    menuSelectionClearContentPane(f);
    } else if (action.equals("twee")) {
    menuSelectionTripleMasterForm(menuItem, f);
    } else if (action.equals("singlemasterform")) {
    menuSelectionSingleMasterForm(menuItem, f);
    }
    }
    			private void menuSelectionClearContentPane(final JFrame f) {
    enableItemsMenu0();
    FrameClearAction(f);
    System.out.println(f.getName() + " is Cleared");
    }
    			private void menuSelectionSingleMasterForm(
    final JMenuItem menuItem, final JFrame f) {
    enableItemsMenu0();
    menuItem.setEnabled(false);
    f.getContentPane().removeAll();
    SingleMasterForm smf = new SingleMasterForm();
    f.setLayout(new RiverLayout());
    f.getContentPane().add("hfill vfill",
    smf.buildform(f, menuItem));
    System.out.println(f.getName() + " is installed");
    f.validate();
    f.repaint();
    }
    			private void menuSelectionTripleMasterForm(
    final JMenuItem menuItem, final JFrame f) {
    enableItemsMenu0();
    menuItem.setEnabled(false);
    f.getContentPane().removeAll();
    TripleMasterForm rmf = new TripleMasterForm();
    rmf.setMenuItemEnabled(false);
    f.setLayout(new RiverLayout());
    f.getContentPane().add("hfill vfill",
    rmf.formRegistration(f, menuItem));
    System.out.println(f.getName() + " is installed");
    f.validate();
    f.repaint();
    }
    			private void enableItemsMenu0() {
    //ToDo name the item indexes
    getMenuItem(0, 0).setEnabled(true);
    getMenuItem(0, 1).setEnabled(true);
    getMenuItem(0, 2).setEnabled(true);
    }
    });
    }
    	public static void FrameClearAction(JFrame f) {
    		f.getContentPane().removeAll();
    f.getContentPane().setLayout(new RiverLayout());
    f.getContentPane().add(new JLabel("Frame Cleared"));
    f.validate();
    f.repaint();
    		System.out.println("pass" + f.getContentPane().getComponents());
    }
    	protected JMenuItem getMenuItem(int menuIndex, int itemIndex) {
    //JMenuBar menuBar;
    JMenu menu = menuBar.getMenu(menuIndex);
    System.out.println(menu.getName());
    return menu.getItem(itemIndex);
    }
    }
     
    OpeningForm.java
    
    package src;
    /*
    * Copyright (c) 2008 - 2008 willems piet pwProTech All rights reserved.
    *
    * Redistribution and use in source and binary forms, with or without
    * modification, are permitted provided that the following conditions
    * are met:
    *
    * - Redistributions of source code must retain the above copyright
    * notice, this list of conditions and the following disclaimer.
    *
    * - Redistributions in binary form must reproduce the above copyright
    * notice, this list of conditions and the following disclaimer in the
    * documentation and/or other materials provided with the distribution.
    *
    *
    * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
    * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
    * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
    * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
    * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
    * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
    * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
    * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
    * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
    * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
    * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    */
    import java.awt.Dimension;
    import java.awt.Font;
    import javax.swing.JLabel;
    import javax.swing.JPanel;
    import se.datadosen.component.RiverLayout;
    public class OpeningForm {
    public static JPanel buildForm() {
    JPanel openingPanel = new JPanel();
    openingPanel.setLayout(new RiverLayout());

            JLabel infoLabel = new JLabel();
    JLabel gapLabel = new JLabel();
            gapLabel.setPreferredSize(new Dimension(150, 240));
    infoLabel.setPreferredSize(new Dimension(400, 240));
    infoLabel.setFont(new Font("sansserif", Font.BOLD, 32));
    infoLabel.setText("Test Riverlayout");
    openingPanel.add("p" , gapLabel);
    openingPanel.add("tab" , infoLabel);
    return openingPanel;
    }
    }
     
    
    RiverLayoutTest.java
    package testen;
    /*
    * Copyright (c) 2008 - 2008 willems piet pwProTech All rights reserved.
    *
    * Redistribution and use in source and binary forms, with or without
    * modification, are permitted provided that the following conditions
    * are met:
    *
    * - Redistributions of source code must retain the above copyright
    * notice, this list of conditions and the following disclaimer.
    *
    * - Redistributions in binary form must reproduce the above copyright
    * notice, this list of conditions and the following disclaimer in the
    * documentation and/or other materials provided with the distribution.
    *
    *
    * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
    * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
    * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
    * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
    * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
    * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
    * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
    * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
    * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
    * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
    * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    */
    import java.awt.*;
    import java.awt.event.*;
    import javax.swing.*;
    import com.jgoodies.forms.factories.Borders;
    import beans.TripleForm;
    import se.datadosen.component.RiverLayout;
    import src.MenuBar;
    /* TopLevelDemo.java requires no other files. */
    public class RiverLayoutTest {
    /**
    * Create the GUI and show it.
    */
    private static void createAndShowGUI() {
    //Create and set up the window.
    JFrame frame = new JFrame("Test Layout");
    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    frame.getContentPane().setLayout(new RiverLayout());
    		//Set the menu bar and add the openingForm to the content pane.
    frame.setJMenuBar(new MenuBar().MenuBarRegistration(frame));
    frame.getContentPane().add("hfill", src.OpeningForm.buildForm());
    		//Display the window.
    frame.setLocation(150, 200);
    frame.pack();
    frame.setVisible(true);
    }
    	public static void main(String[] args) {
    //creating and showing this application's GUI.
    javax.swing.SwingUtilities.invokeLater(new Runnable() {
    public void run() {
    createAndShowGUI();
    }
    });
    }
    }

    Tags : RiverLayout , sample , java , example , jgoodies , valuemodel, model

     


    29-05-2008 om 00:00 geschreven door de makers


    » Reageer (0)
    20-05-2008
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Project pw Helpdesk
    Klik op de afbeelding om de link te volgen



    Started with new project helpdesk:




    -basic layout : see pic

    -todo :  treeview final configuration
    -todo : create searchpanel
    -todo : create tabpane » reflecting search
    -todo : implement riverlayout as a test.

    20-05-2008 om 12:44 geschreven door de makers


    » Reageer (0)
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.LookAndFeel
    Klik op de afbeelding om de link te volgen



    LookAndFeel




    To change the lookandfeel for example to "windowslookandfeel" you will have to add
    UIManager.setLookAndFeel to your code :: see sample

    buildregistration.java  [ full example code :  see 19-05-2008 ]

    package formbuilding;

    import javax.swing.JFrame;
    import javax.swing.UIManager;
    import javax.swing.UnsupportedLookAndFeelException;

    import formbeans.Registration;

    public class BuildRegistration {

        public BuildRegistration(String title) {
            JFrame f = new JFrame(title);
            try {
                UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
            } catch (ClassNotFoundException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (InstantiationException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (IllegalAccessException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (UnsupportedLookAndFeelException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            Registration r = new Registration();
            f.setLocation(200, 200);
            r.formRiverLayout(f);
            f.pack();
            f.setVisible(true);

        }

        public static void main(String[] args) {
            BuildRegistration br = new BuildRegistration("Registration");

        }
    }

    20-05-2008 om 00:00 geschreven door de makers


    » Reageer (0)
    19-05-2008
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.JGoodies binding - RiverLayout
    Klik op de afbeelding om de link te volgen





    A working example: JGoodies binding - RiverLayout


    1: Registration.java


    package formbeans;

    import java.awt.Container;
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import java.beans.PropertyChangeListener;

    import javax.swing.JButton;
    import javax.swing.JFrame;
    import javax.swing.JLabel;
    import javax.swing.JPanel;
    import javax.swing.JScrollPane;
    import javax.swing.JSplitPane;
    import javax.swing.JTextArea;
    import javax.swing.JTextField;
    import javax.swing.border.EmptyBorder;

    import se.datadosen.component.RiverLayout;

    import com.jgoodies.binding.adapter.BasicComponentFactory;
    import com.jgoodies.binding.beans.BeanAdapter;
    import com.jgoodies.binding.beans.ExtendedPropertyChangeSupport;
    import com.jgoodies.binding.value.ValueModel;
    import com.jgoodies.forms.factories.Borders;

    public class Registration {

        String username, age, comment;
     
        private String CMD_OK = "cmd.ok"/* NOI18N */;
        private JButton okButton, ok1Button, ok2Button;
        private ExtendedPropertyChangeSupport changeSupport = new ExtendedPropertyChangeSupport(
                this);

        public String getUsername() {
            return username;
        }

        public void setUsername(String username) {
            String oldValue = username;
            this.username = username;
            changeSupport.firePropertyChange("stringValue", oldValue, username);
            System.out.println(username);
        }

        public String getAge() {
            return age;
        }

        public void setAge(String age) {
            String oldValue = age;
            this.age = age;
            changeSupport.firePropertyChange("stringValue", oldValue, age);
            System.out.println(age);
        }

        public String getComment() {
            return comment;
        }

        public void setComment(String comment) {
            String oldValue = comment;
            this.comment = comment;
            changeSupport.firePropertyChange("stringValue", oldValue, comment);
            System.out.println(comment);
        }

        public void addPropertyChangeListener(PropertyChangeListener x) {
            changeSupport.addPropertyChangeListener(x);
        }

        public void removePropertyChangeListener(PropertyChangeListener x) {
            changeSupport.removePropertyChangeListener(x);
        }

        public Container formRiverLayout(JFrame f) {
            okButton = new JButton();
            okButton.setText("ok");
            okButton.setActionCommand(CMD_OK);
            okButton.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent event) {
                    // windowAction(event);
                    System.out.println("ACTION : BUTTON OK WAS CLICKED");
                    System.out.println(okButton.getActionCommand());
                }
            });

            ok1Button = new JButton();
            ok1Button.setText("ok 1");
            ok1Button.setActionCommand(CMD_OK);
            ok1Button.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent event) {
                    // windowAction(event);
                    System.out.println("ACTION : BUTTON 1 OK WAS CLICKED");
                    System.out.println(ok1Button.getActionCommand());
                }
            });

            ok2Button = new JButton(); // we'll need this soon
            ok2Button.setText("ok 2");
            ok2Button.setActionCommand(CMD_OK);
            ok2Button.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent event) {
                    // windowAction(event);
                    System.out.println("ACTION : BUTTON 2 OK WAS CLICKED");
                    System.out.println(ok2Button.getActionCommand());
                }
            });

            Registration bean = new Registration();
            BeanAdapter adapter = new BeanAdapter(bean, true);

            ValueModel nameModel = adapter.getValueModel("username");
            ValueModel ageModel = adapter.getValueModel("age");
            ValueModel commentModel = adapter.getValueModel("comment");

            JTextField userinput = BasicComponentFactory.createTextField(nameModel);
            JTextField ageinput = BasicComponentFactory.createTextField(ageModel);
            JTextArea commentinput = BasicComponentFactory
                    .createTextArea(commentModel);

            ValueModel nameModel01 = adapter.getValueModel("username");
            ValueModel ageModel01 = adapter.getValueModel("age");
            ValueModel commentModel01 = adapter.getValueModel("comment");

            JTextField userinput01 = BasicComponentFactory
                    .createTextField(nameModel01);
            JTextField ageinput01 = BasicComponentFactory
                    .createTextField(ageModel01);
            JTextArea commentinput01 = BasicComponentFactory
                    .createTextArea(commentModel01);

            ValueModel nameModel02 = adapter.getValueModel("username");
            ValueModel ageModel02 = adapter.getValueModel("age");
            ValueModel commentModel02 = adapter.getValueModel("comment");

            JTextField userinput02 = BasicComponentFactory
                    .createTextField(nameModel02);
            JTextField ageinput02 = BasicComponentFactory
                    .createTextField(ageModel02);
            JTextArea commentinput02 = BasicComponentFactory
                    .createTextArea(commentModel02);

            // Panel 1 = left + center

            // left
            JPanel left = new JPanel();
            left.setLayout(new RiverLayout());
            left.add("right", new JLabel("Registration form left"));
            left.add("p left", new JLabel("Name"));
            left.add("tab hfill", userinput);
            left.add("br", new JLabel("Age"));
            ageinput.setColumns(5);
            left.add("tab", ageinput);
            left.add("br vtop", new JLabel("Comment"));
            commentinput.setRows(3);
            left.add("tab hfill vfill", new JScrollPane(commentinput));
            left.add("p right", okButton);
            // added to level the content of the 3 panels
            left.setBorder(Borders.DIALOG_BORDER);

            // center
            JPanel center = new JPanel();
            center.setLayout(new RiverLayout());
            center.add("right", new JLabel("Registration form center"));
            center.add("p left", new JLabel("Name-center"));
            center.add("tab hfill", userinput01);
            center.add("br", new JLabel("Age-center"));
            ageinput01.setColumns(2);
            center.add("tab", ageinput01);
            center.add("br vtop", new JLabel("Comment-center"));
            center.add("tab hfill vfill", new JScrollPane(commentinput01));
            center.add("p right", ok1Button);
            center.add(left);
            // added to level the content of the 3 panels
            center.setBorder(Borders.DIALOG_BORDER);

            JSplitPane splitPane = new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,
                    left, center);
            JPanel panel1 = new JPanel();
            panel1.setLayout(new RiverLayout());
            splitPane.setBorder(new EmptyBorder(-10, -5, -20, -8));
            //splitPane.setDividerLocation(150);
            //splitPane.setOneTouchExpandable(true);
            splitPane.setDividerSize(3);
            panel1.add("hfill vfill", splitPane);

            JPanel right = new JPanel();
            right.setLayout(new RiverLayout());
            right.add("right", new JLabel("Registration form right"));
            right.add("p left", new JLabel("Name-right"));
            right.add("tab hfill", userinput02);
            right.add("br", new JLabel("Age-right"));
            ageinput02.setColumns(3);
            right.add("tab", ageinput02);
            right.add("br vtop", new JLabel("Comment-right"));
            right.add("tab hfill vfill", new JScrollPane(commentinput02));
            right.add("p right", ok2Button);
            // added to level the content of the 3 panels
            right.setBorder(new EmptyBorder(6, 0, 6, 0));

            JSplitPane splitPane0 = new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,
                    panel1, right);

            splitPane0.setBorder(new EmptyBorder(-4, 0, -10, 0));
            splitPane0.setDividerSize(3);

            Container c = f.getContentPane();

            c.add(splitPane0);
            // to add a gray border change the code to :
            // c.setBackground(Color.GRAY);
            // c.setLayout(new RiverLayout());
            // c.add("hfill vfill",splitPane0);
            return c;
        }
    }






    2.BuildRegistration.java

    package formbuilding;

    import javax.swing.JFrame;
    import formbeans.Registration;

    public class BuildRegistration {

        public BuildRegistration(String title) {
            JFrame f = new JFrame(title);

            Registration r = new Registration();
            f.setLocation(200, 200);
            r.formRiverLayout(f);
            f.pack();
            f.setVisible(true);

        }

        public static void main(String[] args) {
            BuildRegistration br = new BuildRegistration("Registration");

        }

    }

    <hr>
    <pre><font face="Arial">Tags : RiverLaout , sample , java , example , jgoodies , valuemodel</font></pre><hr>

    19-05-2008 om 00:00 geschreven door de makers


    » Reageer (1)
    18-05-2008
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.JGoodies binding and RiverLayout
    How to define the length of a JTextField by using the RiverLayout - a simple and flexible Java Layout Manager- and the JGoodies binding


    sample:

    imports :

    import java.awt.Container;
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import java.beans.PropertyChangeListener;

    import javax.swing.JButton;
    import javax.swing.JFrame;
    import javax.swing.JLabel;
    import javax.swing.JScrollPane;
    import javax.swing.JTextArea;
    import javax.swing.JTextField;

    import com.jgoodies.binding.adapter.BasicComponentFactory;
    import com.jgoodies.binding.beans.BeanAdapter;
    import com.jgoodies.binding.beans.ExtendedPropertyChangeSupport;
    import com.jgoodies.binding.value.ValueModel;

    import se.datadosen.component.RiverLayout;

    ...


        public Container formRiverLayout(JFrame f) {
            okButton = new JButton();
            okButton.setText("ok");
            okButton.setActionCommand(CMD_OK);
            okButton.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent event) {
                    // windowAction(event);
                    System.out.println("ACTION : BUTTON OK WAS CLICKED");
                    System.out.println(okButton.getActionCommand());
                }
            });

            Registration bean = new Registration();
            BeanAdapter adapter = new BeanAdapter(bean, true);

            ValueModel nameModel = adapter.getValueModel("username");
            ValueModel ageModel = adapter.getValueModel("age");
            ValueModel commentModel = adapter.getValueModel("comment");

            JTextField userinput = BasicComponentFactory.createTextField(nameModel);
            JTextField ageinput = BasicComponentFactory.createTextField(ageModel);
            ageinput.setColumns(3);
            // When this configuration isn't done the BasicComponentFactory
            //will not configure the width and the  JTextField will be redused to
            //a few millimeter.

            JTextArea commentinput = BasicComponentFactory.createTextArea(commentModel);

            Container c = f.getContentPane();
                c.setLayout(new RiverLayout());
                c.add("right", new JLabel("Registration form"));
                c.add("p left", new JLabel("Name"));
                c.add("tab hfill", userinput);
                c.add("br", new JLabel("Age"));
                c.add("tab", ageinput);
                c.add("br vtop", new JLabel("Comment"));
                c.add("tab hfill vfill", new JScrollPane(commentinput));
                c.add("p center", okButton);
            return c;
        }


    18-05-2008 om 00:00 geschreven door de makers


    » Reageer (0)
    02-02-2008
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Enkele JAVA gebonden afkortingen

    JAVA gebonden afkortingen
    ORM
    JSP
    JSF
    MVC
    J2EE
    J2SE
    POJO
    Object-Relational mapping
    JavaServer Pages
    JavaServer Faces
    Model-view-controller
    Java 2 Platform Enterprise Edition
    Java 2 Platform, Standard Edition
    Plain Old Java Object
    JTA
    EJB
    API
    AOP
    JDBC
    Java Transaction API
    Enterprise JavaBeans
    Application programming interface
    Aspect-oriented programming
    Java Database Connectivity
    SQL
    HQL
    JDO
    DAO
    Structured Query Language
    Hibernate Query Language
    Java Data Objects
    Data Access Object
    iBATIS is a persistence framework which enables mapping SQL queries to POJOs
    Apache Struts is an open-source web application framework for developing Java EE web applications.
    WebWork is a Java-based web application framework developed by OpenSymphony.
    Tapestry is an open-source framework for creating dynamic, robust, highly scalable web applications in Java.
    TopLink is an object-relational mapping package for Java developers.
    Hibernate is an object-relational mapping (ORM) library for the Java language, providing a framework for mapping an object-oriented domain model to a traditional relational database.
    Spring Spring is a layered Java/J2EE application framework, based on code published in Expert One-on-One J2EE Design and Development by Rod Johnson (Wrox, 2002).


    02-02-2008 om 15:59 geschreven door de makers


    » Reageer (0)
    21-11-2007
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Java Persistence with Hibernate

    Java Persistence with Hibernate 
                Schermbreed weergeven : klik voorlaatste ikoon van toolbalk


    21-11-2007 om 21:50 geschreven door de makers


    » Reageer (1)
    12-11-2007
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Exel : Woorden vervangen in tekst m.b..v een macro

    Macro voor excel om een lijst woorden in één keer te vervangen in een tekst.


    De code voor Visual Basic macro "Vervang"

    De lijst woorden die men wenst te vervangen bevindt zich in dit voorbeeld in de kolom C4 tot C13.De wisselwoorden in de kolom daarnaast [Offset(0, 1)].


    Sub Vervang()

    'author piet :: pwProTech

    For Each c In Worksheets(1).Range("C4:C13")
    Sheets("Blad2").Cells.Replace What:=c.Value, Replacement:=c.Offset(0, 1).Value, LookAt:=xlPart _
    , SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
    ReplaceFormat:=False
    Next c

    End Sub


    De inhoud van excel Blad1
    Range C4 tot C13 :
    Hier plaats je de woorden die je wil vervangen en de veervangtekst

    Vb.:Blad1:

    Op dit blad kan je ook de knop [VERVANG] (die de macro "Vervang" start) aanbrengen.:

    A B C D ...
    1        
    2        
    3   Te vervangen: met:  
    4   Event DB_action  
    5   event db_action  
    ...    ...  ...  


    De inhoud van excel Blad2


    Op Blad2 plaats je de tekst die bewerkt moet worden.

    Je plakt best de hele tekst in één enkele cel zodat je hem weer gemakelijk kan copiëren
    Hoe : dubbele klik in de cel die je verkiest en plakken


    Noot: Je kan ook een knop voorzien om de woorden op "Blad1" te verwijderen met de macro "Reset"

    Code:


    Sub Reset()

      'author piet :: pwProTech

      For Each c In Worksheets(1).Range("C4:C13")
         c.Value = ""
         c.Offset(0, 1).Value = ""
      Next c

    End Sub

    12-11-2007 om 21:21 geschreven door de makers


    » Reageer (0)
    20-10-2007
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Systray : verwijderen tags taakbalk. Wijzigingen start programma's
    Systray : verwijderen tags ( icoon ) taakbalk . Wijzigingen start programma's enz.


    1Ga naar start

    2.Klik op "Uitvoeren" [run] in het geopend menu.
    3.Type in de ingavebalk : msconfig
    4.Klik ok

    Het venster "Hulpprogramma voor systeemconfiguratie" wordt geopend.

    5.In het gegeven venster kan je nu de nodige veranderingen doorvoeren.

    Tip :Programma's met "onbekend" als leverancier of "" (prog's die geen indentificartie hebben) zijn dikwijls dubieus tenzij je natuurlijk het programma kent of het zelf geinstalleerd hebt.

    Noot
    -icoons taakbalk bevinden zich onder de tab "Opstarten"
    -wat bvb. het icoon van het gevaarlijke "antivirusgear" betreft : het bevat in de tab "opstarten" geen gegevens.Het kan wel via deze weg verwijderd worden doch het programma zelf moet apart verwijderd worden.

    20-10-2007 om 00:00 geschreven door de makers


    » Reageer (0)
    27-08-2007
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Scholier kraakt pornofilter van 50 miljoen euro

    Scholier kraakt pornofilter van 50 miljoen euro

    De Morgen   ::
      
    KLIK HIER en LEES MEER

    27-08-2007 om 14:55 geschreven door de makers


    » Reageer (0)
    25-08-2007
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Items Kantorenproject
     

    Project :: Kantoren :: Items

  • Minimumindeling van het algemeen rekeningstelsel MAR Databesetabel voor MySQL
  • 25-08-2007 om 14:41 geschreven door de makers


    » Reageer (0)
    24-08-2007
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Minimumindeling van het algemeen rekeningstelsel
    Minimumindeling van het algemeen rekeningstelsel MAR Databasetabel voor MySQL

    -- phpMyAdmin SQL Dump
    -- version 2.6.1-pl3
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generatie Tijd: 25 Aug 2007 om 14:28
    -- Server versie: 5.0.24
    -- PHP Versie: 5.0.3
    --
    -- Database: `boekhouding`
    --

    -- --------------------------------------------------------

    --
    -- Tabel structuur voor tabel `rekeningstelsel`
    --

    CREATE TABLE `rekeningstelsel` (
      `id` int(11) NOT NULL auto_increment,
      `rekening` varchar(8) NOT NULL,
      `beschrijving` varchar(255) default NULL,
      `code1` varchar(8) default NULL,
      `code` varchar(25) default NULL,
      `APR` char(1) NOT NULL,
      `bedrag` double NOT NULL,
      `info` tinytext NOT NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=942 ;

    --
    -- Gegevens worden uitgevoerd voor tabel `rekeningstelsel`
    --

    INSERT INTO `rekeningstelsel` VALUES (1, '1. ', 'Eigen vermogen, voorzieningen voor risico’s en kosten en schulden op meer dan één jaar', '', '', '', 0, '');
    INSERT INTO `rekeningstelsel` VALUES (2, '10.', 'Kapitaal', '', 'I.', 'P', 0, '');
    INSERT INTO `rekeningstelsel` VALUES (3, '100', 'Geplaatst kapitaal', '', 'I.A.', 'P', 0, '');
    INSERT INTO `rekeningstelsel` VALUES (4, '101', 'Niet-opgevraagd kapitaal (-)', '', 'I.B.', 'P', 0, '');
    INSERT INTO `rekeningstelsel` VALUES (5, '102', 'Afgeschreven kapitaal', '', 'I.A.', 'P', 0, '');
    INSERT INTO `rekeningstelsel` VALUES (6, '109', 'Rekening van de uitbater', '', 'I.A.', 'P', 0, '');
    INSERT INTO `rekeningstelsel` VALUES (7, '11.', 'Uitgiftepremies', '', 'II.', 'P', 0, '');
    INSERT INTO `rekeningstelsel` VALUES (8, '12.', 'Herwaarderingsmeerwaarden', '', 'III.', 'P', 0, '');
    INSERT INTO `rekeningstelsel` VALUES (9, '120', 'Herwaarderingsmeerwaarden op immateriële vaste activa', '', '', '', 0, '');  ....


    Voor de volledige code : klik hier    (Code te groot voor tekstvak)

    24-08-2007 om 00:00 geschreven door de makers


    » Reageer (0)
    17-08-2007
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Items Java - eclipse
     

    Eclipse :: Java :: Items

  • Eclipse - Mysql - MS sql-server
  • Een database Mysql - Project starten met eclipse
  • Test mysql-connectie :: java
  • Java :: eclipse :: Check of een internal frame is aangemaakt
  • Java :: eclipse :: JTable addRow
  • Java :: eclipse :: tabel leegmaken [clear JTable]
  • Java :: eclipse :: omzetting nr string
  • Java :: eclipse :: arrays
  • Java :: eclipse :: voorbeeld internalframe mysql , menu, klantenformulier
  • Java :: eclipse :: Aanmaken van het object klant [classe]
  • Java :: eclipse :: Voorbeeld HQL [sample HQL FRom (class name)
  • Java :: eclipse :: Voorbeeld DAO [sample DAO (klant,user database mysql)
  • Java :: eclipse :: In voorbeeld DAO KlantDao.java en UserDao.java vervangen door 1 enkel bestand : dbDao.java
  • 17-08-2007 om 00:00 geschreven door de makers


    » Reageer (0)
    16-08-2007
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Java :: eclipse :: Voorbeeld DAO [sample DAO (klant,user database mysql)

    Elipse :: java »» Project DAO :: voorbeeld (sample user , klant : database mysql).


    Structuur :

    [-]prjdao (project)
    |      |
    |     [-]config (map)
    |      |     klant.hbm.xml
    |      |     user.hbm.xml
    |      |
    |     [-]src (package)
    |      |     main.java
    |      |     Klant.java
    |      |     User.java
    |      |     KlantDao.java
    |      |     UserDao.java
    |      |     HibernateFactory.java
    |      |     ConstructDao.java
    |      |     DataAccessError.java
    |     [+] JRE System Library
    |     [+] xerces-2.6.2.jar
    |     [+] ant-antlr-1.6.3.jar
    |     [+] antlr-2.7.5H3.jar
    |     [+] asm.jar
    |     [+] asm-attrs.jar
    |     [+] cglib-2.1.jar
    |     [+] commons-collections-2.1.1.jar
    |     [+] commons-logging-1.0.4.jar
    |     [+] dom4j-1.6.jar
    |     [+] ehache-1.1.jar
    |     [+] hibernate3.jar
    |     [+] hsqldb.jar
    |     [+] jta.jar
    |     [+] log4j-1.2.9.jar
    |     [+] mysql-connector-java-3.1.6-bin.jar
    |
    hibernate.cfg.xml
    log4j.properties
     




    1.--- begin main.java ------

    package src;

    import java.util.Date;

    public class Main {

        public static void main(String[] args) {

        Date now = new Date ();

        /*
        * User toevoegen aan de database
        */
        System.out.println("user toegevoegd voor");
        UserDao userDao = new UserDao();
        User user = new User();
        userDao.create(user);
        user.setNaam("De Gavere");
        user.setWachtwoord("gaverzicht");
        user.setAansluiting(now);
        userDao.update(user);
        System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>user toegevoegd");
        userDao.findAll();

        /*
        * Klant toevoegen aan de database
        */
        KlantDao klantDao = new KlantDao();
        Klant klant = new Klant();
        klantDao.create(klant);
        klant.setVoornaam("Kere-gerom");
        klant.setAchternaam("Reuzegom");
        klant.setStraat("Lange Wapperstraat");
        klant.setHuisnr("12");
        klant.setPostnr("8640");
        klant.setGemeente("Papoptvier");
        klantDao.update(klant);
        System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>klant toegevoegd");
        klantDao.findAll();


        System.out.println("Einde main");

        }
    }


    --- einde Main java ------ top
     



    2.--- begin Klant.java ------

    package src;

    public class Klant {//implements Serializable {

    private Long id;
    private String voonaam;
    private String achternaam;
    private String straat;
    private String huisnr;
    private String postnr;
    private String gemeente;


    public Long getId() {return id;}
    public void setId(Long id) {this.id = id;}

    public String getVoornaam() {return voonaam;}
    public void setVoornaam(String voonaam) {this.voonaam = voonaam;}

    public String getAchternaam() {return achternaam;}
    public void setAchternaam(String achternaam) {this.achternaam = achternaam;}

    public String getStraat() {return straat;}
    public void setStraat(String straat) {this.straat = straat;}

    public String getHuisnr() {return huisnr;}
    public void setHuisnr(String huisnr) {this.huisnr = huisnr;}

    public String getPostnr() {return postnr;}
    public void setPostnr(String postnr) {this.postnr = postnr;}

    public String getGemeente() {return gemeente;}
    public void setGemeente(String gemeente) {this.gemeente = gemeente;}

    }


    --- einde Klant.java ------  top
     



    3.--- begin User.java ------

    package src;

    import java.util.Date;


    public class User {
    private Long id;
    private int werkniveau;
    private String naam;
    private String wachtwoord;
    private Date aansluiting;



    public Long getId() {return id;}
    public void setId(Long id) {this.id = id;}

    public String getNaam() {return naam;}
    public void setNaam(String naam) {System.out.println("in klant :naam");this.naam = naam;}

    public String getWachtwoord() {return wachtwoord;}
    public void setWachtwoord(String wachtwoord) {this.wachtwoord = wachtwoord;}

    public Date getAansluiting() {return aansluiting;}
    public void setAansluiting(Date aansluiting) {this.aansluiting = aansluiting;}

    public int getwerkniveau() {return werkniveau;}
    public void setwerkniveau(int werkniveau) {this.werkniveau = werkniveau;}

    }

    --- einde User.java ------ top
     



    4.--- begin HibernateFactory.java ------

    package src;

    import org.hibernate.*;
    import org.hibernate.cfg.Configuration;
    import org.apache.commons.logging.*;



    public class HibernateFactory {
    private static SessionFactory sessionFactory;
    private static Log log = LogFactory.getLog(HibernateFactory.class);

        /*
        * Maakt een nieuwe Singleton SessionFactory aan
        */
        public static SessionFactory buildSessionFactory() throws HibernateException {
        System.out.println("sessionfact build");
        if (sessionFactory != null) {
        closeFactory();
        }
        return configureSessionFactory();
        }

        /*
        * Maakt een nieuwe Singleton SessionFactory aan indien nodig.
        */
        public static SessionFactory buildIfNeeded() throws DataAccessError{

        if (sessionFactory != null) {
        return sessionFactory;
        }
            try {
                return configureSessionFactory();
        } catch (HibernateException err) {
            throw new DataAccessError("build if needed mislukt >> "+err);
        }
    }

    public static SessionFactory getSessionFactory() {
    return sessionFactory;
    }

    public static Session openSession() throws HibernateException {
    buildIfNeeded();
    return sessionFactory.openSession();
    }

    public static void closeFactory() {
        if (sessionFactory != null) {
            try {
                sessionFactory.close();
            } catch (HibernateException ignored) {
                log.error("SessionFactory kon niet afgesloten worden", ignored);
            }
        }
    }

    public static void close(Session session) {
        if (session != null) {
            try {
            session.close();
            } catch (HibernateException ignored) {
            log.error("Session kon niet afgesloten worden", ignored);
            }
        }
    }

    public static void rollback(Transaction trans) {
        try {
            if (trans != null) {
            trans.rollback();
            System.out.println("Terugschroeven");
            }
        } catch (HibernateException ignored) {
            log.error("Transaction-terugschroeven (rollback) is mislukt", ignored);
        }
    }


    /*
    * Configuratie SessionFactory
    */
    private static SessionFactory configureSessionFactory() throws HibernateException {
        Configuration configuration = new Configuration();
        configuration.configure();
        sessionFactory = configuration.buildSessionFactory();
        return sessionFactory;
        }
    }

    --- einde HibernateFactory.java ------ top
     



    5.--- begin ConstructDao.java -----


    package src;

    import org.hibernate.HibernateException;
    import org.hibernate.Session;
    import org.hibernate.Transaction;
    import org.hibernate.Query;
    import java.util.List;

    public abstract class ConstructDao {
    private Session session;
    private Transaction trans;

    public ConstructDao() {
    System.out.println("maak indien nodig");
    HibernateFactory.buildIfNeeded();
    }

    protected void saveOrUpdate(Object obj) {
        try {
            System.out.println("saveOrUpdate");
            openSessionTrans();
            session.saveOrUpdate(obj);
            trans.commit();
        } catch (HibernateException err) {
            handleException(err);
        } finally {
            HibernateFactory.rollback(trans);
            HibernateFactory.close(session);
        }
    }

    protected void delete(Object object) {
        try {
            openSessionTrans();
            session.delete(object);
            trans.commit();
        } catch (HibernateException err) {
            handleException(err);
        } finally {
            HibernateFactory.close(session);
        }
    }

    protected Object find(Class clazz, Long id) {
    Object object = null;
        try {
            openSessionTrans();
            object = session.load(clazz, id);
            trans.commit();
        } catch (HibernateException err) {
            handleException(err);
        } finally {
            HibernateFactory.close(session);
        }
        return object;
    }

    protected List findAll(Class clazz) {
    List objects = null;
        try {
            openSessionTrans();
            Query query = session.createQuery("from " + clazz.getName());
            objects = query.list();
            trans.commit();
        } catch (HibernateException err) {
            handleException(err);
        } finally {
            HibernateFactory.close(session);
        }
        return objects;
    }

    protected void handleException(HibernateException err) throws DataAccessError {
        HibernateFactory.rollback(trans);
        throw new DataAccessError(err);
    }

    protected void openSessionTrans() throws HibernateException {
        System.out.println("openSessionTrans");
        session = HibernateFactory.openSession();
        trans = session.beginTransaction();
        }
    }



    --- einde ConstructDao.java ------ top
     



    6.--- begin KlantDao.java ------

    package src;

    import java.util.List;


    public class KlantDao extends ConstructDao {

    public KlantDao() {
    super();
    }

    /*
    * Nieuwe Klant toevoegen aan database.
    */
    public void create(Klant klant) throws DataAccessError {
    super.saveOrUpdate(klant);
    }


    /*
    * Een Klant verwijderen van de database.
    */
    public void delete(Klant klant) throws DataAccessError {
    super.delete(klant);
    }

    /*
    * Een Klant vinden met de primary key.
    */
    public Klant find(Long id) throws DataAccessError {
    System.out.print("klant update");
    return (Klant) super.find(Klant.class, id);
    }

    /*
    * Klant toevoegen aan - of wijzigen in de database.
    */
    public void update(Klant klant) throws DataAccessError {
    System.out.print("klant update");
    super.saveOrUpdate(klant);
    }

    /**
    * Zoek alle klanten in de database.
    */
    public List findAll() throws DataAccessError{
    return super.findAll(Klant.class);
    }

    }
    --- einde klantDao.java ------ top
     



    7.--- begin UserDao.java ------

    package src;

    import java.util.List;

    public class UserDao extends ConstructDao {
    public UserDao() {
    super();
    }

    /*
    * Een User toevoegen aan - wijzigen in de database.
    */
    public void create(User user) throws DataAccessError {
    super.saveOrUpdate(user);
    }


    /*
    * Een User verwijderen uit de database.
    */
    public void delete(User user) throws DataAccessError {
    super.delete(user);
    }

    /**
    * Find an Event by its primary key.
    * @param id
    * @return
    */
    public User find(Long id) throws DataAccessError {

    return (User) super.find(User.class, id);
    }

    /*
    * User toevoegen aan - of wijzigen in de database.
    */
    public void update(User user) throws DataAccessError {
    System.out.println(">>>>> user update");
    super.saveOrUpdate(user);
    }

    /*
    * Haal alle users op uit de database.
    */
    public List findAll() throws DataAccessError{
    return super.findAll(User.class);
    }

    }

    --- einde UserDao.java ------ top

     



    8.--- begin DataAccesError.java ------
    package src;

    /*
    * Exceptions opgeworpen door de Data Access Layer.
    */
    public class DataAccessError extends RuntimeException {
    public DataAccessError() {
    }

    public DataAccessError(String message) {
    super(message);
    }

    public DataAccessError(Throwable cause) {
    super(cause);
    }

    public DataAccessError(String message, Throwable cause) {
    super(message, cause);
    }
    }


    --- einde DataAccesError.java ------ top

     



    map config

        klant.hbm.xml
        user.hbm.xml




    1.--- begin klant.hbm.xml ------

    <?xml version="1.0"?>
    <!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">


    <hibernate-mapping >
        <class name="src.Klant" table="klanten">
            <id name="id" column="id" type="long">
            <generator class="increment"/>
            </id>
            <property name="voornaam" type="string"/>
            <property name="achternaam" type="string"/>
            <property name="straat" type="string"/>
            <property name="huisnr" type="string"/>
            <property name="postnr" type="string"/>
            <property name="gemeente" type="string"/>
        </class>
    </hibernate-mapping>

    --- einde klant.hbm.xml ------ top

     



    2.--- begin user.hbm.xml ------

    <?xml version="1.0"?>
    <!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">


    <hibernate-mapping >
        <class name="src.User" table="users">
            <id name="id" column="id" type="long">
            <generator class="increment"/>
            </id>
            <property name="naam" type="string"/>
            <property name="wachtwoord" type="string"/>
            <property name="aansluiting" type="date"/>
            <property name="werkniveau" type="integer"/>
        </class>
    </hibernate-mapping>

    --- einde user.hbm.xml ------ top

     




    project prjdao
        hibernate.cfg.xml
        log4j.properties



    1.--- begin hibernate.cfg.xml ------

    <?xml version='1.0' encoding='utf-8'?>
    <!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

    <hibernate-configuration>
        <session-factory>
            <!-- Database connection settings -->
            <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
            <property name="connection.url">jdbc:mysql://localhost/mysqltest</property>
            <property name="connection.username">db-usernaam</property>
            <property name="connection.password">uwpaswoord</property>

            <!-- JDBC connection pool (use the built-in) -->
            <property name="connection.pool_size">1</property>

            <!-- SQL dialect -->
            <property name="dialect">org.hibernate.dialect.HSQLDialect</property>

            <!-- Echo all executed SQL to stdout -->
            <property name="show_sql">true</property>

            <mapping resource="config/User.hbm.xml"/>
            <mapping resource="config/Klant.hbm.xml"/>
        </session-factory>
    </hibernate-configuration>


    --- einde hibernate.cfg.xml ------ top

     



    2.--- begin log4j.properties ------

    log4j.rootLogger=DEBUG, A1
    log4j.appender.A1=
    org.apache.log4j.ConsoleAppender
    log4j.appender.A1.layout=
    org.apache.log4j.PatternLayout
    log4j.appender.A1.layout.ConversionPattern=
    %-4r [%t] %-5p %c %x - %m%n

    --- einde log4j.properties ------ top

     


    Tables mysql database "mysqltest"

    -- phpMyAdmin SQL Dump
    -- version 2.6.1-pl3
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generatie Tijd: 17 Aug 2007 om 17:40
    -- Server versie: 5.0.24
    -- PHP Versie: 5.0.3
    --
    -- Database: `mysqltest`
    --

    -- --------------------------------------------------------

    --
    -- Tabel structuur voor tabel `klanten`
    --

    CREATE TABLE `klanten` (
      `id` bigint(20) NOT NULL auto_increment,
      `voornaam` varchar(30) default NULL,
      `achternaam` varchar(15) default NULL,
      `straat` varchar(30) default NULL,
      `huisnr` varchar(10) default NULL,
      `postnr` varchar(4) default NULL,
      `gemeente` varchar(30) default NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

    --
    -- Gegevens worden uitgevoerd voor tabel `klanten`
    --

    INSERT INTO `klanten` VALUES (1, 'Reuzegom', 'Kere-gerom', 'Smallestraat', '12', '8640', 'Tzalbeteren');
    INSERT INTO `klanten` VALUES (2, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Tzalbeteren');
    INSERT INTO `klanten` VALUES (3, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Tzalbeteren');
    INSERT INTO `klanten` VALUES (4, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Tzalbeteren');
    INSERT INTO `klanten` VALUES (5, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Tzalbeteren');
    INSERT INTO `klanten` VALUES (6, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (7, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (8, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (9, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (10, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (11, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (12, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (13, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (14, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (15, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (16, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (17, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (18, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (19, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (20, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (21, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (22, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (23, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (24, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (25, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (26, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (27, 'Kere-gerom', 'Reuzegom', 'Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (28, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (29, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (30, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (31, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (32, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (33, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (34, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');
    INSERT INTO `klanten` VALUES (35, 'Kere-gerom', 'Reuzegom', 'Lange Wapperstraat', '12', '8640', 'Papoptvier');

    -- phpMyAdmin SQL Dump
    -- version 2.6.1-pl3
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generatie Tijd: 17 Aug 2007 om 17:41
    -- Server versie: 5.0.24
    -- PHP Versie: 5.0.3
    --
    -- Database: `mysqltest`
    --

    -- --------------------------------------------------------

    --
    -- Tabel structuur voor tabel `users`
    --

    CREATE TABLE `users` (
      `id` bigint(20) NOT NULL auto_increment,
      `naam` varchar(30) default NULL,
      `wachtwoord` varchar(10) default NULL,
      `aansluiting` date default NULL,
      `werkniveau` int(11) default NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

    --
    -- Gegevens worden uitgevoerd voor tabel `users`
    --

    INSERT INTO `users` VALUES (1, 'dillems', 'blabla', '2007-07-29', 1);
    INSERT INTO `users` VALUES (2, 'De Vlucht', 'Wachtwoord', '2007-08-08', 0);
    INSERT INTO `users` VALUES (3, 'De Vlucht', 'Wachtwoord', '2007-08-08', 0);
    INSERT INTO `users` VALUES (4, 'De Gavere', 'gaverzicht', '2007-08-08', 0);
    INSERT INTO `users` VALUES (5, 'De Gavere', 'gaverzicht', '2007-08-08', 0);
    INSERT INTO `users` VALUES (6, 'De Gavere', 'gaverzicht', '2007-08-09', 0);
    INSERT INTO `users` VALUES (7, 'De Gavere', 'gaverzicht', '2007-08-09', 0);
    INSERT INTO `users` VALUES (8, 'De Gavere', 'gaverzicht', '2007-08-09', 0);
    INSERT INTO `users` VALUES (9, 'De Gavere', 'gaverzicht', '2007-08-09', 0);
    INSERT INTO `users` VALUES (10, NULL, NULL, NULL, 0);
    INSERT INTO `users` VALUES (11, 'De Gavere', 'gaverzicht', '2007-08-17', 0);
    INSERT INTO `users` VALUES (12, 'De Gavere', 'gaverzicht', '2007-08-17', 0);

    Resultaat prjdao

    16-08-2007 om 00:00 geschreven door de makers


    » Reageer (0)
    15-08-2007
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Resultaat eclipse project DAO :: jrjdao
    Resultaat prjdao na vervangen User en KlantDao door dbDao:

    0    [main] INFO  org.hibernate.cfg.Environment  - Hibernate 3.0rc1
    0    [main] INFO  org.hibernate.cfg.Environment  - hibernate.properties not found
    0    [main] INFO  org.hibernate.cfg.Environment  - using CGLIB reflection optimizer
    0    [main] INFO  org.hibernate.cfg.Environment  - using JDK 1.4 java.sql.Timestamp handling
    0    [main] INFO  org.hibernate.cfg.Configuration  - configuring from resource: /hibernate.cfg.xml
    0    [main] INFO  org.hibernate.cfg.Configuration  - Configuration resource: /hibernate.cfg.xml
    313  [main] DEBUG org.hibernate.util.DTDEntityResolver  - trying to locate http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd in classpath under org/hibernate/
    313  [main] DEBUG org.hibernate.util.DTDEntityResolver  - found http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd in classpath
    360  [main] DEBUG org.hibernate.cfg.Configuration  - connection.driver_class=com.mysql.jdbc.Driver
    360  [main] DEBUG org.hibernate.cfg.Configuration  - connection.url=jdbc:mysql://localhost/mysqltest
    375  [main] DEBUG org.hibernate.cfg.Configuration  - connection.username=xxxxx
    375  [main] DEBUG org.hibernate.cfg.Configuration  - connection.password=xxxxxx
    375  [main] DEBUG org.hibernate.cfg.Configuration  - connection.pool_size=1
    375  [main] DEBUG org.hibernate.cfg.Configuration  - dialect=org.hibernate.dialect.HSQLDialect
    375  [main] DEBUG org.hibernate.cfg.Configuration  - show_sql=true
    375  [main] DEBUG org.hibernate.cfg.Configuration  - null<-org.dom4j.tree.DefaultAttribute@c3c749 [Attribute: name resource value "config/User.hbm.xml"]
    375  [main] INFO  org.hibernate.cfg.Configuration  - Mapping resource: config/User.hbm.xml
    375  [main] DEBUG org.hibernate.util.DTDEntityResolver  - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under org/hibernate/
    375  [main] DEBUG org.hibernate.util.DTDEntityResolver  - found http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
    500  [main] INFO  org.hibernate.cfg.HbmBinder  - Mapping class: src.User -> users
    500  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: id -> id
    516  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: naam -> naam
    516  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: wachtwoord -> wachtwoord
    516  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: aansluiting -> aansluiting
    516  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: werkniveau -> werkniveau
    516  [main] DEBUG org.hibernate.cfg.Configuration  - null<-org.dom4j.tree.DefaultAttribute@56a499 [Attribute: name resource value "config/Klant.hbm.xml"]
    516  [main] INFO  org.hibernate.cfg.Configuration  - Mapping resource: config/Klant.hbm.xml
    516  [main] DEBUG org.hibernate.util.DTDEntityResolver  - trying to locate http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under org/hibernate/
    516  [main] DEBUG org.hibernate.util.DTDEntityResolver  - found http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
    563  [main] INFO  org.hibernate.cfg.HbmBinder  - Mapping class: src.Klant -> klanten
    563  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: id -> id
    563  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: voornaam -> voornaam
    563  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: achternaam -> achternaam
    563  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: straat -> straat
    563  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: huisnr -> huisnr
    563  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: postnr -> postnr
    563  [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: gemeente -> gemeente
    563  [main] INFO  org.hibernate.cfg.Configuration  - Configured SessionFactory: null
    579  [main] DEBUG org.hibernate.cfg.Configuration  - properties:
    579  [main] DEBUG org.hibernate.cfg.Configuration  - Preparing to build session factory with filters : {}
    579  [main] INFO  org.hibernate.cfg.Configuration  - processing extends queue
    579  [main] INFO  org.hibernate.cfg.Configuration  - processing collection mappings
    579  [main] INFO  org.hibernate.cfg.Configuration  - processing association property references
    579  [main] INFO  org.hibernate.cfg.Configuration  - processing foreign key constraints
    672  [main] INFO  org.hibernate.dialect.Dialect  - Using dialect: org.hibernate.dialect.HSQLDialect
    672  [main] DEBUG org.hibernate.exception.SQLExceptionConverterFactory  - Using dialect defined converter
    688  [main] INFO  org.hibernate.cfg.SettingsFactory  - Default batch fetch size: 1
    688  [main] INFO  org.hibernate.cfg.SettingsFactory  - Generate SQL with comments: disabled
    688  [main] INFO  org.hibernate.cfg.SettingsFactory  - Order SQL updates by primary key: disabled
    688  [main] INFO  org.hibernate.cfg.SettingsFactory  - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
    688  [main] INFO  org.hibernate.hql.ast.ASTQueryTranslatorFactory  - Using ASTQueryTranslatorFactory
    688  [main] INFO  org.hibernate.cfg.SettingsFactory  - Query language substitutions: {}
    688  [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider  - Using Hibernate built-in connection pool (not for production use!)
    688  [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider  - Hibernate connection pool size: 1
    688  [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider  - autocommit mode: false
    704  [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider  - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/mysqltest
    704  [main] INFO  org.hibernate.connection.DriverManagerConnectionProvider  - connection properties: {user=user, password=passwoord}
    704  [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
    704  [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - opening new JDBC connection
    891  [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - created connection to: jdbc:mysql://localhost/mysqltest, Isolation Level: 4
    891  [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1
    891  [main] INFO  org.hibernate.cfg.SettingsFactory  - JDBC batch size: 15
    891  [main] INFO  org.hibernate.cfg.SettingsFactory  - JDBC batch updates for versioned data: disabled
    891  [main] INFO  org.hibernate.cfg.SettingsFactory  - Scrollable result sets: enabled
    891  [main] DEBUG org.hibernate.cfg.SettingsFactory  - Wrap result sets: disabled
    891  [main] INFO  org.hibernate.cfg.SettingsFactory  - JDBC3 getGeneratedKeys(): enabled
    891  [main] INFO  org.hibernate.transaction.TransactionFactoryFactory  - Using default transaction strategy (direct JDBC transactions)
    891  [main] INFO  org.hibernate.transaction.TransactionManagerLookupFactory  - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
    907  [main] INFO  org.hibernate.cfg.SettingsFactory  - Automatic flush during beforeCompletion(): disabled
    907  [main] INFO  org.hibernate.cfg.SettingsFactory  - Automatic session close at end of transaction: disabled
    907  [main] INFO  org.hibernate.cfg.SettingsFactory  - Cache provider: org.hibernate.cache.EhCacheProvider
    907  [main] INFO  org.hibernate.cfg.SettingsFactory  - Second-level cache: enabled
    907  [main] INFO  org.hibernate.cfg.SettingsFactory  - Optimize cache for minimal puts: disabled
    907  [main] INFO  org.hibernate.cfg.SettingsFactory  - Structured second-level cache entries: enabled
    907  [main] INFO  org.hibernate.cfg.SettingsFactory  - Query cache: disabled
    907  [main] INFO  org.hibernate.cfg.SettingsFactory  - Echoing all SQL to stdout
    907  [main] INFO  org.hibernate.cfg.SettingsFactory  - Statistics: disabled
    907  [main] INFO  org.hibernate.cfg.SettingsFactory  - Deleted entity synthetic identifier rollback: disabled
    907  [main] INFO  org.hibernate.cfg.SettingsFactory  - Default entity-mode: pojo
    1063 [main] INFO  org.hibernate.impl.SessionFactoryImpl  - building session factory
    1063 [main] DEBUG org.hibernate.impl.SessionFactoryImpl  - Session factory constructed with filter configurations : {}
    1063 [main] DEBUG org.hibernate.impl.SessionFactoryImpl  - instantiating session factory with properties:
    1063 [main] DEBUG net.sf.ehcache.CacheManager  - Creating new CacheManager with default config
    1063 [main] DEBUG net.sf.ehcache.CacheManager  - Configuring ehcache from classpath.
    1063 [main] WARN  net.sf.ehcache.config.Configurator  - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/J:/eclipse/jars_plugins/jars/ibernate3-extra/ehcache-1.1.jar!/ehcache-failsafe.xml
    1079 [main] DEBUG net.sf.ehcache.config.Configuration$DiskStore  - Disk Store Path: C:DOCUME~1EigenaarLOCALS~1Temp
    in klant :naam
    1360 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  - Static SQL for entity: src.User
    1360 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  -  Version select: select id from users where id =?
    1360 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  -  Snapshot select: select user_.id, user_.naam as naam0_, user_.wachtwoord as wachtwoord0_, user_.aansluiting as aansluit4_0_, user_.werkniveau as werkniveau0_ from users user_ where user_.id=?
    1360 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  -  Insert 0: insert into users (naam, wachtwoord, aansluiting, werkniveau, id) values (?, ?, ?, ?, ?)
    1360 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  -  Update 0: update users set naam=?, wachtwoord=?, aansluiting=?, werkniveau=? where id=?
    1360 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  -  Delete 0: delete from users where id=?
    1454 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  - Static SQL for entity: src.Klant
    1454 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  -  Version select: select id from klanten where id =?
    1454 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  -  Snapshot select: select klant_.id, klant_.voornaam as voornaam1_, klant_.achternaam as achternaam1_, klant_.straat as straat1_, klant_.huisnr as huisnr1_, klant_.postnr as postnr1_, klant_.gemeente as gemeente1_ from klanten klant_ where klant_.id=?
    1454 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  -  Insert 0: insert into klanten (voornaam, achternaam, straat, huisnr, postnr, gemeente, id) values (?, ?, ?, ?, ?, ?, ?)
    1454 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  -  Update 0: update klanten set voornaam=?, achternaam=?, straat=?, huisnr=?, postnr=?, gemeente=? where id=?
    1454 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  -  Delete 0: delete from klanten where id=?
    1485 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity src.User: select user0_.id as id0_, user0_.naam as naam0_0_, user0_.wachtwoord as wachtwoord0_0_, user0_.aansluiting as aansluit4_0_0_, user0_.werkniveau as werkniveau0_0_ from users user0_ where user0_.id=?
    1485 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity src.User: select user0_.id as id0_, user0_.naam as naam0_0_, user0_.wachtwoord as wachtwoord0_0_, user0_.aansluiting as aansluit4_0_0_, user0_.werkniveau as werkniveau0_0_ from users user0_ where user0_.id=?
    1485 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity src.User: select user0_.id as id0_, user0_.naam as naam0_0_, user0_.wachtwoord as wachtwoord0_0_, user0_.aansluiting as aansluit4_0_0_, user0_.werkniveau as werkniveau0_0_ from users user0_ where user0_.id=?
    1485 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity src.User: select user0_.id as id0_, user0_.naam as naam0_0_, user0_.wachtwoord as wachtwoord0_0_, user0_.aansluiting as aansluit4_0_0_, user0_.werkniveau as werkniveau0_0_ from users user0_ where user0_.id=?
    1485 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity src.Klant: select klant0_.id as id0_, klant0_.voornaam as voornaam1_0_, klant0_.achternaam as achternaam1_0_, klant0_.straat as straat1_0_, klant0_.huisnr as huisnr1_0_, klant0_.postnr as postnr1_0_, klant0_.gemeente as gemeente1_0_ from klanten klant0_ where klant0_.id=?
    1485 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity src.Klant: select klant0_.id as id0_, klant0_.voornaam as voornaam1_0_, klant0_.achternaam as achternaam1_0_, klant0_.straat as straat1_0_, klant0_.huisnr as huisnr1_0_, klant0_.postnr as postnr1_0_, klant0_.gemeente as gemeente1_0_ from klanten klant0_ where klant0_.id=?
    1485 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity src.Klant: select klant0_.id as id0_, klant0_.voornaam as voornaam1_0_, klant0_.achternaam as achternaam1_0_, klant0_.straat as straat1_0_, klant0_.huisnr as huisnr1_0_, klant0_.postnr as postnr1_0_, klant0_.gemeente as gemeente1_0_ from klanten klant0_ where klant0_.id=?
    1485 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity src.Klant: select klant0_.id as id0_, klant0_.voornaam as voornaam1_0_, klant0_.achternaam as achternaam1_0_, klant0_.straat as straat1_0_, klant0_.huisnr as huisnr1_0_, klant0_.postnr as postnr1_0_, klant0_.gemeente as gemeente1_0_ from klanten klant0_ where klant0_.id=?
    1485 [main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory  - initializing class SessionFactoryObjectFactory
    1500 [main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory  - registered: 402881e6147cdcb601147cdcb85d0000 (unnamed)
    1500 [main] INFO  org.hibernate.impl.SessionFactoryObjectFactory  - Not binding factory to JNDI, no JNDI name configured
    1500 [main] DEBUG org.hibernate.impl.SessionFactoryImpl  - instantiated session factory
    1500 [main] INFO  org.hibernate.impl.SessionFactoryImpl  - Checking 0 named queries
    >>>>> user update
    saveOrUpdate
    openSessionTrans
    sessionfactorg.hibernate.impl.SessionFactoryImpl@fbb7cb
    1532 [main] DEBUG org.hibernate.impl.SessionImpl  - opened session
    1532 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - begin
    1532 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - opening JDBC connection
    1532 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
    1532 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - using pooled JDBC connection, pool size: 0
    1532 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - current autocommit status: false
    1532 [main] DEBUG org.hibernate.event.def.AbstractSaveEventListener  - transient instance of: src.User
    1532 [main] DEBUG org.hibernate.event.def.DefaultSaveOrUpdateEventListener  - saving transient instance
    1532 [main] DEBUG org.hibernate.id.IncrementGenerator  - fetching initial value: select max(id) from users
    1547 [main] DEBUG org.hibernate.id.IncrementGenerator  - first free id: 2
    1547 [main] DEBUG org.hibernate.event.def.AbstractSaveEventListener  - generated identifier: 2, using strategy: org.hibernate.id.IncrementGenerator
    1547 [main] DEBUG org.hibernate.event.def.AbstractSaveEventListener  - saving [src.User#2]
    1563 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - commit
    1563 [main] DEBUG org.hibernate.impl.SessionImpl  - automatically flushing session
    1563 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - flushing session
    1563 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - processing flush-time cascades
    1563 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - dirty checking collections
    1563 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushing entities and processing referenced collections
    1563 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Processing unreferenced collections
    1563 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Scheduling collection removes/(re)creates/updates
    1563 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushed: 1 insertions, 0 updates, 0 deletions to 1 objects
    1563 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
    1563 [main] DEBUG org.hibernate.pretty.Printer  - listing entities:
    1579 [main] DEBUG org.hibernate.pretty.Printer  - src.User{aansluiting=19 augustus 2007, naam=De Koster, wachtwoord=kost, id=2, werkniveau=0}
    1579 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - executing flush
    1579 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  - Inserting entity: [src.User#2]
    1579 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
    1579 [main] DEBUG org.hibernate.SQL  - insert into users (naam, wachtwoord, aansluiting, werkniveau, id) values (?, ?, ?, ?, ?)
    Hibernate: insert into users (naam, wachtwoord, aansluiting, werkniveau, id) values (?, ?, ?, ?, ?)
    1579 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - preparing statement
    1579 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  - Dehydrating entity: [src.User#2]
    1579 [main] DEBUG org.hibernate.type.StringType  - binding 'De Koster' to parameter: 1
    1579 [main] DEBUG org.hibernate.type.StringType  - binding 'kost' to parameter: 2
    1579 [main] DEBUG org.hibernate.type.DateType  - binding '19 augustus 2007' to parameter: 3
    1579 [main] DEBUG org.hibernate.type.IntegerType  - binding '0' to parameter: 4
    1579 [main] DEBUG org.hibernate.type.LongType  - binding '2' to parameter: 5
    1579 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - Adding to batch
    1579 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - Executing batch size: 1
    1579 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
    1579 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing statement
    1579 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - post flush
    1579 [main] DEBUG org.hibernate.jdbc.JDBCContext  - before transaction completion
    1579 [main] DEBUG org.hibernate.impl.SessionImpl  - before transaction completion
    1610 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - committed JDBC Connection
    1610 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after transaction completion
    1610 [main] DEBUG org.hibernate.impl.SessionImpl  - after transaction completion
    1610 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - rollback
    1610 [main] DEBUG org.hibernate.jdbc.JDBCContext  - before transaction completion
    1610 [main] DEBUG org.hibernate.impl.SessionImpl  - before transaction completion
    1610 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - rolled back JDBC Connection
    1610 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after transaction completion
    1610 [main] DEBUG org.hibernate.impl.SessionImpl  - after transaction completion
    Terugschroeven
    1610 [main] DEBUG org.hibernate.impl.SessionImpl  - closing session
    1610 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing JDBC connection (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)
    1610 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1
    1610 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after transaction completion
    1610 [main] DEBUG org.hibernate.impl.SessionImpl  - after transaction completion
    >>>>>>>>>>>>>>>>>>>>>>>>>>user toegevoegd
    openSessionTrans
    sessionfactorg.hibernate.impl.SessionFactoryImpl@fbb7cb
    1610 [main] DEBUG org.hibernate.impl.SessionImpl  - opened session
    1610 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - begin
    1610 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - opening JDBC connection
    1610 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
    1610 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - using pooled JDBC connection, pool size: 0
    1610 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - current autocommit status: false
    1610 [main] DEBUG org.hibernate.impl.SessionImpl  - find: from src.User
    1610 [main] DEBUG org.hibernate.engine.QueryParameters  - named parameters: {}
    1625 [Finalizer] DEBUG org.hibernate.jdbc.JDBCContext  - running Session.finalize()
    1688 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl  - parse() - HQL: from src.User
    1704 [main] DEBUG org.hibernate.hql.AST  - --- HQL AST ---
     -[QUERY] CommonAST: 'query'
        -[SELECT_FROM] CommonAST: 'SELECT_FROM'
           -[FROM] CommonAST: 'from'
              -[DOT] CommonAST: '.'
                 +-[IDENT] CommonAST: 'src'
                 -[IDENT] CommonAST: 'User'

    1704 [main] DEBUG hql.parser  - throwQueryException() : no errors
    1735 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker  - query() << begin, level = 1
    1766 [main] DEBUG org.hibernate.hql.ast.FromElement  - src.User (no alias) -> user0_
    1766 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker  - query() : finishing up...
    1766 [main] DEBUG org.hibernate.hql.ast.HqlSqlWalker  - Derived SELECT clause created.
    1782 [main] DEBUG org.hibernate.hql.ast.JoinProcessor  - Using FROM fragment [users user0_]
    1782 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker  - query() >> end, level = 1
    1782 [main] DEBUG org.hibernate.hql.AST  - --- SQL AST ---
     -[SELECT] QueryNode: 'SELECT'  querySpaces (users)
        +-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
        |  +-[SELECT_EXPR] SelectExpressionImpl: 'user0_.id as id' {FromElement{explicit,not a collection join,classAlias=null,role=null,tableName=users,tableAlias=user0_,colums={,className=src.User}}}
        |  -[SQL_TOKEN] SqlFragment: 'user0_.naam as naam0_, user0_.wachtwoord as wachtwoord0_, user0_.aansluiting as aansluit4_0_, user0_.werkniveau as werkniveau0_'
        -[FROM] FromClause: 'from' FromClause{from}
           -[FROM_FRAGMENT] FromElement: 'users user0_' FromElement{explicit,not a collection join,classAlias=null,role=null,tableName=users,tableAlias=user0_,colums={,className=src.User}}

    1782 [main] DEBUG hql.parser  - throwQueryException() : no errors
    1797 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl  - HQL: from src.User
    1797 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl  - SQL: select user0_.id as id, user0_.naam as naam0_, user0_.wachtwoord as wachtwoord0_, user0_.aansluiting as aansluit4_0_, user0_.werkniveau as werkniveau0_ from users user0_
    1797 [main] DEBUG hql.parser  - throwQueryException() : no errors
    1797 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
    1797 [main] DEBUG org.hibernate.SQL  - select user0_.id as id, user0_.naam as naam0_, user0_.wachtwoord as wachtwoord0_, user0_.aansluiting as aansluit4_0_, user0_.werkniveau as werkniveau0_ from users user0_
    Hibernate: select user0_.id as id, user0_.naam as naam0_, user0_.wachtwoord as wachtwoord0_, user0_.aansluiting as aansluit4_0_, user0_.werkniveau as werkniveau0_ from users user0_
    1797 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - preparing statement
    1797 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open ResultSet (open ResultSets: 0, globally: 0)
    1797 [main] DEBUG org.hibernate.loader.Loader  - processing result set
    1797 [main] DEBUG org.hibernate.loader.Loader  - result set row: 0
    1797 [main] DEBUG org.hibernate.type.LongType  - returning '1' as column: id
    1797 [main] DEBUG org.hibernate.loader.Loader  - result row: EntityKey[src.User#1]
    1797 [main] DEBUG org.hibernate.loader.Loader  - Initializing object from ResultSet: [src.User#1]
    1797 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  - Hydrating entity: [src.User#1]
    1797 [main] DEBUG org.hibernate.type.StringType  - returning 'De Koster' as column: naam0_
    1797 [main] DEBUG org.hibernate.type.StringType  - returning 'kost' as column: wachtwoord0_
    1813 [main] DEBUG org.hibernate.type.DateType  - returning '19 augustus 2007' as column: aansluit4_0_
    1813 [main] DEBUG org.hibernate.type.IntegerType  - returning '0' as column: werkniveau0_
    1813 [main] DEBUG org.hibernate.loader.Loader  - result set row: 1
    1813 [main] DEBUG org.hibernate.type.LongType  - returning '2' as column: id
    1813 [main] DEBUG org.hibernate.loader.Loader  - result row: EntityKey[src.User#2]
    1813 [main] DEBUG org.hibernate.loader.Loader  - Initializing object from ResultSet: [src.User#2]
    1813 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  - Hydrating entity: [src.User#2]
    1813 [main] DEBUG org.hibernate.type.StringType  - returning 'De Koster' as column: naam0_
    1813 [main] DEBUG org.hibernate.type.StringType  - returning 'kost' as column: wachtwoord0_
    1813 [main] DEBUG org.hibernate.type.DateType  - returning '19 augustus 2007' as column: aansluit4_0_
    1813 [main] DEBUG org.hibernate.type.IntegerType  - returning '0' as column: werkniveau0_
    1813 [main] DEBUG org.hibernate.loader.Loader  - done processing result set (2 rows)
    1813 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close ResultSet (open ResultSets: 1, globally: 1)
    1813 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
    1813 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing statement
    1813 [main] DEBUG org.hibernate.loader.Loader  - total objects hydrated: 2
    1813 [main] DEBUG org.hibernate.engine.TwoPhaseLoad  - resolving associations for [src.User#1]
    in klant :naam
    1813 [main] DEBUG org.hibernate.engine.TwoPhaseLoad  - done materializing entity [src.User#1]
    1813 [main] DEBUG org.hibernate.engine.TwoPhaseLoad  - resolving associations for [src.User#2]
    in klant :naam
    1813 [main] DEBUG org.hibernate.engine.TwoPhaseLoad  - done materializing entity [src.User#2]
    1813 [main] DEBUG org.hibernate.engine.PersistenceContext  - initializing non-lazy collections
    1813 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - commit
    1813 [main] DEBUG org.hibernate.impl.SessionImpl  - automatically flushing session
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - flushing session
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - processing flush-time cascades
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - dirty checking collections
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushing entities and processing referenced collections
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Processing unreferenced collections
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Scheduling collection removes/(re)creates/updates
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushed: 0 insertions, 0 updates, 0 deletions to 2 objects
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
    1813 [main] DEBUG org.hibernate.pretty.Printer  - listing entities:
    1813 [main] DEBUG org.hibernate.pretty.Printer  - src.User{aansluiting=19 augustus 2007, naam=De Koster, wachtwoord=kost, id=2, werkniveau=0}
    1813 [main] DEBUG org.hibernate.pretty.Printer  - src.User{aansluiting=19 augustus 2007, naam=De Koster, wachtwoord=kost, id=1, werkniveau=0}
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - executing flush
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - post flush
    1813 [main] DEBUG org.hibernate.jdbc.JDBCContext  - before transaction completion
    1813 [main] DEBUG org.hibernate.impl.SessionImpl  - before transaction completion
    1813 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - committed JDBC Connection
    1813 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after transaction completion
    1813 [main] DEBUG org.hibernate.impl.SessionImpl  - after transaction completion
    1813 [main] DEBUG org.hibernate.impl.SessionImpl  - closing session
    1813 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing JDBC connection (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)
    1813 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1
    1813 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after transaction completion
    1813 [main] DEBUG org.hibernate.impl.SessionImpl  - after transaction completion
    maak indien nodig
    sessionfactorg.hibernate.impl.SessionFactoryImpl@fbb7cb
    >>>>> user update
    saveOrUpdate
    openSessionTrans
    sessionfactorg.hibernate.impl.SessionFactoryImpl@fbb7cb
    1813 [main] DEBUG org.hibernate.impl.SessionImpl  - opened session
    1813 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - begin
    1813 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - opening JDBC connection
    1813 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
    1813 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - using pooled JDBC connection, pool size: 0
    1813 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - current autocommit status: false
    1813 [main] DEBUG org.hibernate.event.def.AbstractSaveEventListener  - transient instance of: src.Klant
    1813 [main] DEBUG org.hibernate.event.def.DefaultSaveOrUpdateEventListener  - saving transient instance
    1813 [main] DEBUG org.hibernate.id.IncrementGenerator  - fetching initial value: select max(id) from klanten
    1813 [main] DEBUG org.hibernate.id.IncrementGenerator  - first free id: 2
    1813 [main] DEBUG org.hibernate.event.def.AbstractSaveEventListener  - generated identifier: 2, using strategy: org.hibernate.id.IncrementGenerator
    1813 [main] DEBUG org.hibernate.event.def.AbstractSaveEventListener  - saving [src.Klant#2]
    1813 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - commit
    1813 [main] DEBUG org.hibernate.impl.SessionImpl  - automatically flushing session
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - flushing session
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - processing flush-time cascades
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - dirty checking collections
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushing entities and processing referenced collections
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Processing unreferenced collections
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Scheduling collection removes/(re)creates/updates
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushed: 1 insertions, 0 updates, 0 deletions to 1 objects
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
    1813 [main] DEBUG org.hibernate.pretty.Printer  - listing entities:
    1813 [main] DEBUG org.hibernate.pretty.Printer  - src.Klant{postnr=4578, straat=Klantenstraat, voornaam=Andre, gemeente=Winkelen, huisnr=15, achternaam=De Client, id=2}
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - executing flush
    1813 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  - Inserting entity: [src.Klant#2]
    1813 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
    1813 [main] DEBUG org.hibernate.SQL  - insert into klanten (voornaam, achternaam, straat, huisnr, postnr, gemeente, id) values (?, ?, ?, ?, ?, ?, ?)
    Hibernate: insert into klanten (voornaam, achternaam, straat, huisnr, postnr, gemeente, id) values (?, ?, ?, ?, ?, ?, ?)
    1813 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - preparing statement
    1813 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  - Dehydrating entity: [src.Klant#2]
    1813 [main] DEBUG org.hibernate.type.StringType  - binding 'Andre' to parameter: 1
    1813 [main] DEBUG org.hibernate.type.StringType  - binding 'De Client' to parameter: 2
    1813 [main] DEBUG org.hibernate.type.StringType  - binding 'Klantenstraat' to parameter: 3
    1813 [main] DEBUG org.hibernate.type.StringType  - binding '15' to parameter: 4
    1813 [main] DEBUG org.hibernate.type.StringType  - binding '4578' to parameter: 5
    1813 [main] DEBUG org.hibernate.type.StringType  - binding 'Winkelen' to parameter: 6
    1813 [main] DEBUG org.hibernate.type.LongType  - binding '2' to parameter: 7
    1813 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - Adding to batch
    1813 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - Executing batch size: 1
    1813 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
    1813 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing statement
    1813 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - post flush
    1813 [main] DEBUG org.hibernate.jdbc.JDBCContext  - before transaction completion
    1813 [main] DEBUG org.hibernate.impl.SessionImpl  - before transaction completion
    1844 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - committed JDBC Connection
    1844 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after transaction completion
    1844 [main] DEBUG org.hibernate.impl.SessionImpl  - after transaction completion
    1844 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - rollback
    1844 [main] DEBUG org.hibernate.jdbc.JDBCContext  - before transaction completion
    1844 [main] DEBUG org.hibernate.impl.SessionImpl  - before transaction completion
    1844 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - rolled back JDBC Connection
    1844 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after transaction completion
    1844 [main] DEBUG org.hibernate.impl.SessionImpl  - after transaction completion
    Terugschroeven
    1844 [main] DEBUG org.hibernate.impl.SessionImpl  - closing session
    1844 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing JDBC connection (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)
    1844 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1
    1844 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after transaction completion
    1844 [main] DEBUG org.hibernate.impl.SessionImpl  - after transaction completion
    >>>>>>>>>>>>>>>>>>>>>>>>>>klant toegevoegd
    openSessionTrans
    sessionfactorg.hibernate.impl.SessionFactoryImpl@fbb7cb
    1844 [main] DEBUG org.hibernate.impl.SessionImpl  - opened session
    1844 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - begin
    1844 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - opening JDBC connection
    1844 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
    1844 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - using pooled JDBC connection, pool size: 0
    1844 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - current autocommit status: false
    1844 [main] DEBUG org.hibernate.impl.SessionImpl  - find: from src.Klant
    1844 [main] DEBUG org.hibernate.engine.QueryParameters  - named parameters: {}
    1844 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl  - parse() - HQL: from src.Klant
    1860 [main] DEBUG org.hibernate.hql.AST  - --- HQL AST ---
     -[QUERY] CommonAST: 'query'
        -[SELECT_FROM] CommonAST: 'SELECT_FROM'
           -[FROM] CommonAST: 'from'
              -[DOT] CommonAST: '.'
                 +-[IDENT] CommonAST: 'src'
                 -[IDENT] CommonAST: 'Klant'

    1860 [main] DEBUG hql.parser  - throwQueryException() : no errors
    1860 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker  - query() << begin, level = 1
    1860 [main] DEBUG org.hibernate.hql.ast.FromElement  - src.Klant (no alias) -> klant0_
    1860 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker  - query() : finishing up...
    1860 [main] DEBUG org.hibernate.hql.ast.HqlSqlWalker  - Derived SELECT clause created.
    1860 [main] DEBUG org.hibernate.hql.ast.JoinProcessor  - Using FROM fragment [klanten klant0_]
    1860 [main] DEBUG org.hibernate.hql.antlr.HqlSqlBaseWalker  - query() >> end, level = 1
    1860 [main] DEBUG org.hibernate.hql.AST  - --- SQL AST ---
     -[SELECT] QueryNode: 'SELECT'  querySpaces (klanten)
        +-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
        |  +-[SELECT_EXPR] SelectExpressionImpl: 'klant0_.id as id' {FromElement{explicit,not a collection join,classAlias=null,role=null,tableName=klanten,tableAlias=klant0_,colums={,className=src.Klant}}}
        |  -[SQL_TOKEN] SqlFragment: 'klant0_.voornaam as voornaam1_, klant0_.achternaam as achternaam1_, klant0_.straat as straat1_, klant0_.huisnr as huisnr1_, klant0_.postnr as postnr1_, klant0_.gemeente as gemeente1_'
        -[FROM] FromClause: 'from' FromClause{from}
           -[FROM_FRAGMENT] FromElement: 'klanten klant0_' FromElement{explicit,not a collection join,classAlias=null,role=null,tableName=klanten,tableAlias=klant0_,colums={,className=src.Klant}}

    1860 [main] DEBUG hql.parser  - throwQueryException() : no errors
    1860 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl  - HQL: from src.Klant
    1860 [main] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl  - SQL: select klant0_.id as id, klant0_.voornaam as voornaam1_, klant0_.achternaam as achternaam1_, klant0_.straat as straat1_, klant0_.huisnr as huisnr1_, klant0_.postnr as postnr1_, klant0_.gemeente as gemeente1_ from klanten klant0_
    1860 [main] DEBUG hql.parser  - throwQueryException() : no errors
    1860 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
    1860 [main] DEBUG org.hibernate.SQL  - select klant0_.id as id, klant0_.voornaam as voornaam1_, klant0_.achternaam as achternaam1_, klant0_.straat as straat1_, klant0_.huisnr as huisnr1_, klant0_.postnr as postnr1_, klant0_.gemeente as gemeente1_ from klanten klant0_
    Hibernate: select klant0_.id as id, klant0_.voornaam as voornaam1_, klant0_.achternaam as achternaam1_, klant0_.straat as straat1_, klant0_.huisnr as huisnr1_, klant0_.postnr as postnr1_, klant0_.gemeente as gemeente1_ from klanten klant0_
    1860 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - preparing statement
    1860 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open ResultSet (open ResultSets: 0, globally: 0)
    1860 [main] DEBUG org.hibernate.loader.Loader  - processing result set
    1860 [main] DEBUG org.hibernate.loader.Loader  - result set row: 0
    1860 [main] DEBUG org.hibernate.type.LongType  - returning '1' as column: id
    1860 [main] DEBUG org.hibernate.loader.Loader  - result row: EntityKey[src.Klant#1]
    1860 [main] DEBUG org.hibernate.loader.Loader  - Initializing object from ResultSet: [src.Klant#1]
    1860 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  - Hydrating entity: [src.Klant#1]
    1860 [main] DEBUG org.hibernate.type.StringType  - returning 'Andre' as column: voornaam1_
    1860 [main] DEBUG org.hibernate.type.StringType  - returning 'De Client' as column: achternaam1_
    1860 [main] DEBUG org.hibernate.type.StringType  - returning 'Klantenstraat' as column: straat1_
    1860 [main] DEBUG org.hibernate.type.StringType  - returning '15' as column: huisnr1_
    1860 [main] DEBUG org.hibernate.type.StringType  - returning '4578' as column: postnr1_
    1860 [main] DEBUG org.hibernate.type.StringType  - returning 'Winkelen' as column: gemeente1_
    1860 [main] DEBUG org.hibernate.loader.Loader  - result set row: 1
    1860 [main] DEBUG org.hibernate.type.LongType  - returning '2' as column: id
    1860 [main] DEBUG org.hibernate.loader.Loader  - result row: EntityKey[src.Klant#2]
    1860 [main] DEBUG org.hibernate.loader.Loader  - Initializing object from ResultSet: [src.Klant#2]
    1860 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister  - Hydrating entity: [src.Klant#2]
    1860 [main] DEBUG org.hibernate.type.StringType  - returning 'Andre' as column: voornaam1_
    1860 [main] DEBUG org.hibernate.type.StringType  - returning 'De Client' as column: achternaam1_
    1860 [main] DEBUG org.hibernate.type.StringType  - returning 'Klantenstraat' as column: straat1_
    1860 [main] DEBUG org.hibernate.type.StringType  - returning '15' as column: huisnr1_
    1860 [main] DEBUG org.hibernate.type.StringType  - returning '4578' as column: postnr1_
    1860 [main] DEBUG org.hibernate.type.StringType  - returning 'Winkelen' as column: gemeente1_
    1860 [main] DEBUG org.hibernate.loader.Loader  - done processing result set (2 rows)
    1860 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close ResultSet (open ResultSets: 1, globally: 1)
    1860 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
    1860 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing statement
    1860 [main] DEBUG org.hibernate.loader.Loader  - total objects hydrated: 2
    1860 [main] DEBUG org.hibernate.engine.TwoPhaseLoad  - resolving associations for [src.Klant#1]
    1860 [main] DEBUG org.hibernate.engine.TwoPhaseLoad  - done materializing entity [src.Klant#1]
    1860 [main] DEBUG org.hibernate.engine.TwoPhaseLoad  - resolving associations for [src.Klant#2]
    1860 [main] DEBUG org.hibernate.engine.TwoPhaseLoad  - done materializing entity [src.Klant#2]
    1860 [main] DEBUG org.hibernate.engine.PersistenceContext  - initializing non-lazy collections
    1860 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - commit
    1860 [main] DEBUG org.hibernate.impl.SessionImpl  - automatically flushing session
    1860 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - flushing session
    1860 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - processing flush-time cascades
    1860 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - dirty checking collections
    1860 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushing entities and processing referenced collections
    1860 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Processing unreferenced collections
    1860 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Scheduling collection removes/(re)creates/updates
    1860 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushed: 0 insertions, 0 updates, 0 deletions to 2 objects
    1860 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
    1860 [main] DEBUG org.hibernate.pretty.Printer  - listing entities:
    1860 [main] DEBUG org.hibernate.pretty.Printer  - src.Klant{postnr=4578, straat=Klantenstraat, voornaam=Andre, gemeente=Winkelen, huisnr=15, achternaam=De Client, id=2}
    1860 [main] DEBUG org.hibernate.pretty.Printer  - src.Klant{postnr=4578, straat=Klantenstraat, voornaam=Andre, gemeente=Winkelen, huisnr=15, achternaam=De Client, id=1}
    1860 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - executing flush
    1860 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener  - post flush
    1860 [main] DEBUG org.hibernate.jdbc.JDBCContext  - before transaction completion
    1860 [main] DEBUG org.hibernate.impl.SessionImpl  - before transaction completion
    1860 [main] DEBUG org.hibernate.transaction.JDBCTransaction  - committed JDBC Connection
    1860 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after transaction completion
    1860 [main] DEBUG org.hibernate.impl.SessionImpl  - after transaction completion
    1860 [main] DEBUG org.hibernate.impl.SessionImpl  - closing session
    1860 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing JDBC connection (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)
    1860 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1
    1875 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after transaction completion
    1875 [main] DEBUG org.hibernate.impl.SessionImpl  - after transaction completion
    Einde main


    15-08-2007 om 00:00 geschreven door de makers


    » Reageer (0)
    14-08-2007
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.KlantDao.java en UserDao.java vervangen door dbDao.java

    Vervangen van KlantDao.java en UserDao.java door 1 enkel bestand : dbDao.java

    1.Nieuwe code voor Main.java
    2.Code voor dbDao [Nieuwe code voor User-KlantDao]

    » Naar  Menu


     

    1.Nieuwe code voor Main.java

    --- begin Main.java ------

    package src;

    import java.util.Date;

    public class Main {

        public static void main(String[] args) {


        Date now = new Date ();

        /*
        * User toevoegen aan de database
        */
        User user = new User();
        user.setNaam("De Koster");
        user.setWachtwoord("kost");
        user.setAansluiting(now);

        dbDao dbuser = new dbDao();
        dbuser.update(user);
        System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>user toegevoegd");
        dbuser.findAll(User.class);

        /*
        * Klant toevoegen aan de database
        */
        Klant klant = new Klant();
        klant.setAchternaam("De Client");
        klant.setVoornaam("Andre");
        klant.setStraat("Klantenstraat");
        klant.setHuisnr("15");
        klant.setPostnr("4578");
        klant.setGemeente("Winkelen");


        dbDao dbklant = new dbDao();
        dbklant.update(klant);
        System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>klant toegevoegd");
        dbklant.findAll(Klant.class);


        System.out.println("Einde main");

    }

    }
     

    --- einde Main.java ------


     

    2.Vervangen van de 2 codebestanden userDao.java en KlantDao.java door dbDao.java te gebruiken voor klant and user

    --- begin dbDao.java ------

    package src;

    import java.util.List;

    public class dbDao extends ConstructDao {
    public dbDao() {
    super();
    }

        /*
        * Een Oject toevoegen aan - wijzigen in de database.
        */
        public void create(Object obj) throws DataAccessError {
            super.saveOrUpdate(obj);
        }


        /*
        * Een Oject  verwijderen uit de database.
        */
        public void delete(Object obj) throws DataAccessError {
            super.delete(obj);
        }

        /**
        * Zoeken met primary key.
        * @param id
        * @return
        */
        public Object find(Long id) throws DataAccessError {
            return (Object) super.find(Object.class, id);
        }

        /*
        * Oject  toevoegen aan - of wijzigen in de database.
        */
        public void update(Object obj) throws DataAccessError {
            super.saveOrUpdate(obj);
        }

        /*
        * Haal Oject op uit de database.
        */
        public List findAll() throws DataAccessError{
            return super.findAll(Object.class);
        }
    }

    --- einde dbDao.java ------

     

    14-08-2007 om 00:00 geschreven door de makers


    » Reageer (0)
    20-07-2007
    Klik hier om een link te hebben waarmee u dit artikel later terug kunt lezen.Voorbeeld HQL - sample HQL FROM (class name)
    Java eclipse HQL :: mapping    Database server : mysql
    Ophalen van databasegegevens met HQL ::  Hibernate Query Language

        Copyright willems(c)juli 2007
        Link = http://blog.seniorennet.be/pwtechniek/archief.php?ID=57


    Voordeel van het gebruik van HQL:
     - overzichtelijke code
     - programma is nadien gemakkelijk aan te passen

    Voorbeeld HQL [sample HQL FROM (class name)]

    Structuur project:

    [-]mysqltest
        [-]bron
         + Leverancier.java
         + main_test.java
        [+][] JRE System Library
        [+][] xerces-2.6.2.jar
        [+][] ant-antlr-1.6.3.jar
        [+][] antlr-2.7.5H3.jar
        [+][] asm.jar
        [+][] asm-attrs.jar
        [+][] cglib-2.1.jar
        [+][] commons-collections-2.1.1.jar
        [+][] commons-logging-1.0.4.jar
        [+][] dom4j-1.6.jar
        [+][] ehache-1.1.jar
        [+][] hibernate3.jar
        [+][] hsqldb.jar
        [+][] jta.jar
        [+][] log4j-1.2.9.jar
        [+][] mysql-connector-java-3.1.6-bin.jar
         |-- hibernate.cfg.xml
         |-- Leverancier.hbm.xml
         |-- log4j.properties

    1.Code van Leverancier.java in package bron

    package bron;


        import java.sql.ResultSet;

        import java.sql.SQLException;
        public class Leverancier{

        private String firmanaam, rechtspers, straat, gemeente, telefoon, fax, GSM, email, vertegenwoordiger, vertegen_GSM, vertegen_email, tweede_naam, tweede_straat, tweede_gemeente, tweede_telefoon, tweede_GSM, beschrijving, info ;
        private int id, nr, postcode, tweede_nr, tweede_postcode ;



        public int getid(){
        return id;
        }
        public void setid(int id){
        this.id = id;
        }
        public String getfirmanaam(){
        return firmanaam;
        }
        public void setfirmanaam(String firmanaam){
        this.firmanaam = firmanaam;
        }
        public String getrechtspers(){
        return rechtspers;
        }
        public void setrechtspers(String rechtspers){
        this.rechtspers = rechtspers;
        }
        public String getstraat(){
        return straat;
        }
        public void setstraat(String straat){
        this.straat = straat;
        }
        public int getnr(){
        return nr;
        }
        public void setnr(int nr){
        this.nr = nr;
        }
        public int getpostcode(){
        return postcode;
        }
        public void setpostcode(int postcode){
        this.postcode = postcode;
        }
        public String getgemeente(){
        return gemeente;
        }
        public void setgemeente(String gemeente){
        this.gemeente = gemeente;
        }
        public String gettelefoon(){
        return telefoon;
        }
        public void settelefoon(String telefoon){
        this.telefoon = telefoon;
        }
        public String getfax(){
        return fax;
        }
        public void setfax(String fax){
        this.fax = fax;
        }
        public String getGSM(){
        return GSM;
        }
        public void setGSM(String GSM){
        this.GSM = GSM;
        }
        public String getemail(){
        return email;
        }
        public void setemail(String email){
        this.email = email;
        }
        public String getvertegenwoordiger(){
        return vertegenwoordiger;
        }
        public void setvertegenwoordiger(String vertegenwoordiger){
        this.vertegenwoordiger = vertegenwoordiger;
        }
        public String getvertegen_GSM(){
        return vertegen_GSM;
        }
        public void setvertegen_GSM(String vertegen_GSM){
        this.vertegen_GSM = vertegen_GSM;
        }
        public String getvertegen_email(){
        return vertegen_email;
        }
        public void setvertegen_email(String vertegen_email){
        this.vertegen_email = vertegen_email;
        }
        public String gettweede_naam(){
        return tweede_naam;
        }
        public void settweede_naam(String tweede_naam){
        this.tweede_naam = tweede_naam;
        }
        public String gettweede_straat(){
        return tweede_straat;
        }
        public void settweede_straat(String tweede_straat){
        this.tweede_straat = tweede_straat;
        }
        public int gettweede_nr(){
        return tweede_nr;
        }
        public void settweede_nr(int tweede_nr){
        this.tweede_nr = tweede_nr;
        }
        public int gettweede_postcode(){
        return tweede_postcode;
        }
        public void settweede_postcode(int tweede_postcode){
        this.tweede_postcode = tweede_postcode;
        }
        public String gettweede_gemeente(){
        return tweede_gemeente;
        }
        public void settweede_gemeente(String tweede_gemeente){
        this.tweede_gemeente = tweede_gemeente;
        }
        public String gettweede_telefoon(){
        return tweede_telefoon;
        }
        public void settweede_telefoon(String tweede_telefoon){
        this.tweede_telefoon = tweede_telefoon;
        }
        public String gettweede_GSM(){
        return tweede_GSM;
        }
        public void settweede_GSM(String tweede_GSM){
        this.tweede_GSM = tweede_GSM;
        }
        public String getbeschrijving(){
        return beschrijving;
        }
        public void setbeschrijving(String beschrijving){
        this.beschrijving = beschrijving;
        }
        public String getinfo(){
        return info;
        }
        public void setinfo(String info){
        this.info = info;
        }

        }

    2.Code van main_test.java in package bron

    package bron;

    import org.hibernate.*;
    import org.hibernate.cfg.*;
    import java.util.*;


    /**
     * @author piet willems
     *
     * pwTechniek
     * HQL Example
     */

    public class main_test {
        public static void main(String[] args) {
        Session session = null;

        try{
            // lezen hibernate.cfg.xml en voorbereiding hibernate
            SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
            session =sessionFactory.openSession();

              // HQL : FROM class !!
             String hql_QUERY ="FROM Leverancier as p";
             Query query = session.createQuery(hql_QUERY);
             for(Iterator it=query.iterate();it.hasNext();){
                 Leverancier row = (Leverancier) it.next();

                 System.out.println("Firma: " + row.getfirmanaam());
                 System.out.println("Straat: " + row.getstraat());
                 System.out.println("Gemeente: " + row.getgemeente());
                 System.out.println("ID: " + row.getid());
             }
            session.close();
        }catch(Exception e){
            System.out.println(e.getMessage());
        }finally{
            }
         System.out.println("end");
        }

    }


    3.Code van hibernate.cfg.xml in project mysqltest

    <?xml version='1.0' encoding='utf-8'?>
    <!DOCTYPE hibernate-configuration PUBLIC
            "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
            "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

    <hibernate-configuration>

        <session-factory>

            <!-- Database connection settings -->
            <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
            <property name="connection.url">jdbc:mysql://localhost/mysqltest</property>
            <property name="connection.username">sa</property>
            <property name="connection.password">hqlhql</property>

            <!-- JDBC connection pool (use the built-in) -->
            <property name="connection.pool_size">1</property>
            <!-- Volgende lijn uit commentaar zetten om de database opnieuw te laten aanmaken -->       
            <!--property name="hbm2ddl.auto">create</property-->

            <!-- SQL dialect -->
            <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>

            <!-- Echo all executed SQL to stdout -->
            <property name="show_sql">true</property>

            <mapping resource="Leverancier.hbm.xml"/>

        </session-factory>

    </hibernate-configuration>


    4.Code van Leverancier.hbm.xml

    !! Overeenkomst :
    - classe Leverancier met hoofdletter
    - tabel database : met kleine letters

    code :

    <?xml version="1.0"?>
    <!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

    <hibernate-mapping>

    <!--
    pwTechniek:: class:bron.Leverancier, tabel: leverancier"
    pwTechniek:: HQL -voorbeeld, project : Kantoren , mapping
    -->

    <class name="bron.Leverancier" table="leverancier">
    <id name="id" column="ID" type="int" unsaved-value="null">
     <generator class="increment"/>
    </id>

    <property name="firmanaam" type="string"/>
    <property name="straat" type="string"/>
    <property name="nr" type="int"/>
    <property name="postcode" type="int"/>
    <property name="gemeente" type="string"/>
    <property name="telefoon" type="string"/>
    <property name="fax" type="string"/>
    <property name="GSM" type="string"/>
    <property name="email" type="string"/>
    <property name="vertegenwoordiger" type="string"/>
    <property name="vertegen_GSM" type="string"/>
    <property name="vertegen_email" type="string"/>
    <property name="tweede_naam" type="string"/>
    <property name="tweede_straat" type="string"/>
    <property name="tweede_nr" type="int"/>
    <property name="tweede_postcode" type="int"/>
    <property name="tweede_gemeente" type="string"/>
    <property name="tweede_telefoon" type="string"/>
    <property name="tweede_GSM" type="string"/>
    <property name="beschrijving" type="string"/>
    <property name="info" type="string"/>
    </class>

    </hibernate-mapping>



    5.Code log4j.properties

    log4j.rootLogger=DEBUG, A1
    log4j.appender.A1=
      org.apache.log4j.ConsoleAppender
    log4j.appender.A1.layout=
      org.apache.log4j.PatternLayout
    log4j.appender.A1.layout.ConversionPattern=
      %-4r [%t] %-5p %c %x - %m%n


    6.Database : Mysqltest : table : leverancier

    -- phpMyAdmin SQL Dump
    -- version 2.6.1-pl3
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generatie Tijd: 21 Jul 2007 om 21:06
    -- Server versie: 5.0.24
    -- PHP Versie: 5.0.3
    --
    -- Database: `mysqltest`
    --

    -- --------------------------------------------------------

    --
    -- Tabel structuur voor tabel `leverancier`
    --

    CREATE TABLE `leverancier` (
      `id` int(11) NOT NULL auto_increment,
      `firmanaam` varchar(30) NOT NULL,
      `rechtspers` varchar(6) NOT NULL,
      `straat` varchar(50) NOT NULL,
      `nr` int(11) NOT NULL,
      `postcode` int(11) NOT NULL,
      `gemeente` varchar(30) NOT NULL,
      `telefoon` varchar(9) NOT NULL,
      `fax` varchar(9) NOT NULL,
      `GSM` varchar(10) NOT NULL,
      `email` varchar(50) NOT NULL,
      `vertegenwoordiger` varchar(30) NOT NULL,
      `vertegen_GSM` varchar(10) NOT NULL,
      `vertegen_email` varchar(50) NOT NULL,
      `tweede_naam` varchar(50) NOT NULL,
      `tweede_straat` varchar(50) NOT NULL,
      `tweede_nr` int(11) NOT NULL,
      `tweede_postcode` int(11) NOT NULL,
      `tweede_gemeente` varchar(30) NOT NULL,
      `tweede_telefoon` varchar(9) NOT NULL,
      `tweede_GSM` varchar(10) NOT NULL,
      `beschrijving` varchar(255) NOT NULL,
      `info` varchar(255) NOT NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

    --
    -- Gegevens worden uitgevoerd voor tabel `leverancier`
    --

    INSERT INTO `leverancier` VALUES (1, 'Sarcotem', 'NV', 'Industiepark', 11, 4562, 'Bontem', '4144141', '141445', '14745456', 'sarc@bottem.be', 'Gulleman', '147456458', 'sarc-gul@bottem.be', 'Torrens', 'kortebeekstraat', 14, 5584, 'Strandem', '05785245', '147569485', 'verwarmingstoestellen', 'info1');
    INSERT INTO `leverancier` VALUES (2, 'ADGE', 'bvba', 'nieuwstraat', 11, 4562, 'grimstad', '4144141', '141445544', '147458154', 'mail@infotec.be', 'Debreke', '147658254', 'miel.mail@infotec.be', 'Tamin', 'torenstraat', 45, 5466, 'Bunzegem', '05765489', 'geen', 'verlichtingsarmaturen', 'info2');
           

    20-07-2007 om 00:00 geschreven door de makers


    » Reageer (0)

    >

    Blog tegen de regels? Meld het ons!
    Gratis blog op http://blog.seniorennet.be - SeniorenNet Blogs, eenvoudig, gratis en snel jouw eigen blog!