Pena Emas Web blogs’

Script berikut adalah sebagian program aplikasi koperasi yang diminta peronalia perusahaan, cape deh… proyek baru, simple dan harus jalan di dua platform Linux Suse dan Window…opsss..

Jika ada yang mau ngembangkan lebih baik lagi boleh lah kita share,Open Source koq… , dan Jar Program nya bisa diminta lewat email … siapa berminat…. ?

==========

package babx;

import java.lang.*;
import javax.swing.*;
import java.awt.*;
import javax.swing.table.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.text.*;
import java.util.*;

public class data_transaksi extends JInternalFrame {
// Deklarasi Komponen
JTextField dataKode = new JTextField();
JTextField dataNama = new JTextField();
JComboBox dataTrans = new JComboBox();
JComboBox data_tglx = new JComboBox();
JComboBox data_blnx = new JComboBox();
JComboBox data_thnx = new JComboBox();
JComboBox data_sort = new JComboBox();
JTextField dataNomi = new JTextField();
JTextField dataBung = new JTextField();
JTextField dataKets = new JTextField();
JTextField Totalx01 = new JTextField();
JTextField Totalx02 = new JTextField();
JTextField Totalx03 = new JTextField();
JTextField Totalx04 = new JTextField();
JTextField Totalx05 = new JTextField();

JTextField Totalx06 = new JTextField();
JTextField Totalx07 = new JTextField();
JTextField Totalx08 = new JTextField();
JTextField Totalx09 = new JTextField();
JTextField Totalx10 = new JTextField();
JTextField Totalx11 = new JTextField();
JTextField Totalx12 = new JTextField();
JTextField Totalx13 = new JTextField();
JTextField Totalx14 = new JTextField();
JTextField Totalx15 = new JTextField();
JTextField Totalx16 = new JTextField();
JTextField Totalx17 = new JTextField();
JTextField Totalx18 = new JTextField();
JTextField Totalx19 = new JTextField();
JTextField Totalx20 = new JTextField();
JTextField Totalx21 = new JTextField();
JTextField Totalx22 = new JTextField();

Button simpan = new Button();
Button updata = new Button();
Button deleta = new Button();
JLabel jLabel1 = new JLabel();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JLabel jLabel4 = new JLabel();
JLabel jLabel5 = new JLabel();
JLabel jLabel6 = new JLabel();
JLabel jLabel7 = new JLabel();
JLabel jLabel8 = new JLabel();
JLabel jLabel9 = new JLabel();
JLabel jLabel10 = new JLabel();
JLabel jLabel11 = new JLabel();
JLabel jLabel12 = new JLabel();

JLabel jLabel13 = new JLabel();
JLabel jLabel14 = new JLabel();
JLabel jLabel15 = new JLabel();
JLabel jLabel16 = new JLabel();
JLabel jLabel17 = new JLabel();

JLabel jLabel18 = new JLabel();
JLabel jLabel19 = new JLabel();
JLabel jLabel20 = new JLabel();
JLabel jLabel21 = new JLabel();
JLabel jLabel22 = new JLabel();
JLabel jLabel23 = new JLabel();
JLabel jLabel24 = new JLabel();
JLabel jLabel25 = new JLabel();

JCheckBox cek1 = new JCheckBox();

JTabbedPane tabbedpane = new JTabbedPane();

JScrollPane jScrollPane1 = new JScrollPane();
JTable tabel = new JTable();
DefaultTableModel tabMode;

JScrollPane jScrollPane1x = new JScrollPane();
JTable tabelx = new JTable();
DefaultTableModel tabModex;

JScrollPane jScrollPane1y = new JScrollPane();
JTable tabely = new JTable();
DefaultTableModel tabModey;

JScrollPane jScrollPane1z = new JScrollPane();
JTable tabelz = new JTable();
DefaultTableModel tabModez;

JScrollPane jScrollPane1r = new JScrollPane();
JTable tabelr = new JTable();
DefaultTableModel tabModer;

Connection konek;

/**
* Konstuktor
* Methode ini berisikan pembuatan komponen dan penambahan Action Listener
*/
public data_transaksi() {
this.setSize(780, 565);
this.setTitle(“Proses:Transaksi Anggota”);
this.setClosable(true);
this.getContentPane().setLayout(null);
this.setLocation(50,50);
this.setResizable(false);
this.setVisible(true);
this.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 9));

dataKode.setBounds(new Rectangle(101, 17, 91, 22));
dataKode.setDocument(new batasiInput((byte) 5).getFilter());
dataKode.setToolTipText(“kode anggota…”);

dataNama.setBounds(new Rectangle(101, 42, 243, 22));
dataNama.setToolTipText(“nama anggota…”);

dataTrans.setBounds(new Rectangle(101, 67, 215, 22));
dataTrans.setToolTipText(“Mutasi Transaksi…”);
dataTrans.addItem(“01.Tabungan Wajib”);
dataTrans.addItem(“02.Iuran Wajib Anggota”);
dataTrans.addItem(“03.Pinjaman Anggota”);
dataTrans.addItem(“04.Cicilan Pinjaman”);
dataTrans.addItem(“05.Pengambilan Oleh Anggota”);
dataTrans.addItem(“06.Pembagian Hasil Usaha”);

cek1.setBounds(new Rectangle(320,67,50,22));
cek1.setText(“”);

data_tglx.setBounds(new Rectangle(101, 92, 50, 20));
data_blnx.setBounds(new Rectangle(153, 92, 90, 20));
data_thnx.setBounds(new Rectangle(245, 92, 70, 20));
for (int i = 1; i <= 31; i++) {
if (i < 10) {
data_tglx.addItem(“0″+Integer.toString(i));
} else {
data_tglx.addItem(Integer.toString(i));
}
}
data_blnx.addItem(“Januari”);
data_blnx.addItem(“Februari”);
data_blnx.addItem(“Maret”);
data_blnx.addItem(“April”);
data_blnx.addItem(“Mei”);
data_blnx.addItem(“Juni”);
data_blnx.addItem(“Juli”);
data_blnx.addItem(“Agustus”);
data_blnx.addItem(“September”);
data_blnx.addItem(“Oktober”);
data_blnx.addItem(“November”);
data_blnx.addItem(“Desember”);
Calendar dt = Calendar.getInstance();
for (int i = 2004; i <= (Calendar.getInstance().get(Calendar.YEAR)) + 5; i++) {
data_thnx.addItem(Integer.toString(i));
}
int nilai_bulan = dt.get(dt.MONTH);
int nilai_tahun = dt.get(dt.YEAR);
data_thnx.setSelectedItem(Integer.toString(nilai_tahun));

data_sort.setBounds(new Rectangle(315, 92, 65, 20));
data_sort.addItem(“DESC”);
data_sort.addItem(“ASC”);
data_sort.setToolTipText(“ASC:Ascending – DSC:Descending!”);

dataNomi.setBounds(new Rectangle(101, 117, 91, 22));
dataNomi.setToolTipText(“nilai nominal…”);
dataNomi.setHorizontalAlignment(SwingConstants.RIGHT);
dataNomi.setText(“0″);
dataNomi.setDocument(new onlyDigit().getOnlyDigit());

dataBung.setBounds(new Rectangle(250, 117, 91, 22));
dataBung.setToolTipText(“nilai bunga…”);
dataBung.setHorizontalAlignment(SwingConstants.RIGHT);
dataBung.setEnabled(false);
dataBung.setText(“0″);
dataBung.setDocument(new onlyDigit().getOnlyDigit());

dataKets.setBounds(new Rectangle(12, 367, 220, 22));
dataKets.setToolTipText(“keterangan…”);
dataKets.setHorizontalAlignment(SwingConstants.LEFT);

Totalx01.setBounds(new Rectangle(250, 407, 125, 22));
Totalx01.setToolTipText(“Total Tabungan Wajib Anggota…”);
Totalx01.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx01.setEnabled(false);
Totalx01.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx02.setBounds(new Rectangle(250, 432, 125, 22));
Totalx02.setToolTipText(“Total Iuran Wajib Bulanan Anggota…”);
Totalx02.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx02.setEnabled(false);
Totalx02.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx03.setBounds(new Rectangle(250, 457, 125, 22));
Totalx03.setToolTipText(“Sisa Pinjaman Anggota…”);
Totalx03.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx03.setEnabled(false);
Totalx03.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx04.setBounds(new Rectangle(250, 367, 125, 22));
Totalx04.setToolTipText(“Sub Total…”);
Totalx04.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx04.setEnabled(false);
Totalx04.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

//Label12
Totalx05.setBounds(new Rectangle(640, 230, 125, 23));
Totalx05.setToolTipText(“Total Saldo Akhir..(1+2+4-3-5-6+X+7+8-9-10+11-12).”);
Totalx05.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx05.setEnabled(false);
Totalx05.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx06.setBounds(new Rectangle(225, 17, 125, 23));
Totalx06.setToolTipText(“Tabungan Wajib + Iuran Wajib…”);
Totalx06.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx06.setEnabled(false);
Totalx06.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx07.setBounds(new Rectangle(225, 42, 125, 23));
Totalx07.setToolTipText(“Saldo Netto Anggota (A-Sisa Pinjaman)…”);
Totalx07.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx07.setEnabled(false);
Totalx07.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx08.setBounds(new Rectangle(225, 67, 125, 23));
Totalx08.setToolTipText(“Pengambilan Oleh Anggota…”);
Totalx08.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx08.setEnabled(false);
Totalx08.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx09.setBounds(new Rectangle(225, 92, 125, 23));
Totalx09.setToolTipText(“Pembagian Hasil Usaha…”);
Totalx09.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx09.setEnabled(false);
Totalx09.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx10.setBounds(new Rectangle(225, 117, 125, 23));
Totalx10.setToolTipText(“Saldo Netto (B-C-D) !…”);
Totalx10.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx10.setEnabled(false);
Totalx10.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx11.setBounds(new Rectangle(225, 17, 125, 23));
Totalx11.setToolTipText(“Total Modal Dasar…”);
Totalx11.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx11.setEnabled(false);
Totalx11.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx12.setBounds(new Rectangle(225, 42, 125, 23));
Totalx12.setToolTipText(“Laba / Pendapatan Usaha…”);
Totalx12.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx12.setEnabled(false);
Totalx12.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx13.setBounds(new Rectangle(225, 67, 125, 23));
Totalx13.setToolTipText(“Pendapatan dari Bunga Bank…”);
Totalx13.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx13.setEnabled(false);
Totalx13.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx14.setBounds(new Rectangle(225, 92, 125, 23));
Totalx14.setToolTipText(“Pengeluran Rutin Organisasi…”);
Totalx14.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx14.setEnabled(false);
Totalx14.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx15.setBounds(new Rectangle(225, 117, 125, 23));
Totalx15.setToolTipText(“Net Income Organisasi…”);
Totalx15.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx15.setEnabled(false);
Totalx15.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx16.setBounds(new Rectangle(225, 142, 125, 23));
Totalx16.setToolTipText(“Piutang (AR) pada Anggota…”);
Totalx16.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx16.setEnabled(false);
Totalx16.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx17.setBounds(new Rectangle(222, 200, 125, 23));
Totalx17.setToolTipText(“Total Bunga…”);
Totalx17.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx17.setEnabled(false);
Totalx17.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx18.setBounds(new Rectangle(89, 200, 125, 23));
Totalx18.setToolTipText(“Total Nominal…”);
Totalx18.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx18.setEnabled(false);
Totalx18.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx19.setBounds(new Rectangle(222, 200, 125, 23));
Totalx19.setToolTipText(“Total Sisa Pinjaman…”);
Totalx19.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx19.setEnabled(false);
Totalx19.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx20.setBounds(new Rectangle(222, 200, 125, 23));
Totalx20.setToolTipText(“Total Modal…”);
Totalx20.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx20.setEnabled(false);
Totalx20.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx21.setBounds(new Rectangle(225, 167, 125, 23));
Totalx21.setToolTipText(“Saldo pada Acct Bank…”);
Totalx21.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx21.setEnabled(false);
Totalx21.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

Totalx22.setBounds(new Rectangle(225, 192, 125, 23));
Totalx22.setToolTipText(“Dana Koperasi (A+B+C)…”);
Totalx22.setHorizontalAlignment(SwingConstants.RIGHT);
Totalx22.setEnabled(false);
Totalx22.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

simpan.setBackground(Color.green);
simpan.setLabel(“SIMPAN”);
simpan.setBounds(new Rectangle(12, 490, 60, 26));
simpan.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 8));
updata.setBackground(Color.CYAN);
updata.setLabel(“UPDATE”);
updata.setBounds(new Rectangle(73, 490, 60, 26));
updata.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 8));
updata.setEnabled(false);
deleta.setBackground(Color.ORANGE);
deleta.setLabel(“DELETE”);
deleta.setBounds(new Rectangle(134, 490, 60, 26));
deleta.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 8));
deleta.setEnabled(false);
deleta.setVisible(false);

tabel.setToolTipText(“Data Transaksi”);
tabel.setVerifyInputWhenFocusTarget(false);
tabelx.setToolTipText(“Rekap All Mutasi”);
tabelx.setVerifyInputWhenFocusTarget(false);

cek1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
if (cek1.isSelected()) {
dataTrans.setEnabled(false);
} else {
dataTrans.setEnabled(true);
}
}
});

dataKode.addKeyListener(new KeyAdapter() {
public void keyPressed(KeyEvent e) {
dataKode_keyPressed(e);
}
});

dataTrans.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
tampilDataKeTabel();
hitungSubTotal();
hitungTotal();
String tranx = String.valueOf(dataTrans.getSelectedItem()).trim();
dataBung.setEnabled(false);
dataBung.setText(“0″);
dataKets.setText(“”);
if (tranx.equalsIgnoreCase(“03.Pinjaman Anggota”)) {
dataBung.setEnabled(true);
}
tabel.setToolTipText(“Data Transaksi “+tranx+” : “+dataNama.getText());
}
});

data_sort.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
tampilDataKeTabel();
}
});

simpan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
tombol_simpan();
}
});

updata.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
proses_rubahData();
}
});

deleta.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
//proses_hapusData();
}
});

jLabel1.setBounds(new Rectangle(7, 17, 92, 23));
jLabel1.setHorizontalAlignment(SwingConstants.RIGHT);
jLabel1.setText(“Kode :”);
jLabel1.setRequestFocusEnabled(true);

jLabel2.setBounds(new Rectangle(10, 42, 89, 23));
jLabel2.setHorizontalAlignment(SwingConstants.RIGHT);
jLabel2.setText(“Nama :”);
jLabel2.setRequestFocusEnabled(true);

jLabel3.setBounds(new Rectangle(10, 67, 89, 23));
jLabel3.setHorizontalAlignment(SwingConstants.RIGHT);
jLabel3.setText(“Transaksi :”);
jLabel3.setRequestFocusEnabled(true);

jLabel4.setBounds(new Rectangle(10,92,89,23));
jLabel4.setHorizontalAlignment(SwingConstants.RIGHT);
jLabel4.setText(“Tanggal :”);
jLabel4.setRequestFocusEnabled(true);

jLabel6.setBounds(new Rectangle(10,117,89,23));
jLabel6.setHorizontalAlignment(SwingConstants.RIGHT);
jLabel6.setText(“Nilai :”);
jLabel6.setRequestFocusEnabled(true);

jLabel5.setBounds(new Rectangle(13, 148, 189, 23));
jLabel5.setHorizontalAlignment(SwingConstants.LEFT);
jLabel5.setText(“Data Mutasi Transaksi Anggota”);
jLabel5.setRequestFocusEnabled(true);

jLabel7.setBounds(new Rectangle(150,117,89,23));
jLabel7.setHorizontalAlignment(SwingConstants.RIGHT);
jLabel7.setText(“Bunga :”);
jLabel7.setRequestFocusEnabled(true);

jLabel8.setBounds(new Rectangle(13, 407, 189, 23));
jLabel8.setHorizontalAlignment(SwingConstants.LEFT);
jLabel8.setText(“Jumlah Tabungan Wajib :”);
jLabel8.setRequestFocusEnabled(true);

jLabel9.setBounds(new Rectangle(13, 432, 189, 23));
jLabel9.setHorizontalAlignment(SwingConstants.LEFT);
jLabel9.setText(“Jumlah Iuran Wajib Anggota :”);
jLabel9.setRequestFocusEnabled(true);

jLabel10.setBounds(new Rectangle(13, 457, 189, 23));
jLabel10.setHorizontalAlignment(SwingConstants.LEFT);
jLabel10.setText(“Sisa Pinjaman :”);
jLabel10.setRequestFocusEnabled(true);

jLabel11.setBounds(new Rectangle(400, 17, 120, 23));
jLabel11.setHorizontalAlignment(SwingConstants.LEFT);
jLabel11.setText(“Perhitungan :”);
jLabel11.setRequestFocusEnabled(true);
jLabel11.setFont(new java.awt.Font(“Dialog”, Font.BOLD, 14));

//Total0×05
jLabel12.setBounds(new Rectangle(400, 230, 230, 23));
jLabel12.setHorizontalAlignment(SwingConstants.LEFT);
jLabel12.setText(“Saldo Kas :”);
jLabel12.setRequestFocusEnabled(true);

jLabel13.setBounds(new Rectangle(7, 17, 200, 23));
jLabel13.setHorizontalAlignment(SwingConstants.LEFT);
jLabel13.setText(“A.Tab Wajib+Iuran Wajib :”);
jLabel13.setRequestFocusEnabled(true);

jLabel14.setBounds(new Rectangle(7, 42, 200, 23));
jLabel14.setHorizontalAlignment(SwingConstants.LEFT);
jLabel14.setText(“B.Netto(A-Sisa Pinjaman) :”);
jLabel14.setRequestFocusEnabled(true);

jLabel15.setBounds(new Rectangle(7, 67, 200, 23));
jLabel15.setHorizontalAlignment(SwingConstants.LEFT);
jLabel15.setText(“C.Pengambilan :”);
jLabel15.setRequestFocusEnabled(true);

jLabel16.setBounds(new Rectangle(7, 92, 200, 23));
jLabel16.setHorizontalAlignment(SwingConstants.LEFT);
jLabel16.setText(“D.Hasil Usaha :”);
jLabel16.setRequestFocusEnabled(true);

jLabel17.setBounds(new Rectangle(7, 117, 200, 23));
jLabel17.setHorizontalAlignment(SwingConstants.LEFT);
jLabel17.setText(“E.Netto(B-C-D):”);
jLabel17.setRequestFocusEnabled(true);

jLabel18.setBounds(new Rectangle(7, 17, 200, 23));
jLabel18.setHorizontalAlignment(SwingConstants.LEFT);
jLabel18.setText(“A.MODAL DASAR(01+02-05):”);
jLabel18.setRequestFocusEnabled(true);

jLabel19.setBounds(new Rectangle(7, 42, 200, 23));
jLabel19.setHorizontalAlignment(SwingConstants.LEFT);
jLabel19.setText(“B.LABA (X+08) :”);
jLabel19.setRequestFocusEnabled(true);

jLabel20.setBounds(new Rectangle(7, 67, 200, 23));
jLabel20.setHorizontalAlignment(SwingConstants.LEFT);
jLabel20.setText(“C.PEND.BUNGA BANK (07):”);
jLabel20.setRequestFocusEnabled(true);

jLabel21.setBounds(new Rectangle(7, 92, 200, 23));
jLabel21.setHorizontalAlignment(SwingConstants.LEFT);
jLabel21.setText(“D.PENGELUARAN(06+09+12):”);
jLabel21.setRequestFocusEnabled(true);

jLabel22.setBounds(new Rectangle(7, 117, 200, 23));
jLabel22.setHorizontalAlignment(SwingConstants.LEFT);
jLabel22.setText(“E.NET INCOME (B+C-D) :”);
jLabel22.setRequestFocusEnabled(true);

jLabel23.setBounds(new Rectangle(7, 142, 200, 23));
jLabel23.setHorizontalAlignment(SwingConstants.LEFT);
jLabel23.setText(“Piutang(AR) (03-04) :”);
jLabel23.setRequestFocusEnabled(true);

jLabel24.setBounds(new Rectangle(7, 167, 200, 23));
jLabel24.setHorizontalAlignment(SwingConstants.LEFT);
jLabel24.setText(“SAL.BANK(10-11-12+07) :”);
jLabel24.setRequestFocusEnabled(true);

jLabel25.setBounds(new Rectangle(7, 192, 200, 23));
jLabel25.setHorizontalAlignment(SwingConstants.LEFT);
jLabel25.setText(“DANA (A+B+C) :”);
jLabel25.setRequestFocusEnabled(true);

// (400,255,365,270) //
// (x1,y1,y2,x2) //
// 400,255………………… //
// . . //
// . . //
// ………………..270,365 //
tabbedpane.setBounds(new Rectangle(400,255,365,270));
String nameTb1 = “Anggota”;
JPanel pix1 = new JPanel();
pix1.setLayout(null);
tabbedpane.add(nameTb1, pix1);

String nameTb2 = “CashFlow”;
JPanel pix2 = new JPanel();
pix2.setLayout(null);
tabbedpane.add(nameTb2, pix2);

String nameTb3 = “Rincian”;
JPanel pix3 = new JPanel();
pix3.setLayout(null);
tabbedpane.add(nameTb3, pix3);

String nameTb4 = “Pinjaman”;
JPanel pix4 = new JPanel();
pix4.setLayout(null);
tabbedpane.add(nameTb4, pix4);

String nameTb5 = “Modal”;
JPanel pix5 = new JPanel();
pix5.setLayout(null);
tabbedpane.add(nameTb5, pix5);

// Membuat Tabel 1
Object[] row = {“Kode”, “Transaksi”, “Tanggal”, “Nominal”,”Bunga”,”Ket”};
tabMode = new DefaultTableModel(null, row);
jScrollPane1.setBounds(new Rectangle(13, 170, 365, 185));
tabel.setModel(tabMode);
tabel.getAutoscrolls();
JTableHeader header = tabel.getTableHeader();
header.setBackground(Color.yellow);
header.setFont(new java.awt.Font(“Dialog”,Font.BOLD,10));

//Membuat Tabel 2
Object[] rowx = {“Mutasi Transaksi”, “Total”,”Bunga (X)”};
tabModex = new DefaultTableModel(null, rowx);
jScrollPane1x.setBounds(new Rectangle(400, 40, 365, 185));
tabelx.setModel(tabModex);
tabelx.getAutoscrolls();
tabelx.setShowHorizontalLines(false);
TableColumn tc0 = tabelx.getColumn(“Mutasi Transaksi”);
tc0.setWidth(170);
tc0.setMinWidth(170);
tc0.setMaxWidth(170);
TableColumn tc1 = tabelx.getColumn(“Total”);
tc1.setWidth(90);
tc1.setMaxWidth(90);
tc1.setMinWidth(90);
JTableHeader headerx = tabelx.getTableHeader();
headerx.setBackground(Color.MAGENTA);

//Membuat Tabel 3
Object[] rowy = {“Kode”,”Tanggal”,”Total”,”Bunga”,”Ket”};
tabModey = new DefaultTableModel(null, rowy);
jScrollPane1y.setBounds(new Rectangle(7, 17, 340, 180));
tabely.setModel(tabModey);
tabely.getAutoscrolls();
//Membuat Tabel 4
Object[] rowz = {“Kode”,”Nama”,”Sisa Pinjaman”};
tabModez = new DefaultTableModel(null, rowz);
jScrollPane1z.setBounds(new Rectangle(7, 17, 340, 180));
tabelz.setModel(tabModez);
tabelz.getAutoscrolls();
//Membuat Tabel 5
Object[] rowr = {“Kode”,”Nama”,”Pokok”,”Tab”,”Ambil”,”Total”};
tabModer = new DefaultTableModel(null, rowr);
jScrollPane1r.setBounds(new Rectangle(7, 17, 340, 180));
tabelr.setModel(tabModer);
tabelr.getAutoscrolls();

tabel.addMouseListener(new java.awt.event.MouseAdapter() {
// Proses saat TABEL di klik
public void mouseClicked(MouseEvent e) {
dapatData_dari_Tabel();
}
});

tabelx.addMouseListener(new java.awt.event.MouseAdapter() {
// Proses saat TABEL di klik
public void mouseClicked(MouseEvent e) {
tampilsisaPinjaman();
tampilModalAnggota();
dapatData_keDetil_Tabel();
}
});

this.getContentPane().add(jLabel1, null);
this.getContentPane().add(jLabel2, null);
this.getContentPane().add(jLabel3, null);
this.getContentPane().add(jLabel4, null);
this.getContentPane().add(jLabel5, null);
this.getContentPane().add(jLabel6, null);
this.getContentPane().add(jLabel7, null);
this.getContentPane().add(jLabel8, null);
this.getContentPane().add(jLabel9, null);
this.getContentPane().add(jLabel10, null);
this.getContentPane().add(jLabel11, null);
this.getContentPane().add(jLabel12, null);

pix1.add(jLabel13);
pix1.add(jLabel14);
pix1.add(jLabel15);
pix1.add(jLabel16);
pix1.add(jLabel17);

pix2.add(jLabel18);
pix2.add(jLabel19);
pix2.add(jLabel20);
pix2.add(jLabel21);
pix2.add(jLabel22);
pix2.add(jLabel23);
pix2.add(jLabel24);
pix2.add(jLabel25);

this.getContentPane().add(dataKode, null);
this.getContentPane().add(dataNama, null);
this.getContentPane().add(dataTrans, null);
this.getContentPane().add(data_tglx, null);
this.getContentPane().add(data_blnx, null);
this.getContentPane().add(data_thnx, null);
this.getContentPane().add(data_sort, null);
this.getContentPane().add(dataNomi, null);
this.getContentPane().add(dataBung, null);
this.getContentPane().add(dataKets, null);
this.getContentPane().add(Totalx01, null);
this.getContentPane().add(Totalx02, null);
this.getContentPane().add(Totalx03, null);
this.getContentPane().add(Totalx04, null);
this.getContentPane().add(Totalx05, null);

this.getContentPane().add(cek1, null);

pix1.add(Totalx06);
pix1.add(Totalx07);
pix1.add(Totalx08);
pix1.add(Totalx09);
pix1.add(Totalx10);

pix2.add(Totalx11);
pix2.add(Totalx12);
pix2.add(Totalx13);
pix2.add(Totalx14);
pix2.add(Totalx15);
pix2.add(Totalx16);
pix2.add(Totalx21);
pix2.add(Totalx22);

pix3.add(Totalx17);
pix3.add(Totalx18);
pix4.add(Totalx19);
pix5.add(Totalx20);

this.getContentPane().add(tabbedpane, null);

this.getContentPane().add(jScrollPane1, null);
jScrollPane1.getViewport().add(tabel, null);

this.getContentPane().add(jScrollPane1x, null);
jScrollPane1x.getViewport().add(tabelx, null);

pix3.add(jScrollPane1y, null);
jScrollPane1y.getViewport().add(tabely, null);

pix4.add(jScrollPane1z, null);
jScrollPane1z.getViewport().add(tabelz, null);

pix5.add(jScrollPane1r, null);
jScrollPane1r.getViewport().add(tabelr, null);

this.getContentPane().add(simpan, null);
this.getContentPane().add(updata, null);
this.getContentPane().add(deleta, null);

// Memanggil Methode koneksiDatabase() untuk koneksi database
koneksiDatabase();
// Memanggil methode tampilDataTabel() untuk menampilkan data pada tabel
tampilDataKeTabel();
// All Mutasi
tampilMutasiAllTabel();
}

public void koneksiDatabase() {
// Mencoba memanggil Driver JDBC
try {
String JDBCDriver = getData(“DriverJDBC”);
Class.forName(JDBCDriver);
System.out.println(“Sukses Driver JDBC ditemukan ….”);
try {
String url = getData(“url”);
String user = getData(“user”);
String password = getData(“password”);
konek = DriverManager.getConnection(url, user, password);
System.out.println(“Sukses Koneksi ….”);
}
// Gagal Koneksi dengan Database
catch (SQLException se) {
System.out.println(“Koneksi Gagal = ” + se);
System.exit(0);
}
}
// Gagal Memanggil Driver JDBC
catch (ClassNotFoundException cnfe) {
System.out.println(“Class tidak ditemukan.. Error : ” + cnfe);
System.exit(0);
}
} // Akhir methode koneksiDatabase()

public void tampilDataKeTabel() {
hapusTabel();
String kodex = dataKode.getText();
String tranx = String.valueOf(dataTrans.getSelectedItem());
String xsort = String.valueOf(data_sort.getSelectedItem());
try {
String sql = “Select * from data_trans where kode = ‘”+ kodex +”‘ and trans = ‘”+tranx+”‘ order by tanggal “+xsort;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
String kode = set.getString(“kode”);
String trans = set.getString(“trans”);
String tgltr = set.getString(“tanggal”);
String nomin = set.getString(“nominal”);
String bunga = set.getString(“bunga”);
String keter = set.getString(“keterangan”);
int nomix = Integer.parseInt(nomin);
//String[] data = {kode, trans, tgltr, nomin, bunga,keter};
Object[] data = {kode, trans, tgltr, nomin, bunga, keter};
tabMode.addRow(data);
}
stat.close();
}
catch (Exception e) {}
}

public void hapusTabel() {
int row = tabMode.getRowCount();
for (int i = 0; i < row; i++) {
tabMode.removeRow(0);
}
}

public void tampilsisaPinjaman() {
hapusTabeltampilsisaPinjaman();
int sisa1x = 0;
int pinjam = 0;
int baliki = 0;
int totaling = 0;
String sql1 = “select a.kode, a.nama, sum(b.nominal) as totalpinjam from data_anggota as a, data_trans as b “+
“where a.kode=b.kode and b.trans=’03.Pinjaman Anggota’ group by a.kode”;
try {
Statement stat1 = konek.createStatement();
ResultSet set1 = stat1.executeQuery(sql1);
while (set1.next()) {
String kodex1 = set1.getString(“kode”);
String namax1 = set1.getString(“nama”);
String nilaix1 = set1.getString(“totalpinjam”);
String nilaix2 = “0″;
pinjam = Integer.parseInt(nilaix1);
String sql2 = “select kode, sum(nominal) as totalbayar from data_trans where kode = ‘”+kodex1+
“‘ and trans=’04.Cicilan Pinjaman’ group by kode”;
try {
Statement stat2 = konek.createStatement();
ResultSet set2 = stat2.executeQuery(sql2);
baliki = 0;
while (set2.next()) {
nilaix2 = set2.getString(“totalbayar”);
baliki = Integer.parseInt(nilaix2);
}
} catch (Exception ex) {
}
sisa1x = pinjam – baliki;
totaling = totaling + sisa1x;
String[] data = {kodex1,namax1, Integer.toString(sisa1x)};
pinjam = 0;
baliki = 0;
tabModez.addRow(data);
}
Totalx19.setText(Integer.toString(totaling));
set1.close();
} catch (Exception e) {}
}

public void hapusTabeltampilsisaPinjaman() {
int row = tabModez.getRowCount();
for (int i = 0; i < row; i++) {
tabModez.removeRow(0);
}
}

public void tampilModalAnggota() {
hapusTabelModalAnggota();
String kodex2 = “”;
String kodex3 = “”;
int tmodal = 0;
int pokok = 0;
int tabung = 0;
int ambilx = 0;
int totalinx1 = 0;
int totalambil = 0;
String sql1 = “select a.kode, a.nama, sum(b.nominal) as modaldasar from data_anggota as a, data_trans as b “+
“where a.kode=b.kode and b.trans=’01.Tabungan Wajib’ group by a.kode”;
try {
Statement stat1 = konek.createStatement();
ResultSet set1 = stat1.executeQuery(sql1);
while (set1.next()) {
String kodex1 = set1.getString(“kode”);
String namax1 = set1.getString(“nama”);
String nilaix1 = set1.getString(“modaldasar”);
String nilaix2 = “0″;
String nilaix3 = “0″;
pokok = Integer.parseInt(nilaix1);

String sql2 = “select kode, sum(nominal) as tabunganx from data_trans where kode = ‘”+kodex1+
“‘ and trans=’02.Iuran Wajib Anggota’ group by kode”;
try {
Statement stat2 = konek.createStatement();
ResultSet set2 = stat2.executeQuery(sql2);
tabung = 0;
while (set2.next()) {
kodex2 = set2.getString(“kode”);
nilaix2 = set2.getString(“tabunganx”);
tabung = Integer.parseInt(nilaix2);
};
String sql3 = “select kode, sum(nominal) as ambilanx from data_trans where kode = ‘”+kodex1+
“‘ and trans=’05.Pengambilan Oleh Anggota’ group by kode”;
try {
Statement stat3 = konek.createStatement();
ResultSet set3 = stat3.executeQuery(sql3);
while (set3.next()) {
kodex3 = set3.getString(“kode”);
nilaix3 = set3.getString(“ambilanx”);
ambilx = Integer.parseInt(nilaix3);
}
set3.close();
} catch (SQLException sx) {
} //exc akhir
set2.close();
} catch (Exception ex) {
} //exc akhir
tmodal = pokok + tabung;
totalinx1 = totalinx1 + tmodal;
totalambil = totalambil + ambilx;
String[] data = {kodex1,namax1, Integer.toString(pokok), Integer.toString(tabung), Integer.toString(ambilx), Integer.toString(tmodal – ambilx)};
tabModer.addRow(data);
int totalmodaldasar = 0;
totalmodaldasar = totalinx1 – totalambil;
pokok = 0;
tabung = 0;
ambilx = 0;
tmodal = 0;
Totalx20.setText(Integer.toString(totalmodaldasar));
}
set1.close();
} catch (Exception e) {
} //exc akhir
}

public void hapusTabelModalAnggota() {
int row = tabModer.getRowCount();
for (int i = 0; i < row; i++) {
tabModer.removeRow(0);
}
}

public void tampilMutasiAllTabel() {
int nilai01 = 0;
int nilai02 = 0;
int nilai03 = 0;
int nilai04 = 0;
int nilai05 = 0;
int nilai06 = 0;
int nilai07 = 0;
int nilai08 = 0;
int nilai09 = 0;
int nilai0x = 0;
int nilaiA = 0;
int nilaiB = 0;
int nilaiC = 0;
int saldoakhir = 0;
int modaldasar = 0;
int bungpendlain = 0;
int piutangar = 0;
int pengeluaran = 0;
int nettoomzet = 0;
int saldobank = 0;
int danaall = 0;
hapusTabelx();
try {
String sql = “Select trans,sum(nominal) as totalix, sum(bunga) as bungaix from data_trans group by trans”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
String mutasiall = set.getString(“trans”);
String nominaall = set.getString(“totalix”);
String bungall = set.getString(“bungaix”);
String[] datax = {mutasiall,nominaall,bungall};
tabModex.addRow(datax);
if (mutasiall.equals(“01.Tabungan Wajib”)) {
nilai01 = Integer.parseInt(nominaall);
}
if (mutasiall.equals(“02.Iuran Wajib Anggota”)) {
nilai02 = Integer.parseInt(nominaall);
}
if (mutasiall.equals(“03.Pinjaman Anggota”)) {
nilai03 = Integer.parseInt(nominaall);
nilai0x = Integer.parseInt(bungall);
}
if (mutasiall.equals(“04.Cicilan Pinjaman”)) {
nilai04 = Integer.parseInt(nominaall);
}
if (mutasiall.equals(“05.Pengambilan Oleh Anggota”)) {
nilai05 = Integer.parseInt(nominaall);
}
if (mutasiall.equals(“06.Pembagian Hasil Usaha”)) {
nilai06 = Integer.parseInt(nominaall);
}
if (mutasiall.equals(“07.Pendapatan Bunga Bank”)) {
nilai07 = Integer.parseInt(nominaall);
}
if (mutasiall.equals(“08.Pendapatan Lain Lain”)) {
nilai08 = Integer.parseInt(nominaall);
}
if (mutasiall.equals(“09.Pengeluaran Lain Lain”)) {
nilai09 = Integer.parseInt(nominaall);
}
if (mutasiall.equals(“10.Setoran Ke Acct Bank”)) {
nilaiA = Integer.parseInt(nominaall);
}
if (mutasiall.equals(“11.Pengambilan Acct Bank”)) {
nilaiB = Integer.parseInt(nominaall);
}
if (mutasiall.equals(“12.Biaya Acct Bank”)) {
nilaiC = Integer.parseInt(nominaall);
}
}

// tampilkan perhitungan total
// 01+02+04-03-05-06+X+07+08-09
saldobank = (nilaiA – nilaiB – nilaiC + nilai07);
saldoakhir = (nilai01+nilai02+nilai04+nilai07+nilai08+nilai0x+nilaiB) – (nilai03+nilai05+nilai06+nilai09+nilaiA+nilaiC) ;
modaldasar = (nilai01 + nilai02 – nilai05);
bungpendlain = (nilai0x + nilai08);
piutangar = (nilai03 – nilai04);
pengeluaran = (nilai06 + nilai09 + nilaiC);
nettoomzet = (bungpendlain + nilai07) – pengeluaran;
danaall = (modaldasar + bungpendlain + nilai07);

Totalx05.setText(Integer.toString(saldoakhir));
Totalx11.setText(Integer.toString(modaldasar));
Totalx12.setText(Integer.toString(bungpendlain));
Totalx13.setText(Integer.toString(nilai07));
Totalx14.setText(Integer.toString(pengeluaran));
Totalx15.setText(Integer.toString(nettoomzet));
Totalx16.setText(Integer.toString(piutangar));
Totalx21.setText(Integer.toString(saldobank));
Totalx22.setText(Integer.toString(danaall));

stat.close();
}
catch (Exception e) {}
}

public void hapusTabelx() {
int row = tabModex.getRowCount();
for (int i = 0; i < row; i++) {
tabModex.removeRow(0);
}
}

void dapatData_keDetil_Tabel() {
hapusTabely();
int row = tabelx.getSelectedRow();
int subttl = 0;
int subttx = 0;
String trans = tabModex.getValueAt(row,0).toString();
String sql = “Select * from data_trans where trans = ‘”+trans+”‘ order by kode,tanggal”;;

if (trans.equals(“07.Pendapatan Bunga Bank”)) {
sql = “Select * from data_trans where trans = ‘”+trans+”‘ order by tanggal”;
} else {
if (trans.equals(“08.Pendapatan Lain Lain”)) {
sql = “Select * from data_trans where trans = ‘”+trans+”‘ order by tanggal”;
} else {
if (trans.equals(“09.Pengeluaran Lain Lain”)) {
sql = “Select * from data_trans where trans = ‘”+trans+”‘ order by tanggal”;
} else {
if (trans.equals(“10.Setoran Ke Acct Bank”)) {
sql = “Select * from data_trans where trans = ‘”+trans+”‘ order by tanggal”;
} else {
if (trans.equals(“11.Pengambilan Acct Bank”)) {
sql = “Select * from data_trans where trans = ‘”+trans+”‘ order by tanggal”;
} else {
if (trans.equals(“12.Biaya Acct Bank”)) {
sql = “Select * from data_trans where trans = ‘”+trans+”‘ order by tanggal”;
} else {
sql = “Select * from data_trans where trans = ‘”+trans+”‘ order by kode,tanggal”;;
}
}
}
}
}
}

try {
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
String kode = set.getString(“kode”);
String ketx = set.getString(“keterangan”);
String tgltr = set.getString(“tanggal”);
String nomin = set.getString(“nominal”);
String bunga = set.getString(“bunga”);
String[] data = {kode, tgltr, nomin, bunga, ketx};
tabModey.addRow(data);
subttl = subttl + Integer.parseInt(bunga);
subttx = subttx + Integer.parseInt(nomin);
}
stat.close();
Totalx17.setText(Integer.toString(subttl));
Totalx18.setText(Integer.toString(subttx));
tabely.setToolTipText(“Data Detail All “+trans);
} catch (SQLException se) {
}
}

public void hapusTabely() {
int row = tabModey.getRowCount();
for (int i = 0; i < row; i++) {
tabModey.removeRow(0);
}
}

void dapatData_dari_Tabel() {
int row = tabel.getSelectedRow();
// Mengambil data-data yang dipilih pada TABEL
String kodx = tabMode.getValueAt(row, 0).toString();
String sql = “select * from data_anggota where kode = ‘”+kodx+”‘”;
String nam = “”;
try {
PreparedStatement stat = konek.prepareStatement(sql);
ResultSet set = stat.executeQuery();
while (set.next()) {
nam = set.getString(“nama”);
dataNama.setText(nam);
}
if (nam.equalsIgnoreCase(“”)) {
dataKode.requestFocus();
}
dataTrans.requestFocus();
tampilDataKeTabel();
set.close();
} catch (Exception ie) {
}
String Nama = nam;
String Tran = tabMode.getValueAt(row, 1).toString();
String Tglx = tabMode.getValueAt(row, 2).toString();
String Nomi = tabMode.getValueAt(row, 3).toString();
String bung = tabMode.getValueAt(row, 4).toString();
String blns = Tglx.substring(5,7);
String nabl = “”;

if (blns.equals(“01″)) {
nabl = “Januari”;
};
if (blns.equals(“02″)) {
nabl = “Februari”;
};
if (blns.equals(“03″)) {
nabl = “Maret”;
};
if (blns.equals(“04″)) {
nabl = “April”;
};
if (blns.equals(“05″)) {
nabl = “Mei”;
};
if (blns.equals(“06″)) {
nabl = “Juni”;
};
if (blns.equals(“07″)) {
nabl = “Juli”;
};
if (blns.equals(“08″)) {
nabl = “Agustus”;
};
if (blns.equals(“09″)) {
nabl = “September”;
};
if (blns.equals(“10″)) {
nabl = “Oktober”;
};
if (blns.equals(“11″)) {
nabl = “November”;
};
if (blns.equals(“12″)) {
nabl = “Desember”;
};

//cek keterangan
String keterx = “”;
try {
String sqlket = “select * from data_trans where kode = ‘”+kodx+”‘ and tanggal = ‘”+Tglx+”‘ and trans = ‘”+Tran+”‘”;
Statement statket = konek.createStatement();
ResultSet setket = statket.executeQuery(sqlket);
while (setket.next()) {
keterx = setket.getString(“keterangan”);
}
setket.close();
} catch (Exception e) {
}

dataKode.setText(kodx);
dataNama.setText(Nama);
dataTrans.setSelectedItem(Tran);
data_tglx.setSelectedItem(Tglx.substring(8,10));
data_blnx.setSelectedItem(nabl);
data_thnx.setSelectedItem(Tglx.substring(0,4));
dataNomi.setText(Nomi);
dataBung.setText(bung);
dataKets.setText(keterx);
// Apabila data tidak dipilih
if (dataKode.getText().equals(“”)) {
updata.setEnabled(false);
dataKode.setEnabled(false);
dataNama.setEnabled(false);
dataTrans.setEnabled(false);
}
// Apabila data dipilih
else {
updata.setEnabled(true);
dataKode.setEnabled(false);
dataNama.setEnabled(false);
dataTrans.setEnabled(false);
dataNomi.requestFocus();
data_tglx.setEnabled(false);
data_blnx.setEnabled(false);
data_thnx.setEnabled(false);
simpan.setEnabled(false);
deleta.setEnabled(true);
}
}

public void tombol_simpan() {
String kodex = dataKode.getText();
String namax = dataNama.getText();
String tranx = String.valueOf(dataTrans.getSelectedItem());
String tglx1 = String.valueOf(data_tglx.getSelectedItem());
String blnx1 = String.valueOf(data_blnx.getSelectedItem());
String thnx1 = String.valueOf(data_thnx.getSelectedItem());
String nomix = dataNomi.getText();
String bungx = dataBung.getText();
String keter = dataKets.getText();
String blnx2 = “01″;
int itabwajib = Integer.parseInt(Totalx01.getText());
int isisapinj = Integer.parseInt(Totalx03.getText());
int imodaldas = Integer.parseInt(Totalx06.getText());

if (nomix.equalsIgnoreCase(“”)) {
dataNomi.setText(“0″);
nomix = “0″;
}
if (bungx.equalsIgnoreCase(“”)) {
dataBung.setText(“0″);
bungx = “0″;
}

if (blnx1.equals(“Januari”)) {
blnx2 = “01″;
};
if (blnx1.equals(“Februari”)) {
blnx2 = “02″;
};
if (blnx1.equals(“Maret”)) {
blnx2 = “03″;
};
if (blnx1.equals(“April”)) {
blnx2 = “04″;
};
if (blnx1.equals(“Mei”)) {
blnx2 = “05″;
};
if (blnx1.equals(“Juni”)) {
blnx2 = “06″;
};
if (blnx1.equals(“Juli”)) {
blnx2 = “07″;
};
if (blnx1.equals(“Agustus”)) {
blnx2 = “08″;
};
if (blnx1.equals(“September”)) {
blnx2 = “09″;
};
if (blnx1.equals(“Oktober”)) {
blnx2 = “10″;
};
if (blnx1.equals(“November”)) {
blnx2 = “11″;
};
if (blnx1.equals(“Desember”)) {
blnx2 = “12″;
};

//cek validasi kode anggota
boolean kode_ok = false;
boolean kode_bodong = false;
boolean nilai_ok = false;
boolean bunga_ok = true;
boolean simpwajib_ok = true;
boolean udahsetorwajib = true;
boolean batalcicil = true;
boolean batasambil = true;
boolean masihnunggak = true;
boolean tglsama_ok = true;
boolean okeaktif = false;
String kode1x = “”;
String tran1x = “”;
String nomwjb = “”;
String tglwjb = “”;
String tglsam = “”;
String nomisa = “0″;
String bungsa = “0″;
String bulanaktif = “”;
String tahunaktif = “”;
try {
String sql = “select * from data_anggota where kode = ‘”+dataKode.getText()+”‘”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
kode1x = set.getString(“kode”);
}
if (kode1x.equalsIgnoreCase(dataKode.getText())) {
kode_ok = true;
}
set.close();
} catch (SQLException sq) {
}
//cek nominal
if (Integer.parseInt(nomix) > 0 ) {
nilai_ok = true;
}
//cek nominal bunga
if (tranx.equalsIgnoreCase(“03.Pinjaman Anggota”)) {
if (Integer.parseInt(bungx) <= 0 ) {
bunga_ok = true;
}
}
//cek simpanan wajib hanya sekali saja, dan cek jika ada
try {
String sql = “select * from data_trans where kode = ‘”+dataKode.getText()+”‘ and trans = ‘01.Tabungan Wajib’”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
kode1x = set.getString(“kode”);
tran1x = set.getString(“trans”);
nomwjb = set.getString(“nominal”);
tglwjb = set.getString(“tanggal”);
}
if (kode1x.equalsIgnoreCase(dataKode.getText())) {
if (tranx.equalsIgnoreCase(tran1x)) {
simpwajib_ok = false;
}
}
set.close();
} catch (SQLException sq) {
}
//cekkode bodong
if ( kodex.equals(“”) ) {
kode_bodong = true;
}
//cek pembayaran Tabungan wajib
if (itabwajib <= 0 ) {
if (String.valueOf(dataTrans.getSelectedItem()).equals(“02.Iuran Wajib Anggota”)) {
udahsetorwajib = false;
}
}
//cek cicilan tidak bisa lebih dari sisa pinjaman
if (isisapinj < Integer.parseInt(dataNomi.getText())) {
if (String.valueOf(dataTrans.getSelectedItem()).equals(“04.Cicilan Pinjaman”)) {
batalcicil = false;
}
}
//cek pengambilan semua modal dasar
if (imodaldas < Integer.parseInt(dataNomi.getText())) {
if (String.valueOf(dataTrans.getSelectedItem()).equals(“05.Pengambilan Oleh Anggota”)) {
batasambil = false;
}
}
//jika batas ammbil oke tapi masih ada sisa cicilan
if (imodaldas >= Integer.parseInt(dataNomi.getText())) {
if (String.valueOf(dataTrans.getSelectedItem()).equals(“05.Pengambilan Oleh Anggota”)) {
if (isisapinj > 0 ) {
masihnunggak = false;
}
}
}
// cek validasi tanggal dan tahun
try {
String sql = “select * from data_master”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
bulanaktif = set.getString(“bulan”);
tahunaktif = set.getString(“tahun”);
}
set.close();
} catch (SQLException sq) {
}
//cek bulan tahun inputan
if (tahunaktif.equals(thnx1)) {
if (bulanaktif.equals(blnx2)) {
okeaktif = true;
}
}

if (kode_bodong == false ) {
if (kode_ok == true) {
if (nilai_ok == true) {
if (bunga_ok == true) {
if (simpwajib_ok == true) {
String tanggal_new = thnx1+”-”+blnx2+”-”+tglx1;
int ok = JOptionPane.showConfirmDialog(null,”Anda Yakin Input data berikut ini :\nDengan Kode = ‘” + kodex +”‘ “+namax+
” \nTransaksi = ‘”+tranx+”‘ \nTanggal = ‘”+tanggal_new+”‘ \nNominal Nilai = ‘”+nomix+”‘ \n”+
“Bunga = ‘”+bungx+”‘ \n”, “Konfirmasi Input Data “,JOptionPane.YES_NO_OPTION);
//all simpan prosess…..
if (ok == 0) {
//cek kode+tran+tanggal sama – jika ada batal
try {
String sql = “select * from data_trans where kode = ‘”+kodex+”‘ and trans =’”+tranx+”‘ and tanggal = ‘”+tanggal_new+”‘”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
tglsam = set.getString(“tanggal”);
nomisa = set.getString(“nominal”);
bungsa = set.getString(“bunga”);
}
if (tanggal_new.equalsIgnoreCase(tglsam)) {
tglsama_ok = false;
}
set.close();
} catch (SQLException sq) {
}
if ( tglsama_ok == true ) {
if ( udahsetorwajib == true ) {
if ( batalcicil == true ) {
if ( batasambil == true ) {
if ( masihnunggak == true ) {
if (okeaktif == true) {
try {
//String sql = “INSERT INTO data_trans (kode,trans,tanggal,nominal,bunga,keterangan) VALUES (‘”+kodex+”‘,’”+tranx+”‘,’”+
//tanggal_new+”‘,’”+Integer.parseInt(nomix)+”‘,’”+Integer.parseInt(bungx)+”‘,’”+keter+”‘)”;

String sql = “INSERT INTO data_trans (kode,trans,tanggal,nominal,bunga,keterangan) VALUES (?,?,?,?,?,?)”;
PreparedStatement stat = konek.prepareStatement(sql);
try {
stat.setString(1, kodex);
stat.setString(2, tranx);
stat.setString(3, tanggal_new);
stat.setString(4, nomix);
stat.setString(5, bungx);
stat.setString(6, keter);
stat.executeUpdate();
simpan.setEnabled(true);
updata.setEnabled(false);
deleta.setEnabled(false);
dataKode.requestFocus();
tampilDataKeTabel();
hitungTotal();
hitungSubTotal();
stat.close();
} catch (SQLException se) {
JOptionPane.showMessageDialog(null,”Gagal Insert Data !”);
dataKode.requestFocus();
}
} catch (Exception e) {
} //if terakhir
} else {
JOptionPane.showMessageDialog(null,”Bulan dan atau Tahun tidak Valid \nTidak Sesuai dengan Bulan & Tahun Berjalan !! \nBulan Aktif : “+bulanaktif+” \nTahun Aktif : “+tahunaktif+” !!”);
dataKode.requestFocus();
} //if terakhir
} else {
JOptionPane.showMessageDialog(null,”Batas Maksimum Pengambilan Sebesar Rp “+Integer.toString(imodaldas)+” !!!\nPengambilan sebesar Rp “+nomix+
” bisa dimbil \ntetapi masih punya tunggakan pinjaman sebesar Rp “+Integer.toString(isisapinj)+”\ndi batalkan !!!”);
dataKode.requestFocus();
}
//if terakhir
} else {
JOptionPane.showMessageDialog(null,”Batas Maksimum Pengambilan Sebesar Rp “+Integer.toString(imodaldas)+” !!!\nPengambilan sebesar Rp “+nomix+” terlalu besar \ndi batalkan !!!”);
dataKode.requestFocus();
}
//if teakhir
} else {
JOptionPane.showMessageDialog(null,”Cicilan Sebesar Rp “+nomix+” Lebih Besar dari Sisa Pinjaman “+Integer.toString(isisapinj)+” \nBatal Pembayaran Cicilan !!!”);
dataKode.requestFocus();
}
//if terakhir
} else {
JOptionPane.showMessageDialog(null,”Anggota tersebut belum Membayar 01.Tabungan Wajib !!”);
dataKode.requestFocus();
}
///if terakhir
} else {
JOptionPane.showMessageDialog(null,”Tanggal Tidak Boleh Sama dalam Mutasi Transaksi Sejenis ! \nAda Transaksi berikut ini :”+
“\nKode Anggota = ‘”+kodex+”‘ “+namax+” \nTransaksi = ‘”+tranx+”‘ \nNilai Nominal = ‘”+nomisa+”‘ \nBunga = ‘”+bungsa+”‘ \nTanggal = ‘”+tglsam+”‘”);
dataKode.requestFocus();
}
}

if ( ok != 0 ) {
JOptionPane.showMessageDialog(null,”Batal Simpan Input Data !!”);
dataKode.requestFocus();
}
} else {
JOptionPane.showMessageDialog(null,”Transaksi Simpanan Wajib untuk \nKode = ‘”+kodex+”‘ “+namax+” \nTanggal = “+
“‘”+tglwjb+”‘ \nNominal Nilai = ‘”+nomwjb+”‘ \nSudah ada dan di Wajib kan hanya sekali saja !!”);
dataKode.requestFocus();
}
} else {
JOptionPane.showMessageDialog(null,”Nilai Bunga lebih kecil atau sana dengan Nol !”);
dataBung.requestFocus();
}
} else {
JOptionPane.showMessageDialog(null,”Nilai Nominal lebih kecil atau sana dengan Nol !”);
dataNomi.requestFocus();
}
}
} else {
JOptionPane.showMessageDialog(null,”Kode Anggota Tidak Boleh Null / Kosong !”);
dataKode.requestFocus();
}
}

public void proses_rubahData() {
String kodex = dataKode.getText();
String namax = dataNama.getText();
String tranx = String.valueOf(dataTrans.getSelectedItem());
String tglx1 = String.valueOf(data_tglx.getSelectedItem());
String blnx1 = String.valueOf(data_blnx.getSelectedItem());
String thnx1 = String.valueOf(data_thnx.getSelectedItem());
String nomix = dataNomi.getText();
String bungx = dataBung.getText();
String keter = dataKets.getText();
String blnx2 = “01″;
int itabwajib = Integer.parseInt(Totalx01.getText());
int isisapinj = Integer.parseInt(Totalx03.getText());
int imodaldas = Integer.parseInt(Totalx06.getText());

if (blnx1.equals(“Januari”)) {
blnx2 = “01″;
};
if (blnx1.equals(“Februari”)) {
blnx2 = “02″;
};
if (blnx1.equals(“Maret”)) {
blnx2 = “03″;
};
if (blnx1.equals(“April”)) {
blnx2 = “04″;
};
if (blnx1.equals(“Mei”)) {
blnx2 = “05″;
};
if (blnx1.equals(“Juni”)) {
blnx2 = “06″;
};
if (blnx1.equals(“Juli”)) {
blnx2 = “07″;
};
if (blnx1.equals(“Agustus”)) {
blnx2 = “08″;
};
if (blnx1.equals(“September”)) {
blnx2 = “09″;
};
if (blnx1.equals(“Oktober”)) {
blnx2 = “10″;
};
if (blnx1.equals(“November”)) {
blnx2 = “11″;
};
if (blnx1.equals(“Desember”)) {
blnx2 = “12″;
};

boolean ambil_ok = true;
//ceking parameter
if (Integer.parseInt(dataNomi.getText()) > imodaldas) {
if (String.valueOf(dataTrans.getSelectedItem()).equals(“05.Pengambilan Oleh Anggota”)) {
ambil_ok = false;
}
}

String tanggal_new = thnx1+”-”+blnx2+”-”+tglx1;
//JOptionPane.showMessageDialog(null,tanggal_new,”Pesan”,JOptionPane.OK_OPTION);
int ok = JOptionPane.showConfirmDialog(null,”Anda Yakin Ingin Memodifikasi Data\nDengan Kode = ‘” + kodex +” “+namax+
“‘ \nTransaksi = ‘”+tranx+”‘ \nTanggal = ‘”+tanggal_new+”‘ \nNominal Nilai = ‘”+nomix+”‘ \nHanya Merubah Nominal !”,
“Konfirmasi Memodifikasi Data”,JOptionPane.YES_NO_OPTION);
if ( ok == 0 ) {
if ( ambil_ok == true ) {
try {
String sql =”UPDATE data_trans SET nominal = ?, bunga = ?, keterangan = ? WHERE kode = ‘” +kodex+ “‘”+
” AND tanggal = ‘”+tanggal_new+”‘ AND trans = ‘”+tranx+”‘”;
PreparedStatement stat = konek.prepareStatement(sql);
try {
stat.setString(1, nomix);
stat.setString(2, bungx);
stat.setString(3, keter);
stat.executeUpdate();
tampilDataKeTabel();
hitungSubTotal();
hitungTotal();
dataKode.setEnabled(true);
dataNama.setEnabled(true);
dataTrans.setEnabled(true);
data_tglx.setEnabled(true);
data_blnx.setEnabled(true);
data_thnx.setEnabled(true);
simpan.setEnabled(true);
updata.setEnabled(false);
deleta.setEnabled(false);
dataKode.requestFocus();
stat.close();
JOptionPane.showMessageDialog(null,”Update Sukses …!!”);
dataKode.requestFocus();
} catch (SQLException se) {
}
} catch (SQLException se) {
} //akhir proses update
} else {
JOptionPane.showMessageDialog(null,”Pengambilan Sebesar Rp “+nomix+” \nMelebihi Modal Dasar Anggota Rp “+
Integer.toString(imodaldas)+”\nTabungan Wajib + Iuran Wajib !! \nBatal Update !!”);
dataKode.requestFocus();
}
}
if ( ok != 0 ) {
tampilDataKeTabel();
hitungSubTotal();
hitungTotal();
dataKode.setEnabled(true);
dataNama.setEnabled(true);
dataTrans.setEnabled(true);
data_tglx.setEnabled(true);
data_blnx.setEnabled(true);
data_thnx.setEnabled(true);
simpan.setEnabled(true);
updata.setEnabled(false);
deleta.setEnabled(false);
dataNomi.setText(nomix);
dataBung.setText(bungx);
dataKode.requestFocus();
JOptionPane.showMessageDialog(null,”Batal Update…!!”);
dataKode.requestFocus();
}

}

public void hitungSubTotal() {
String kodex = dataKode.getText();
String tranx = String.valueOf(dataTrans.getSelectedItem());
String subtotal = “0″;
Totalx04.setText(subtotal);
try {
String sql = “select sum(nominal) as tt1 from data_trans where kode = ‘”+kodex+”‘ and trans = ‘”+tranx+”‘”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
subtotal = set.getString(“tt1″);
}
Totalx04.setText(subtotal);
stat.close();
} catch (Exception e) {
}
}

public void hitungTotal() {
String kodex = dataKode.getText();
String total1 = “0″;
String total2 = “0″;
String total3 = “0″;
String ttl3a = “0″;
String ttl3b = “0″;
String ttl3c = “0″;
String ttl3d = “0″;
int totalin = 0;
int nilaiA = 0;
int nilaiB = 0;
int nilaiC = 0;
int nilaiD = 0;
int nilaiE = 0;
int nilaiF = 0;
Totalx01.setText(“0″);
Totalx02.setText(“0″);
Totalx03.setText(“0″);
//Totalx01
try {
String sql = “select sum(nominal) as tt1 from data_trans where kode = ‘”+kodex+”‘ and trans = ‘01.Tabungan Wajib’”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
total1 = set.getString(“tt1″);
nilaiA = Integer.parseInt(total1);
}
Totalx01.setText(total1);
stat.close();
} catch (Exception e) {
}
//Totalx02
try {
String sql = “select sum(nominal) as tt2 from data_trans where kode = ‘”+kodex+”‘ and trans = ‘02.Iuran Wajib Anggota’”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
total2 = set.getString(“tt2″);
nilaiB = Integer.parseInt(total2);
}
Totalx02.setText(total2);
stat.close();
} catch (Exception e) {
}
//Totalx03
try {
String sql = “select sum(nominal) as tt3a from data_trans where kode = ‘”+kodex+”‘ and trans = ‘03.Pinjaman Anggota’”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
ttl3a = set.getString(“tt3a”);
nilaiC = Integer.parseInt(ttl3a);
}
stat.close();
} catch (Exception e) {
}
try {
String sql = “select sum(nominal) as tt3b from data_trans where kode = ‘”+kodex+”‘ and trans = ‘04.Cicilan Pinjaman’”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
ttl3b = set.getString(“tt3b”);
nilaiD = Integer.parseInt(ttl3b);
}
stat.close();
} catch (Exception e) {
}
try {
String sql = “select sum(nominal) as tt3c from data_trans where kode = ‘”+kodex+”‘ and trans = ‘05.Pengambilan Oleh Anggota’”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
ttl3c = set.getString(“tt3c”);
nilaiE = Integer.parseInt(ttl3c);
}
stat.close();
} catch (Exception e) {
}
try {
String sql = “select sum(nominal) as tt3d from data_trans where kode = ‘”+kodex+”‘ and trans = ‘06.Pembagian Hasil Usaha’”;
Statement stat = konek.createStatement();
ResultSet set = stat.executeQuery(sql);
while (set.next()) {
ttl3d = set.getString(“tt3d”);
nilaiF = Integer.parseInt(ttl3d);
}
stat.close();
} catch (Exception e) {
}

//perhitungan totalin – sisa pinjaman
totalin = nilaiC – nilaiD;

total3 = Integer.toString(totalin);
Totalx03.setText(total3);

int iwajibx = nilaiA + nilaiB;
Totalx06.setText(Integer.toString(iwajibx));

int NetSaldo = iwajibx – totalin;
Totalx07.setText(Integer.toString(NetSaldo));

Totalx08.setText(Integer.toString(nilaiE));
Totalx09.setText(Integer.toString(nilaiF));

int NetSaldoAkhir = NetSaldo – nilaiE – nilaiF;
jLabel17.setText(“E.Netto(B-C-D): “+dataNama.getText());
Totalx10.setText(Integer.toString(NetSaldoAkhir));

if (totalin > 0) {
JOptionPane.showMessageDialog(null,”Ada Pinjaman Rp. “+Integer.toString(totalin)+” Belum Lunas !”);
}
tampilMutasiAllTabel();
tampilsisaPinjaman();
tampilModalAnggota();
}

public void dataKode_keyPressed(KeyEvent e) {
int ascii = e.getKeyCode();
//String msx = String.valueOf(ascii);
//JOptionPane.showMessageDialog(null,”ASCII Kode “+msx,”Pesan”,JOptionPane.OK_OPTION);
if (ascii == 10) {
if (dataKode.getText().equalsIgnoreCase(“”)) {
JOptionPane.showMessageDialog(null,”Kode Nomor Anggota tersebut tidak ada !”,”Pesan”,JOptionPane.OK_OPTION);
}
else {
String kodx = dataKode.getText();
String sql = “select * from data_anggota where kode = ‘”+kodx+”‘”;
String nam = “”;
try {
PreparedStatement stat = konek.prepareStatement(sql);
ResultSet set = stat.executeQuery();
while (set.next()) {
nam = set.getString(“nama”);
dataNama.setText(nam);
}
if (nam.equalsIgnoreCase(“”)) {
JOptionPane.showMessageDialog(null,”Kode Anggota tidak di temukan !”,”Pesan”,JOptionPane.OK_OPTION);
tampilDataKeTabel();
hitungTotal();
hitungSubTotal();
dataKode.setEditable(true);
dataKode.requestFocus();
dataNomi.setText(“0″);
dataBung.setText(“0″);
} else {
tampilDataKeTabel();
hitungTotal();
hitungSubTotal();
dataTrans.requestFocus();
dataNomi.setText(“0″);
dataBung.setText(“0″);
}
set.close();
} catch (Exception ie) {
}
}
}
}

public String getData(String key) {
String value = null;
try {
value = getResourceBundle().getString(key);
}
catch (MissingResourceException e) {
System.out.println(e + ” : Couldn’t find value for: ” + key);
}
return value;
}

public ResourceBundle getResourceBundle() {
ResourceBundle bundle = null;
if (bundle == null) {
bundle = ResourceBundle.getBundle(“babx.data_koneksiDatabase”);
}
return bundle;
}

class batasiInput {
byte length;
PlainDocument filter;
public batasiInput(byte length) {
this.length = length;
}

public PlainDocument getFilter() {
filter = new javax.swing.text.PlainDocument() {
public void insertString(int offs, String str, AttributeSet a) throws
BadLocationException {
int ab = dataKode.getText().length();
if (ab < length) {
super.insertString(offs, str, a);
}
}
};
return filter;
}
}

class onlyDigit {
public onlyDigit() {
}

public PlainDocument getOnlyDigit() {
PlainDocument filterDigit = new PlainDocument() {
public void insertString(int offs, String str, AttributeSet a) throws
BadLocationException {
StringBuffer buffer = new StringBuffer();
int s = 0;
char[] dataInput = str.toCharArray();
// Memeriksa semua data yang dimasukkan
for (int i = 0; i < dataInput.length; i++) {
// Menyaring Apakah data masukkan berupa DIGIT ??
boolean isOnlyDigit = Character.isDigit(dataInput[i]);
if (isOnlyDigit == true) {
dataInput[s] = dataInput[i];
s++;
}
}
buffer.append(dataInput, 0, s);
super.insertString(offs, new String(buffer), a);
}
};
return filterDigit;
}
}
}