package uas_database; //tampil data kemudian
import java.awt.Dimension; //menampilakan sebuah gambar atau ukuran
screenzise
import java.awt.Toolkit; //suatu komponen yang mempunyai fungsi
merancang form sebuah gambar atau ukuran
import java.sql.Connection; //mengkoneksikan ke
localhost database
import java.sql.DriverManager; //nama koneksi pada database
import java.sql.Statement; //proses INSERT, UPDATE, DELETE pada database
import java.sql.ResultSet; //menampilkan seluruh data pada tabel
Mahasiswa yang ada pada database NETBEANS
import java.text.SimpleDateFormat; //untuk mengformat data tanggal di database
import javax.swing.JOptionPane; //untuk masuk ke
login user database
public class mahasiswa extends javax.swing.JFrame
{ //untuk menampilkan field (attribut/properti)
private Connection con; //memangil fungsi konek()
untuk melakukan koneksi
private Statement stat; //memangil fungsi konek()
untuk melakukan koneksi
private ResultSet res; //memangil fungsi konek() untuk melakukan koneksi
private String t; //menampilkan data variable pada database
public mahasiswa() {
initComponents(); //memangil fungsi konek()
setTitle("Data Mahasiswa");
//memunculkan keterangan pada jFrame
koneksi(); //memangil fungsi konek()
kosongkan(); //mengosongkan data pada variable
class jFrame
jurusan(); // menampilkan data jurusan pada
jFrame
//membuat layout tampil di tengah pada saat di
tampilkan
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
//menampilakan sebuah gambar atau ukuran
Dimension frameSize = getSize(); //menampilakan sebuah gambar atau ukuran
setLocation(
////menampilakan sebuah lokasi jFrame database
(screenSize.width - frameSize.width) / 2,
//menampilakan sebuah ukuran
(screenSize.height - frameSize.height) / 2); //menampilakan sebuah ukuran
}
private void koneksi(){ //memangil fungsi konek()
untuk melakukan koneksi
try {
//menampilkan semua event pada exammp database
Class.forName("com.mysql.jdbc.Driver");
//nama koneksi pada database mysql xamp
con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/siswa",
"root", ""); //login
pada exampp dan memanggil fungsi koneksi
stat=con.createStatement(); //memangil fungsi
konek() untuk melakukan koneksi
} catch (Exception e) { //untuk menampilkan data
apakah sudah berhasil di simpan atau tidak
JOptionPane.showMessageDialog(null, e);
//menampilkan perintah yang salah
}
}
private void kosongkan()
{ //menampilkan data text,item,dan index pada
jFrame
nim.setText("");
nama.setText("");
tanggallahir.setText("");
agm.setSelectedItem("");
jurusan.setSelectedItem("");
alamat.setText("");
harusdibayar.setText("");
dibayar.setText("");
kembaliananda.setText("");
nim.requestFocus();
}
private void jurusan(){ //menampilkan jurusan
pada jFrame
jurusan.addItem("Teknik Informatika");
jurusan.addItem("Tata Boga");
jurusan.addItem("Multimedia");
jurusan.setSelectedIndex(-1); }
@SuppressWarnings("unchecked")
// <editor-fold
defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jButton4 = new javax.swing.JButton();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
tgl = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
nim = new javax.swing.JTextField();
nama = new javax.swing.JTextField();
jurusan = new javax.swing.JComboBox();
simpan = new javax.swing.JButton();
edit = new javax.swing.JButton();
hapus = new javax.swing.JButton();
batal = new javax.swing.JButton();
keluar = new javax.swing.JButton();
tanggallahir = new javax.swing.JTextField();
agama = new javax.swing.JLabel();
agm = new javax.swing.JComboBox();
alamat = new javax.swing.JTextField();
jml = new javax.swing.JLabel();
byr = new javax.swing.JLabel();
kbl = new javax.swing.JLabel();
harusdibayar = new javax.swing.JTextField();
dibayar = new javax.swing.JTextField();
kembaliananda = new javax.swing.JTextField();
jButton4.setText("jButton4");
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setBackground(new java.awt.Color(51, 255, 255));
getContentPane().setLayout(null);
jLabel1.setFont(new
java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel1.setText("Pendaftaran siswa
baru");
getContentPane().add(jLabel1);
jLabel1.setBounds(250, 10, 220, 40);
jLabel2.setFont(new java.awt.Font("Tahoma",
0, 12)); // NOI18N
jLabel2.setText("NIM");
getContentPane().add(jLabel2);
jLabel2.setBounds(10, 70, 21, 15);
jLabel3.setFont(new
java.awt.Font("Tahoma", 0, 12)); // NOI18N
jLabel3.setText("Nama");
getContentPane().add(jLabel3);
jLabel3.setBounds(10, 110, 30, 15);
jLabel4.setFont(new
java.awt.Font("Tahoma", 0, 12)); // NOI18N
jLabel4.setText("Jurusan");
getContentPane().add(jLabel4);
jLabel4.setBounds(10, 250, 60, 15);
tgl.setFont(new java.awt.Font("Tahoma",
0, 12)); // NOI18N
tgl.setText("Tanggal Lahir");
getContentPane().add(tgl);
tgl.setBounds(10, 160, 72, 15);
jLabel6.setFont(new
java.awt.Font("Tahoma", 0, 12)); // NOI18N
jLabel6.setText("Alamat");
getContentPane().add(jLabel6);
jLabel6.setBounds(10, 300, 37, 15);
nim.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
nimActionPerformed(evt);
}
});
getContentPane().add(nim);
nim.setBounds(110, 70, 140, 30);
getContentPane().add(nama);
nama.setBounds(110, 110, 140, 30);
jurusan.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
jurusanActionPerformed(evt);
}
});
getContentPane().add(jurusan);
jurusan.setBounds(110, 240, 144, 30);
simpan.setText("Simpan");
simpan.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
simpanActionPerformed(evt);
}
});
getContentPane().add(simpan);
simpan.setBounds(570, 80, 70, 23);
edit.setText("Edit");
edit.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
editActionPerformed(evt);
}
});
getContentPane().add(edit);
edit.setBounds(570, 130, 70, 23);
hapus.setText("Hapus");
hapus.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
hapusActionPerformed(evt);
}
});
getContentPane().add(hapus);
hapus.setBounds(570, 180, 70, 23);
batal.setText("Batal");
batal.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
batalActionPerformed(evt);
}
});
getContentPane().add(batal);
batal.setBounds(570, 230, 70, 23);
keluar.setText("Keluar");
keluar.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
keluarActionPerformed(evt);
}
});
getContentPane().add(keluar);
keluar.setBounds(570, 280, 70, 23);
tanggallahir.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
tanggallahirActionPerformed(evt);
}
});
getContentPane().add(tanggallahir);
tanggallahir.setBounds(110, 150, 140, 30);
agama.setText("AGAMA");
getContentPane().add(agama);
agama.setBounds(10, 200, 50, 14);
agm.setModel(new
javax.swing.DefaultComboBoxModel(new String[] { "islam",
"kristen", "hindu", "budha" }));
getContentPane().add(agm);
agm.setBounds(110, 200, 90, 20);
alamat.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
alamatActionPerformed(evt);
}
});
getContentPane().add(alamat);
alamat.setBounds(110, 290, 150, 30);
jml.setText("harus di bayar");
getContentPane().add(jml);
jml.setBounds(10, 340, 190, 30);
byr.setText("di bayar");
getContentPane().add(byr);
byr.setBounds(10, 390, 110, 30);
kbl.setText("kembalian anda");
getContentPane().add(kbl);
kbl.setBounds(10, 450, 90, 20);
harusdibayar.addActionListener(new
java.awt.event.ActionListener() {
public void
actionPerformed(java.awt.event.ActionEvent evt) {
harusdibayarActionPerformed(evt);
}
});
getContentPane().add(harusdibayar);
harusdibayar.setBounds(210, 340, 140, 30);
getContentPane().add(dibayar);
dibayar.setBounds(210, 390, 140, 30);
getContentPane().add(kembaliananda);
kembaliananda.setBounds(210, 450, 140, 30);
setBounds(0, 0, 749, 572);
}// </editor-fold>
private void
tglPropertyChange(java.beans.PropertyChangeEvent evt) {
if(tanggallahir.getText()!=null){ //untuk mengisi dan memasukkan data tanggal
SimpleDateFormat format=new
SimpleDateFormat("yyyy-MM-dd");
t = format.format(tanggallahir.getText());
}
}
private void simpanActionPerformed(java.awt.event.ActionEvent
evt) {
try {
//untuk memperbaruhi data yang sudah di simpan
stat.executeUpdate("insert into siswa_baru
values ("
+ "'" + nim.getText()+"',"
+ "'" + nama.getText()+"',"
+ "'" +
tanggallahir.getText()+"',"
+ "'" + agm.getSelectedItem()+
"',"
+ "'" + jurusan.getSelectedItem()+
"',"
+ "'" + alamat.getText()+
"',"
+ "'" + harusdibayar.getText() +
"',"
+ "'" + dibayar.getText() +
"',"
+ "'" + kembaliananda.getText() +
"')");
kosongkan();
JOptionPane.showMessageDialog(null,
"Berhasil Menyimpan Data");
} catch (Exception e) {
JOptionPane.showMessageDialog(null,
"Perintah Salah : "+e);
}
}
private void
keluarActionPerformed(java.awt.event.ActionEvent evt) {
this.dispose();
}
private void
editActionPerformed(java.awt.event.ActionEvent evt) {
try {
stat.executeUpdate("update siswa set "
+ "nama='"+nim.getText()+"',"
+
"agama='"+nama.getText()+"',"
+
"jurusan='"+tanggallahir.getText()+"',"
+
"jurusan='"+agama.getText()+"',"
+ "jurusan='"+jurusan.getSelectedItem()+"',"
+
"agama='"+alamat.getText()+"',"
+
"agama='"+harusdibayar.getText()+"',"
+
"agama='"+dibayar.getText()+"',"
+
"agama='"+kembaliananda.getText()+"',"
+ " where " +
"nim='"+nim.getText()+"'" );
kosongkan();
JOptionPane.showMessageDialog(rootPane,
"Data berhasil Diupdate");
} catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private void
nimActionPerformed(java.awt.event.ActionEvent evt) {
try {
res=stat.executeQuery("select * from
siswa_baru where "+ "nim='" +nim.getText()
+"'" ); while (res.next())
{
nim.setText(res.getString("nis"));
nama.setText(res.getString("nama"));
tanggallahir.setText(res.getString("ttl"));
agm.setSelectedItem(res.getString("agama"));
jurusan.setSelectedItem(res.getString("jurusan"));
alamat.setText(res.getString("alamat"));
harusdibayar.setText(res.getString("harus_di_bayar"));
dibayar.setText(res.getString("di_bayar"));
kembaliananda.setText(res.getString("kembalian_anda"));
}
}
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
}
private void
hapusActionPerformed(java.awt.event.ActionEvent evt) {
try {
stat.executeUpdate("delete from siswa where
"
+ "nim='"+nim.getText()
+"'" );
kosongkan();
JOptionPane.showMessageDialog(null, "Berhasil");
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "pesan
salah : "+e);
}
}
private void
batalActionPerformed(java.awt.event.ActionEvent evt) {
kosongkan();
}
private void
tanggallahirActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void
alamatActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void harusdibayarActionPerformed(java.awt.event.ActionEvent
evt) {
// TODO add your handling code here:
}
private void
jurusanActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
/**
* @param args the command line arguments
*/
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(mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(mahasiswa.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new mahasiswa().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JLabel agama;
private javax.swing.JComboBox agm;
private javax.swing.JTextField alamat;
private javax.swing.JButton batal;
private javax.swing.JLabel byr;
private javax.swing.JTextField dibayar;
private javax.swing.JButton edit;
private javax.swing.JButton hapus;
private javax.swing.JTextField harusdibayar;
private javax.swing.JButton jButton4;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jml;
private javax.swing.JComboBox jurusan;
private javax.swing.JLabel kbl;
private javax.swing.JButton keluar;
private javax.swing.JTextField kembaliananda;
private javax.swing.JTextField nama;
private javax.swing.JTextField nim;
private javax.swing.JButton simpan;
private javax.swing.JTextField tanggallahir;
private javax.swing.JLabel tgl;
// End of variables declaration
}
