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......
Tidak ada komentar:
Posting Komentar