Konversi Mata Uang with J2ME

Assalmu'alaikum wr. wb....

oke bagi yang mau msh mu belajar j2me seperti saya... nah ini  saya buat cara bru lgi buat konversi mata uang rupiah menjadi dolar, Euro, dan YEn nah dlu saya buatnya pake C++ nah sekarang nyoba deh pakej2me.....  sebenernya konsepnya sama tapi cm saya mengconvert antara choicegroup dengan command...... oke langsung pembahasan ke codingnya ya :

import javax.microedition.lcdui.Alert;
import javax.microedition.lcdui.AlertType;
import javax.microedition.lcdui.ChoiceGroup;
import javax.microedition.lcdui.Command;
import javax.microedition.lcdui.CommandListener;
import javax.microedition.lcdui.Display;
import javax.microedition.lcdui.Displayable;
import javax.microedition.lcdui.Form;
import javax.microedition.lcdui.TextField;
import javax.microedition.midlet.*;

/**
 * @author tiwi
 */
public class MidletMataUang extends MIDlet implements CommandListener{

    Form form;
    Display display;
    Command cexit, cOk, creset;
    TextField t1, t2;
    ChoiceGroup choiceGroup;
    Alert a1, a2, a3;
    double a,b;

    public MidletMataUang() {
        initComp();
    }

    public void startApp() {
        display = Display.getDisplay(this);
        display.setCurrent(form);
    }

    public void pauseApp() {
    }

    public void destroyApp(boolean unconditional) {
    }

    private void initComp() {
        form = new Form("Konversi Mata Uang Rupiah");
        cexit = new Command("Exit", Command.EXIT, 1);
        cOk = new Command("OK", Command.OK, 1);
        creset=new Command("Reset", Command.OK, 1);
        t1 = new TextField("Rupiah", null, 20, TextField.NUMERIC);
        t2 = new TextField("Hasil", null, 20, TextField.ANY);
        choiceGroup = new ChoiceGroup("Konversi", ChoiceGroup.EXCLUSIVE);
        choiceGroup.append("Dolar", null);
        choiceGroup.append("Euro", null);
        choiceGroup.append("Yen", null);
        a1 = new Alert("Informtion", "Konversi Ke Dolar ", null, AlertType.INFO);
        a2 = new Alert("Information", "Konversi ke Euro", null, AlertType.INFO);
        a3 = new Alert("Information", "Konversi ke Yen", null, AlertType.INFO);
        form.append(t1);
        form.append(choiceGroup);
        form.append(t2);
        form.addCommand(cexit);
        form.addCommand(cOk);
        form.addCommand(creset);
        form.setCommandListener(this);
    }

    public void commandAction(Command c, Displayable d) {
        if(c==cexit){
            destroyApp(true);
            notifyDestroyed();
        }else if(c== cOk){
            if(choiceGroup.isSelected(0)){
                a=Double.parseDouble(t1.getString());
                b=(a*9400);
                String e=String.valueOf(b);
                t2.setString(e);
                display.setCurrent(a1);
            }else if(choiceGroup.isSelected(1)){
                a=Double.parseDouble(t1.getString());
                b=(a*14000);
                String f=String.valueOf(b);
                t2.setString(f);
                display.setCurrent(a2);
            }else if(choiceGroup.isSelected(2)){
                a=Double.parseDouble(t1.getString());
                b=(a*88);
                String g=String.valueOf(b);
                t2.setString(g);
                display.setCurrent(a3);
            }
        }else if( c== creset){
            t1.setString("");
            t2.setString("");
            choiceGroup.setSelectedIndex(0, true);
        }
    }
}

simple banget kan codingnya..... nah dari coding itu outputnya kayak gini ni:

nah buat ganti-ganti konversinya tinggl pilih yg ada d choicegroupnya, trus pilih tombol yg kanan buat ngeOKnya.... trus muncul deh konversinya yg ada di bawah.... sialakan bsa dikembangkan menurut cara teman-teman sendiri...
Ok segitu lu postinganya... tar klo ada yg baru lagi di share lagi...... buat kritik dan saran bisa langsung dituliskan di komentar..... maacih...^_^

Wassalamu'alaikum wr.wb

Konversi Suhu With J2ME

Assalamu'alaikum wr.wb.....

Setelah lama tidak posting akhirnya kembali lagi buat posting ilmu yang baru.... yah walaupun sederhana tapi ya gimana ya buatan sendiri gitu loh....hihiihihihihi....
Tiba-tiba ide ini muncul ketika mencoba buat program enkripsi  pake j2ME yg blm jdi karena logikanya blm dpt2 e.... ayo-ayok klo yg bisa bantu saya buat programnya... dan survey membuktikan juga klo ngoding itu dapat menghilangkan penat dan stress karena maslah yang ada di luar sana.... heheheh=D *itu menurut yg nulis....
Dari pada banyak basa-basi langsung saya bagi-bagi codingnya Konversi dari celcius ke Fahrenhait dan Reamur:

import javax.microedition.lcdui.Alert;
import javax.microedition.lcdui.AlertType;
import javax.microedition.lcdui.Command;
import javax.microedition.lcdui.CommandListener;
import javax.microedition.lcdui.Display;
import javax.microedition.lcdui.Displayable;
import javax.microedition.lcdui.Form;
import javax.microedition.lcdui.TextField;
import javax.microedition.midlet.*;

/**
 * @author tiwi
 */
public class MidletSuhu extends MIDlet implements CommandListener {

    Form form;
    Display display;
    Command exit, fahrenhait, reamur, reset;
    Alert a1, a2;
    TextField t1, t2;
    double a, b;

    public MidletSuhu() {

        form = new Form("Konversi Suhu");
        exit = new Command("Exit", Command.EXIT, 1);
        fahrenhait = new Command("Fahrenhait", Command.OK, 1);
        reamur = new Command("Reamur", Command.OK, 1);
        reset = new Command("reset", Command.OK, 1);
        t1 = new TextField("Masukkan Suhu Celcius", null, 20, TextField.NUMERIC);
        t2 = new TextField("Hasil", null, 20, TextField.ANY);
        a1 = new Alert("Informatiaon", "Konfersi Fahrenhait", null, AlertType.CONFIRMATION);
        a2 = new Alert("Information", "Konfersi Reamur", null, AlertType.CONFIRMATION);
        form.append(t1);
        form.append(t2);
        form.addCommand(exit);
        form.addCommand(fahrenhait);
        form.addCommand(reamur);
        form.addCommand(reset);
        form.setCommandListener(this);

    }

    public void startApp() {
        display = Display.getDisplay(this);
        display.setCurrent(form);

    }

    public void pauseApp() {
    }

    public void destroyApp(boolean unconditional) {
    }

    public void commandAction(Command c, Displayable d) {
        if (c == exit) {
            destroyApp(true);
            notifyDestroyed();


        } else if (c == fahrenhait) {
            display.setCurrent(a1);
            a = Double.parseDouble(t1.getString());
            b = (a * 1.8) + 32;
            String e = String.valueOf(b);
            t2.setString(e);


        } else if (c == reamur) {
            display.setCurrent(a2);
            a = Double.parseDouble(t1.getString());
            b = (a * 0.8);
            String f = String.valueOf(b);
            t2.setString(f);


        } else if (c == reset) {
            t1.setString("");
            t2.setString("");

        }
    }
}

oh ya sblm k outputnya kayak gmna mau tak terangin dikit ni walaupun mungkin udah bnyak yg tau, tp gpp lah klo ada yang blm tau bs nambah2 ilmu. Buat komponen textfield di J2me itu dapat di tentuin tipe inputanya nah yg saya pake ada yg inputan khusus numeric di t1nya jdi klo gk angka gk bisa, trus yg t2nya yg buat nampilin hasil aq pke any yg bsa buat semuanya. Tdnya saya pake numeric eh ketika saya ganti tipe datanya pake double (kan biasanya klo konfersi pasti ada koma2nya) pas nampilinya ternyata gk bisa, kenapa??? karena textfild numerik itu hanya bisa digunakan untuk menginputkan  dan menampilkan bilangan bulat saja dan tidak bisa bilangan pecahan ternyata... hehehehe

nah dari coding itu outputnya kayak gini, trus inputin deh angkanya:

trus klik tombol menu yg sblh kanan sndiri:

                                                            
trus pilih mau konfersi k fahrenhait ato reamur cara ngeOknya pake tombol bulet yg tengh itu.
jadinya kayak gini:

nah dari contoh diatas tar dapat di kembangkan sendiri buat yang lainya misalnya fahrenhait k celcius dan reamur dan sebaliknya, dan dapat menggunakan metode2 yg lbih keren lagi......
oke sekian saja dari saya ....


Wassalamu'alaikum Wr.wB........

Input Format Tanggal di C++

Assalamu'alaikum wr.wb.


Setelah lm gk posting akhirnya ada topik juga yg mau di postingin,,,, gimana cara input format tanggal di C++ (dd-mm-yyyy) nah itu ada ide sewaktu soal responsi ktika sy jdi Coass.... permasalahanya gni tentang defaul Zodiak, disini sy ambil contoh adalh tnggal dan bulan lahir yg zodiknya gemini (Zodiak sy hahahah =D) aja, tar default yg lain bs di tambahin sndiri.... lngsung ke souce codenya:



outputnya sbb:



okelah itu msh sederhana sekali dan sy jg msh cri2 klo yg pake java, silakan diperbaiki dan dikembnagkan sndiri......
makasih.....

Wassalamu'alaikum wr.wb....

LAPORAN&TUGAS BASISDATA

LAPORAN PRAKTIKUM BASIS DATA

Pertemuan ke 7 basis data membahas tentang fungsi agregat, fungsi numeric, fungsi String, fungsi tanggal, dan konversi data.

1. Fungsi Agregat adalah fungsi yang bekerja terhadap suatu group. Fungsinya terdiri dari:

• Count, digunakan untuk menghitung cacah record/baris dari sutu table

Sintax SQLnya: select count(*) from namatable;

Atau untuk menampilkan data tertentu saja syntaxnya: select count(*) from nama table where letaknya;

• SUM, digunakan untuk meghitung jumlah dari sekumpulan kolom dari sutu table.

Sintax SQLnya: select sum(kolomyang akan dijumlahkan) from namatable;

Atau juga dapat berdasarkan kondisi tertentu. Syntaxnya: select sum(kolomyang akan dijumlahkan) from namatable where letaknya;

• AVG, digunakan untuk mendapatkan nilai kolom tertentu pada suatu table.

Syntax SQLnya: select avg(kolom yang akan dihitung rata-ratanya) from namatable;

• Max , diggunakan untuk mendapatkan nilai terbesar dalam sekumpulan nilai, kolom dari suatu table.

Syntax SQLnya: select max(kolom yang akan dicari) from namatable;

Atau dapt ditambahkan pada kondisi tertentu select max(kolom yang akan dicari) from namatable where letaknya;

• Min, digunakan untuk mendapatkan nilai terkecil dari sekumpulan nilai kolom dari suatu table.

Syntax SQLnya: select min(kolom yang akan dicari) from namatable;

2. Fungsi Numerik yaitu format standar dalam penggunaan operasi aritmatika. Fungsi numerik juga termasuk fungsi matematika dan trigonometri:

Contoh syntax penggunaanya dalam MYSQL:

select Round (224.9980,0)

select Floor (-496.45)

3. Fungsi String yaitu fungsi yang digunakan untuk memanipulasi atau mengkonversi string sesuai dengan yang diinginkan.

Contoh penggunaan String dalam Syntax MYSQL:

select 'selamat' + 'Belajar';

select LTRIM ('Balajar Java)

4. Fungsi Tanggal yaitu fungsi yang digunakan untuk aritmatika/perhitungan tanggal.

Contoh penggunaanya dalam Syntax MYSQL:

select getdate()

select datediff(yy, tgl_pinjam, getdate()) from namatabel;

5. Fungsi konversi data, dalam SQL menggunakan fungsi CONVERT, ungsi ini digunakan untuk mengubah data dari satu tipe ke tipe yag lainya ketika mysql server tidak dapat mengenal sebuah konversi.

Contoh syntax dalam MYSQLnya:

CONVERT (tipe data [panjang),ekspresi [,bentuk])

select convert (int, nim) from mahasiswa

oke segitu laporan praktikumnya habis itu langsung ke jawaban tugasnya :

TUGAS PRAKTIKUM BASIS DATA

1. Tampilkan Jumlah mahasiswa yang ada dalam table mahasiswa
   syntaxnya:
   
   outpunya:
1.            
2. Tampilkan Jumlah Penerbit yang ada
   sytaxnya:
   
    outputnya:
   
   
   
3. Tampilkan Jumlah buku terbanyak
   syntaxnya:
   
                              
4. Tampilkan jumlah buku paling sedikit 
   syntax:
   
   
    
5. Tampilkan total buku per penerbit
   syntaxnya:
   
   
   
   
6. Tampilkan total judul buku per penerbit yang lebih besar dari 2

selesai deh............!!!

MP3 playerQ......

 Assalamu'alaikum wr.wb

Akhirnya lm nyoba2 buat MP3 player akhirnya bisa juga sekarang,,, pake JMF langsung k codingnya,,,

package mp3;

import com.sun.java.swing.plaf.nimbus.NimbusLookAndFeel;

import java.awt.FlowLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.io.File;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.media.Manager;

import javax.media.MediaLocator;

import javax.media.Player;

import javax.swing.JButton;

import javax.swing.JFileChooser;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.UIManager;

import javax.swing.UnsupportedLookAndFeelException;

/**

*

* @author tiwi

*/

public class MP3Player extends JFrame {

JButton bopen, bplay, bstop, bclose;

JFileChooser fc;

JLabel l;

private String alamat;

File file;

MediaLocator ml;

Player player;

public MP3Player() {

super("MP3 Player");

initComponent();

initAction();

}

private void initComponent() {

bopen = new JButton("Open");

bplay = new JButton("Play");

bstop = new JButton("Stop");

bclose = new JButton("Close");

fc = new JFileChooser();

l = new JLabel("");

setLayout(new FlowLayout());

add(bopen);

add(bplay);

add(bstop);

add(bclose);

add(l);

setVisible(true);

setLocationRelativeTo(null);

pack();

setDefaultCloseOperation(EXIT_ON_CLOSE);

}

private void initAction() {

bopen.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

try {

fc.showOpenDialog(bopen);

alamat = fc.getSelectedFile().getPath();

file = new File(alamat);

l.setText(alamat);

ml = new MediaLocator(file.toURL());

player = Manager.createPlayer(ml);

} catch (Exception ex) {

ex.printStackTrace();

JOptionPane.showMessageDialog(null, "Tidak Dapat Dibuka", "Information ", JOptionPane.ERROR_MESSAGE);

}

}

});

bplay.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

player.start();

}

});

bstop.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

player.stop();

}

});

bclose.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

player.close();

}

});

}

public static void main(String[] args) {

try {

UIManager.setLookAndFeel(new NimbusLookAndFeel());

new MP3Player();

} catch (UnsupportedLookAndFeelException ex) {

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

}

}

}

screenshotnya: 

selamat mencoba.....
Wassalamu'alikum wr.wb.

Tugas I Basis Data

Praktikum basis data yang kedua bahas tentang insert table, update table, hapus table, menghapus field pada table, dan menambahkan field pada table.
Habis di terangin itu lalu ada semacam latihan yaitu siapa yang bisa nyelesain/ buat table  buku penerbit sama table pinjam dapat point deh..........
setelah buat-buat eh jadi deh,,,,,, akhirnya dpt point keaktifan,,,, lumayan.......hehehe.....
trus dilanjut ke tugasnya dri table yang uda jadi tadi trus diisi ato di insertin, tentang syntax SQLnya oke lnsung aja:

pertama table Buku,

pertama buat table buku dengan field2 kode buku panjngnya 4 character yg sebagi primary key, lalu judul buku panjangnya 20 character , pengarang panjangnya 15 character, jml_buku sama kode penerbit pnjngnya 2 character........ klo uda syntaxnya kemudian klik go............. jadi deh tablenya.

trus mengisikan isi yang ada di table buku syntaxnya sbb:
insert di table buku:

lalu klik jga tombol go..... jd deh.....
hasilnya :

table penerbit:

untuk buat table penerbit pertama create nama tablenya dlu,,, trus deklarasiin field2nya kode_penerbit dg pnjng 2 character dan nama_penerbit dg panjang 15 character..
untuk mengisinya syntaxnya sbb:
insert table penerbit:

hasil penerbit

table pinjam:

untuk buat table pinjam pertama create nama tablenya dlu,,, trus deklarasiin field2nya tgl pinjam tipe datanya datetime, trus mhs_no_induk dg pnjng 9 character dan buk_kode_buku dg panjang 4 character, tgl_hrs_kembali tipenya datetime dan tgl_kembali jga datetime. abis itu di go.....


Syntax untuk ngisi di tablenya sbb:
insert table pinjam:

hasil pinjam

segitu postingnya smoga bermanfaat........ selamat mencoba............=D

SetTitle&KeyPress

Assalamu'alaikum wr.wb

Postingan kali ini tentang title yg di buat dri keypress, jadi titlenya klo uda d enter dari textfieldnya......
langsung k codingnya aja ya.....

package baru;

import com.sun.java.swing.plaf.nimbus.NimbusLookAndFeel;
import java.awt.FlowLayout;
import java.awt.event.KeyEvent;
import java.awt.event.KeyListener;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.UIManager;
import javax.swing.UnsupportedLookAndFeelException;

/**
 *
 * @author tiwi
 */
public class NewClass extends JFrame implements KeyListener {

    JLabel l;
    JTextField tf;

    public NewClass() {
        super("NIM : ");
        l = new JLabel("NIM");
        tf = new JTextField(20);
        setLayout(new FlowLayout());
        add(l);
        add(tf);
        tf.addKeyListener(this);
        setVisible(true);
        setLocationRelativeTo(null);
        setDefaultCloseOperation(EXIT_ON_CLOSE);
        pack();
    }

    public void keyTyped(KeyEvent e) {
    }

    public void keyPressed(KeyEvent e) {
        if (e.getKeyCode() == KeyEvent.VK_ENTER) {
            setTitle("NIM : " + tf.getText());
            tf.setText("");
        }
    }

    public void keyReleased(KeyEvent e) {
    }

    public static void main(String[] args) {
        try {
            UIManager.setLookAndFeel(new NimbusLookAndFeel());
            new NewClass();
        } catch (UnsupportedLookAndFeelException ex) {
            Logger.getLogger(NewClass.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
}
screnshotnya

  

                                                

                                       

selamat mencoba.... terima kasih.....

wassalamu'alaikum wr.wb

JCombo di atas JButton

Assalamu'alaikum wr.wb

pas bangun tidur, e kepikiran lgi project combo yg blm jd akhirnya jdnya jcombo di atas jbutton,,,,, lngsung k codingnya aja ya,,,
package combo;

import java.awt.Color;
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.BoxLayout;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;

/**
 *
 * @author tiwi
 */
public class Coba extends JFrame {

    JComboBox cb;
    JButton b;
    JLabel l1, l2;
    JPanel p1, p2;

    public Coba() {
        initComponent();
        initLayout();
        initAction();
    }

    private void initComponent() {
        b = new JButton();
        String[] gambar = {"-pilih-", "icon", "home", "chat"};
        cb = new JComboBox(gambar);
        l1 = new JLabel("ComBo");
        l2 = new JLabel();
        p1 = new JPanel();
        p2 = new JPanel();
    }

    private void initLayout() {
        b.setLayout(new FlowLayout());
        b.add(cb);
        b.setBackground(Color.BLUE);
        Container c = getContentPane();
        c.setLayout(new BoxLayout(c, BoxLayout.Y_AXIS));
        c.add(p1);
        c.add(p2);
        p1.setLayout(new FlowLayout());
        p1.add(b);
        p2.setLayout(new FlowLayout());
        p2.add(l1);
        p2.add(l2);
        c.setSize(400, 300);
        setVisible(true);
        pack();
        setDefaultCloseOperation(EXIT_ON_CLOSE);
        setLocationRelativeTo(null);
    }

    private void initAction() {
        b.addActionListener(new ActionListener() {

            public void actionPerformed(ActionEvent e) {
                if (cb.getSelectedIndex() == 1) {
                    l2.setIcon(new ImageIcon("src/Icon.png"));
                } else if (cb.getSelectedIndex() == 2) {
                    l2.setIcon(new ImageIcon("src/Home.png"));
                }
                else if (cb.getSelectedIndex() == 3) {
                    l2.setIcon(new ImageIcon("src/Chat.png"));
                }
            }
        });
    }
}
screenshotnya:

nah jdnya action combonya di dapat ktika buttonya d klik......
oke selamat mencoba ya..... jngn lupa kritik dan saranya.....


Wassalamu'allaikum Wr.WB.....

Apikasi Conter Pulsa2 an....

Assalamu'alaikum.....

aplikasi kali ne ttng conter pulssa2an msh pake java data base koq thp2ny jga sm,,,,, gk usa basa basi ya,,,,,, lnsung k coding ma Screenshotnya,,,,,
codingnya:
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * Form.java
 *
 * Created on Mar 10, 2011, 7:30:41 PM
 */
package conter.form;

import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

/**
 *
 * @author tiwi
 */
public class Form extends javax.swing.JFrame {

    Connection connection;
    Statement statement;
    ResultSet resultSet;
    DefaultTableModel dtm;

    /** Creates new form Form */
    public Form() {
        initComponents();
        initTable();
    }

    /** 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() {

        panel1 = new conter.panel.Panel();
        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        tfkode = new conter.panel.TextField1();
        tfhp = new conter.panel.TextField1();
        tfoperator = new conter.panel.TextField1();
        tfbanyak = new conter.panel.TextField1();
        bkirim = new conter.panel.Button1();
        btampil = new conter.panel.Button1();
        bhapus = new conter.panel.Button1();
        bedit = new conter.panel.Button1();
        jScrollPane1 = new javax.swing.JScrollPane();
        jScrollPane2 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        bexit = new conter.panel.Button1();
        tfcari = new conter.panel.TextField1();
        jLabel10 = new javax.swing.JLabel();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        panel1.setBackground(new java.awt.Color(204, 204, 204));
        panel1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED), ":: Tiwi'S Cell ::", javax.swing.border.TitledBorder.CENTER, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Times New Roman", 1, 48), new java.awt.Color(255, 255, 255))); // NOI18N

        jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 18));
        jLabel1.setForeground(new java.awt.Color(255, 255, 255));
        jLabel1.setText("SeLamat Datang,......");

        jLabel2.setFont(new java.awt.Font("Times New Roman", 1, 18));
        jLabel2.setForeground(new java.awt.Color(255, 255, 255));
        jLabel2.setText("Di Conternya Tiwi.....");

        jLabel3.setFont(new java.awt.Font("Times New Roman", 1, 18));
        jLabel3.setForeground(new java.awt.Color(255, 255, 255));
        jLabel3.setText("SilakaN Isi Ulang  Pulsa Anda,,,,,,,");

        jLabel4.setFont(new java.awt.Font("Times New Roman", 1, 24));
        jLabel4.setForeground(new java.awt.Color(255, 255, 255));
        jLabel4.setText("InDoSaT, TelKomseL, XL, Axis, Esia dll..");

        jLabel5.setFont(new java.awt.Font("Times New Roman", 1, 14));
        jLabel5.setForeground(new java.awt.Color(255, 255, 255));
        jLabel5.setText("Kode           :");

        jLabel6.setFont(new java.awt.Font("Times New Roman", 1, 18));
        jLabel6.setForeground(new java.awt.Color(255, 255, 255));
        jLabel6.setText("Isikan Pesanan Anda disini:");

        jLabel7.setFont(new java.awt.Font("Times New Roman", 1, 14));
        jLabel7.setForeground(new java.awt.Color(255, 255, 255));
        jLabel7.setText(" No HP        :");

        jLabel8.setFont(new java.awt.Font("Times New Roman", 1, 14));
        jLabel8.setForeground(new java.awt.Color(255, 255, 255));
        jLabel8.setText("OpeRator    :");

        jLabel9.setFont(new java.awt.Font("Times New Roman", 1, 14));
        jLabel9.setForeground(new java.awt.Color(255, 255, 255));
        jLabel9.setText("Banyaknya  :");

        tfkode.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                tfkodeKeyPressed(evt);
            }
        });

        tfhp.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                tfhpKeyPressed(evt);
            }
        });

        tfoperator.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                tfoperatorKeyPressed(evt);
            }
        });

        tfbanyak.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                tfbanyakKeyPressed(evt);
            }
        });

        bkirim.setText("Kirim");
        bkirim.setFont(new java.awt.Font("Times New Roman", 1, 14));
        bkirim.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bkirimActionPerformed(evt);
            }
        });

        btampil.setText("Tampil");
        btampil.setFont(new java.awt.Font("Times New Roman", 1, 14));
        btampil.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btampilActionPerformed(evt);
            }
        });

        bhapus.setText("Hapus");
        bhapus.setFont(new java.awt.Font("Times New Roman", 1, 14));
        bhapus.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bhapusActionPerformed(evt);
            }
        });

        bedit.setText("Edit");
        bedit.setFont(new java.awt.Font("Times New Roman", 1, 14));
        bedit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                beditActionPerformed(evt);
            }
        });

        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Kode", "No HP", "Operator", "Banyaknya"
            }
        ));
        jTable1.setGridColor(new java.awt.Color(51, 51, 51));
        jTable1.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTable1MouseClicked(evt);
            }
        });
        jScrollPane2.setViewportView(jTable1);

        jScrollPane1.setViewportView(jScrollPane2);

        bexit.setText("Exit");
        bexit.setFont(new java.awt.Font("Times New Roman", 1, 14));
        bexit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bexitActionPerformed(evt);
            }
        });

        tfcari.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyTyped(java.awt.event.KeyEvent evt) {
                tfcariKeyTyped(evt);
            }
        });

        jLabel10.setFont(new java.awt.Font("Times New Roman", 1, 14));
        jLabel10.setForeground(new java.awt.Color(255, 255, 255));
        jLabel10.setText("C a R i");

        javax.swing.GroupLayout panel1Layout = new javax.swing.GroupLayout(panel1);
        panel1.setLayout(panel1Layout);
        panel1Layout.setHorizontalGroup(
            panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(panel1Layout.createSequentialGroup()
                .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(panel1Layout.createSequentialGroup()
                            .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addGroup(panel1Layout.createSequentialGroup()
                                    .addGap(85, 85, 85)
                                    .addComponent(jLabel2))
                                .addGroup(panel1Layout.createSequentialGroup()
                                    .addGap(44, 44, 44)
                                    .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 509, javax.swing.GroupLayout.PREFERRED_SIZE)
                                        .addComponent(jLabel1)
                                        .addGroup(panel1Layout.createSequentialGroup()
                                            .addComponent(jLabel3)
                                            .addGap(84, 84, 84)
                                            .addComponent(tfcari, javax.swing.GroupLayout.PREFERRED_SIZE, 141, javax.swing.GroupLayout.PREFERRED_SIZE)))))
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 58, Short.MAX_VALUE))
                        .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, panel1Layout.createSequentialGroup()
                            .addContainerGap()
                            .addComponent(jLabel10)
                            .addGap(131, 131, 131)))
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, panel1Layout.createSequentialGroup()
                        .addContainerGap()
                        .addComponent(jLabel4)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)))
                .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(panel1Layout.createSequentialGroup()
                        .addGap(64, 64, 64)
                        .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, panel1Layout.createSequentialGroup()
                                .addComponent(jLabel6)
                                .addGap(35, 35, 35))
                            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, panel1Layout.createSequentialGroup()
                                .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jLabel5)
                                    .addComponent(jLabel7)
                                    .addComponent(jLabel8)
                                    .addComponent(jLabel9))
                                .addGap(26, 26, 26)
                                .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                    .addComponent(tfbanyak, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .addComponent(tfoperator, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .addComponent(tfhp, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .addComponent(tfkode, javax.swing.GroupLayout.PREFERRED_SIZE, 157, javax.swing.GroupLayout.PREFERRED_SIZE)))))
                    .addGroup(panel1Layout.createSequentialGroup()
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addComponent(bexit, javax.swing.GroupLayout.PREFERRED_SIZE, 84, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGroup(panel1Layout.createSequentialGroup()
                                .addComponent(bkirim, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(6, 6, 6)
                                .addComponent(bedit, javax.swing.GroupLayout.PREFERRED_SIZE, 85, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                .addComponent(btampil, javax.swing.GroupLayout.PREFERRED_SIZE, 89, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                .addComponent(bhapus, javax.swing.GroupLayout.PREFERRED_SIZE, 84, javax.swing.GroupLayout.PREFERRED_SIZE)))))
                .addGap(35, 35, 35))
        );
        panel1Layout.setVerticalGroup(
            panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(panel1Layout.createSequentialGroup()
                .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(panel1Layout.createSequentialGroup()
                        .addGap(86, 86, 86)
                        .addComponent(jLabel2))
                    .addGroup(panel1Layout.createSequentialGroup()
                        .addGap(46, 46, 46)
                        .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(panel1Layout.createSequentialGroup()
                                .addComponent(jLabel6)
                                .addGap(33, 33, 33)
                                .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                                    .addComponent(jLabel5)
                                    .addComponent(tfkode, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGap(18, 18, 18)
                                .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                                    .addComponent(jLabel7)
                                    .addComponent(tfhp, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGap(18, 18, 18)
                                .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                                    .addComponent(jLabel8)
                                    .addComponent(tfoperator, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGap(18, 18, 18)
                                .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                                    .addComponent(jLabel9)
                                    .addComponent(tfbanyak, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGap(18, 18, 18)
                                .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(bkirim, javax.swing.GroupLayout.DEFAULT_SIZE, 47, Short.MAX_VALUE)
                                    .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                                        .addComponent(bhapus, javax.swing.GroupLayout.DEFAULT_SIZE, 47, Short.MAX_VALUE)
                                        .addComponent(bedit, javax.swing.GroupLayout.DEFAULT_SIZE, 45, Short.MAX_VALUE)
                                        .addComponent(btampil, javax.swing.GroupLayout.DEFAULT_SIZE, 45, Short.MAX_VALUE)))
                                .addGap(59, 59, 59))
                            .addGroup(panel1Layout.createSequentialGroup()
                                .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addGroup(panel1Layout.createSequentialGroup()
                                        .addComponent(jLabel1)
                                        .addGap(58, 58, 58)
                                        .addComponent(jLabel3))
                                    .addGroup(panel1Layout.createSequentialGroup()
                                        .addGap(72, 72, 72)
                                        .addComponent(tfcari, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
                                .addGap(18, 18, 18)
                                .addComponent(jLabel10)
                                .addGap(18, 18, 18)
                                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)))
                        .addGap(0, 0, 0)
                        .addGroup(panel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(bexit, javax.swing.GroupLayout.DEFAULT_SIZE, 34, Short.MAX_VALUE)
                            .addComponent(jLabel4))
                        .addGap(12, 12, 12)))
                .addGap(14, 14, 14))
        );

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(panel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(panel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );

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

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

    private void tfkodeKeyPressed(java.awt.event.KeyEvent evt) {                                 
        if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
            tfhp.requestFocus();
        }
        // TODO add your handling code here:
    }                                

    private void tfhpKeyPressed(java.awt.event.KeyEvent evt) {                               
        if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
            tfoperator.requestFocus();
        }// TODO add your handling code here:
    }                              

    private void tfoperatorKeyPressed(java.awt.event.KeyEvent evt) {                                     
        if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
            tfbanyak.requestFocus();
        }// TODO add your handling code here:
    }                                    

    private void tfbanyakKeyPressed(java.awt.event.KeyEvent evt) {                                   
        if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
            bkirim.requestFocus();
        }
        // TODO add your handling code here:
    }                                  

    private void bkirimActionPerformed(java.awt.event.ActionEvent evt) {                                      
        insertData();
        String data[] = {tfkode.getText(), tfhp.getText(), tfoperator.getText(), tfbanyak.getText()};
        dtm.addRow(data);
        kosong();
        // TODO add your handling code here:
    }                                     

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

    private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {                                    
        jTable1.getValueAt(jTable1.getSelectedRow(), 1);
        ambildata();// TODO add your handling code here:
    }                                   

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

    private void bhapusActionPerformed(java.awt.event.ActionEvent evt) {                                      
        hapusData();
        dtm.removeRow(jTable1.getSelectedRow());
        // TODO add your handling code here:
    }                                     

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

    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                new Form().setVisible(true);
            }
        });
    }
    // Variables declaration - do not modify                    
    private conter.panel.Button1 bedit;
    private conter.panel.Button1 bexit;
    private conter.panel.Button1 bhapus;
    private conter.panel.Button1 bkirim;
    private conter.panel.Button1 btampil;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JTable jTable1;
    private conter.panel.Panel panel1;
    private conter.panel.TextField1 tfbanyak;
    private conter.panel.TextField1 tfcari;
    private conter.panel.TextField1 tfhp;
    private conter.panel.TextField1 tfkode;
    private conter.panel.TextField1 tfoperator;
    // End of variables declaration                  

    public void koneksi() {
        try {
            Class.forName("org.gjt.mm.mysql.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost/conter", "root", null);
            statement = connection.createStatement();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public void closeKoneksi() {
        try {
            connection.close();
            statement.close();
        } catch (Exception ex) {
            ex.printStackTrace();

        }
    }

    public void kosong() {
        tfkode.setText("");
        tfhp.setText("");
        tfoperator.setText("");
        tfbanyak.setText("");
        tfcari.setText("");
    }

    private void insertData() {
        try {
            koneksi();
            String sql = "insert into pesan values('" + tfkode.getText() + "','" + tfhp.getText() + "','" + tfoperator.getText() + "','"
                    + tfbanyak.getText() + "')";
            statement.executeUpdate(sql);
            JOptionPane.showMessageDialog(null, "pulsa Sudah dikrim", "Information", JOptionPane.INFORMATION_MESSAGE);
        } catch (Exception ex) {
            ex.printStackTrace();
            JOptionPane.showMessageDialog(null, "Pulsa belum terkirim", "information", JOptionPane.ERROR_MESSAGE);
        }
        closeKoneksi();

    }

    private void initTable() {
        String kolom[] = {"Kode", "No HP", "Operator", "Banyaknya"};
        dtm = new DefaultTableModel(kolom, 0);
        jTable1.setModel(dtm);
        jScrollPane1.setViewportView(jTable1);
    }

    private void editData() {
        try {
            koneksi();
            String sql = "update pesan set Hp= '" + tfhp.getText() + "',operator ='" + tfoperator.getText() + "',banyak ='" + tfbanyak.getText() + "'where kode ='" + tfkode.getText() + "'";
            statement.executeUpdate(sql);
            JOptionPane.showMessageDialog(null, "Data Berhasil di ubah", "informaton ", JOptionPane.INFORMATION_MESSAGE);
        } catch (Exception ex) {
            ex.printStackTrace();
            JOptionPane.showMessageDialog(null, "Data Gagal Disimpan", "Information", JOptionPane.ERROR_MESSAGE);
        }
        closeKoneksi();
        kosong();
    }

    private void ambildata() {
        String kode = (String) jTable1.getValueAt(jTable1.getSelectedRow(), 0);
        String hp = (String) jTable1.getValueAt(jTable1.getSelectedRow(), 1);
        String operator = (String) jTable1.getValueAt(jTable1.getSelectedRow(), 2);
        String banyak = (String) jTable1.getValueAt(jTable1.getSelectedRow(), 3);
        tfkode.setText(kode);
        tfhp.setText(hp);
        tfoperator.setText(operator);
        tfbanyak.setText(banyak);
    }

    private void tampilData() {
        String data[][] = new String[6][4];
        try {
            koneksi();
            String sql = "select *from pesan ";
            resultSet = statement.executeQuery(sql);
            int n = 0;
            while (resultSet.next()) {
                data[n][0] = resultSet.getString(1);
                data[n][1] = resultSet.getString(2);
                data[n][2] = resultSet.getString(3);
                data[n][3] = resultSet.getString(4);
                n++;
            }
            String kolom[] = {"Kode", "No Hp", "Operator", "Banyaknya"};
            dtm = new DefaultTableModel(data, kolom);
            jTable1.setModel(dtm);
            jScrollPane1.setViewportView(jTable1);
            JOptionPane.showMessageDialog(null, "Data Berhasil Ditampilkan", "Information", JOptionPane.INFORMATION_MESSAGE);
        } catch (Exception ex) {
            ex.printStackTrace();
            JOptionPane.showMessageDialog(null, "Data Gagal Ditampilkan", "Information", JOptionPane.ERROR_MESSAGE);
        }
        closeKoneksi();
        kosong();
    }

    private void hapusData() {
        try {
            koneksi();
            String sql = "delete from pesan where kode ='" + tfkode.getText() + "'";
            statement.executeUpdate(sql);
            JOptionPane.showMessageDialog(null, "Data Berhasil Dihapus", "information", JOptionPane.INFORMATION_MESSAGE);
        } catch (Exception ex) {
            ex.printStackTrace();
            JOptionPane.showMessageDialog(null, "Data gagal dihapus", "Information", JOptionPane.ERROR_MESSAGE);
        }
        closeKoneksi();
        kosong();
    }

    private void cariData() {
        String data[][] = new String[6][4];
        try {
            koneksi();
            String sql = "select * from pesan where operator ='" + tfcari.getText() + "'";
            resultSet = statement.executeQuery(sql);
            int n = 0;
            while (resultSet.next()) {
                data[n][0] = resultSet.getString(1);
                data[n][1] = resultSet.getString(2);
                data[n][2] = resultSet.getString(3);
                data[n][3] = resultSet.getString(4);
                n++;
            }
            String kolom[] = {"Kode", "No HP", "Operator", "Banyaknya"};
            dtm = new DefaultTableModel(data, kolom);
            jTable1.setModel(dtm);
            jScrollPane1.setViewportView(jTable1);
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        closeKoneksi();

    }
}

screenshotnya:

selamat mencoba,,,,,,,=D
Wassalamu'alaikum wr.wb......