---

.

---

---

Metode dan Algoritma | Custom Database Wizard Access MySQL Java NetBeans (2) . Anda bisa melakukan konsultasi tentang Custom Database Wizard Access MySQL Java NetBeans (2) melalui form di samping kanan !!!

---

Custom Database Wizard (2)

23. Kemudian hentikan dahulu program, kembali ke IDE NEtBeans, pada FContacts dari palette Swing Controls, tambahkan 3 buah jTextField, 3 buah jLabel, dan 9 buah jButton pada FContacts.

24. Buka Source Code milik FContacts dengan cara klik Tombol Source pada FContacts.java. Tambahkan Kode program berikut :

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed

// TODO add your handling code here:

    jTable1.setRowSelectionInterval(0, 0);

}//GEN-LAST:event_jButton1ActionPerformed

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed

// TODO add your handling code here:

    if (jTable1.getSelectedRow() > 0) {

        jTable1.setRowSelectionInterval(jTable1.getSelectedRow() - 1, jTable1.getSelectedRow() - 1);

    }

}//GEN-LAST:event_jButton2ActionPerformed

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed

// TODO add your handling code here:

    if (jTable1.getSelectedRow() < (jTable1.getRowCount() - 1)) {

        jTable1.setRowSelectionInterval(jTable1.getSelectedRow() + 1, jTable1.getSelectedRow() + 1);

    }

}//GEN-LAST:event_jButton3ActionPerformed

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed

// TODO add your handling code here:

    jTable1.setRowSelectionInterval(jTable1.getRowCount() - 1, jTable1.getRowCount() - 1);

}//GEN-LAST:event_jButton4ActionPerformed

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed

// TODO add your handling code here:

    //entityManager1.getTransaction().rollback();

    entityManager1.getTransaction().rollback();

    entityManager1.getTransaction().begin();

    java.util.Collection data = query1.getResultList();

    for (Object entity : data) {

        entityManager1.refresh(entity);

    }

    list1.clear();

    list1.addAll(data);

    jTable1.setRowSelectionInterval(0, 0);

}//GEN-LAST:event_jButton5ActionPerformed

private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton6ActionPerformed

// TODO add your handling code here:

    my.dbworld.Contacts c = new my.dbworld.Contacts();

    entityManager1.persist(c);

    list1.add(c);

    int row = list1.size() - 1;

    jTable1.setRowSelectionInterval(row, row);

    jTable1.scrollRectToVisible(jTable1.getCellRect(row, 0, true));

}//GEN-LAST:event_jButton6ActionPerformed

private void jButton12ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton12ActionPerformed

// TODO add your handling code here:

    System.exit(0);

}//GEN-LAST:event_jButton12ActionPerformed

private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton10ActionPerformed

// TODO add your handling code here:

    int[] selected = jTable1.getSelectedRows();

    List<my.dbworld.Contacts> toRemove = new ArrayList<my.dbworld.Contacts>(selected.length);

    for (int idx = 0; idx < selected.length; idx++) {

        my.dbworld.Contacts c = (my.dbworld.Contacts) list1.get(jTable1.convertRowIndexToModel(selected[idx]));

        toRemove.add(c);

        entityManager1.remove(c);

    }

    list1.removeAll(toRemove);

    jTable1.setRowSelectionInterval(0, 0);

}//GEN-LAST:event_jButton10ActionPerformed

private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton8ActionPerformed

// TODO add your handling code here:

    try {

        entityManager1.getTransaction().commit();

        entityManager1.getTransaction().begin();

    } catch (RollbackException rex) {

        rex.printStackTrace();

        entityManager1.getTransaction().begin();

        List<my.dbworld.Contacts> merged = new ArrayList<my.dbworld.Contacts>(list1.size());

        for (my.dbworld.Contacts c : list1) {

            merged.add(entityManager1.merge(c));

        }

        list1.clear();

        list1.addAll(merged);

    }

}//GEN-LAST:event_jButton8ActionPerformed

25. Kemudian klik Run untuk menjalankan aplikasi. Cobalah semua fiturnya.

Berikut ini adalah source code program selengkapnya :

/* Contacts.java

 * To change this template, choose Tools | Templates

 * and open the template in the editor.

 */

package my.dbworld;

import java.beans.PropertyChangeListener;

import java.beans.PropertyChangeSupport;

import java.io.Serializable;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.Id;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

import javax.persistence.Transient;

/**

 *

 * @author Amijaya

 */

@Entity

@Table(name = "CONTACTS")

@NamedQueries({@NamedQuery(name = "Contacts.findByName", query = "SELECT c FROM Contacts c WHERE c.name = :name"), @NamedQuery(name = "Contacts.findByAddress", query = "SELECT c FROM Contacts c WHERE c.address = :address"), @NamedQuery(name = "Contacts.findByPhone", query = "SELECT c FROM Contacts c WHERE c.phone = :phone")})

public class Contacts implements Serializable {

    @Transient

    private PropertyChangeSupport changeSupport = new PropertyChangeSupport(this);

    private static final long serialVersionUID = 1L;

    @Id

    @Column(name = "NAME", nullable = false)

    private String name;

    @Column(name = "ADDRESS")

    private String address;

    @Column(name = "PHONE")

    private String phone;

    public Contacts() {

    }

    public Contacts(String name) {

        this.name = name;

    }

    public String getName() {

        return name;

    }

    public void setName(String name) {

        String oldName = this.name;

        this.name = name;

        changeSupport.firePropertyChange("name", oldName, name);

    }

    public String getAddress() {

        return address;

    }

    public void setAddress(String address) {

        String oldAddress = this.address;

        this.address = address;

        changeSupport.firePropertyChange("address", oldAddress, address);

    }

    public String getPhone() {

        return phone;

    }

    public void setPhone(String phone) {

        String oldPhone = this.phone;

        this.phone = phone;

        changeSupport.firePropertyChange("phone", oldPhone, phone);

    }

    @Override

    public int hashCode() {

        int hash = 0;

        hash += (name != null ? name.hashCode() : 0);

        return hash;

    }

    @Override

    public boolean equals(Object object) {

        // TODO: Warning - this method won't work in the case the id fields are not set

        if (!(object instanceof Contacts)) {

            return false;

        }

        Contacts other = (Contacts) object;

        if ((this.name == null && other.name != null) || (this.name != null && !this.name.equals(other.name))) {

            return false;

        }

        return true;

    }

    @Override

    public String toString() {

        return "my.dbworld.Contacts[name=" + name + "]";

    }

    public void addPropertyChangeListener(PropertyChangeListener listener) {

        changeSupport.addPropertyChangeListener(listener);

    }

    public void removePropertyChangeListener(PropertyChangeListener listener) {

        changeSupport.removePropertyChangeListener(listener);

    }

}

/* ================================================

 * FContacts.java

 *

 * Created on October 19, 2008, 10:29 PM

 */

package my.dbworld;

import java.util.ArrayList;

import java.util.List;

import javax.persistence.RollbackException;

/**

 *

 * @author  Amijaya

 */

public class FContacts extends javax.swing.JFrame {

    /** Creates new form FContacts */

    public FContacts() {

        initComponents();

        entityManager1.getTransaction().begin();

        jTable1.setRowSelectionInterval(0, 0);

    }

    /** This method is called from within the constructor to

     * initialize the form.

     * WARNING: Do NOT modify this code. The content of this method is

     * always regenerated by the Form Editor.

     */

    @SuppressWarnings("unchecked")

    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents

    private void initComponents() {

        bindingGroup = new org.jdesktop.beansbinding.BindingGroup();

        entityManager1 = java.beans.Beans.isDesignTime() ? null : javax.persistence.Persistence.createEntityManagerFactory("DBWorldPU").createEntityManager();

        query1 = java.beans.Beans.isDesignTime() ? null : entityManager1.createQuery("SELECT c FROM Contacts c");

        list1 = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : org.jdesktop.observablecollections.ObservableCollections.observableList(query1.getResultList());

        jScrollPane1 = new javax.swing.JScrollPane();

        jTable1 = new javax.swing.JTable();

        jTextField1 = new javax.swing.JTextField();

        jTextField2 = new javax.swing.JTextField();

        jTextField3 = new javax.swing.JTextField();

        jButton1 = new javax.swing.JButton();

        jButton2 = new javax.swing.JButton();

        jButton3 = new javax.swing.JButton();

        jButton4 = new javax.swing.JButton();

        jButton5 = new javax.swing.JButton();

        jButton6 = new javax.swing.JButton();

        jButton8 = new javax.swing.JButton();

        jButton10 = new javax.swing.JButton();

        jButton12 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        org.jdesktop.swingbinding.JTableBinding jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, list1, jTable1);

        org.jdesktop.swingbinding.JTableBinding.ColumnBinding columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${name}"));

        columnBinding.setColumnName("Name");

        columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${address}"));

        columnBinding.setColumnName("Address");

        columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${phone}"));

        columnBinding.setColumnName("Phone");

        bindingGroup.addBinding(jTableBinding);

        jTableBinding.bind();

        jScrollPane1.setViewportView(jTable1);

        org.jdesktop.beansbinding.Binding binding = org.jdesktop.beansbinding.Bindings.createAutoBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, jTable1, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.name}"), jTextField1, org.jdesktop.beansbinding.BeanProperty.create("text"));

        bindingGroup.addBinding(binding);

        binding = org.jdesktop.beansbinding.Bindings.createAutoBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, jTable1, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.address}"), jTextField2, org.jdesktop.beansbinding.BeanProperty.create("text"));

        bindingGroup.addBinding(binding);

        binding = org.jdesktop.beansbinding.Bindings.createAutoBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, jTable1, org.jdesktop.beansbinding.ELProperty.create("${selectedElement.phone}"), jTextField3, org.jdesktop.beansbinding.BeanProperty.create("text"));

        bindingGroup.addBinding(binding);

...

    }// </editor-fold>//GEN-END:initComponents

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed

// TODO add your handling code here:

    jTable1.setRowSelectionInterval(0, 0);

}//GEN-LAST:event_jButton1ActionPerformed

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed

// TODO add your handling code here:

    if (jTable1.getSelectedRow() > 0) {

        jTable1.setRowSelectionInterval(jTable1.getSelectedRow() - 1, jTable1.getSelectedRow() - 1);

    }

}//GEN-LAST:event_jButton2ActionPerformed

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed

// TODO add your handling code here:

    if (jTable1.getSelectedRow() < (jTable1.getRowCount() - 1)) {

        jTable1.setRowSelectionInterval(jTable1.getSelectedRow() + 1, jTable1.getSelectedRow() + 1);

    }

}//GEN-LAST:event_jButton3ActionPerformed

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed

// TODO add your handling code here:

    jTable1.setRowSelectionInterval(jTable1.getRowCount() - 1, jTable1.getRowCount() - 1);

}//GEN-LAST:event_jButton4ActionPerformed

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed

// TODO add your handling code here:

    //entityManager1.getTransaction().rollback();

    entityManager1.getTransaction().rollback();

    entityManager1.getTransaction().begin();

    java.util.Collection data = query1.getResultList();

    for (Object entity : data) {

        entityManager1.refresh(entity);

    }

    list1.clear();

    list1.addAll(data);

    jTable1.setRowSelectionInterval(0, 0);

}//GEN-LAST:event_jButton5ActionPerformed

private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton6ActionPerformed

// TODO add your handling code here:

    my.dbworld.Contacts c = new my.dbworld.Contacts();

    entityManager1.persist(c);

    list1.add(c);

    int row = list1.size() - 1;

    jTable1.setRowSelectionInterval(row, row);

    jTable1.scrollRectToVisible(jTable1.getCellRect(row, 0, true));

}//GEN-LAST:event_jButton6ActionPerformed

private void jButton12ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton12ActionPerformed

// TODO add your handling code here:

    System.exit(0);

}//GEN-LAST:event_jButton12ActionPerformed

private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton10ActionPerformed

// TODO add your handling code here:

    int[] selected = jTable1.getSelectedRows();

    List<my.dbworld.Contacts> toRemove = new ArrayList<my.dbworld.Contacts>(selected.length);

    for (int idx = 0; idx < selected.length; idx++) {

        my.dbworld.Contacts c = (my.dbworld.Contacts) list1.get(jTable1.convertRowIndexToModel(selected[idx]));

        toRemove.add(c);

        entityManager1.remove(c);

    }

    list1.removeAll(toRemove);

    jTable1.setRowSelectionInterval(0, 0);

}//GEN-LAST:event_jButton10ActionPerformed

private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton8ActionPerformed

// TODO add your handling code here:

    try {

        entityManager1.getTransaction().commit();

        entityManager1.getTransaction().begin();

    } catch (RollbackException rex) {

        rex.printStackTrace();

        entityManager1.getTransaction().begin();

        List<my.dbworld.Contacts> merged = new ArrayList<my.dbworld.Contacts>(list1.size());

        for (my.dbworld.Contacts c : list1) {

            merged.add(entityManager1.merge(c));

        }

        list1.clear();

        list1.addAll(merged);

    }

}//GEN-LAST:event_jButton8ActionPerformed

    /**

     * @param args the command line arguments

     */

    public static void main(String args[]) {

        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {

                new FContacts().setVisible(true);

            }

        });

    }

    // Variables declaration - do not modify//GEN-BEGIN:variables

    private javax.persistence.EntityManager entityManager1;

    private javax.swing.JButton jButton1;

    private javax.swing.JButton jButton10;

    private javax.swing.JButton jButton12;

    private javax.swing.JButton jButton2;

    private javax.swing.JButton jButton3;

    private javax.swing.JButton jButton4;

    private javax.swing.JButton jButton5;

    private javax.swing.JButton jButton6;

    private javax.swing.JButton jButton8;

    private javax.swing.JScrollPane jScrollPane1;

    private javax.swing.JTable jTable1;

    private javax.swing.JTextField jTextField1;

    private javax.swing.JTextField jTextField2;

    private javax.swing.JTextField jTextField3;

    private java.util.List<my.dbworld.Contacts> list1;

    private javax.persistence.Query query1;

    private org.jdesktop.beansbinding.BindingGroup bindingGroup;

    // End of variables declaration//GEN-END:variables

}

---

ActionScript AS3 ASP.NET AJAX C / C++ C# Clipper COBOL ColdFusion DataFlex Delphi Emacs Lisp Fortran FoxPro Java J2ME JavaScript JScript Lingo MATLAB Perl PHP PostScript Python SQL VBScript Visual Basic 6.0 Visual Basic .NET Flash MySQL Oracle Android

---

Related Post :

---

Judul: Custom Database Wizard Access MySQL Java NetBeans (2)
Rating: 100% based on 99998 ratings. 5 user reviews.
Ditulis Oleh hank2

Anda sedang membaca artikel tentang Custom Database Wizard Access MySQL Java NetBeans (2), Semoga artikel tentang Custom Database Wizard Access MySQL Java NetBeans (2) ini sangat bermanfaat bagi teman-teman semua, jangan lupa untuk mengunjungi lagi melalui link Custom Database Wizard Access MySQL Java NetBeans (2).

---