untuk tugas kali ini saya akan membuat tabel data siswa dengan koneksi database MySQL
pertama buka xamp terlebih dahulu
lalu start apache dan MySQL
lalu membuat database melalui browser dengan mengetik localhost/phpmyadmin
sehingga menjadi
lalu ke netbeans dan buatlah projek sesuai keinginan
untuk koneksi database klik menu servis
dan creatconection
kita add library untuk projek
untuk projek netbeans kita buat dengan Master/Detail sample Form
lalu next dan jadilah projek yang kita buat dengan tampilan dan tabel sederhana
untuk source code nya:
package tabel;
import java.awt.EventQueue;
import java.beans.Beans;
import java.util.ArrayList;
import java.util.List;
import javax.persistence.RollbackException;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
/**
*
* @author rusdi
*/
public class tabelmahasiswa extends JPanel {
public tabelmahasiswa() {
initComponents();
if (!Beans.isDesignTime()) {
entityManager.getTransaction().begin();
}
}
/**
menu exit
private void exitActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if(JOptionPane.showConfirmDialog(null,"Anda Yakin Akan Keluar","Selesai",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE)==JOptionPane.YES_OPTION){
System.exit(0);
}else{
JOptionPane.showMessageDialog(null,"Anda Membatalkan","Pesan",JOptionPane.CANCEL_OPTION);
}
}
menu pertama run
public static void main(String[] args) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(tabelmahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(tabelmahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(tabelmahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(tabelmahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
//</editor-fold>
/* Create and display the form */
EventQueue.invokeLater(new Runnable() {
public void run() {
JOptionPane.showMessageDialog(null,"selamat datang","Pesan",JOptionPane.CANCEL_OPTION);
JFrame frame = new JFrame();
frame.setContentPane(new tabelmahasiswa());
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.pack();
frame.setVisible(true);
}
});
}
untuk sorce lengkap projek lainya
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package tabel;
import java.beans.PropertyChangeListener;
import java.beans.PropertyChangeSupport;
import java.io.Serializable;
import javax.persistence.Basic;
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 rusdi
*/
@Entity
@Table(name = "tabmahasiswa", catalog = "test", schema = "")
@NamedQueries({
@NamedQuery(name = "Tabmahasiswa.findAll", query = "SELECT t FROM Tabmahasiswa t"),
@NamedQuery(name = "Tabmahasiswa.findByNpm", query = "SELECT t FROM Tabmahasiswa t WHERE t.npm = :npm"),
@NamedQuery(name = "Tabmahasiswa.findByNama", query = "SELECT t FROM Tabmahasiswa t WHERE t.nama = :nama"),
@NamedQuery(name = "Tabmahasiswa.findByJurusan", query = "SELECT t FROM Tabmahasiswa t WHERE t.jurusan = :jurusan"),
@NamedQuery(name = "Tabmahasiswa.findByJeniskelamin", query = "SELECT t FROM Tabmahasiswa t WHERE t.jeniskelamin = :jeniskelamin"),
@NamedQuery(name = "Tabmahasiswa.findByAlamat", query = "SELECT t FROM Tabmahasiswa t WHERE t.alamat = :alamat")})
public class Tabmahasiswa implements Serializable {
@Transient
private PropertyChangeSupport changeSupport = new PropertyChangeSupport(this);
private static final long serialVersionUID = 1L;
@Basic(optional = false)
@Column(name = "npm")
private String npm;
@Basic(optional = false)
@Column(name = "nama")
private String nama;
@Basic(optional = false)
@Column(name = "jurusan")
private String jurusan;
@Id
@Basic(optional = false)
@Column(name = "jeniskelamin")
private String jeniskelamin;
@Basic(optional = false)
@Column(name = "alamat")
private String alamat;
public Tabmahasiswa() {
}
public Tabmahasiswa(String jeniskelamin) {
this.jeniskelamin = jeniskelamin;
}
public Tabmahasiswa(String jeniskelamin, String npm, String nama, String jurusan, String alamat) {
this.jeniskelamin = jeniskelamin;
this.npm = npm;
this.nama = nama;
this.jurusan = jurusan;
this.alamat = alamat;
}
public String getNpm() {
return npm;
}
public void setNpm(String npm) {
String oldNpm = this.npm;
this.npm = npm;
changeSupport.firePropertyChange("npm", oldNpm, npm);
}
public String getNama() {
return nama;
}
public void setNama(String nama) {
String oldNama = this.nama;
this.nama = nama;
changeSupport.firePropertyChange("nama", oldNama, nama);
}
public String getJurusan() {
return jurusan;
}
public void setJurusan(String jurusan) {
String oldJurusan = this.jurusan;
this.jurusan = jurusan;
changeSupport.firePropertyChange("jurusan", oldJurusan, jurusan);
}
public String getJeniskelamin() {
return jeniskelamin;
}
public void setJeniskelamin(String jeniskelamin) {
String oldJeniskelamin = this.jeniskelamin;
this.jeniskelamin = jeniskelamin;
changeSupport.firePropertyChange("jeniskelamin", oldJeniskelamin, jeniskelamin);
}
public String getAlamat() {
return alamat;
}
public void setAlamat(String alamat) {
String oldAlamat = this.alamat;
this.alamat = alamat;
changeSupport.firePropertyChange("alamat", oldAlamat, alamat);
}
@Override
public int hashCode() {
int hash = 0;
hash += (jeniskelamin != null ? jeniskelamin.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 Tabmahasiswa)) {
return false;
}
Tabmahasiswa other = (Tabmahasiswa) object;
if ((this.jeniskelamin == null && other.jeniskelamin != null) || (this.jeniskelamin != null && !this.jeniskelamin.equals(other.jeniskelamin))) {
return false;
}
return true;
}
@Override
public String toString() {
return "tabel.Tabmahasiswa[ jeniskelamin=" + jeniskelamin + " ]";
}
public void addPropertyChangeListener(PropertyChangeListener listener) {
changeSupport.addPropertyChangeListener(listener);
}
public void removePropertyChangeListener(PropertyChangeListener listener) {
changeSupport.removePropertyChangeListener(listener);
}
}
