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("");
    }