UTS Semester 4 STMIK Eresha 04TPLP001

Program Pencetak Invoice Laundry Menggunakan Visual Stuido 2012

1. Deskripsi Program

Assalamu'alaikum, hari ini saya akan mem-posting sebuah program pencetak invoice/tagihan laundry dengan menggunakan MS.Word atau MS.Excel.
Program yang saya buat kali ini bertujuan untuk mempermudah anda yang ingin membuka usaha laundry kecil - kecilan untuk meminimalisir kesalahan saat akan mengantar barang customer anda.
Macam - macam komponen yang dipakai pada program ini :

• 9 Label
• 5 TextBox
• 1 ComboBox
• 4 RadioButton
• 1 DateTimePicker
• 5 Buah Button

Input Program Terdiri dari :

• Tanggal
• Nama
• Jenis Cucian
• Harga/Kg
• Berat Cucian
• Total
• Bayar

Sedangkan Output Program Terdiri Dari :

• Kembali
• Cetak Word
• Cetak Excel
• Clear
• Keluar

2. Screenshoot

1. Screenshoot Interface Program

2. Screenshoot Output MS.Word dan MS.Excel

3. Source Code Program

Berikut ini adalah Source Code dari program di atas :

Imports word = Microsoft.Office.Interop.Word

Imports excel = Microsoft.Office.Interop.Excel

Public Class UTS_Muhammad_Rizqi_Nadjima_161021450141

    Public harga, nama, keluar As String

    Public aplikasiword As New word.Application

    Public dokumenword As word.Document

    Public aplikasiexcel As New excel.Application

    Public dokumenexcel As excel.Workbook

    Public Sub clear()

        txtnama.Text = ""

        rbaju.Checked = False

        rjaket.Checked = False

        rkarpet.Checked = False

        rbedcover.Checked = False

        txtharga.Text = ""

        comboberat.Text = ""

        txttotal.Text = ""

        txtbayar.Text = ""

        txtkembali.Text = ""

    End Sub

    Public Sub r1()

        harga = txtharga.Text

        If rbaju.Checked Then

            txtharga.Text = 7000

        End If

    End Sub

    Public Sub r2()

        harga = txtharga.Text

        If rjaket.Checked Then

            txtharga.Text = 8000

        End If

    End Sub

    Public Sub r3()

        harga = txtharga.Text

        If rkarpet.Checked Then

            txtharga.Text = 20000

        End If

    End Sub

    Public Sub r4()

        harga = txtharga.Text

        If rbedcover.Checked Then

            txtharga.Text = 15000

        End If

    End Sub

    Private Sub comboberat_SelectedIndexChanged(sender As Object, e As EventArgs) Handles comboberat.SelectedIndexChanged

        harga = txtharga.Text

        Select Case comboberat.Text

            Case "1 Kg"

                txttotal.Text = harga

            Case "2 Kg"

                txttotal.Text = harga * 2

            Case "3 Kg"

                txttotal.Text = harga * 3

            Case "4 Kg"

                txttotal.Text = harga * 4

            Case "5 Kg"

                txttotal.Text = harga * 5

            Case "6 Kg"

                txttotal.Text = harga * 6

            Case "7 Kg"

                txttotal.Text = harga * 7

            Case "8 Kg"

                txttotal.Text = harga * 8

            Case "9 Kg"

                txttotal.Text = harga * 9

            Case "10 Kg"

                txttotal.Text = harga * 10

        End Select

    End Sub

    Private Sub rbaju_CheckedChanged(sender As Object, e As EventArgs) Handles rbaju.CheckedChanged

        r1()

    End Sub

    Private Sub rjaket_CheckedChanged(sender As Object, e As EventArgs) Handles rjaket.CheckedChanged

        r2()

    End Sub

    Private Sub rkarpet_CheckedChanged(sender As Object, e As EventArgs) Handles rkarpet.CheckedChanged

        r3()

    End Sub

    Private Sub rbedcover_CheckedChanged(sender As Object, e As EventArgs) Handles rbedcover.CheckedChanged

        r4()

    End Sub

    Private Sub btnproses_Click(sender As Object, e As EventArgs) Handles btnproses.Click

        If txtnama.Text = "" Then

            MsgBox("Kolom Nama Belum Di Isi!", vbCritical, "Salah!")

            txtnama.Focus()

        End If

        txtkembali.Text = txtbayar.Text - txttotal.Text

    End Sub

    Private Sub btnclear_Click(sender As Object, e As EventArgs) Handles btnclear.Click

        clear()

    End Sub

    Private Sub btnkeluar_Click(sender As Object, e As EventArgs) Handles btnkeluar.Click

        keluar = MsgBox("Anda Yakin Ingin Keluar ?", vbQuestion + vbYesNo, "Konfirmasi")

        If keluar = vbYes Then

            Close()

        End If

    End Sub

    Private Sub btnword_Click(sender As Object, e As EventArgs) Handles btnword.Click

        nama = (boxtgl.Text + " " + txtnama.Text)

        dokumenword = aplikasiword.Documents.Open("C:\Users\Muhammad Rizqi Nadji\Documents\invoice_laundry\template_word.docx")

        dokumenword.Bookmarks("BD").Select()

        aplikasiword.Selection.TypeText(boxtgl.Value)

        dokumenword.Bookmarks("BN").Select()

        aplikasiword.Selection.TypeText(txtnama.Text)

        If rbaju.Checked Then

            dokumenword.Bookmarks("BJC").Select()

            aplikasiword.Selection.TypeText("Baju")

        ElseIf rjaket.Checked Then

            dokumenword.Bookmarks("BJC").Select()

            aplikasiword.Selection.TypeText("Jaket")

        ElseIf rkarpet.Checked Then

            dokumenword.Bookmarks("BJC").Select()

            aplikasiword.Selection.TypeText("Karpet")

        ElseIf rbedcover.Checked Then

            dokumenword.Bookmarks("BJC").Select()

            aplikasiword.Selection.TypeText("Bedcover")

        End If

        dokumenword.Bookmarks("BH").Select()

        aplikasiword.Selection.TypeText(txtharga.Text)

        dokumenword.Bookmarks("BBC").Select()

        aplikasiword.Selection.TypeText(comboberat.Text)

        dokumenword.Bookmarks("BT").Select()

        aplikasiword.Selection.TypeText(txttotal.Text)

        dokumenword.Bookmarks("BB").Select()

        aplikasiword.Selection.TypeText(txtbayar.Text)

        dokumenword.Bookmarks("BK").Select()

        aplikasiword.Selection.TypeText(txtkembali.Text)

        dokumenword.SaveAs("C:\Users\Muhammad Rizqi Nadji\Documents\invoice_laundry\word\" + nama + ".docx")

        MsgBox("Sukses!")

        aplikasiword.Visible = True

    End Sub

    Private Sub btnexcel_Click(sender As Object, e As EventArgs) Handles btnexcel.Click

        nama = (boxtgl.Text + " " + txtnama.Text)

        dokumenexcel = aplikasiexcel.Workbooks.Open("C:\Users\Muhammad Rizqi Nadji\Documents\invoice_laundry\template_excel.xlsx")

        aplikasiexcel.Range("A3").Value = boxtgl.Value

        aplikasiexcel.Range("B3").Value = txtnama.Text

        If rbaju.Checked Then

            aplikasiexcel.Range("C3").Value = "Baju"

        ElseIf rjaket.Checked Then

            aplikasiexcel.Range("C3").Value = "Jaket"

        ElseIf rkarpet.Checked Then

            aplikasiexcel.Range("C3").Value = "Karpet"

        ElseIf rbedcover.Checked Then

            aplikasiexcel.Range("C3").Value = "Bedcover"

        End If

        aplikasiexcel.Range("D3").Value = txtharga.Text

        aplikasiexcel.Range("E3").Value = comboberat.Text

        aplikasiexcel.Range("F3").Value = txttotal.Text

        aplikasiexcel.Range("G3").Value = txtbayar.Text

        aplikasiexcel.Range("H3").Value = txtkembali.Text

        dokumenexcel.SaveAs("C:\Users\Muhammad Rizqi Nadji\Documents\invoice_laundry\excel\" + nama + ".xlsx")

        MsgBox("Sukses!")

        aplikasiexcel.Visible = True

    End Sub

End Class

TUGAS UAS SEMESTER II ALGORITMA DAN PEMROGRAMAN 2

Assalamu'alaikum, hari ini saya akan Posting Project ATM Untuk Koperasi Simpan Pinjam.
Jadi program ini akan membantu Koperasi untuk bisa Menjalankan program ATM pada perkampungan ataupun Organisasi Kecil - Menengah :)

1. Login Form

Source Code:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
        this.dispose();
    }                                     

    private void jToggleButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                             
        // TODO add your handling code here:
        if (vusername.getText().equals("admin")) {
        if (vpassword.getText().equals("admin")) {
// Bila Login Sukses Maka Masuk Menu Utama
            new utama().show();
            this.dispose(); }
       else {
// Bila Login Gagal Maka Ulangi Login
            JOptionPane.showMessageDialog(rootPane, "<error> Password Salah, Silahkan Coba Lagi");
            vpassword.setText("");
            vpassword.requestFocus(); }}
        else {
            JOptionPane.showMessageDialog(rootPane, "<error> Username, Silahkan Coba Lagi");
            vusername.setText("");
            vpassword.setText(""); 
            vusername.requestFocus();
        }
    }

2. Menu Utama
                       
Source Code:         
 private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
        new rekening_nasabah().setVisible(true);
         dispose();
    }                                     

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
        new anggota().setVisible(true);
         dispose();
    }                                     

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
        new jenis_pinjaman().setVisible(true);
         dispose();
    }                                     

    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
        new trans_pinjaman().setVisible(true);
         dispose();
    }                                     

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
        new jenis_simpanan().setVisible(true);
         dispose();
    }                                     

    private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
        new login_koperasi().setVisible(true);
        dispose();
    }                                     

    private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {                                       
        new trans_simpanan().setVisible(true);
         dispose();

        // TODO add your handling code here:
   
    }
3. Formulir Anggota

Source Code:
package Aplikasi;

import java.awt.event.KeyEvent;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

public class anggota extends javax.swing.JFrame {

     koneksi con=new koneksi();
     Date tgl=new Date();
     SimpleDateFormat noformat=new SimpleDateFormat("yyMM");

    /* Membuat form Anggota */
    public anggota() {
        initComponents();
    }

    private void aktif()
{
tnama.setEnabled(true);
talamat.setEnabled(true);
tkota.setEnabled(true);
ttelp.setEnabled(true);
tpekerjaan.setEnabled(true);
}

private void bersih()
{
tno.setText("");
tnama.setText("");
talamat.setText("");
tkota.setText("");
ttelp.setText("");
tpekerjaan.setText("");
}

public DefaultTableModel gettabel()
{
String[]judul={"No.Anggota","Nama","Alamat","Kota","No.Telpon","Pekerjaan"};
DefaultTableModel kolom=new DefaultTableModel(null,judul);
    try
    {
    con.setkoneksi();
    con.rs=con.st.executeQuery("select * from anggota");
    String data[]=new String[6];
        while(con.rs.next())
        {
        data[0]=con.rs.getString(1);
        data[1]=con.rs.getString(2);
        data[2]=con.rs.getString(3);
        data[3]=con.rs.getString(4);
        data[4]=con.rs.getString(5);
        data[5]=con.rs.getString(6);
        kolom.addRow(data);
        }
    }
    catch(Exception e)
    {
    JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih Dahulu : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
    }
return kolom;
}

private void awal()
{
Table1.setModel(gettabel());
bersih();
aktif();
no();
tno.setEnabled(false);
tnama.requestFocus();
bkeluar.setEnabled(true);
bupdate.setVisible(false);
bedit.setEnabled(false);
bhapus.setEnabled(false);
bsimpan.setVisible(true);
}

private void pasif()
{
tno.setEnabled(false);
tnama.setEnabled(false);
talamat.setEnabled(false);
tkota.setEnabled(false);
ttelp.setEnabled(false);
tpekerjaan.setEnabled(false);
}

private void no()
{
try
{
    con.setkoneksi();
    String nomor=null;
    con.rs=con.st.executeQuery("Select right(no_ang,3)+1 as no from anggota order by no_ang desc");
    if(con.rs.next())
    {
    nomor=con.rs.getString("no");
        while(nomor.length()<2)
            nomor="0"+nomor;
            nomor=noformat.format(tgl)+nomor;
    }
    else
        nomor=noformat.format(tgl)+"0";
        tno.setText(nomor);
}
catch(Exception e){JOptionPane.showMessageDialog(rootPane, e);
}

}

    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                       
    private void initComponents() {

        jLabel1 = new javax.swing.JLabel();
        jPanel2 = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        tnama = new javax.swing.JTextField();
        talamat = new javax.swing.JTextField();
        ttelp = new javax.swing.JTextField();
        tpekerjaan = new javax.swing.JTextField();
        tkota = new javax.swing.JTextField();
        tno = new javax.swing.JTextField();
        jPanel4 = new javax.swing.JPanel();
        bsimpan = new javax.swing.JButton();
        bhapus = new javax.swing.JButton();
        bedit = new javax.swing.JButton();
        bkeluar = new javax.swing.JButton();
        bupdate = new javax.swing.JButton();
        jScrollPane1 = new javax.swing.JScrollPane();
        Table1 = new javax.swing.JTable();
        jPanel1 = new javax.swing.JPanel();
        jLabel8 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        tcarikode = new javax.swing.JTextField();
        tcarinama = new javax.swing.JTextField();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        addWindowListener(new java.awt.event.WindowAdapter() {
            public void windowOpened(java.awt.event.WindowEvent evt) {
                formWindowOpened(evt);
            }
        });

        jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 18)); // NOI18N
        jLabel1.setText("Formulir Anggota Koperasi");

        jPanel2.setBorder(javax.swing.BorderFactory.createEtchedBorder(javax.swing.border.EtchedBorder.RAISED, new java.awt.Color(204, 204, 204), new java.awt.Color(204, 204, 204)));

        jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel2.setText("No. Anggota :");

        jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel3.setText("Nama :");

        jLabel4.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel4.setText("Alamat :");

        jLabel5.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel5.setText("Kota :");

        jLabel6.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel6.setText("No. Telp :");

        jLabel7.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel7.setText("Pekerjaan :");

        ttelp.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                ttelpActionPerformed(evt);
            }
        });

        tno.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tnoActionPerformed(evt);
            }
        });
        tno.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                tnoKeyPressed(evt);
            }
        });

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jLabel2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jLabel3, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jLabel5, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jLabel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jLabel6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jLabel7, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(tnama, javax.swing.GroupLayout.PREFERRED_SIZE, 211, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(talamat, javax.swing.GroupLayout.PREFERRED_SIZE, 301, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                        .addComponent(ttelp, javax.swing.GroupLayout.Alignment.LEADING)
                        .addComponent(tpekerjaan, javax.swing.GroupLayout.Alignment.LEADING)
                        .addComponent(tkota, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 160, Short.MAX_VALUE))
                    .addComponent(tno, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(32, 32, 32))
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel2)
                    .addComponent(tno, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(tnama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel3))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(talamat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel4))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(tkota, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel5))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(ttelp, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel6))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(tpekerjaan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel7))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jPanel4.setBorder(javax.swing.BorderFactory.createEtchedBorder(javax.swing.border.EtchedBorder.RAISED, new java.awt.Color(204, 204, 204), new java.awt.Color(204, 204, 204)));

        bsimpan.setText("Simpan");
        bsimpan.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bsimpanActionPerformed(evt);
            }
        });

        bhapus.setText("Hapus");
        bhapus.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bhapusActionPerformed(evt);
            }
        });

        bedit.setText("Edit");
        bedit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                beditActionPerformed(evt);
            }
        });

        bkeluar.setText("Kembali");
        bkeluar.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bkeluarActionPerformed(evt);
            }
        });

        bupdate.setText("Update");
        bupdate.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bupdateActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
        jPanel4.setLayout(jPanel4Layout);
        jPanel4Layout.setHorizontalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel4Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(bkeluar, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(bhapus, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(bedit, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(bupdate, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(bsimpan, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );
        jPanel4Layout.setVerticalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel4Layout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(bupdate)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(bsimpan)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(bedit)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(bhapus)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(bkeluar)
                .addGap(23, 23, 23))
        );

        Table1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        jScrollPane1.setViewportView(Table1);

        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Cari Berdasarkan"));

        jLabel8.setText("Kode Anggota :");

        jLabel9.setText("Nama Anggota :");

        tcarikode.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tcarikodeActionPerformed(evt);
            }
        });
        tcarikode.addPropertyChangeListener(new java.beans.PropertyChangeListener() {
            public void propertyChange(java.beans.PropertyChangeEvent evt) {
                tcarikodePropertyChange(evt);
            }
        });
        tcarikode.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                tcarikodeKeyPressed(evt);
            }
        });

        tcarinama.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tcarinamaActionPerformed(evt);
            }
        });
        tcarinama.addPropertyChangeListener(new java.beans.PropertyChangeListener() {
            public void propertyChange(java.beans.PropertyChangeEvent evt) {
                tcarinamaPropertyChange(evt);
            }
        });
        tcarinama.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                tcarinamaKeyPressed(evt);
            }
        });

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(tcarikode, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(jLabel9, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(tcarinama, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel8)
                        .addComponent(jLabel9))
                    .addComponent(tcarikode, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(tcarinama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jScrollPane1)
                    .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                        .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 228, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(0, 0, Short.MAX_VALUE)))
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jLabel1)
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                    .addComponent(jPanel4, 0, 0, Short.MAX_VALUE)
                    .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 167, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );

        pack();
    }// </editor-fold>                     

    private void bkeluarActionPerformed(java.awt.event.ActionEvent evt) {                                     
    new utama().setVisible(true);
         dispose();
}                                     

    private void formWindowOpened(java.awt.event.WindowEvent evt) {                               
        // TODO add your handling code here:
    awal();
    }                               

    private void tnoActionPerformed(java.awt.event.ActionEvent evt) {                                 
        // TODO add your handling code here:
    }                                 

    private void tnoKeyPressed(java.awt.event.KeyEvent evt) {                             
        // TODO add your handling code here:
    }                           

    private void bsimpanActionPerformed(java.awt.event.ActionEvent evt) {                                     
        // TODO add your handling code here:
    try
    {
    con.setkoneksi();
    String sql="insert into anggota values('"+tno.getText()+"','"+tnama.getText()+"','"+talamat.getText()+"','"+tkota.getText()+"','"+ttelp.getText()+"','"+tpekerjaan.getText()+"')";
    con.st.executeUpdate(sql);
    con.rs.close();
    JOptionPane.showMessageDialog(null,"Database Berhasil Tersimpan","Koneksi Sukses",JOptionPane.INFORMATION_MESSAGE);
    con.conn.close();
    awal();
    }
    catch(Exception e)
    {
    JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih Dahulu : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
    }
    }                                     

    private void tcarikodeActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
    }                                       

    private void tcarikodePropertyChange(java.beans.PropertyChangeEvent evt) {                                       
        // TODO add your handling code here:
    }                                     

    private void tcarikodeKeyPressed(java.awt.event.KeyEvent evt) {                                   
        // TODO add your handling code here:
    if(evt.getKeyCode()==KeyEvent.VK_ENTER)
    {
    try
    {
    con.setkoneksi();
    con.rs=con.st.executeQuery("select * from anggota where no_ang like '"+tcarikode.getText()+"'");
    if(con.rs.next())
        {
        tno.setText(con.rs.getString(1));
        tnama.setText(con.rs.getString(2));
        talamat.setText(con.rs.getString(3));
        tkota.setText(con.rs.getString(4));
        ttelp.setText(con.rs.getString(5));
        tpekerjaan.setText(con.rs.getString(6));
        pasif();
        bedit.setEnabled(true);
        bhapus.setEnabled(true);
        bsimpan.setVisible(false);
        bupdate.setVisible(true);
        bupdate.setEnabled(false);
        }
        else
        {
        JOptionPane.showMessageDialog(null,"Kode Tidak Tersedia");
        tcarikode.setText("");
        }
    con.rs.close();
    con.conn.close();
    }
    catch(Exception e)
    {
    JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih Dahulu : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
    }
    }
    }                                 

    private void tcarinamaKeyPressed(java.awt.event.KeyEvent evt) {                                   
        // TODO add your handling code here:
    if(evt.getKeyCode()==KeyEvent.VK_ENTER)
    {
    try
    {
    con.setkoneksi();
    con.rs=con.st.executeQuery("select * from anggota where nama_ang like '"+tcarinama.getText()+"'");
    if(con.rs.next())
        {
        tno.setText(con.rs.getString(1));
        tnama.setText(con.rs.getString(2));
        talamat.setText(con.rs.getString(3));
        tkota.setText(con.rs.getString(4));
        ttelp.setText(con.rs.getString(5));
        tpekerjaan.setText(con.rs.getString(6));
        pasif();
        bedit.setEnabled(true);
        bhapus.setEnabled(true);
        bsimpan.setVisible(false);
        bupdate.setVisible(true);
        bupdate.setEnabled(false);
        //Table1.setModel(gettabel());
        }
        else
        {
        JOptionPane.showMessageDialog(null,"Nama Tidak Tersedia");
        tcarinama.setText("");
        }
    con.rs.close();
    con.conn.close();
    }
    catch(Exception e)
    {
    JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih Dahulu : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
    }
    }
    }                                 

    private void beditActionPerformed(java.awt.event.ActionEvent evt) {                                   
        // TODO add your handling code here:
    aktif();
    bupdate.setEnabled(true);
    bedit.setEnabled(false);
    bhapus.setEnabled(false);
    }                                   

    private void bupdateActionPerformed(java.awt.event.ActionEvent evt) {                                     
        // TODO add your handling code here:
    try
    {
    con.setkoneksi();String sql="update anggota set nama_ang='"+tnama.getText()+"',alamat='"+talamat.getText()+"',kota='"+tkota.getText()+"',no_telp='"+ttelp.getText()+"',pekerjaan='"+tpekerjaan.getText()+"' where no_ang='"+tno.getText()+"'";
    con.st.executeUpdate(sql);
 
    con.rs.close();
    JOptionPane.showMessageDialog(null,"Database Berhasil Terupdate","Koneksi Sukses",JOptionPane.INFORMATION_MESSAGE);
    con.conn.close();
    awal();
    tcarikode.setText("");
    tcarinama.setText("");
    }
    catch(Exception e)
    {
    JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih Dahulu : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
    }
    }                                     

    private void bhapusActionPerformed(java.awt.event.ActionEvent evt) {                                     
        // TODO add your handling code here:
    try
    {
    con.setkoneksi();
    String sql="delete from anggota where no_ang='"+tcarikode.getText()+"' or nama_ang='"+tcarinama.getText()+"'";
    con.st.executeUpdate(sql);
    con.rs.close();
    JOptionPane.showMessageDialog(null,"Database Berhasil Terhapus","Koneksi Sukses",JOptionPane.INFORMATION_MESSAGE);
    con.conn.close();
    awal();
    tcarikode.setText("");
    tcarinama.setText("");
    }
    catch(Exception e)
    {
    JOptionPane.showMessageDialog(null,"<Error> Koneksikan Xampp Terlebih  : "+e,"Koneksi Gagal",JOptionPane.WARNING_MESSAGE);
    }
    }                                   

    private void tcarinamaActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
    }                                       

    private void tcarinamaPropertyChange(java.beans.PropertyChangeEvent evt) {                                       
        // TODO add your handling code here:
    }                                     

    private void ttelpActionPerformed(java.awt.event.ActionEvent evt) {                                   
        // TODO add your handling code here:
    }                                   

    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new anggota().setVisible(true);
            }
        });
    }
Sekian Terimakasih :)