Minibank Tampilan

selamat berpuasa "Bagi yang menjalankan."

Oke sekang saya mau mencoret-coret dinding blogger saya dengan tugas akhir saya yaitu Minibank.
yang pertema kamu siapkan duli aplikasinya seperti biasa.

Aplikasinya:
Netbeans dan SQLyog

yang pertama buat tampilan Seperti ini.

1.

 2.

-cara masukkan gambar ikon itu pakai label.

Oke, Setelah itu Coding untuk no 1:

import com.sun.java.swing.plaf.windows.WindowsLookAndFeel;
import javax.swing.UIManager;
import javax.swing.UnsupportedLookAndFeelException;

public nasabah() {
        initComponents();
        jsc.setViewportView(new register());
    }
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        jsc.setViewportView(new register());
        // TODO add your handling code here:
    }                                       

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        jsc.setViewportView(new lihat_nasabah());
        // TODO add your handling code here:
    }                                       

    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        jsc.setViewportView(new status_cs());        // TODO add your handling code here:
    }                                       

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

    private void exitMouseClicked(java.awt.event.MouseEvent evt) {                                 
        System.exit(0);
        // TODO add your handling code here:
    }                                

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

Yang No 2 :
Sama saja cuma SetView portnya tinggal di ganti ke link mau yang d tuju

Setelah itu
Coding Transfer bisa dilihat Disini
Coding Lihat bisa dilihat Disini
Coding Daftar bisa dilihat Disini
Coding Lanjut bisa dilihat Disini
Coding Lihat Transaksi bisa dilihat Disini
Coding Tarik Tunai bisa dilihat Disini
Coding Setor bisa dilihat Disini


Untuk Hasil akhir Tugas saya ini bisa dilihat Disini

Sekian Dari saya, Terimakasih.

Minibank #7

Buat JPanel dan beri nama "Transfer"

Buat tampilan sperti ini:

   

 

Coding:

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Vector;
import javax.swing.JOptionPane;
import sql.konek;

private Vector<Vector<String>> db = new Vector();

    public trasfer() {
        initComponents();
        bacaData();
        dat();
    }

    private void bacaData() {
        db.removeAll(db);
        try {
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "Select * from saldo where `status`=1";
            ResultSet r = s.executeQuery(sql);
            String tem;
            while (r.next()) {
                Object[] o = new Object[5];
                o[0] = r.getString("nama_cs");
                o[1] = r.getString("no_rek");
                o[2] = r.getString("jum_saldo");
                Vector<String> tmp2 = new Vector();
                tmp2.add((String) o[0]);
                tmp2.add((String) o[1]);
                tmp2.add((String) o[2]);
                db.add(tmp2);
            }
            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

    public void dat() {
        Calendar cal = Calendar.getInstance();
        SimpleDateFormat contoh4 = new SimpleDateFormat("yyyy-MM-dd");
        String Tanggal = contoh4.format(cal.getTime());
        tgl.setText(Tanggal);
    }

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        String norek = "'" + nrt.getText() + "',";
        String saldo = "'" + sa.getText() + "',";
        String jn = "'" + js.getText() + "',";
        String tg = "'" + tgl.getText() + "'";
        String ket = "3,";
        String notu = "'" + nr.getText() + "',";
        String nama = "'" + name.getText() + "',";

        int upsaldo = Integer.parseInt(sa.getText()) - Integer.parseInt(js.getText());
        String us = "" + upsaldo;
        if (Integer.parseInt(sa.getText()) > Integer.parseInt(js.getText())) {
            try {
                Connection c = konek.getkoneksi();
                Statement stat = c.createStatement();
                try {
                    String sql = "INSERT INTO transaksi( `no_rek`,`nama_cs` ,`no_rek_tujuan`,`nom_seb`,`nominal`,`keterangan`,`tanggal`) VALUES (" + norek + nama + notu + saldo + jn + ket + tg + ")";
                    String sql1 = "UPDATE `saldo` SET `jum_saldo` = '" + us + "' WHERE `no_rek` = '" + nrt.getText() + "';";
                    stat.execute(sql);
                    stat.execute(sql1);
                    stat.close();
                    stat.close();
                } catch (SQLException ex) {
                    System.out.println(ex);
                }
            } catch (SQLException ex) {
            }
        name.setText("Nama Tertanda");
        js.setText("");
        sa.setText(".....................................");
        nr.setText("");
        }else{
            JOptionPane.showMessageDialog(null, "Jumlah Saldo Anda Kurang!!!");
            nr.setText("");
        }
        bacaData();
    }                                       

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        bacaData();
        for (int i = 0; i < db.size(); i++) {
            if (nrt.getText().equals(db.get(i).get(1))) {
                System.out.print("ada");
                sa.setText(db.get(i).get(2));
                name.setText(db.get(i).get(0));
                break;
            } else {
                sa.setText("No Rekening Salah");
            }
        }
    }

 

Minibank #6

Buat JPanel dan beri nama "Status Cs"

Buat tampilan sperti ini:

 

Coding:

 import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
import sql.konek;

private Vector<Vector<String>> db = new Vector();

    /**
     * Creates new form status_cs
     */
    public status_cs() {
        initComponents();
        bacaData();
    }

    private void bacaData() {
        db.removeAll(db);
        try {
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "Select * from customer where `status`=1 or `status`=2";
            ResultSet r = s.executeQuery(sql);
            String tem;
            while (r.next()) {
                Object[] o = new Object[5];
                o[0] = r.getString("nama_cs");
                o[1] = r.getString("no_rek");
                o[2] = r.getString("status");
                Vector<String> tmp2 = new Vector();
                tmp2.add((String) o[0]);
                tmp2.add((String) o[1]);
                tmp2.add((String) o[2]);
                db.add(tmp2);
            }
            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
       // norek.setText("");
    }

    public void exec() {
        String Norek = norek.getText();
        String Status = status.getText();
        String aksi = "";

        if (b1.isSelected()) {
            aksi = "1";
        } else if (b2.isSelected()) {
            aksi = "2";
        } else if (b3.isSelected()) {
            aksi = "3";
        }

        try {
            Connection c = konek.getkoneksi();
            Statement stat = c.createStatement();
            try {
                String sql = "update `customer` set `status`=" + aksi + " where `no_rek`='" + Norek + "';";
                stat.execute(sql);
                String sql1 = "update `saldo` set `status`=" + aksi + " where `no_rek`='" + Norek + "';";
                stat.execute(sql1);
                stat.close();
            } catch (SQLException ex) {
                System.out.println(ex);
            }
        } catch (SQLException ex) {
        }
        bacaData();
    }

private void norekKeyPressed(java.awt.event.KeyEvent evt) {                                
        if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
            for (int i = 0; i < db.size(); i++) {
                if (norek.getText().equals(db.get(i).get(1))) {
                    status.setText(db.get(i).get(2));
                    break;
                } else {
                    status.setText("No Rekening Salah");
                }
            }    bacaData();
        }
  
    }                               

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        if (status.getText().equals("aktif") || status.getText().equals("blokir")) {
            exec();
        }
    }

Minibank #5

Buat JPanel dan beri nama "Setor"

Buat tampilan sperti ini:

   

Coding:

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Vector;
import sql.konek;

private Vector<Vector<String>> db = new Vector();
    private Vector<Vector<String>> db1 = new Vector();

    public setor() {
        initComponents();
        bacaData();
        dat();
    }

    private void bacaData() {
        db.removeAll(db);
        try {
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "Select * from saldo where `status`=1";
            ResultSet r = s.executeQuery(sql);
            String tem;
            while (r.next()) {
                Object[] o = new Object[5];
                o[0] = r.getString("nama_cs");
                o[1] = r.getString("no_rek");
                o[2] = r.getString("jum_saldo");
                Vector<String> tmp2 = new Vector();
                tmp2.removeAllElements();
                tmp2.add((String) o[0]);
                tmp2.add((String) o[1]);
                tmp2.add((String) o[2]);
                db.add(tmp2);
            }
            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
       
    }

    public void dat() {
        Calendar cal = Calendar.getInstance();
        SimpleDateFormat contoh4 = new SimpleDateFormat("yyyy-MM-dd");
        String Tanggal = contoh4.format(cal.getTime());
        tgl.setText(Tanggal);
    }

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        bacaData();
        for (int i = 0; i < db.size(); i++) {
            if (nrt.getText().equals(db.get(i).get(1))) {
           //   System.out.print("ada");
                sa.setText(db.get(i).get(2));
                name.setText(db.get(i).get(0));
                break;
            } else {
                sa.setText("No Rekening Salah");
            }
        }
        System.out.println(sa.getText());

    }                                       

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        Setor();
    }                                       

    public void Setor() {
        String norek = "'" + nrt.getText() + "',";
        String saldo = "'" + sa.getText() + "',";
        String jn = "'" + js.getText() + "',";
        String tg = "'" + tgl.getText() + "'";
        String nama = "'" + name.getText() + "',";
        String ket = "2,";

        int upsaldo = Integer.parseInt(sa.getText()) + Integer.parseInt(js.getText());
        String us = "" + upsaldo;
        try {
            Connection c = konek.getkoneksi();
            Statement stat = c.createStatement();
            try {
                String sql = "INSERT INTO transaksi( `no_rek`,`nama_cs` ,`nom_seb`,`nominal`,`keterangan`,`tanggal`) VALUES (" + norek + nama + saldo + jn + ket + tg + ")";
                String sql1 = "UPDATE `saldo` SET `jum_saldo` = '" + us + "' WHERE `no_rek` = '" + nrt.getText() + "';";
                stat.execute(sql);
                stat.execute(sql1);
                stat.close();
            } catch (SQLException ex) {
                System.out.println(ex);
            }
        } catch (SQLException ex) {
        }

        bacaData();
        name.setText("Nama Tertanda");
        js.setText("");
        sa.setText(".....................................");
    }

Minibank #4

Buat JPanel dan beri nama "Register"

Buat tampilan sperti ini:

Coding:

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import sql.konek;

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        String Nama = "'" + nama.getText() + "',";
        String Rek = "'" + rek.getText() + "',";
        String Nik = "'" + nik.getText() + "',";
        String Alamat = "'" + alamat.getText() + "',";
        String jenis = "";
        if (j1.isSelected()) {
            jenis = "1";
        } else if (j2.isSelected()) {
            jenis = "2";
        } else if (j3.isSelected()) {
            jenis = "3";
        }
        try {
            Connection c = konek.getkoneksi();
            Statement stat = c.createStatement();
            try {
                String sql = "INSERT INTO customer(`nama_cs`,`nik_cs`, `no_rek`,`alamat_cs`,`jenis`,`status`) VALUES (" + Nama + Nik + Rek + Alamat + jenis + ", 1"+")";
                stat.execute(sql);
                String sql1 = "INSERT INTO saldo(`no_rek`,`nama_cs`,`jum_saldo`,`status`) VALUES ("+Rek+Nama+"0,1)";
                stat.execute(sql1);
                stat.close();
            } catch (SQLException ex) {
                System.out.println(ex);
            }
        } catch (SQLException ex) {
        }

        nama.setText("");
        rek.setText("");
        nik.setText("");
        alamat.setText("");
    }

Minibank #3

Buat JPanel dan beri nama "Lihat Transaksi"

Buat tampilan sperti ini:

Coding:

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import sql.konek;

public lihat_transaksi() {
        initComponents();
    }

    public void cari() {
        DefaultTableModel model = (DefaultTableModel) tdata.getModel();
        model.setRowCount(0);
        String Norek = norek.getText();
        String Nama = nama.getText();
        String Aw = aw.getText();
        String Ak = ak.getText();

        try {
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "SELECT * FROM transaksi WHERE `no_rek`='" + Norek + "' AND `nama_cs`='" + Nama + "' AND DAY(tanggal) BETWEEN " + Aw + " AND " + Ak;
            ResultSet r = s.executeQuery(sql);
            while (r.next()) {
                Object[] o = new Object[4];
                o[0] = r.getString("tanggal");
                o[1] = r.getString("keterangan");
                o[2] = r.getString("nominal");
                o[3] = r.getString("nom_seb");
                model.addRow(o);
            }
            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println("No Rekening atas nama " + Nama + " Tidak Ada");
            System.out.print(e.getMessage());
            JOptionPane.showMessageDialog(null, e);
        }
    }

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        DefaultTableModel model = (DefaultTableModel) tdata.getModel();

        if (tdata.getRowCount() == 0) {
            cari();
        } else {
            cari();
        }

        if (tdata.getRowCount() == 0) {
            JOptionPane.showMessageDialog(null, "Transaksi Kosong!!! ");
        }
    }

 

Minibank #2

Buat jPanel dan beri nama "Nasabah"

Buat tampilan seperti ini:

Coding:

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;
import sql.konek;

private Vector<Vector<String>> db = new Vector();

    public lihat_nasabah() {
        initComponents();
        bacaData();
        norek();

    }

    private void bacaData() {
        db.removeAll(db);
        try {
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "Select * from saldo";
            ResultSet r = s.executeQuery(sql);
            String tem;
            while (r.next()) {
                Object[] o = new Object[5];
                o[0] = r.getString("nama_cs");
                o[1] = r.getString("no_rek");
                Vector<String> tmp2 = new Vector();
                tmp2.add((String) o[0]);
                tmp2.add((String) o[1]);
                db.add(tmp2);
            }
            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

    public void norek() {
        int op = cb1.getItemCount();
        cb1.removeAllItems();
        for (int i = 0; i < db.size(); i++) {
            cb1.addItem(db.get(i).get(1));
        }
    }

    public void simpan() {
        try {
            String rek = "'" + cb1.getSelectedItem().toString() + "'";
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "SELECT * from saldo where no_rek=" + rek;
            ResultSet r = s.executeQuery(sql);
            while (r.next()) {
                Object[] o = new Object[5];
                o[0] = r.getString("no_rek");
                o[1] = r.getString("nama_cs");
                o[2] = r.getString("jum_saldo");

                nama.setText(o[1].toString());
                nor.setText(o[0].toString());
                sal.setText(o[2].toString());
            }

            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

     public void simpan1() {
        try {
            String rek = "'" + cb1.getSelectedItem().toString() + "'";
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "SELECT * from customer where no_rek=" + rek;
            ResultSet r = s.executeQuery(sql);
            while (r.next()) {
                Object[] o = new Object[5];
                o[0] = r.getString("status");
                o[1] = r.getString("jenis");
               
                st.setText(o[1].toString());
                jt.setText(o[0].toString());
            }

            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        simpan(); simpan1();
    }

Minibank #1

Buat JPanel dan beri nama "Tarik"

Buat seperti ini

Coding :

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Vector;
import javax.swing.JOptionPane;
import sql.konek;

private Vector<Vector<String>> db = new Vector();
   
    public tarik() {
        initComponents();
        bacaData();
        dat();
    }
   
    private void bacaData() {
        db.removeAll(db);
        try {
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "Select * from saldo where `status`=1";
            ResultSet r = s.executeQuery(sql);
            String tem;
            while (r.next()) {
                Object[] o = new Object[5];
                o[0] = r.getString("nama_cs");
                o[1] = r.getString("no_rek");
                o[2] = r.getString("jum_saldo");
                Vector<String> tmp2 = new Vector();
                tmp2.add((String) o[0]);
                tmp2.add((String) o[1]);
                tmp2.add((String) o[2]);
                db.add(tmp2);
            }
            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }
   
    public void dat() {
        Calendar cal = Calendar.getInstance();
        SimpleDateFormat contoh4 = new SimpleDateFormat("yyyy-MM-dd");
        String Tanggal = contoh4.format(cal.getTime());
        tgl.setText(Tanggal);
    }

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        String norek = "'" + nrt.getText() + "',";
        String saldo = "'" + sa.getText() + "',";
        String jn = "'" + js.getText() + "',";
        String tg = "'" + tgl.getText() + "'";
        String nama = "'" + name.getText() + "',";
        String ket = "1,";
       
        int upsaldo = Integer.parseInt(sa.getText()) - Integer.parseInt(js.getText());
        String us = "" + upsaldo;
       
        if (Integer.parseInt(sa.getText()) > Integer.parseInt(js.getText())) {
            try {
                Connection c = konek.getkoneksi();
                Statement stat = c.createStatement();
                try {
                    String sql = "INSERT INTO transaksi( `no_rek`,`nama_cs` ,`nom_seb`,`nominal`,`keterangan`,`tanggal`) VALUES (" + norek + nama + saldo + jn + ket + tg + ")";                   
                    String sql1 = "UPDATE `saldo` SET `jum_saldo` = '" + us + "' WHERE `no_rek` = '" + nrt.getText() + "';";
                    stat.execute(sql);
                    stat.execute(sql1);                   
                    stat.close();
                } catch (SQLException ex) {
                    System.out.println(ex);
                }
            } catch (SQLException ex) {
            }
        name.setText("Nama Tertanda");
        js.setText("");
        sa.setText(".....................................");
        }else{
            JOptionPane.showMessageDialog(null, "Jumlah Saldo Anda Kurang!!!");
            js.setText("");
        }
        bacaData();
    }                                       

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        bacaData();
        for (int i = 0; i < db.size(); i++) {
            if (nrt.getText().equals(db.get(i).get(1))) {
                System.out.print("ada");
                sa.setText(db.get(i).get(2));
                name.setText(db.get(i).get(0));
                break;
            } else {
                sa.setText("No Rekening Salah");
            }
        }
    }

Menyambungkan Tabel di Java Ke Database

Halo apa kabar. Lama gak posting. hehehe
kali ini saya akan posting tentang tabel di java netbeans di sambungkan ke database.
Oke.... Kita Langsung saja, Siapkan aplikasinya.

Netbeans

Untuk Aplikasi Databasenya Saya pakai SQLyog

SQLyog 

Oke..., Setelah aplikasinya sudah siap, kita buat databasenya di SQLyog, cara membuatnya sudah banyak di mbah google. hehehe

buat database yang bernama "mahasiswa" (tanpa petik ya kawan) terus  buat tabelnya juga yang diberi nama "tb_mhs". kalo kurang jelas bisa di lihat gambar ini :

Setelah itu buat projectnya nama terserah sampeyan-sampeyan saja. Hehehehe

Contohnya Seperti ini :

Sama di tambah Form java untuk mengisi data, dan java Class untuk menyambungkan ke Database.

Kalau sudah kita tambah data di "Libraries" Seperti berikut :

Ketika sudah selesai, mari kita masuk codingannya.

Pertama masuk yang codingan java class, berikut kodingnya :

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;

/**
 *
 * @author Acer
 */

public class koneksi {
    private Connection con;

    public koneksi() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mahasiswa","root", "");
        } catch (Exception e) {
            System.exit(0);
        }
    }
 
    public Connection getCon() {
        return con;
    }
}

 Setelah itu kita masuk ke Formnya buat seperti ini Desainnya

trus Coding di bawahnya public class utama extends javax.swing.JFrame

seperti ini :

public class utama extends javax.swing.JFrame {

private Connection con;

    private koneksi K = new koneksi();
    private Vector data, header, tmp;
 
    public form_utama() {
        initComponents();
        con = K.getCon();
        header = new Vector();
        header.add("NIM"); header.add("Nama"); header.add("Alamat");
        tampil();
    }

 Setelah itu method untuk menampilkan database di tabel.

public void tampil() {
        String sql = "SELECT * FROM tb_mhs";
        try {
            data = new Vector();
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery(sql);
            while (rs.next()) {
                tmp = new Vector();
                tmp.add(rs.getString(1));
                tmp.add(rs.getString(2));
                tmp.add(rs.getString(3));

    data.add(tmp);
            }
            header = new Vector();
            for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
                header.add(rs.getMetaData().getColumnName(i));              
            }
            tblData.setModel(new DefaultTableModel(data, header));
        } catch (Exception e) {
        }
    }

Untuk simpan

public void simpan() {
        try {
            Connection con = K.getCon();
            Statement stat = con.createStatement();
            String Nim = NIM.getText() + ",";
            String nama = "'" + Nama.getText() + "',";
            String alamat = "'" + Alamat.getText() + "'";
            try {
                String sql = "INSERT INTO tb_mhs VALUES"+"('" + NIM.getText() + "',"+ "'" + Nama.getText() + "',"+ "'" + Alamat.getText() + "')";
                stat.execute(sql)
                stat.close();
            } catch (SQLException ex) {
                System.out.println(ex);
            }
        } catch (SQLException ex) {
            Logger.getLogger(utama.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

untuk hapus

public void hapus() {
        DefaultTableModel model = (DefaultTableModel) tblData.getModel();
        try {
            Connection con = K.getCon();
            Statement stat = con.createStatement();
            int j = tblData.getSelectedRow();
            String i = NIM.getText();
            String sql = "DELETE FROM `tb_mhs` WHERE `NIM`='" + i + "';";
            try {
                stat.execute(sql);

                stat.close();
            } catch (SQLException ex) {
                System.out.println(ex);
            }
        } catch (SQLException ex) {
            Logger.getLogger(utama.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

untuk update

public void update() {
        String nim = NIM.getText();
        String nama = Nama.getText();
        String alamat = Alamat.getText();
        try {
            Connection c = K.getCon();
            Statement stat = c.createStatement();
            int jb = tblData.getRowCount();
            try {
                String sql = "UPDATE `tb_mhs` SET `NIM` = '" + NIM + "', `NAMA` = '" + Nama + "' WHERE `ALAMAT` = '" + Alamat + "';";
                stat.execute(sql);
                stat.close();
            } catch (SQLException ex) {
                System.out.println(ex);
            }
        } catch (SQLException ex) {
            Logger.getLogger(form_utama.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

untuk buttonnya tinggal klik 2X trus di isi :
Simpan :
Simpan();
Tampil();

Hapus :
Hapus();
Tampil();

Simpan :
Update();
Tampil();

Hasil

Sekian Dari saya, Mohon maaf kalau ada banyak yang salah. karena saya juga masih belajar.

Tugas UTS

Pertama Buka Aplikasi Netbeans.

Setelah itu

Membuat projectnya selesai, Terus kita buat framenya.

Source Kode:
private void ramActionPerformed(java.awt.event.ActionEvent evt) {                                  
        // TODO add your handling code here:
        if(ram.isSelected()){
        jTnamab.setText("RAM");
        }
       
    }                                  

    private void moboActionPerformed(java.awt.event.ActionEvent evt) {                                    
        // TODO add your handling code here:
        if(mobo.isSelected()){
        jTnamab.setText("Motherboard");
        }
       
    }                                  

    private void mActionPerformed(java.awt.event.ActionEvent evt) {                                
        // TODO add your handling code here:
        if(m.isSelected()){
        jTnamab.setText("Monitor");
        }
       
    }                                

    private void procActionPerformed(java.awt.event.ActionEvent evt) {                                    
        // TODO add your handling code here:
        if(proc.isSelected()){
        jTnamab.setText("Prosesor");
        }
       
    }  

private void KlikPeralatan(java.awt.event.ActionEvent evt) {                              
        // TODO add your handling code here:
        if(hdd.isSelected()){
        jTnamab.setText("HardDisk");
        }
       
    }                            

    private void drActionPerformed(java.awt.event.ActionEvent evt) {                                  
        // TODO add your handling code here:
        if(dr.isSelected()){
        jTnamab.setText("DVD ROM");
        }
    }

private void jBProsesActionPerformed(java.awt.event.ActionEvent evt) {                                        
        // TODO add your handling code here:
        jTabbedPane1.setSelectedIndex(1);
    }

import com.itextpdf.text.DocumentException;

import static com.sun.xml.internal.fastinfoset.alphabet.BuiltInRestrictedAlphabets.table;

import java.io.BufferedReader;

import java.io.BufferedWriter;

import java.io.FileNotFoundException;

import java.io.FileReader;

import java.io.FileWriter;

import java.util.StringTokenizer;

import java.util.Vector;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;

import javax.swing.SwingConstants;

import javax.swing.table.DefaultTableCellRenderer;

import javax.swing.table.DefaultTableModel;

private Vector<Vector<String>> DB = new Vector(), data = new Vector();

    private Vector head = new Vector();

    private int max = 0;

    private String fileName = "E:/dataKomputer.txt";

    private DefaultTableCellRenderer rightRenderer = new DefaultTableCellRenderer();

    

    public Komputer() {

        initComponents();

        rightRenderer.setHorizontalAlignment(SwingConstants.RIGHT);

        bacaData();

        updateTabel();

    }

    

    private void bacaData(){

        try {

            BufferedReader br = new BufferedReader(new FileReader(fileName));

            String tmp;

            while((tmp=br.readLine())!=null){

                StringTokenizer st = new StringTokenizer(tmp, "#");

                Vector<String> tmp2 = new Vector();

                String Kode = st.nextToken();

                String Nama = st.nextToken();

                String Unit = st.nextToken();

                String Harga = st.nextToken();

                String Total = st.nextToken();

                tmp2.add(Kode); tmp2.add(Nama); tmp2.add(Unit); tmp2.add(Harga); tmp2.add(Total);

                DB.add(tmp2);

                if(Integer.parseInt(Kode) > max) max = Integer.parseInt(Kode);

            }

            br.close();

        } catch (Exception e) {

            System.out.println(e.getMessage());

        }

    }

    

    private void updateTabel(){

        data = new Vector();

        head = new Vector();

        head.add("Kode"); head.add("Nama"); head.add("Unit"); head.add("Harga");

        if(CBtotal.isSelected()) head.add("Total"); 

        

        for (Vector<String> v1 : DB) {

            Vector<String> v2 = new Vector<>();

            v2.add(v1.get(0));

            v2.add(v1.get(1));

            v2.add(v1.get(2));

            v2.add(v1.get(3));

            if(CBtotal.isSelected()) v2.add(v1.get(4));

            data.add(v2);

        }

        

        Tabel.setModel(new DefaultTableModel(data, head));

        Tabel.getColumnModel().getColumn(0).setPreferredWidth(50);

        Tabel.getColumnModel().getColumn(1).setPreferredWidth(100);

        Tabel.getColumnModel().getColumn(2).setPreferredWidth(100);

        Tabel.getColumnModel().getColumn(3).setPreferredWidth(100);

        if(CBtotal.isSelected()) Tabel.getColumnModel().getColumn(4).setPreferredWidth(300);

        Tabel.getColumnModel().getColumn(0).setCellRenderer(rightRenderer);

        Tabel.getColumnModel().getColumn(1).setCellRenderer(rightRenderer);

    }

    

    private void simpanData(){

        try {

            BufferedWriter bw = new BufferedWriter(new FileWriter(fileName));

            for (Vector<String> v : DB) {

                bw.write(v.get(0)+"#"+v.get(1)+"#"+v.get(2)+"#"+v.get(3)+"#"+v.get(4));

                bw.newLine();

            }

            bw.close();

        } catch (Exception e) {

        }

    }

    

    private void hapusData() {

        String kode = jTkodeb.getText().trim();

        if(kode.equals("")) {

            JOptionPane.showMessageDialog(this, "Tentukan nama barang yang ingin dihapus.");

        } else {

            if(JOptionPane.showConfirmDialog(this, "Data "+kode+" dihapus?", "Konfirmasi", JOptionPane.YES_NO_OPTION) == JOptionPane.NO_OPTION) return;

            boolean b = false;

            int i;

            for (i = 0; i < DB.size(); i++) {

                if(DB.get(i).get(1).equals(kode)) { b = true; break; }

            }

            if(b){

                DB.remove(i);

                JOptionPane.showMessageDialog(this, "Proses Hapus sukses.");

                max = 0;

                for (Vector<String> v : DB) {

                    if(Integer.parseInt(v.get(0)) > max) max = Integer.parseInt(v.get(0));

                }

                updateTabel();

                jTkodeb.setText(""); jTnamab.setText(""); jTunitdpsn.setText(""); jThargab.setText(""); jTtotal.setText("");

            } else {

                JOptionPane.showMessageDialog(this, "Data tidak ditemukan.");

            }

        }

    }

private void jbtotalActionPerformed(java.awt.event.ActionEvent evt) {                                        

        // TODO add your handling code here:

        int bil1=Integer.parseInt(jTunitdpsn.getText().toString());

        int bil2=Integer.parseInt(jThargab.getText().toString());

        int total = bil1*bil2;

        jTtotal.setText(""+total);

    }

private void TabelMouseClicked(java.awt.event.MouseEvent evt) {                                   

        // TODO add your handling code here:

        int row = Tabel.getSelectedRow();

        if(row < 0) {

            JOptionPane.showMessageDialog(this, "Pilih data (klik kiri) terlebih dahulu.");

            return;

        }

        jTkodeb.setText(DB.get(row).get(0));

        jTnamab.setText(DB.get(row).get(1));

        jTunitdpsn.setText(DB.get(row).get(2));

        jThargab.setText(DB.get(row).get(3));

        jTtotal.setText(DB.get(row).get(4));

        jTkodeb.setEditable(false);

        if(evt.getButton() == java.awt.event.MouseEvent.BUTTON3) {

            MenuHapus.setText("Hapus "+jTkodeb.getText()+", "+jTnamab.getText());

            PopupMenu.show(Tabel, evt.getX(), evt.getY());

        }

    }                                  

    private void jbsimpanActionPerformed(java.awt.event.ActionEvent evt) {                                         

        // TODO add your handling code here:

        String Kode = jTkodeb.getText().trim();

        String Nama = jTnamab.getText().trim();

        String Unit = jTunitdpsn.getText().trim();

        String Harga = jTtotal.getText().trim();

        String Total = jTtotal.getText().trim();

        if(Kode.equals("") || Nama.equals("") || Unit.equals("") || Harga.equals("") || Total.equals(""))

            JOptionPane.showMessageDialog(this, "Semua isian harus diisi.");

        else {

            boolean b = false;

            int i;

            Vector<String> v = new Vector<>();

            

            for (i = 0; i < DB.size(); i++) {

                if(DB.get(i).get(1).equals(Kode)) { b = true; break; }

            }

            if(b){

                v.add(DB.get(i).get(0)); v.add(Kode); v.add(Nama); v.add(Unit); v.add(Harga); v.add(Total);

                DB.setElementAt(v, i);

                updateTabel();

                JOptionPane.showMessageDialog(this, "Proses update sukses.");

            } else {

                v.add(Kode); v.add(Nama); v.add(Unit); v.add(Harga); v.add(Total);

                DB.add(v);

                updateTabel(); max++;

                JOptionPane.showMessageDialog(this, "Proses simpan sukses.");

            }

            jTkodeb.setText(""); jTnamab.setText(""); jTunitdpsn.setText(""); jThargab.setText(""); jTtotal.setText(""); jTkodeb.setEditable(false);

        }

    }                                        

    private void CBtotalActionPerformed(java.awt.event.ActionEvent evt) {                                        

        // TODO add your handling code here:

        updateTabel();

    }                                       

    private void formWindowClosing(java.awt.event.WindowEvent evt) {                                   

        // TODO add your handling code here:

        simpanData();

        dispose();

    }                                  

    private void btnbaruActionPerformed(java.awt.event.ActionEvent evt) {                                        

        // TODO add your handling code here:

        

        jTkodeb.setEditable(true);

        jTkodeb.setText(""); jTnamab.setText(""); jTunitdpsn.setText(""); jThargab.setText(""); jTtotal.setText(""); jTkodeb.requestFocus();

    }                                       

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         

        JOptionPane.showMessageDialog(null, "Pembayaran telah Siap"); 

        DefaultTableModel mod = (DefaultTableModel) Tabel.getModel();

        if(CBtotal.isSelected()){

        String[] jud = {"Kode", "Nama", "Unit yang dipesan", "Harga barang", "Total"};

        String[][] isi = new String[Tabel.getRowCount()][Tabel.getColumnCount()];

        for (int i = 0; i < Tabel.getRowCount(); i++) {

            for (int j = 0; j < Tabel.getColumnCount(); j++) {

                isi[i][j] = mod.getValueAt(i, j).toString();

            }

             try {

                 cetakpembayaran cetak

                         = new cetakpembayaran(jud, isi, Tabel.getRowCount(), Tabel.getColumnCount());

             } catch (FileNotFoundException ex) {

                 Logger.getLogger(Komputer.class.getName()).log(Level.SEVERE, null, ex);

             } catch (DocumentException ex) {

                 Logger.getLogger(Komputer.class.getName()).log(Level.SEVERE, null, ex);

             }

    }  

        }else{

            String[] jud = {"Kode", "Nama", "Unit yang dipesan", "Harga barang"};

        String[][] isi = new String[Tabel.getRowCount()][Tabel.getColumnCount()];

        for (int i = 0; i < Tabel.getRowCount(); i++) {

            for (int j = 0; j < Tabel.getColumnCount(); j++) {

                isi[i][j] = mod.getValueAt(i, j).toString();

            }

             try {

                 cetakpembayaran cetak

                         = new cetakpembayaran(jud, isi, Tabel.getRowCount(), Tabel.getColumnCount());

             } catch (FileNotFoundException ex) {

                 Logger.getLogger(Komputer.class.getName()).log(Level.SEVERE, null, ex);

             } catch (DocumentException ex) {

                 Logger.getLogger(Komputer.class.getName()).log(Level.SEVERE, null, ex);

             }

         

    }

            

        }

    

    

    }

Tambahan Untuk Repportnya pakai IText

import com.itextpdf.text.Document;

import com.itextpdf.text.DocumentException;

import com.itextpdf.text.Paragraph;

import com.itextpdf.text.pdf.PdfPTable;

import com.itextpdf.text.pdf.PdfWriter;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

class cetakpembayaran {

    cetakpembayaran(String[] jud, String[][] oo, int bar, int col) throws FileNotFoundException, DocumentException {

        

    Document doc = new Document();

        PdfWriter.getInstance(doc, new FileOutputStream("ll.pdf"));

        PdfPTable pt = new PdfPTable(jud.length);

        doc.open();

        Paragraph p = new Paragraph("Pembayaran Komputer");

        p.setAlignment(Paragraph.ALIGN_CENTER);

        p.setSpacingAfter(10);

        doc.add(p);

        for (int i = 0; i < jud.length; i++) {

            pt.addCell(jud[i]);

        }

        for (int i = 0; i < bar; i++) {

            for (int j = 0; j < col; j++) {

                pt.addCell(oo[i][j]);

            }

        }

        doc.add(pt);

        doc.close();

    }

}

Sekian, Kalau Ada yang kurang Mohon Maaf, Terimakasih