Buat JPanel dan beri nama "Status Cs"
Buat tampilan sperti ini:
Coding:
import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
import sql.konek;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
import sql.konek;
private Vector<Vector<String>> db = new Vector();
/**
* Creates new form status_cs
*/
public status_cs() {
initComponents();
bacaData();
}
private void bacaData() {
db.removeAll(db);
try {
Connection c = konek.getkoneksi();
Statement s = c.createStatement();
String sql = "Select * from customer where `status`=1 or `status`=2";
ResultSet r = s.executeQuery(sql);
String tem;
while (r.next()) {
Object[] o = new Object[5];
o[0] = r.getString("nama_cs");
o[1] = r.getString("no_rek");
o[2] = r.getString("status");
Vector<String> tmp2 = new Vector();
tmp2.add((String) o[0]);
tmp2.add((String) o[1]);
tmp2.add((String) o[2]);
db.add(tmp2);
}
r.close();
s.close();
} catch (Exception e) {
System.out.println(e.getMessage());
}
// norek.setText("");
}
public void exec() {
String Norek = norek.getText();
String Status = status.getText();
String aksi = "";
if (b1.isSelected()) {
aksi = "1";
} else if (b2.isSelected()) {
aksi = "2";
} else if (b3.isSelected()) {
aksi = "3";
}
try {
Connection c = konek.getkoneksi();
Statement stat = c.createStatement();
try {
String sql = "update `customer` set `status`=" + aksi + " where `no_rek`='" + Norek + "';";
stat.execute(sql);
String sql1 = "update `saldo` set `status`=" + aksi + " where `no_rek`='" + Norek + "';";
stat.execute(sql1);
stat.close();
} catch (SQLException ex) {
System.out.println(ex);
}
} catch (SQLException ex) {
}
bacaData();
}
/**
* Creates new form status_cs
*/
public status_cs() {
initComponents();
bacaData();
}
private void bacaData() {
db.removeAll(db);
try {
Connection c = konek.getkoneksi();
Statement s = c.createStatement();
String sql = "Select * from customer where `status`=1 or `status`=2";
ResultSet r = s.executeQuery(sql);
String tem;
while (r.next()) {
Object[] o = new Object[5];
o[0] = r.getString("nama_cs");
o[1] = r.getString("no_rek");
o[2] = r.getString("status");
Vector<String> tmp2 = new Vector();
tmp2.add((String) o[0]);
tmp2.add((String) o[1]);
tmp2.add((String) o[2]);
db.add(tmp2);
}
r.close();
s.close();
} catch (Exception e) {
System.out.println(e.getMessage());
}
// norek.setText("");
}
public void exec() {
String Norek = norek.getText();
String Status = status.getText();
String aksi = "";
if (b1.isSelected()) {
aksi = "1";
} else if (b2.isSelected()) {
aksi = "2";
} else if (b3.isSelected()) {
aksi = "3";
}
try {
Connection c = konek.getkoneksi();
Statement stat = c.createStatement();
try {
String sql = "update `customer` set `status`=" + aksi + " where `no_rek`='" + Norek + "';";
stat.execute(sql);
String sql1 = "update `saldo` set `status`=" + aksi + " where `no_rek`='" + Norek + "';";
stat.execute(sql1);
stat.close();
} catch (SQLException ex) {
System.out.println(ex);
}
} catch (SQLException ex) {
}
bacaData();
}
private void norekKeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
for (int i = 0; i < db.size(); i++) {
if (norek.getText().equals(db.get(i).get(1))) {
status.setText(db.get(i).get(2));
break;
} else {
status.setText("No Rekening Salah");
}
} bacaData();
}
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
if (status.getText().equals("aktif") || status.getText().equals("blokir")) {
exec();
}
}
if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
for (int i = 0; i < db.size(); i++) {
if (norek.getText().equals(db.get(i).get(1))) {
status.setText(db.get(i).get(2));
break;
} else {
status.setText("No Rekening Salah");
}
} bacaData();
}
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
if (status.getText().equals("aktif") || status.getText().equals("blokir")) {
exec();
}
}
Tidak ada komentar:
Posting Komentar