Membuat Project Penjualan dan Form Operator

 

Buatlah Project Penjualan denag nama Penjualan , lalu buatlah form dengan Nama form Operator dengan tampilan sbb :

Adapun pengaturan komponennya sebagai berikut :

Komponen	Properties	Isi
Jlabel	Text	Kode Operator
Jlabel	Text	Nama Operator
Jlabel	Text	Jenis Kelamin
Jlabel	Text	Alamat
Jlabel	Text	User Name
Jlabel	Text	Password
JTextField	Name	txtko
	Text	Kosongkan
JTextField	Name	txtno
	Text	Kosongkan
JTextField	Name	txtal
	Text	Kosongkan
JTextField	Name	txtun
	Text	Kosongkan
JPasswordField	Name	txtpass
	Text	Kosongkan
JRadioButton	Name	rdpria
	Text	Pria
JRadioButton	Name	rdwanita
	Text	Wanita
JscrolPane	Name	JscrolPane1
JTable	Name	TBoperator
	Text	Kosongkan
Jbutton	Name	bsimpan
	Text	Simpan
Jbutton	Name	bhapus
	Text	Hapus
Jbutton	Name	Bkeluar
	Text	Keluar

Berikut Kode Programnya :

package penjualan;

import javax.swing.JTable.*;

import javax.swing.table.DefaultTableModel;

import javax.swing.JOptionPane;

import java.text.*;

import java.sql.*;

import java.util.Date.*;

/**

*

* @author nhyenx

*/

public class operator extends javax.swing.JFrame {

String[] judul={"Kode Operator","Nama Operator","Kelamin","Alamat","Username"};

DefaultTableModel DTM;

/** Creates new form operator */

public operator() {

DTM=new DefaultTableModel(null,judul){

public boolean iscellEditable(int now,int coloum){

return false;

}

};

initComponents();

kosong();

filltable();

}

Kode Untuk Tombol Keluar :

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

// TODO add your handling code here:

if(bkeluar.getText().equals("Keluar")){

dispose();

setVisible(false);

}

else

kosong();

}

Kode Untuk Kode Operator sbb :

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

// TODO add your handling code here:

try{

conekdb getCn=new conekdb();

Connection Cn=getCn.konek();

Statement st=Cn.createStatement();

String SQL="SELECT *FROM operator WHERE kdoperator= '"+txtko.getText().trim()+"'";

ResultSet rs=st.executeQuery(SQL);

if(rs.next()){

JOptionPane.showMessageDialog(null,"Data Sudah ada");

txtno.setText(""+rs.getString("nmoperator"));

if(rs.getString("Kelamin").equals("L"))

rdpria.setSelected(true);

else

rdwanita.setSelected(true);

txtal.setText(""+rs.getString("alamat"));

txtun.setText(""+rs.getString("userid"));

txtpass.setText(""+rs.getString("passid"));

bsimpan.setText("Update");

bhapus.setEnabled(true);

}else{

bsimpan.setText("Simpan");

JOptionPane.showMessageDialog(null,"Data Baru");

}

bsimpan.setEnabled(true);

bkeluar.setText("Batal");

st.close();

Cn.close();

rs.close();

}catch(Exception exc){

System.err.println(exc.getMessage());

}

txtno.requestFocus();

}

Kode untuk Tombol Simpan sbb :

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

// TODO add your handling code here:

if(txtko.getText().equals(""))

JOptionPane.showMessageDialog(null,"Isi Data Operator dengan lengkap");

else{

String kel="";

if(rdpria.isSelected()==true)

kel="L";

else

kel="P";

Data clsData=new Data();

String SQL="";

if(bsimpan.getText().equals("Simpan")){

SQL=" INSERT INTO operator VALUES('"+txtko.getText().trim()+"','"+txtno.getText().trim()+"','"+kel+"','"+txtal.getText().trim()+"','"+txtun.getText().trim()+"','"+txtpass.getText().trim()+"')";

clsData.ExecuteSQL(SQL);

}

else{

SQL="UPDATE operator SET nmoperator='"+txtno.getText().trim()+"',kelamin='"+kel+"',alamat='"+txtal.getText().trim()+"', userid='"+txtun.getText().trim()+"',passid='"+txtpass.getText().trim()+"' WHERE kdoperator = '"+txtko.getText().trim()+"'";

clsData.ExecuteSQL(SQL);

}

clsData=null;

kosong();

filltable();

}

}

Kode untuk Tombol Hapus sbb :

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

// TODO add your handling code here:

try{

conekdb getCn= new conekdb();

Connection Cn=getCn.konek();

Statement st=Cn.createStatement();

String SQL="DELETE FROM operator WHERE kdoperator='"+txtko.getText().trim()+"'";

st.executeUpdate(SQL);

st.close();

Cn.close();

kosong();

JOptionPane.showMessageDialog(null, "Delete berhasil");

}catch(Exception e){

JOptionPane.showMessageDialog(null,"Proses hapus Gagal !!");

System.err.println(e.getMessage());

}

filltable();

}

Kode untuk Prosedur kosong sbb :

void kosong(){

txtko.setText("");

txtno.setText("");

rdpria.setSelected(true);

rdwanita.setSelected(false);

txtal.setText("");

txtun.setText("");

txtpass.setText("");

bsimpan.setEnabled(false);

bhapus.setEnabled(false);

bkeluar.setEnabled(true);

bsimpan.setText("Simpan");

bkeluar.setText("Keluar");

txtko.requestFocus();

}

Kode untuk Prosedur filltable sbb :

void filltable(){

String SQL="SELECT *FROM operator";

DTM.setRowCount(0);

try{

conekdb getCn=new conekdb();

Connection Cn = getCn.konek();

Statement st=Cn.createStatement();

ResultSet rs=st.executeQuery(SQL);

while(rs.next())

{

String vkdoperator=rs.getString("kdoperator");

String vnmoperator=rs.getString("nmoperator");

String valamat=rs.getString("alamat");

String vkelamin=rs.getString("kelamin");

String kel="";

if (vkelamin.equals("L"))

kel="Laki-laki";

else

kel="Wanita";

String vusername=rs.getString("userid");

String[]data={vkdoperator,vnmoperator,kel,valamat,vusername};

DTM.addRow(data);

}

st.close();

Cn.close();

rs.close();

TBoperator.setModel(DTM);

}catch(SQLException e){

}

}