Januari 2020 ~ CoolWolf Entertainment

Program Ini di peruntukkan untuk memenuhi tugas Pemrograman II yang di bimbing oleh Bapak Agus Suharto di STMIK Eresha tahun ajaran 2019/2020.

Foto Kertas Ujian

Penjelasan Program

Program berikut ialah program yang memungkinkan user untuk memesan jasa Laundry dengan mudah. terdapat sistem login dan sistem database menggunakan database MariaDB Mysql lebih tepatnya. User dapat memesan dengan alamat default maupun alamat costum. Dan pesanan akan tersimpan pada database dan akan di tampilkan sesuai user masing - masing. Dan user dapat mengecek Apa saja yang telah ia pesan. Dan pada versi terbaru, terdapat Previlege admin yang dapat mengecek, update pesanan, dan topup saldo. dan terdapat logic yang menampung exception seperti jika saldo user kurang dari harga pesanan, tidak bisa pesan. Pembenahan system login (kemarin ada bug ternyata :D). dan masih banyak lagi. dan juga admin dapat merubah status pesanan/order. dan ketika order sudah sampai ke status "selesai". maka, pesanan dengan idorder yang sama akan di hapus dan di pindahkan ke tabel transaksi (tujuannya seperti history pesanan). Maaf bila masih kurang jelas penjelasannya :D

ScreenShoot Program

diawali oleh splas screen animation

Kemudian Menu Awal / main menunya

user bisa mulai dengan register akun.

lalu user bisa meminta admin untuk topup saldo miliknya (disini saya login admin)

Tampilan adminMain.

admin bisa menginput id user dan nominal yang akan di topup

Selanjutnya user dapat mengecek saldonya dengan login ke app.

Tampilan MainMenu User. user selanjutnya dapat membuat order.

dan user dapat membuat pesanan. (di screenshot saya tampilkan worst case bila saldo kurang)

Selanjutnya user dapat memeriksa pesanan berdasarkan idpesanannya.

pesanan tersebut akan ke database tabel pesanan dengan status default "Mengambil", yang kalau di dunia nyata driver akan mengambil landry ke alamat user.

lalu admin dapat mengubah status pesanan.

dan bila status sudah mencapai akhir yaitu status "Selesai" maka pesanan di tabel pesanan akan di hapus dan di pindah ke dalam tabel transaksi.

Source Code

Code untuk buat Mysql database

-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 08, 2020 at 01:46 AM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.2.26

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `coollaundry2`
--

-- --------------------------------------------------------

--
-- Table structure for table `akun`
--

CREATE TABLE `akun` (
  `IdAkun` varchar(20) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `pass` varchar(50) NOT NULL,
  `email` varchar(200) NOT NULL,
  `jenkel` varchar(10) NOT NULL,
  `alamat` varchar(220) DEFAULT NULL,
  `nope` varchar(20) NOT NULL,
  `saldo` int(20) DEFAULT 0,
  `privilege` varchar(30) DEFAULT 'user'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `akun`
--

INSERT INTO `akun` (`IdAkun`, `nama`, `pass`, `email`, `jenkel`, `alamat`, `nope`, `saldo`, `privilege`) VALUES
('000001', 'husencoolwolf', 'admin', 'husencoolwolf@gmail.com', 'Laki-Laki', NULL, '08777111222', 0, 'admin'),
('154192355124569', 'coolwolf', 'husencool', 'coolwolfentertainment@gmail.com', 'Laki-Laki', 'jl. Merpati Raya no.161', '+62 87771236822', 22000, 'user'),
('328297593997367', 'zahra', 'zahracantik', 'zahra@gmail.com', 'Perempuan', 'jl jl', '+62 8777232323', 0, 'user'),
('828256142311714', 'ahmad', '123', 'ahmad@yahoo.com', 'Laki-Laki', 'jl. kemangi', '+62 20202020', 6000, 'user'),
('887558568479957', 'kiki', '123', 'kiki@gmail.com', 'Laki-Laki', 'denpasar', '+62 888888', 6000, 'user');

-- --------------------------------------------------------

--
-- Table structure for table `cabang`
--

CREATE TABLE `cabang` (
  `IdCabang` varchar(5) NOT NULL,
  `nmCabang` varchar(100) NOT NULL,
  `alamatCabang` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cabang`
--

INSERT INTO `cabang` (`IdCabang`, `nmCabang`, `alamatCabang`) VALUES
('TGS01', 'Ciputat', 'Jl.Kampung Utan no.16');

-- --------------------------------------------------------

--
-- Table structure for table `pesanan`
--

CREATE TABLE `pesanan` (
  `IdOrder` varchar(20) NOT NULL,
  `cabang` varchar(50) NOT NULL,
  `paket` varchar(200) NOT NULL,
  `alamat` varchar(250) NOT NULL,
  `stat` varchar(20) NOT NULL DEFAULT 'Mengambil',
  `harga` int(100) NOT NULL,
  `akun_IdAkun` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `transaksi`
--

CREATE TABLE `transaksi` (
  `IdTransaksi` varchar(50) NOT NULL,
  `pesanan_IdOrder` varchar(20) NOT NULL,
  `akun_nama` varchar(100) NOT NULL,
  `akun_IdAkun` varchar(20) NOT NULL,
  `cabang_nmCabang` varchar(100) NOT NULL,
  `pesanan_harga` int(100) NOT NULL,
  `wktTransaksi` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transaksi`
--

INSERT INTO `transaksi` (`IdTransaksi`, `pesanan_IdOrder`, `akun_nama`, `akun_IdAkun`, `cabang_nmCabang`, `pesanan_harga`, `wktTransaksi`) VALUES
('168961856244181154192355124569', '168961856244181', 'coolwolf', '154192355124569', 'Ciputat', 14000, '2020-01-07 23:56:38'),
('172342579838291887558568479957', '172342579838291', 'kiki', '887558568479957', 'Ciputat', 14000, '2020-01-08 00:03:58'),
('478916675464822828256142311714', '478916675464822', 'ahmad', '828256142311714', 'Ciputat', 14000, '2020-01-08 00:16:24');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `akun`
--
ALTER TABLE `akun`
  ADD PRIMARY KEY (`IdAkun`,`nama`);

--
-- Indexes for table `cabang`
--
ALTER TABLE `cabang`
  ADD PRIMARY KEY (`IdCabang`);

--
-- Indexes for table `pesanan`
--
ALTER TABLE `pesanan`
  ADD PRIMARY KEY (`IdOrder`),
  ADD KEY `pesanan_FKakun` (`akun_IdAkun`);

--
-- Indexes for table `transaksi`
--
ALTER TABLE `transaksi`
  ADD PRIMARY KEY (`IdTransaksi`),
  ADD KEY `transaksi_FKakun` (`akun_IdAkun`,`akun_nama`),
  ADD KEY `transaksi_FKpesanan` (`pesanan_IdOrder`,`pesanan_harga`) USING BTREE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

DBConnect.java

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package utspemrogramanii;

import java.sql.*;
import java.util.ArrayList;
import javax.swing.JOptionPane;
import static javax.swing.JOptionPane.ERROR_MESSAGE;

/**
 *
 * @author CoolWolf
 */
public class DBConnect {
    //Mysql Connector

private Connection con;
    private Statement st;
    private ResultSet rs;
    
    public DBConnect(){
        try{
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/coolLaundry2" ,"root","");
            st = con.createStatement();
        }//catch connection error
        catch(SQLException e){
            JOptionPane.showMessageDialog(null, "Database / Koneksi berada dalam masalah! Silahkan Periksa Sistem Database Anda!", "Error!", ERROR_MESSAGE);
        }catch(Exception ex){
           JOptionPane.showMessageDialog(null, "Error : "+ex, "Error!", ERROR_MESSAGE);
        }
        
    }
    
    public String getAlamat(String user){
        String alamat="";
        try{
            String query = "select alamat from akun where nama='"+user+"';";
            rs = st.executeQuery(query);
            while(rs.next()){
                alamat = rs.getString("alamat");
            }
        }catch(Exception ex){
            System.out.println(ex);
        }
        return alamat;
    }
    
    public String[] getCabang(){
        ArrayList<string> cabang = new ArrayList<string>();
        try{
            String query = "select nmCabang from cabang;";
            rs = st.executeQuery(query);
            while(rs.next()){
                String a =rs.getString("nmCabang");
                cabang.add(a);
            }
        }catch(Exception ex){
            System.out.println(ex);
        }
        String[] nmCabang = new String[cabang.size()];
        nmCabang = cabang.toArray(nmCabang);
        return nmCabang;
    }
    
    public String getUserID(String user){
        String id="";
        try{
            String query = "select IdAkun from akun where nama='"+user+"';";
            rs = st.executeQuery(query);
            while(rs.next()){
                id = rs.getString("IdAkun");
            }
        }catch(Exception ex){
            System.out.println(ex);
        }
        return id;
    }
    
    public String getUserName(String id){
        String name="";
        try{
            String query = "select nama from akun where IdAkun='"+id+"';";
            rs = st.executeQuery(query);
            while(rs.next()){
                name = rs.getString("nama");
            }
        }catch(Exception ex){
            System.out.println(ex);
        }
        return name;
    }
   
    
    public String[] getDetailPesanan(String idAkun, String OrderId){
        ArrayList<string> detail = new ArrayList<string>();
        try{
            String query = "select * from pesanan where IdOrder='"+OrderId+"' and akun_IdAkun='"+idAkun+"';";
            rs = st.executeQuery(query);
            while(rs.next()){
                String IdAkun =rs.getString("akun_IdAkun");
                String IdOrder = rs.getString("IdOrder");
                String cabang = rs.getString("cabang");
                String pesan = rs.getString("paket");
                String alamat = rs.getString("alamat");
                String harga = rs.getString("harga");
                String status = rs.getString("stat");
                detail.add(IdAkun);
                detail.add(IdOrder);
                detail.add(cabang);
                detail.add(pesan);
                detail.add(alamat);
                detail.add(harga);
                detail.add(status);

}
        }catch(Exception ex){
            System.out.println(ex);
        }
        String[] detailz = new String[detail.size()];
        detailz = detail.toArray(detailz);
        return detailz;
    }
    
    public String[] getIdOrder(String user){
        ArrayList<string> pesan = new ArrayList<string>();
        String id = getUserID(user);
        try{
            String query = "select IdOrder from pesanan where akun_IdAkun='"+id+"';";
            rs = st.executeQuery(query);
            while(rs.next()){
                String a =rs.getString("IdOrder");
                pesan.add(a);
            }
        }catch(Exception ex){
            System.out.println(ex);
        }
        String[] order = new String[pesan.size()];
        order = pesan.toArray(order);
        return order;
    }
    
    public String[] getIdOrderAdm(String id){
        ArrayList<string> pesan = new ArrayList<string>();
        try{
            String query = "select IdOrder from pesanan where akun_IdAkun='"+id+"';";
            rs = st.executeQuery(query);
            while(rs.next()){
                String a =rs.getString("IdOrder");
                pesan.add(a);
            }
        }catch(Exception ex){
            System.out.println(ex);
        }
        String[] order = new String[pesan.size()];
        order = pesan.toArray(order);
        return order;
    }
    
    public String[] getPesanan(String user){
        ArrayList<string> pesan = new ArrayList<string>();
        String id = getUserID(user);
        try{
            String query = "select paket from pesanan where akun_IdAkun='"+id+"';";
            rs = st.executeQuery(query);
            int i=1;
            while(rs.next()){
                String a =rs.getString("paket");
                pesan.add(a);
                i++;
            }
        }catch(Exception ex){
            System.out.println(ex);
        }
        String[] order = new String[pesan.size()];
        order = pesan.toArray(order);
        return order;
    }
    
    public Boolean ValidateRegId(String x, String y){
        try{
            ArrayList id = new ArrayList();
            ArrayList nama = new ArrayList();
            String query = "select IdAkun, nama from akun";
            rs = st.executeQuery(query);
            System.out.println("checking...");
            int j=0;
            int a=0;
            while(rs.next()){
                String nomor = rs.getString("IdAkun");
                String name = rs.getString("nama");
                id.add(nomor);
                nama.add(name);
                j++;
                a++;
                }
            Boolean ckid = id.contains(x);
            Boolean cknama = nama.contains(y);
            if ((ckid==true) || (cknama==true)){
                    return true;
                }
            }
            catch(Exception ex){
            System.err.println(ex);
        }
        return false;
    }
    
    
    public String getPrivilege(String user){
        String privilege="";
        String id = getUserID(user);
        try{
            String query = "select privilege from akun where IdAkun='"+id+"';";
            rs = st.executeQuery(query);
            while(rs.next()){
                privilege = rs.getString("privilege");
            }
        }catch(Exception ex){
            System.out.println(ex);
        }
        return privilege;
    }
    
    public Boolean ValidateLogin(String x, String y){
        try{
            ArrayList nama = new ArrayList();
            ArrayList pass = new ArrayList();
            String query = "select nama, pass from akun";
            rs = st.executeQuery(query);
            System.out.println("checking...");
            while(rs.next()){
                String name = rs.getString("nama");
                String pw = rs.getString("pass");
                nama.add(name);
                pass.add(pw);
                }
            Boolean cknama = nama.contains(x);
            //Boolean ckpass = pass.contains(y);
            if ((cknama==true)){
                    int id = nama.indexOf(x);
                    if(pass.indexOf(y)==id){
                        return true;
                    }
                }
            }        
            catch(Exception ex){
            JOptionPane.showMessageDialog(null, "Error : "+ex, "Error!", ERROR_MESSAGE);;
            }
            
        return false;
    }
    
    public Boolean ValidateID(String x){
        try{
            ArrayList nama = new ArrayList();
            
            String query = "select IdAkun from akun";
            rs = st.executeQuery(query);
            
            while(rs.next()){
                String name = rs.getString("IdAkun");
                nama.add(name);
                }
            Boolean cknama = nama.contains(x);
            //Boolean ckpass = pass.contains(y);
            if ((cknama==true)){
                    return true;
                }
            }        
            catch(Exception ex){
            JOptionPane.showMessageDialog(null, "Error : "+ex, "Error!", ERROR_MESSAGE);;
            }
            
        return false;
    }
    
    public void InsertRegistrasi(String query){
            try{
                int a = st.executeUpdate(query);
            }catch(Exception ex){
                System.out.println(ex + " Insert Gagal!");
            }
    }
    
    public int getSaldo(String user){
        int saldo=0;
        String id = getUserID(user);
        try{
            String query = "select saldo from akun where IdAkun='"+id+"';";
            rs = st.executeQuery(query);
            while(rs.next()){
                saldo = rs.getInt("saldo");
            }
        }catch(Exception ex){
            System.out.println(ex);
        }
        return saldo;
    }
    
    public void getData(){
        try{
            String query = "select * from orang";
            rs = st.executeQuery(query);
            System.out.println("Hasil dari Database");
            while(rs.next()){
                String name = rs.getString("nama");
                String age = rs.getString("umur");
                System.out.println("Nama : "+name+" "+"Umur : "+ age);
            }
        }catch(Exception ex){
            System.out.println(ex);
        }
    }
    
}

Splash.java

import java.awt.*;
import java.awt.Image;
import javafx.scene.layout.Border;
import javax.swing.ImageIcon;
import javax.swing.UIManager;
import javax.swing.plaf.basic.BasicProgressBarUI;

/**
 *
 * @author CoolWolf
 */
public class Splash extends javax.swing.JFrame {

/**
     * Creates new form Load
     */
    public Splash() {
        initComponents();
        loadBar.setUI(new BasicProgressBarUI(){
            
        });
        
    }

/**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

Loading = new javax.swing.JPanel();
        loadString = new javax.swing.JLabel();
        loadBar = new javax.swing.JProgressBar();
        loadIcon = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setUndecorated(true);
        addWindowListener(new java.awt.event.WindowAdapter() {
            public void windowActivated(java.awt.event.WindowEvent evt) {
                formWindowActivated(evt);
            }
        });
        getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

Loading.setBackground(new java.awt.Color(255, 255, 255));
        Loading.addComponentListener(new java.awt.event.ComponentAdapter() {
            public void componentShown(java.awt.event.ComponentEvent evt) {
                LoadingComponentShown(evt);
            }
        });
        Loading.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

loadString.setFont(new java.awt.Font("SimSun", 1, 18)); // NOI18N
        loadString.setText("0%");
        Loading.add(loadString, new org.netbeans.lib.awtextra.AbsoluteConstraints(280, 500, 30, 30));

loadBar.setBackground(new java.awt.Color(255, 255, 255));
        loadBar.setForeground(new java.awt.Color(51, 102, 255));
        loadBar.setBorderPainted(false);
        loadBar.setFocusable(false);
        loadBar.setRequestFocusEnabled(false);
        loadBar.setVerifyInputWhenFocusTarget(false);
        Loading.add(loadBar, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 560, 560, -1));

loadIcon.setIcon(new javax.swing.ImageIcon(getClass().getResource("/utspemrogramanii/icon/11.gif"))); // NOI18N
        Loading.add(loadIcon, new org.netbeans.lib.awtextra.AbsoluteConstraints(240, 500, 30, 30));

jPanel1.setBackground(new java.awt.Color(102, 102, 102));
        Loading.add(jPanel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 540, 600, 60));

jLabel1.setIcon(new javax.swing.ImageIcon(new javax.swing.ImageIcon(getClass().getResource("/utspemrogramanii/image/cashier.png")).getImage().getScaledInstance(520,200, Image.SCALE_SMOOTH)));
        Loading.add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 170, 520, 200));

getContentPane().add(Loading, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 600, 600));

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

private void LoadingComponentShown(java.awt.event.ComponentEvent evt) {                                       
        
    }

private void formWindowActivated(java.awt.event.WindowEvent evt) {                                     
        
        
    }

/**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(Splash.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(Splash.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(Splash.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(Splash.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>
        //</editor-fold>

/* Create and display the form */
        Splash s = new Splash();
        s.setVisible(true);
        
        try{
            int i=0;
            int j=0;
            do{
                Thread.sleep(50);
                s.loadBar.setValue(i);
                s.loadString.setText(Integer.toString(i)+"%");
                i++;
            }while (i<=100);

}catch(Exception e){
            System.out.println(e);
        }
        
        try{
            Thread.sleep(2000);
        }catch(Exception e){
            System.out.println(e);
        }
        
        CoolLaundry cl = new CoolLaundry();
        s.setVisible(false); 
        cl.setVisible(true);

}

// Variables declaration - do not modify                     
    private javax.swing.JPanel Loading;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JProgressBar loadBar;
    private javax.swing.JLabel loadIcon;
    private javax.swing.JLabel loadString;
    // End of variables declaration                   
}

CoolLaundry.java

import java.awt.*;
import javax.swing.ImageIcon;

/**
 *
 * @author CoolWolf
 */
public class MainProgram extends javax.swing.JFrame {
    static String CurrentUser = "Guest";
    /**
     * Creates new form MainProgram
     */
    public MainProgram() {
        initComponents();
        this.setResizable(false);
    }
    
    public void setWelcome(){
        this.MainProgramWelcome.setText("Welcome "+CurrentUser);
    }
    
    public void setSaldo(String a){
        this.SaldoL.setText(a);
    }
    
    public void setCurrentUser(String nama){
        CurrentUser = nama;
    }
    
    public static String getCurrentUser(){
        String a = CurrentUser;
        return a;
    }

jPanel1 = new javax.swing.JPanel();
        headerPanel = new javax.swing.JPanel();
        logoLableMainProgram = new javax.swing.JLabel();
        MainProgramWelcome = new javax.swing.JLabel();
        SaldoRpL = new javax.swing.JLabel();
        SaldoL = new javax.swing.JLabel();
        OrderBtnPnl = new javax.swing.JPanel();
        imageOrder = new javax.swing.JLabel();
        OrderBtnLabel = new javax.swing.JLabel();
        OrderListBtnPnl = new javax.swing.JPanel();
        imageOrderList = new javax.swing.JLabel();
        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        MainMenuExitBtn = new javax.swing.JButton();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setFocusable(false);
        setSize(new java.awt.Dimension(800, 800));
        addWindowListener(new java.awt.event.WindowAdapter() {
            public void windowActivated(java.awt.event.WindowEvent evt) {
                formWindowActivated(evt);
            }
        });

jPanel1.setBackground(new java.awt.Color(255, 255, 255));

headerPanel.setBackground(new java.awt.Color(102, 102, 255));
        headerPanel.setForeground(new java.awt.Color(51, 0, 255));

logoLableMainProgram.setFont(new java.awt.Font("Trajan Pro", 3, 18)); // NOI18N
        logoLableMainProgram.setForeground(new java.awt.Color(0, 0, 153));
        logoLableMainProgram.setText("Cool Laundry");

MainProgramWelcome.setFont(new java.awt.Font("Trebuchet MS", 1, 18)); // NOI18N
        MainProgramWelcome.setText("Welcome");

SaldoRpL.setFont(new java.awt.Font("Simplified Arabic", 1, 18)); // NOI18N
        SaldoRpL.setText("Rp.");

SaldoL.setFont(new java.awt.Font("Simplified Arabic", 1, 18)); // NOI18N
        SaldoL.setText("-");

javax.swing.GroupLayout headerPanelLayout = new javax.swing.GroupLayout(headerPanel);
        headerPanel.setLayout(headerPanelLayout);
        headerPanelLayout.setHorizontalGroup(
            headerPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(headerPanelLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(headerPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(MainProgramWelcome, javax.swing.GroupLayout.PREFERRED_SIZE, 371, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(headerPanelLayout.createSequentialGroup()
                        .addComponent(SaldoRpL)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(SaldoL, javax.swing.GroupLayout.PREFERRED_SIZE, 103, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 123, Short.MAX_VALUE)
                .addComponent(logoLableMainProgram, javax.swing.GroupLayout.PREFERRED_SIZE, 176, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );
        headerPanelLayout.setVerticalGroup(
            headerPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(headerPanelLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(headerPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(logoLableMainProgram, javax.swing.GroupLayout.PREFERRED_SIZE, 55, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(headerPanelLayout.createSequentialGroup()
                        .addComponent(MainProgramWelcome)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(headerPanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(SaldoRpL)
                            .addComponent(SaldoL))))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

OrderBtnPnl.setBackground(new java.awt.Color(153, 153, 153));
        OrderBtnPnl.setBorder(javax.swing.BorderFactory.createEtchedBorder());
        OrderBtnPnl.setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
        OrderBtnPnl.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                OrderBtnPnlMouseClicked(evt);
            }
        });

imageOrder.setIcon(new javax.swing.ImageIcon(new javax.swing.ImageIcon(getClass().getResource("/utspemrogramanii/image/wash.png")).getImage().getScaledInstance(74,74, Image.SCALE_SMOOTH)));

OrderBtnLabel.setFont(new java.awt.Font("Gill Sans Ultra Bold Condensed", 1, 18)); // NOI18N
        OrderBtnLabel.setText("Order");

javax.swing.GroupLayout OrderBtnPnlLayout = new javax.swing.GroupLayout(OrderBtnPnl);
        OrderBtnPnl.setLayout(OrderBtnPnlLayout);
        OrderBtnPnlLayout.setHorizontalGroup(
            OrderBtnPnlLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(OrderBtnPnlLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(imageOrder, javax.swing.GroupLayout.PREFERRED_SIZE, 74, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 35, Short.MAX_VALUE)
                .addComponent(OrderBtnLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(22, 22, 22))
        );
        OrderBtnPnlLayout.setVerticalGroup(
            OrderBtnPnlLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(OrderBtnPnlLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(imageOrder, javax.swing.GroupLayout.DEFAULT_SIZE, 74, Short.MAX_VALUE)
                .addContainerGap())
            .addGroup(OrderBtnPnlLayout.createSequentialGroup()
                .addGap(35, 35, 35)
                .addComponent(OrderBtnLabel, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

OrderListBtnPnl.setBackground(new java.awt.Color(153, 153, 153));
        OrderListBtnPnl.setBorder(javax.swing.BorderFactory.createEtchedBorder());
        OrderListBtnPnl.setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
        OrderListBtnPnl.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                OrderListBtnPnlMouseClicked(evt);
            }
        });

imageOrderList.setIcon(new javax.swing.ImageIcon(new javax.swing.ImageIcon(getClass().getResource("/utspemrogramanii/image/orders.png")).getImage().getScaledInstance(74,74, Image.SCALE_SMOOTH)));

jLabel1.setFont(new java.awt.Font("Gill Sans Ultra Bold Condensed", 1, 18)); // NOI18N
        jLabel1.setText("Order");

jLabel2.setFont(new java.awt.Font("Gill Sans Ultra Bold Condensed", 1, 18)); // NOI18N
        jLabel2.setText("List");

javax.swing.GroupLayout OrderListBtnPnlLayout = new javax.swing.GroupLayout(OrderListBtnPnl);
        OrderListBtnPnl.setLayout(OrderListBtnPnlLayout);
        OrderListBtnPnlLayout.setHorizontalGroup(
            OrderListBtnPnlLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(OrderListBtnPnlLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(imageOrderList, javax.swing.GroupLayout.PREFERRED_SIZE, 74, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 29, Short.MAX_VALUE)
                .addGroup(OrderListBtnPnlLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, OrderListBtnPnlLayout.createSequentialGroup()
                        .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 67, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(18, 18, 18))
                    .addComponent(jLabel2, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 67, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18))
        );
        OrderListBtnPnlLayout.setVerticalGroup(
            OrderListBtnPnlLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(OrderListBtnPnlLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(imageOrderList, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addContainerGap())
            .addGroup(OrderListBtnPnlLayout.createSequentialGroup()
                .addGap(20, 20, 20)
                .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jLabel2)
                .addContainerGap(20, Short.MAX_VALUE))
        );

MainMenuExitBtn.setBackground(new java.awt.Color(255, 0, 0));
        MainMenuExitBtn.setFont(new java.awt.Font("Trebuchet MS", 1, 11)); // NOI18N
        MainMenuExitBtn.setForeground(new java.awt.Color(255, 255, 255));
        MainMenuExitBtn.setText("Log out");
        MainMenuExitBtn.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                MainMenuExitBtnActionPerformed(evt);
            }
        });

javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(headerPanel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addContainerGap())
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addGap(236, 236, 236)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(OrderListBtnPnl, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(OrderBtnPnl, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(73, 73, 73)
                        .addComponent(MainMenuExitBtn, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(headerPanel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(90, 90, 90)
                .addComponent(OrderBtnPnl, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(37, 37, 37)
                .addComponent(OrderListBtnPnl, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 40, Short.MAX_VALUE)
                .addComponent(MainMenuExitBtn, javax.swing.GroupLayout.PREFERRED_SIZE, 38, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );

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

private void MainMenuExitBtnActionPerformed(java.awt.event.ActionEvent evt) {                                                
        CoolLaundry cl = new CoolLaundry();
        this.setVisible(false);
        cl.setVisible(true);
    }

private void OrderBtnPnlMouseClicked(java.awt.event.MouseEvent evt) {                                         
        //Order
        Order ord = new Order();
        this.setVisible(false);
        ord.setVisible(true);
    }

private void OrderListBtnPnlMouseClicked(java.awt.event.MouseEvent evt) {                                             
        OrderList list = new OrderList();
        this.setVisible(false);
        list.setVisible(true);
    }

private void formWindowActivated(java.awt.event.WindowEvent evt) {                                     
        DBConnect  con= new DBConnect();
        setWelcome();
        int saldo = con.getSaldo(CurrentUser);
        setSaldo(Integer.toString(saldo));
    }

/**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(MainProgram.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(MainProgram.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(MainProgram.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(MainProgram.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

/* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new MainProgram().setVisible(true);
            }
        });
    }

// Variables declaration - do not modify                     
    private javax.swing.JButton MainMenuExitBtn;
    private javax.swing.JLabel MainProgramWelcome;
    private javax.swing.JLabel OrderBtnLabel;
    private javax.swing.JPanel OrderBtnPnl;
    private javax.swing.JPanel OrderListBtnPnl;
    private javax.swing.JLabel SaldoL;
    private javax.swing.JLabel SaldoRpL;
    private javax.swing.JPanel headerPanel;
    private javax.swing.JLabel imageOrder;
    private javax.swing.JLabel imageOrderList;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JLabel logoLableMainProgram;
    // End of variables declaration                   
}

RegisterFrom.java

import java.awt.*;
import java.util.Random;
import javax.swing.*;

/**
 *
 * @author CoolWolf
 */
public class RegisterForm extends javax.swing.JFrame {

/**
     * Creates new form RegisterForm
     */
    public RegisterForm() {
        initComponents();
        RegisterHeader.setBackground(new Color(0,0,255,30));
    }
    
    public String buatID(){
        char[] id = new char[15];
        String idAkun = "";
        Random rand = new Random();
        for (int i=0; i<id.length;i++){
            //id[i] = (rand.nextInt(9)+1).toString();
            idAkun = idAkun + (Integer.toString(rand.nextInt(9)+1));
        }
        
        return idAkun;
    }

RegisterPanel = new javax.swing.JPanel();
        RegUsernameEntry = new javax.swing.JFormattedTextField();
        RegPassEntry = new javax.swing.JPasswordField();
        RegFormBtn = new javax.swing.JButton();
        RegisterLoginBtn = new javax.swing.JLabel();
        RegUsernameLabel = new javax.swing.JLabel();
        RegPasswordLabel = new javax.swing.JLabel();
        RegEmailEntry = new javax.swing.JFormattedTextField();
        RegEmailLabel = new javax.swing.JLabel();
        RegJenKelLabel = new javax.swing.JLabel();
        RegJenKelCB = new javax.swing.JComboBox();
        RegNopeEntry = new javax.swing.JFormattedTextField();
        RegNopeLabel = new javax.swing.JLabel();
        RegNopeRegionCB = new javax.swing.JComboBox();
        RegOrLabel = new javax.swing.JLabel();
        RegAlamatEntry = new javax.swing.JTextField();
        RegAlamatLabel = new javax.swing.JLabel();
        RegisterHeader = new javax.swing.JPanel();
        RegisterSign = new javax.swing.JLabel();
        RegisterBGL = new javax.swing.JLabel();

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

RegisterPanel.setName(""); // NOI18N
        RegisterPanel.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                RegisterPanelFocusGained(evt);
            }
        });
        RegisterPanel.addComponentListener(new java.awt.event.ComponentAdapter() {
            public void componentShown(java.awt.event.ComponentEvent evt) {
                RegisterPanelComponentShown(evt);
            }
        });
        RegisterPanel.setLayout(null);

RegUsernameEntry.setCursor(new java.awt.Cursor(java.awt.Cursor.TEXT_CURSOR));
        RegUsernameEntry.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                RegUsernameEntryFocusGained(evt);
            }
        });
        RegUsernameEntry.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                RegUsernameEntryActionPerformed(evt);
            }
        });
        RegisterPanel.add(RegUsernameEntry);
        RegUsernameEntry.setBounds(110, 40, 152, 30);

RegPassEntry.setToolTipText("");
        RegPassEntry.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                RegPassEntryFocusGained(evt);
            }
            public void focusLost(java.awt.event.FocusEvent evt) {
                RegPassEntryFocusLost(evt);
            }
        });
        RegPassEntry.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                RegPassEntryMouseClicked(evt);
            }
        });
        RegPassEntry.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                RegPassEntryActionPerformed(evt);
            }
        });
        RegisterPanel.add(RegPassEntry);
        RegPassEntry.setBounds(110, 80, 152, 30);

RegFormBtn.setText("Register");
        RegFormBtn.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                RegFormBtnActionPerformed(evt);
            }
        });
        RegFormBtn.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                RegFormBtnKeyPressed(evt);
            }
        });
        RegisterPanel.add(RegFormBtn);
        RegFormBtn.setBounds(226, 288, 97, 42);

RegisterLoginBtn.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        RegisterLoginBtn.setForeground(new java.awt.Color(0, 0, 204));
        RegisterLoginBtn.setText("Login");
        RegisterLoginBtn.setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
        RegisterLoginBtn.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                RegisterLoginBtnMouseClicked(evt);
            }
            public void mouseEntered(java.awt.event.MouseEvent evt) {
                RegisterLoginBtnMouseEntered(evt);
            }
            public void mouseExited(java.awt.event.MouseEvent evt) {
                RegisterLoginBtnMouseExited(evt);
            }
        });
        RegisterPanel.add(RegisterLoginBtn);
        RegisterLoginBtn.setBounds(360, 300, 30, 14);

RegUsernameLabel.setText("Username");
        RegisterPanel.add(RegUsernameLabel);
        RegUsernameLabel.setBounds(20, 50, 60, 14);

RegPasswordLabel.setText("Password");
        RegisterPanel.add(RegPasswordLabel);
        RegPasswordLabel.setBounds(20, 90, 60, 14);

RegEmailEntry.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                RegEmailEntryFocusGained(evt);
            }
        });
        RegEmailEntry.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                RegEmailEntryActionPerformed(evt);
            }
        });
        RegisterPanel.add(RegEmailEntry);
        RegEmailEntry.setBounds(110, 120, 201, 30);

RegEmailLabel.setText("Email");
        RegisterPanel.add(RegEmailLabel);
        RegEmailLabel.setBounds(20, 130, 40, 14);

RegJenKelLabel.setText("Jenis Kelamin");
        RegisterPanel.add(RegJenKelLabel);
        RegJenKelLabel.setBounds(20, 170, 80, 14);

RegJenKelCB.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Laki-Laki", "Perempuan" }));
        RegisterPanel.add(RegJenKelCB);
        RegJenKelCB.setBounds(110, 160, 130, 31);

RegNopeEntry.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                RegNopeEntryFocusGained(evt);
            }
        });
        RegNopeEntry.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                RegNopeEntryActionPerformed(evt);
            }
        });
        RegisterPanel.add(RegNopeEntry);
        RegNopeEntry.setBounds(250, 240, 170, 30);

RegNopeLabel.setText("No. HP");
        RegisterPanel.add(RegNopeLabel);
        RegNopeLabel.setBounds(20, 250, 50, 14);

RegNopeRegionCB.setForeground(new java.awt.Color(255, 0, 0));
        RegNopeRegionCB.setMaximumRowCount(5);
        RegNopeRegionCB.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                RegNopeRegionCBFocusGained(evt);
            }
            public void focusLost(java.awt.event.FocusEvent evt) {
                RegNopeRegionCBFocusLost(evt);
            }
        });
        RegNopeRegionCB.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                RegNopeRegionCBActionPerformed(evt);
            }
        });
        RegisterPanel.add(RegNopeRegionCB);
        RegNopeRegionCB.setBounds(110, 240, 127, 30);

RegOrLabel.setText("or");
        RegisterPanel.add(RegOrLabel);
        RegOrLabel.setBounds(340, 300, 20, 14);
        RegisterPanel.add(RegAlamatEntry);
        RegAlamatEntry.setBounds(110, 200, 273, 30);

RegAlamatLabel.setText("Alamat");
        RegisterPanel.add(RegAlamatLabel);
        RegAlamatLabel.setBounds(20, 210, 50, 14);

RegisterHeader.setForeground(new java.awt.Color(0, 0, 255));
        RegisterHeader.setLayout(null);

RegisterSign.setFont(new java.awt.Font("Vrinda", 1, 18)); // NOI18N
        RegisterSign.setText("Register");
        RegisterHeader.add(RegisterSign);
        RegisterSign.setBounds(10, 0, 90, 20);

RegisterPanel.add(RegisterHeader);
        RegisterHeader.setBounds(0, 0, 530, 24);

RegisterBGL.setIcon(new javax.swing.ImageIcon(new javax.swing.ImageIcon(getClass().getResource("/utspemrogramanii/image/loginRegBG.jpg")).getImage().getScaledInstance(530,341, Image.SCALE_SMOOTH)));
        RegisterPanel.add(RegisterBGL);
        RegisterBGL.setBounds(0, 0, 530, 340);

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(RegisterPanel, javax.swing.GroupLayout.PREFERRED_SIZE, 530, javax.swing.GroupLayout.PREFERRED_SIZE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(RegisterPanel, javax.swing.GroupLayout.PREFERRED_SIZE, 341, javax.swing.GroupLayout.PREFERRED_SIZE)
        );

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

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

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

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

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

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

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

private void RegFormBtnActionPerformed(java.awt.event.ActionEvent evt) {                                           
        //buat akun baru
        String idAkun = buatID();
        String username = RegUsernameEntry.getText();
        char[] temp = RegPassEntry.getPassword();
        String password = new String(temp);
        String email = RegEmailEntry.getText();
        String gender = (String)RegJenKelCB.getSelectedItem();
        String alamat = RegAlamatEntry.getText();
        String Nope = ((String)RegNopeRegionCB.getSelectedItem() + " " + RegNopeEntry.getText());
        DBConnect connect = new DBConnect();
        if (connect.ValidateRegId(idAkun, username)==true){
            JOptionPane.showMessageDialog(null, "Akun Sudah ada!");
        } else {
            try{
                String values = "'"+idAkun+"'"+", "+"'"+username+"'" + ", "+ "'"+password +"'"+", "+"'"+ email +"'"+", "+"'"+gender+"'"+ ", "+"'" +alamat+"'"+", "+"'"+Nope+"'";
                String query = "INSERT INTO akun(IdAkun, nama, pass, email, jenkel, alamat, nope) VALUES("+values+");";
                System.out.println(query);
                connect.InsertRegistrasi(query);
                JOptionPane.showMessageDialog(null, "Registrasi Berhasil!");
            }catch(Exception ex){
                System.out.println(ex);
            }
        }
    }

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

private void RegisterLoginBtnMouseClicked(java.awt.event.MouseEvent evt) {                                              
        LoginForm login = new LoginForm();
        this.setVisible(false);
        login.setVisible(true);
    }

private void RegisterLoginBtnMouseEntered(java.awt.event.MouseEvent evt) {                                              
        RegisterLoginBtn.setForeground(new Color(102,0,204));
    }

private void RegisterLoginBtnMouseExited(java.awt.event.MouseEvent evt) {                                             
        RegisterLoginBtn.setForeground(new Color(0,0,204));
    }

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

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

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

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

private void RegNopeRegionCBFocusGained(java.awt.event.FocusEvent evt) {                                            
        String[] country = {"Indonesia (+62)", "Iran (+98)"};
        int ind = RegNopeRegionCB.getSelectedIndex();
        RegNopeRegionCB.removeAllItems();
        for (int i=0; i<country.length;i++){
            RegNopeRegionCB.addItem(country[i]);
        }
    }

private void RegNopeRegionCBFocusLost(java.awt.event.FocusEvent evt) {                                          
        String[] countrymin = {"+62", "+98"};
        int ind = RegNopeRegionCB.getSelectedIndex();
        RegNopeRegionCB.removeAllItems();
        for (int i=0; i<countrymin.length;i++){
            RegNopeRegionCB.addItem(countrymin[i]);
        }
        //System.out.println(countrymin[ind]);
        RegNopeRegionCB.setSelectedItem(countrymin[ind]);
    }

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

}

private void RegisterPanelFocusGained(java.awt.event.FocusEvent evt) {

}

private void RegisterPanelComponentShown(java.awt.event.ComponentEvent evt) {

}

private void formWindowActivated(java.awt.event.WindowEvent evt) {                                     
        String[] country = {"Pilih Negara",""};
        for (int i=0; i<country.length; i++){
            RegNopeRegionCB.addItem(country[i]);
        }
        RegNopeRegionCB.setSelectedIndex(0);
    }

/**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(RegisterForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(RegisterForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(RegisterForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(RegisterForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

/* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new RegisterForm().setVisible(true);
            }
        });
    }

// Variables declaration - do not modify                     
    private javax.swing.JTextField RegAlamatEntry;
    private javax.swing.JLabel RegAlamatLabel;
    private javax.swing.JFormattedTextField RegEmailEntry;
    private javax.swing.JLabel RegEmailLabel;
    private javax.swing.JButton RegFormBtn;
    private javax.swing.JComboBox RegJenKelCB;
    private javax.swing.JLabel RegJenKelLabel;
    private javax.swing.JFormattedTextField RegNopeEntry;
    private javax.swing.JLabel RegNopeLabel;
    private javax.swing.JComboBox RegNopeRegionCB;
    private javax.swing.JLabel RegOrLabel;
    private javax.swing.JPasswordField RegPassEntry;
    private javax.swing.JLabel RegPasswordLabel;
    private javax.swing.JFormattedTextField RegUsernameEntry;
    private javax.swing.JLabel RegUsernameLabel;
    private javax.swing.JLabel RegisterBGL;
    private javax.swing.JPanel RegisterHeader;
    private javax.swing.JLabel RegisterLoginBtn;
    private javax.swing.JPanel RegisterPanel;
    private javax.swing.JLabel RegisterSign;
    // End of variables declaration                   
}

LoginForm.java

import java.awt.*;
import javax.swing.*;

/**
 *
 * @author CoolWolf
 */
public class LoginForm extends javax.swing.JFrame {

/**
     * Creates new form LoginForm
     */
    public LoginForm() {
        initComponents();
        transparentBGCover.setBackground(new Color(0,0,0,10));
        LoginFormBtn.setBackground(new Color(0,0,0,200));
        usernameEntry.setBackground(new Color(0,0,0,0));
        passEntry.setBackground(new Color(0,0,0,0));
        LoginHeader.setBackground(new Color(0,0,255,30));
        
    }
    
    private void loginAction(){
        DBConnect connect = new DBConnect();
        String username = usernameEntry.getText();
        char[] temp = passEntry.getPassword();
        String pass = new String(temp);
        Boolean status = connect.ValidateLogin(username, pass); 
        if (status==true){
            //berhasil login
            String priv = connect.getPrivilege(username);
            System.err.println(priv);
            if (priv.equals("user")){
                MainProgram mainprg = new MainProgram();
                this.setVisible(false);
                mainprg.setCurrentUser(username);
                mainprg.setVisible(true);
                mainprg.setWelcome();
            }
            else if(priv.equals("admin")){
                AdminMain adm = new AdminMain();
                this.setVisible(false);
                adm.setCurrentUser(username);
                adm.setVisible(true);
                adm.setWelcome();
            }
            
        }
        else{
            //gagal login
            JOptionPane.showMessageDialog(null, "Username/Password Salah!", "Error", JOptionPane.WARNING_MESSAGE);
        }
    }

LoginPanel = new javax.swing.JPanel();
        LoginBG = new javax.swing.JPanel();
        LoginHeader = new javax.swing.JPanel();
        loginSign = new javax.swing.JLabel();
        usernameEntry = new javax.swing.JFormattedTextField();
        passEntry = new javax.swing.JPasswordField();
        LoginFormBtn = new javax.swing.JButton();
        ask1L = new javax.swing.JLabel();
        LoginDaftarBtn = new javax.swing.JButton();
        Hiasan1 = new javax.swing.JLabel();
        Hiasan2 = new javax.swing.JLabel();
        usernameIcon = new javax.swing.JLabel();
        passwordIcon = new javax.swing.JLabel();
        transparentBGCover = new javax.swing.JPanel();
        LoginBGL = new javax.swing.JLabel();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

LoginPanel.setName(""); // NOI18N
        LoginPanel.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                LoginPanelFocusGained(evt);
            }
        });
        LoginPanel.addComponentListener(new java.awt.event.ComponentAdapter() {
            public void componentShown(java.awt.event.ComponentEvent evt) {
                LoginPanelComponentShown(evt);
            }
        });
        LoginPanel.setLayout(null);

LoginBG.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

LoginHeader.setForeground(new java.awt.Color(0, 0, 255));
        LoginHeader.setLayout(null);

loginSign.setFont(new java.awt.Font("Vrinda", 1, 18)); // NOI18N
        loginSign.setText("Login");
        LoginHeader.add(loginSign);
        loginSign.setBounds(10, 0, 60, 24);

LoginBG.add(LoginHeader, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 530, 24));

usernameEntry.setBorder(null);
        usernameEntry.setText("username");
        usernameEntry.setFont(new java.awt.Font("Lucida Sans", 1, 14)); // NOI18N
        usernameEntry.setOpaque(false);
        usernameEntry.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                usernameEntryFocusGained(evt);
            }
            public void focusLost(java.awt.event.FocusEvent evt) {
                usernameEntryFocusLost(evt);
            }
        });
        usernameEntry.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                usernameEntryActionPerformed(evt);
            }
        });
        LoginBG.add(usernameEntry, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 120, 190, 20));

passEntry.setFont(new java.awt.Font("Lucida Sans", 1, 14)); // NOI18N
        passEntry.setText("password");
        passEntry.setToolTipText("");
        passEntry.setBorder(null);
        passEntry.setOpaque(false);
        passEntry.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                passEntryFocusGained(evt);
            }
            public void focusLost(java.awt.event.FocusEvent evt) {
                passEntryFocusLost(evt);
            }
        });
        passEntry.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                passEntryMouseClicked(evt);
            }
        });
        passEntry.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                passEntryActionPerformed(evt);
            }
        });
        LoginBG.add(passEntry, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 170, 190, 20));

LoginFormBtn.setBackground(new java.awt.Color(0, 0, 0));
        LoginFormBtn.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        LoginFormBtn.setForeground(new java.awt.Color(255, 255, 255));
        LoginFormBtn.setText("Login");
        LoginFormBtn.setBorder(null);
        LoginFormBtn.setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
        LoginFormBtn.setFocusPainted(false);
        LoginFormBtn.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                LoginFormBtnActionPerformed(evt);
            }
        });
        LoginFormBtn.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                LoginFormBtnKeyPressed(evt);
            }
        });
        LoginBG.add(LoginFormBtn, new org.netbeans.lib.awtextra.AbsoluteConstraints(270, 250, 90, 30));

ask1L.setFont(new java.awt.Font("Serif", 1, 12)); // NOI18N
        ask1L.setText("Belum Daftar? ");
        LoginBG.add(ask1L, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 300, 90, -1));

LoginDaftarBtn.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        LoginDaftarBtn.setText("Daftar");
        LoginDaftarBtn.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                LoginDaftarBtnActionPerformed(evt);
            }
        });
        LoginBG.add(LoginDaftarBtn, new org.netbeans.lib.awtextra.AbsoluteConstraints(270, 290, 90, 30));

Hiasan1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        Hiasan1.setText("___________________________");
        LoginBG.add(Hiasan1, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 180, 190, -1));

Hiasan2.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        Hiasan2.setText("___________________________");
        LoginBG.add(Hiasan2, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 130, 190, -1));

usernameIcon.setIcon(new javax.swing.ImageIcon(getClass().getResource("/utspemrogramanii/icon/customer_32px.png"))); // NOI18N
        LoginBG.add(usernameIcon, new org.netbeans.lib.awtextra.AbsoluteConstraints(360, 110, -1, -1));

passwordIcon.setIcon(new javax.swing.ImageIcon(getClass().getResource("/utspemrogramanii/icon/lock_32px.png"))); // NOI18N
        LoginBG.add(passwordIcon, new org.netbeans.lib.awtextra.AbsoluteConstraints(360, 160, -1, -1));

javax.swing.GroupLayout transparentBGCoverLayout = new javax.swing.GroupLayout(transparentBGCover);
        transparentBGCover.setLayout(transparentBGCoverLayout);
        transparentBGCoverLayout.setHorizontalGroup(
            transparentBGCoverLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 530, Short.MAX_VALUE)
        );
        transparentBGCoverLayout.setVerticalGroup(
            transparentBGCoverLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 340, Short.MAX_VALUE)
        );

LoginBG.add(transparentBGCover, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 530, 340));

LoginBGL.setIcon(new javax.swing.ImageIcon(new javax.swing.ImageIcon(getClass().getResource("/utspemrogramanii/image/loginRegBG.jpg")).getImage().getScaledInstance(530,341, Image.SCALE_SMOOTH)));
        LoginBG.add(LoginBGL, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 530, 340));

LoginPanel.add(LoginBG);
        LoginBG.setBounds(0, 0, 530, 341);

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

private void usernameEntryFocusGained(java.awt.event.FocusEvent evt) {

usernameEntry.selectAll();
    }

private void usernameEntryFocusLost(java.awt.event.FocusEvent evt) {

}

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

private void passEntryFocusGained(java.awt.event.FocusEvent evt) {                                      
        passEntry.selectAll();
    }

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

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

}

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

}

private void LoginFormBtnActionPerformed(java.awt.event.ActionEvent evt) {                                             
        loginAction();
    }

private void LoginFormBtnKeyPressed(java.awt.event.KeyEvent evt) {                                        
        if(evt.getKeyCode()==java.awt.event.KeyEvent.VK_ENTER){
            loginAction();
        }
    }

private void LoginDaftarBtnActionPerformed(java.awt.event.ActionEvent evt) {                                               
        RegisterForm reg = new RegisterForm();
        this.setVisible(false);
        reg.setVisible(true);
    }

private void LoginPanelFocusGained(java.awt.event.FocusEvent evt) {

}

private void LoginPanelComponentShown(java.awt.event.ComponentEvent evt) {

}

/**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

/* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new LoginForm().setVisible(true);
            }
        });
    }

// Variables declaration - do not modify                     
    private javax.swing.JLabel Hiasan1;
    private javax.swing.JLabel Hiasan2;
    private javax.swing.JPanel LoginBG;
    private javax.swing.JLabel LoginBGL;
    private javax.swing.JButton LoginDaftarBtn;
    private javax.swing.JButton LoginFormBtn;
    private javax.swing.JPanel LoginHeader;
    private javax.swing.JPanel LoginPanel;
    private javax.swing.JLabel ask1L;
    private javax.swing.JLabel loginSign;
    private javax.swing.JPasswordField passEntry;
    private javax.swing.JLabel passwordIcon;
    private javax.swing.JPanel transparentBGCover;
    private javax.swing.JFormattedTextField usernameEntry;
    private javax.swing.JLabel usernameIcon;
    // End of variables declaration                   
}

MainProgram.java