Java
Interfacenya :
Rancangannya (mengunakan Tool Pemrograman IDE Neatbeans 6.9.1) :
2. Saat di Run (dijalankan)
Untuk mendapatkan kode programnya dapat dilihat di
Kode Program (listing kode) nya :
FormBarang.java
/*
* To change this
template, choose Tools | Templates
* and open the
template in the editor.
*/
/*
* Formbrgptt.java
*
* Created on 04 Mei
11, 4:33:28
*/
package javaapplicationpenjualantunai;
import java.lang.String.*;
import javax.swing.ImageIcon;
import java.io.InputStream.*;
import java.io.*;
import net.sf.jasperreports.view.JasperViewer;
import java.text.*;
import java.sql.*;
import javax.swing.JOptionPane;
import java.sql.Connection;
import java.sql.DriverManager.*;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.*;
import java.io.File.*;
import java.awt.*;
import java.lang.String.*;
import javax.swing.ImageIcon;
import java.io.InputStream.*;
import java.io.*;
import net.sf.jasperreports.*;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperRunManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperManager;
import javax.swing.event.TableModelEvent.*;
import javax.swing.table.*;
import javax.swing.table.AbstractTableModel.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableCellRenderer.*;
import javax.swing.*;
import javax.swing.JFileChooser.*;
import javax.swing.table.TableCellRenderer.*;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.export.JRXlsExporter;
//import java.io.FileNotFoundException;
//import java.util.HashMap;
//import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.engine.JasperPrintManager;
/**
*
* @author Tasik
*/
public class FormBarang extends javax.swing.JFrame {
Connection con;
String
url,db,driver;
public Statement
stat;
public ResultSet
rs;
int count;
int count2;
int iLength;
ImageIcon ii;
Blob pic;
Image image;
String user;
String paswd;
public void
connect(){
con=null;
url="jdbc:mysql://localhost:3306/";
db="ptun";
driver="com.mysql.jdbc.Driver";
try{
Class.forName(driver);
}catch(ClassNotFoundException cnfe){
System.err.println("Class driver tidak ada :
"+cnfe.getMessage());
}
}
public void
connect2(){
try{
user
="root";
paswd="awsm";
}catch(Exception ee){
ee.printStackTrace();
}
}
public void
connectTodatabase(){
try{
Class.forName(driver);
con=DriverManager.getConnection(url+db,user,paswd);
}catch(Exception ee){
ee.printStackTrace();
}
}
public void
querystring(){
try{
stat=con.createStatement();
rs=stat.executeQuery("select
kbrgptun,nmbrgptun,typebrgptun,pictfilebrgptun,vabrgptun,pictfilewebbrgptun,barcode
from brgptun");
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}
public void
querystringfilter(){
try{
String
tk7=jTextField7.getText();
stat=con.createStatement();
rs=stat.executeQuery("select kbrgptun,nmbrgptun,typebrgptun,pictfilebrgptun,vabrgptun,pictfilewebbrgptun,barcode
from brgptun where nmbrgptun like '"+ tk7 +"' ");
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}
public void
querystringsortnamabarang(){
try{
stat=con.createStatement();
rs=stat.executeQuery("select
kbrgptun,nmbrgptun,typebrgptun,pictfilebrgptun,vabrgptun,pictfilewebbrgptun,barcode
from brgptun order by nmbrgptun");
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}
public void
tampildata(){
try{
String
t1=rs.getString(1);
String t2=rs.getString(2);
String t3=rs.getString(3);
String t4=rs.getString(4);
String t5=rs.getString(5);
String t6=rs.getString(6);
String t7=rs.getString(7);
jTextField1.setText(t1);
jTextField2.setText(t2);
jTextField3.setText(t3);
jTextField4.setText(t4);
jTextField5.setText(t5);
jTextField6.setText(t6);
jTextField10.setText(t7);
}catch(Exception e){
e.printStackTrace();
}
}
//------------------------------------------------------------------------
public void
lebarkolomgrid(){
TableColumn
column = null;
for (int i = 0; i < 7; i++) {
column = jTable1.getColumnModel().getColumn(i);
if
(i == 1) {
column.setPreferredWidth(200); //sport column is bigger
}
else if(i == 3) {
column.setPreferredWidth(100); //sport column is bigger
}
else {
column.setPreferredWidth(0);
}
}
}
public void
ref(){
connect();
count=1;
try{
connect2();
connectTodatabase();
try{
querystring();
while
(rs.next()){
String t1=rs.getString(1);
String t2=rs.getString(2);
String t3=rs.getString(3);
String t4=rs.getString(4);
String t5=rs.getString(5);
String t6=rs.getString(6);
String t7=rs.getString(7);
count++;
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][] oo={{t1,t2,t3,t4,t5,t6,t7}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
//DefaultTableModel tableModel = new DefaultTableModel();
while (rs.next()){
count++;
String[] data = new String[7];
data [0]=rs.getString(1);
data [1]=rs.getString(2);
data [2]=rs.getString(3);
data [3]=rs.getString(4);
data [4]=rs.getString(5);
data [5]=rs.getString(6);
data [6]=rs.getString(7);
tableModel.addRow(data);
}
jTable1.setModel(tableModel);
lebarkolomgrid();
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void
refsortnamabarang(){
connect();
count=1;
try{
connect2();
connectTodatabase();
try{
querystringsortnamabarang();
while
(rs.next()){
String
t1=rs.getString(1);
String t2=rs.getString(2);
String t3=rs.getString(3);
String t4=rs.getString(4);
String t5=rs.getString(5);
String t6=rs.getString(6);
String t7=rs.getString(7);
count++;
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][] oo={{t1,t2,t3,t4,t5,t6,t7}};
String[] jj2={"Nama Barang"};
Object[][] oo2={{t2}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
DefaultTableModel tableModel2 = new DefaultTableModel(oo2,jj2);
while (rs.next()){
count++;
String[] data = new String[7];
String[] data2 = new String[7];
data [0]=rs.getString(1);
data [1]=rs.getString(2);
data [2]=rs.getString(3);
data [3]=rs.getString(4);
data [4]=rs.getString(5);
data [5]=rs.getString(6);
data [6]=rs.getString(7);
tableModel.addRow(data);
data2 [0]=rs.getString(2);
tableModel2.addRow(data2);
}
jTable1.setModel(tableModel);
jTable3.setModel(tableModel2);
lebarkolomgrid();
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void refjtable2(){
String vv =
jTextField7.getText();
if
(vv.equals("")){
connect();
count=1;
try{
connect2();
connectTodatabase();
try{
stat=con.createStatement();
rs=stat.executeQuery("select kbrgptun from brgptun");
while
(rs.next()){
String t1=rs.getString(1);
count++;
String[] jj={"Kode Barang"};
Object[][] oo={{t1}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
while (rs.next()){
count++;
String[] data = new String[1];
data [0]=rs.getString(1);
tableModel.addRow(data);
}
jTable2.setModel(tableModel);
}
stat.close();
con.close();
}catch(SQLException
s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
else{
connect();
count2=1;
try{
connect2();
connectTodatabase();
try{
String
tk7=jTextField7.getText();
stat=con.createStatement();
rs=stat.executeQuery("select kbrgptun from brgptun where nmbrgptun
like '"+ tk7 +"' ");
while
(rs.next()){
String t1=rs.getString(1);
count2++;
String[] jj={"Kode Barang"};
Object[][] oo={{t1}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
while (rs.next()){
count2++;
String[] data = new String[1];
data [0]=rs.getString(1);
tableModel.addRow(data);
}
jTable2.setModel(tableModel);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
}
public void refjtable3(){
connect();
count=1;
try{
connect2();
connectTodatabase();
try{
stat=con.createStatement();
rs=stat.executeQuery("select nmbrgptun from brgptun");
while
(rs.next()){
String t1=rs.getString(1);
count++;
String[] jj={"Nama Barang"};
Object[][] oo={{t1}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
while (rs.next()){
count++;
String[] data = new String[1];
data [0]=rs.getString(1);
tableModel.addRow(data);
}
jTable3.setModel(tableModel);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void refjtable4(){
String vv =
jTextField7.getText();
if
(vv.equals("")){
connect();
count=1;
try{
connect2();
connectTodatabase();
try{
stat=con.createStatement();
rs=stat.executeQuery("select barcode from brgptun");
while
(rs.next()){
String t1=rs.getString(1);
count++;
String[] jj={"Barcode"};
Object[][] oo={{t1}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
while (rs.next()){
count++;
String[] data = new String[1];
data [0]=rs.getString(1);
tableModel.addRow(data);
}
jTable4.setModel(tableModel);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
else{
connect();
count2=1;
try{
connect2();
connectTodatabase();
try{
String
tk7=jTextField7.getText();
stat=con.createStatement();
rs=stat.executeQuery("select barcode from brgptun where nmbrgptun like
'"+ tk7 +"' ");
while
(rs.next()){
String t1=rs.getString(1);
count2++;
String[] jj={"Barcode"};
Object[][] oo={{t1}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
while (rs.next()){
count2++;
String[] data = new String[1];
data [0]=rs.getString(1);
tableModel.addRow(data);
}
jTable4.setModel(tableModel);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
}
public void refnumber(){
// TODO add your
handling code here:
connect();
try{
connect2();
connectTodatabase();
try{
stat=con.createStatement();
rs=stat.executeQuery("select count(*) as cc from brgptun");
while
(rs.next()){
String ss =rs.getString(1);
jLabel11.setText(ss);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void refnumber2(){
// TODO add your
handling code here:
connect();
try{
connect2();
connectTodatabase();
try{
String
tk7=jTextField7.getText();
stat=con.createStatement();
rs=stat.executeQuery("select count(*) as cc from brgptun where
nmbrgptun like '"+ tk7 +"' ");
while (rs.next()){
String ss =rs.getString(1);
jLabel11.setText(ss);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void mouseklik1(){
connect();
count=jTable1.getSelectedRow()+1;
try{
connect2();
connectTodatabase();
try{
querystring();
for(int
i=0;i<count;i++){
if
(rs.next()){
tampildata();
}
}
String ss =Integer.toString(count);
jLabel9.setText(ss);
int
nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
imagerecord();
}
public void mouseklik2filter(){
connect();
int countmk2;
countmk2=jTable1.getSelectedRow()+1;
try{
connect2();
connectTodatabase();
try{
querystringfilter();
for(int i=0;i<countmk2;i++){
if
(rs.next()){
tampildata();
}
}
String ss =Integer.toString(countmk2);
jLabel9.setText(ss);
int
nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
imagerecord();
}
public void mousekliksort(){
connect();
count=jTable1.getSelectedRow()+1;
try{
connect2();
connectTodatabase();
try{
querystringsortnamabarang();
for(int
i=0;i<count;i++){
if
(rs.next()){
tampildata();
}
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
imagerecord();
}
public void f1(){
connect();
count2=0;
try{
connect2();
connectTodatabase();
try{
querystringfilter();
while
(rs.next()){
String t1=rs.getString(1);
String t2=rs.getString(2);
String t3=rs.getString(3);
String t4=rs.getString(4);
String t5=rs.getString(5);
String t6=rs.getString(6);
String t7=rs.getString(7);
jTextField1.setText(t1);
jTextField2.setText(t2);
jTextField3.setText(t3);
jTextField4.setText(t4);
jTextField5.setText(t5);
jTextField6.setText(t6);
jTextField10.setText(t7);
count2++;
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][] oo={{t1,t2,t3,t4,t5,t6,t7}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
while (rs.next()){
count2++;
String[] data = new String[7];
data [0]=rs.getString(1);
data [1]=rs.getString(2);
data [2]=rs.getString(3);
data [3]=rs.getString(4);
data [4]=rs.getString(5);
data [5]=rs.getString(6);
data [6]=rs.getString(7);
tableModel.addRow(data);
}
jTable1.setModel(tableModel);
lebarkolomgrid();
refjtable2();
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement
is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
imagerecord();
}
public void r1(){
connect();
count=1;
try{
connect2();
connectTodatabase();
try{
querystring();
if
(rs.next()){
tampildata();
String ss =Integer.toString(count);
jLabel9.setText(ss);
jTable1.setRowSelectionInterval(0, 0);
jTable1.setLocation(0,0);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
imagerecord();
}
public void imagerecord(){
connect();
int cco;
cco=1;
try{
connect2();
connectTodatabase();
try{
String tk1=jTextField1.getText();
stat=con.createStatement();
rs=stat.executeQuery("select kbrgptun,pictbrgptun from brgptun
where kbrgptun like '"+ tk1 +"' ");
for(int i=0;i<cco;i++){
if
(rs.next()){
//while (rs.next()){
Long iLength2;
pic=(Blob)rs.getBlob(2);
iLength2=(long)(pic.length());
int iLengthx;
String bbb
=iLength2.toString();
iLengthx=Integer.parseInt(bbb);
ii=new ImageIcon(pic.getBytes(1,iLengthx));
jLabel8.setIcon(ii);
}
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(NullPointerException ee){
jLabel8.setIcon(null);
}
catch(Exception e){
e.printStackTrace();
}
}
public void refn(){
connect();
int ccco;
ccco=1;
try{
connect2();
connectTodatabase();
try{
querystring();
while
(rs.next()){
String t1=rs.getString(1);
String t2=rs.getString(2);
String t3=rs.getString(3);
String t4=rs.getString(4);
String t5=rs.getString(5);
String t6=rs.getString(6);
String t7=rs.getString(7);
ccco++;
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][] oo={{t1,t2,t3,t4,t5,t6,t7}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
//DefaultTableModel tableModel = new DefaultTableModel();
while (rs.next()){
ccco++;
String[] data = new String[7];
data
[0]=rs.getString(1);
data [1]=rs.getString(2);
data [2]=rs.getString(3);
data [3]=rs.getString(4);
data [4]=rs.getString(5);
data [5]=rs.getString(6);
data [6]=rs.getString(7);
tableModel.addRow(data);
}
jTable1.setModel(tableModel);
lebarkolomgrid();
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void
refnfilter(){
connect();
int ccco;
ccco=1;
try{
connect2();
connectTodatabase();
try{
querystringfilter();
while
(rs.next()){
String t1=rs.getString(1);
String t2=rs.getString(2);
String t3=rs.getString(3);
String t4=rs.getString(4);
String t5=rs.getString(5);
String t6=rs.getString(6);
String t7=rs.getString(7);
ccco++;
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][]
oo={{t1,t2,t3,t4,t5,t6,t7}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
//DefaultTableModel tableModel = new DefaultTableModel();
while (rs.next()){
ccco++;
String[] data = new String[7];
data [0]=rs.getString(1);
data [1]=rs.getString(2);
data [2]=rs.getString(3);
data [3]=rs.getString(4);
data [4]=rs.getString(5);
data [5]=rs.getString(6);
data [6]=rs.getString(7);
tableModel.addRow(data);
}
jTable1.setModel(tableModel);
lebarkolomgrid();
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void refnumbern(){
// TODO add your
handling code here:
connect();
try{
connect2();
connectTodatabase();
try{
stat=con.createStatement();
rs=stat.executeQuery("select count(*) as cc from brgptun");
while
(rs.next()){
String ss =rs.getString(1);
jLabel11.setText(ss);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void
countfilter(){
connect();
int ccco;
ccco=0;
try{
connect2();
connectTodatabase();
try{
String
tk7=jTextField7.getText();
stat=con.createStatement();
rs=stat.executeQuery("select count(*) from brgptun where nmbrgptun
like '"+ tk7 +"' ");
while
(rs.next()){
String tc=rs.getString(1);
jLabel17.setText(tc);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void rn(){
connect();
count=0;
try{
connect2();
connectTodatabase();
try{
querystring();
while (rs.next()){
tampildata();
count++;
String ss =Integer.toString(count);
jLabel9.setText(ss);
int nnnn =Integer.parseInt(jLabel11.getText());
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
public void imageform(){
Toolkit tool
=Toolkit.getDefaultToolkit();
image=tool.getImage("C:/Documents and Settings/agus/My
Documents/NetBeansProjects/JavaApplicationPtun/src/javaapplicationptun/ico/actifast.gif");
FormBarang.this.setIconImage(image);
}
/** Creates new
form Formbrgptt */
public
FormBarang() {
initComponents();
imageform();
ref();
refnumber();
refjtable2();
refjtable3();
refjtable4();
jButton6.setEnabled(false);
r1();
jButton20.setEnabled(false);
}
/** 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() {
jPanel1 = new
javax.swing.JPanel();
jLabel7 = new
javax.swing.JLabel();
jPanel4 = new
javax.swing.JPanel();
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();
jTextField1 =
new javax.swing.JTextField();
jTextField2 =
new javax.swing.JTextField();
jTextField3 =
new javax.swing.JTextField();
jTextField4 =
new javax.swing.JTextField();
jTextField5 =
new javax.swing.JTextField();
jTextField6 =
new javax.swing.JTextField();
jLabel9 = new
javax.swing.JLabel();
jLabel10 = new
javax.swing.JLabel();
jLabel11 = new
javax.swing.JLabel();
jButton21 =
new javax.swing.JButton();
jTextField10 =
new javax.swing.JTextField();
jLabel20 = new
javax.swing.JLabel();
jPanel7 = new
javax.swing.JPanel();
jTabbedPane1 =
new javax.swing.JTabbedPane();
jPanel2 = new
javax.swing.JPanel();
jButton14 =
new javax.swing.JButton();
jTextField9 =
new javax.swing.JTextField();
jLabel14 = new
javax.swing.JLabel();
jScrollPane2 =
new javax.swing.JScrollPane();
jTable2 = new
javax.swing.JTable();
jPanel8 = new
javax.swing.JPanel();
jScrollPane3 =
new javax.swing.JScrollPane();
jTable3 = new
javax.swing.JTable();
jButton17 =
new javax.swing.JButton();
jTextField8 =
new javax.swing.JTextField();
jButton18 =
new javax.swing.JButton();
jPanel10 = new
javax.swing.JPanel();
jLabel21 = new
javax.swing.JLabel();
jTextField11 = new javax.swing.JTextField();
jButton22 =
new javax.swing.JButton();
jScrollPane5 =
new javax.swing.JScrollPane();
jTable4 = new
javax.swing.JTable();
jTabbedPane3 =
new javax.swing.JTabbedPane();
jPanel6 = new
javax.swing.JPanel();
jTextField7 =
new javax.swing.JTextField();
jButton10 =
new javax.swing.JButton();
jButton13 =
new javax.swing.JButton();
jButton11 =
new javax.swing.JButton();
jLabel13 = new
javax.swing.JLabel();
jPanel3 = new
javax.swing.JPanel();
jButton15 =
new javax.swing.JButton();
jButton16 =
new javax.swing.JButton();
jLabel22 = new
javax.swing.JLabel();
jPanel9 = new
javax.swing.JPanel();
jButton19 =
new javax.swing.JButton();
jButton20 =
new javax.swing.JButton();
jLabel15 = new
javax.swing.JLabel();
jLabel12 = new
javax.swing.JLabel();
jLabel17 = new
javax.swing.JLabel();
jLabel18 = new
javax.swing.JLabel();
jLabel19 = new
javax.swing.JLabel();
jPanel5 = new
javax.swing.JPanel();
jButton5 = new
javax.swing.JButton();
jButton6 = new
javax.swing.JButton();
jButton7 = new
javax.swing.JButton();
jButton8 = new
javax.swing.JButton();
jButton1 = new
javax.swing.JButton();
jButton2 = new
javax.swing.JButton();
jButton3 = new
javax.swing.JButton();
jButton4 = new
javax.swing.JButton();
jButton12 =
new javax.swing.JButton();
jButton9 = new
javax.swing.JButton();
jScrollPane1 =
new javax.swing.JScrollPane();
jTable1 = new
javax.swing.JTable();
jScrollPane4 =
new javax.swing.JScrollPane();
jLabel8 = new
javax.swing.JLabel();
jLabel16 = new javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("Form Barang");
jPanel1.setForeground(javax.swing.UIManager.getDefaults().getColor("InternalFrame.inactiveTitleGradient"));
jPanel1.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jLabel7.setFont(new java.awt.Font("Arial", 1, 18));
jLabel7.setText("DAFTAR BARANG");
jPanel1.add(jLabel7, new
org.netbeans.lib.awtextra.AbsoluteConstraints(393, 36, -1, 25));
jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createEtchedBorder(),
"Input Data"));
jPanel4.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jPanel4.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jLabel1.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel1.setText("Kode
Barang");
jPanel4.add(jLabel1, new
org.netbeans.lib.awtextra.AbsoluteConstraints(20, 30, -1, -1));
jLabel2.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel2.setText("Nama Barang");
jPanel4.add(jLabel2,
new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 70, -1, -1));
jLabel3.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel3.setText("Type Barang");
jPanel4.add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(20,
110, -1, -1));
jLabel4.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel4.setText("File Gambar");
jPanel4.add(jLabel4, new
org.netbeans.lib.awtextra.AbsoluteConstraints(20, 150, -1, -1));
jLabel5.setFont(new
java.awt.Font("Microsoft Sans Serif", 0, 11));
jLabel5.setText("VA Barang");
jPanel4.add(jLabel5, new
org.netbeans.lib.awtextra.AbsoluteConstraints(20, 190, -1, -1));
jLabel6.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel6.setText("File Gambar Web");
jPanel4.add(jLabel6, new
org.netbeans.lib.awtextra.AbsoluteConstraints(20, 230, -1, -1));
jTextField1.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jTextField1ActionPerformed(evt);
}
});
jPanel4.add(jTextField1, new org.netbeans.lib.awtextra.AbsoluteConstraints(170,
30, 156, -1));
jPanel4.add(jTextField2, new
org.netbeans.lib.awtextra.AbsoluteConstraints(170, 70, 180, -1));
jPanel4.add(jTextField3, new
org.netbeans.lib.awtextra.AbsoluteConstraints(170, 110, 180, -1));
jTextField4.addActionListener(new
java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jTextField4ActionPerformed(evt);
}
});
jPanel4.add(jTextField4, new org.netbeans.lib.awtextra.AbsoluteConstraints(170,
150, 140, -1));
jPanel4.add(jTextField5, new
org.netbeans.lib.awtextra.AbsoluteConstraints(170, 190, 180, -1));
jPanel4.add(jTextField6, new
org.netbeans.lib.awtextra.AbsoluteConstraints(170, 230, 180, -1));
jLabel9.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel9.setText("0");
jPanel4.add(jLabel9, new
org.netbeans.lib.awtextra.AbsoluteConstraints(170, 310, 93, -1));
jLabel10.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel10.setText("dari");
jPanel4.add(jLabel10, new
org.netbeans.lib.awtextra.AbsoluteConstraints(270, 310, -1, -1));
jLabel11.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel11.setText("0");
jPanel4.add(jLabel11, new
org.netbeans.lib.awtextra.AbsoluteConstraints(300, 310, 62, -1));
jButton21.setText("...");
jButton21.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton21ActionPerformed(evt);
}
});
jPanel4.add(jButton21, new
org.netbeans.lib.awtextra.AbsoluteConstraints(320, 150, 39, -1));
jPanel4.add(jTextField10, new
org.netbeans.lib.awtextra.AbsoluteConstraints(170, 270, 180, -1));
jLabel20.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel20.setText("Barcode");
jPanel4.add(jLabel20, new
org.netbeans.lib.awtextra.AbsoluteConstraints(20, 270, -1, -1));
jPanel1.add(jPanel4, new
org.netbeans.lib.awtextra.AbsoluteConstraints(27, 90, 370, 340));
jPanel7.setBorder(javax.swing.BorderFactory.createEtchedBorder());
jTabbedPane1.setFont(new
java.awt.Font("Microsoft Sans Serif", 0, 11)); // NOI18N
jPanel2.setFont(new java.awt.Font("Tahoma", 1, 11));
jButton14.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton14.setText("Cari");
jButton14.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton14ActionPerformed(evt);
}
});
jLabel14.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel14.setText("Cari Kode Barang =");
jTable2.setModel(new javax.swing.table.DefaultTableModel(
new Object
[][] {
{},
{},
{},
{}
},
new String
[] {
}
));
jScrollPane2.setViewportView(jTable2);
javax.swing.GroupLayout jPanel2Layout = new
javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField9, javax.swing.GroupLayout.DEFAULT_SIZE, 197,
Short.MAX_VALUE)
.addComponent(jLabel14)
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(jButton14)
.addGap(18, 18, 18)
.addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 128,
Short.MAX_VALUE)))
.addContainerGap())
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel14)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jTextField9, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jButton14)
.addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 85,
Short.MAX_VALUE))
.addContainerGap())
);
jTabbedPane1.addTab("Cari", jPanel2);
jPanel8.setFont(new
java.awt.Font("Microsoft Sans Serif", 0, 11)); // NOI18N
jPanel8.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jTable3.setModel(new javax.swing.table.DefaultTableModel(
new Object
[][] {
{},
{},
{},
{}
},
new String
[] {
}
));
jScrollPane3.setViewportView(jTable3);
jPanel8.add(jScrollPane3, new org.netbeans.lib.awtextra.AbsoluteConstraints(118,
37, 89, 110));
jButton17.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton17.setText("Cari & Sort");
jButton17.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton17ActionPerformed(evt);
}
});
jPanel8.add(jButton17, new
org.netbeans.lib.awtextra.AbsoluteConstraints(10, 37, 102, -1));
jPanel8.add(jTextField8, new
org.netbeans.lib.awtextra.AbsoluteConstraints(10, 11, 197, -1));
jButton18.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11)); // NOI18N
jButton18.setText("End");
jButton18.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton18ActionPerformed(evt);
}
});
jPanel8.add(jButton18, new
org.netbeans.lib.awtextra.AbsoluteConstraints(10, 70, -1, -1));
jTabbedPane1.addTab("Cari & Sort =", jPanel8);
jPanel10.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel21.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11)); // NOI18N
jLabel21.setText("Cari Barcode disini =");
jButton22.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton22.setText("Cari");
jButton22.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton22ActionPerformed(evt);
}
});
jTable4.setModel(new javax.swing.table.DefaultTableModel(
new Object
[][] {
{},
{},
{},
{}
},
new String
[] {
}
));
jScrollPane5.setViewportView(jTable4);
javax.swing.GroupLayout jPanel10Layout = new
javax.swing.GroupLayout(jPanel10);
jPanel10.setLayout(jPanel10Layout);
jPanel10Layout.setHorizontalGroup(
jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel10Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTextField11, javax.swing.GroupLayout.DEFAULT_SIZE, 197,
Short.MAX_VALUE)
.addComponent(jLabel21)
.addGroup(jPanel10Layout.createSequentialGroup()
.addComponent(jButton22)
.addGap(18, 18, 18)
.addComponent(jScrollPane5, javax.swing.GroupLayout.DEFAULT_SIZE, 128,
Short.MAX_VALUE)))
.addContainerGap())
);
jPanel10Layout.setVerticalGroup(
jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel10Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel21)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jTextField11, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jButton22)
.addComponent(jScrollPane5, javax.swing.GroupLayout.DEFAULT_SIZE, 85,
Short.MAX_VALUE))
.addContainerGap())
);
jTabbedPane1.addTab("Cari Barcode", jPanel10);
jTabbedPane3.setFont(new java.awt.Font("Microsoft Sans Serif",
0, 11));
jTextField7.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jTextField7ActionPerformed(evt);
}
});
jTextField7.addFocusListener(new java.awt.event.FocusAdapter() {
public
void focusLost(java.awt.event.FocusEvent evt) {
jTextField7FocusLost(evt);
}
});
jButton10.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton10.setText("Filter");
jButton10.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton10ActionPerformed(evt);
}
});
jButton13.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton13.setText("Report Filter");
jButton13.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton13ActionPerformed(evt);
}
});
jButton11.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton11.setText("End Filter");
jButton11.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton11ActionPerformed(evt);
}
});
jLabel13.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11)); // NOI18N
jLabel13.setText("Filter berdasarkan Nama Barang =");
javax.swing.GroupLayout jPanel6Layout = new
javax.swing.GroupLayout(jPanel6);
jPanel6.setLayout(jPanel6Layout);
jPanel6Layout.setHorizontalGroup(
jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel6Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel6Layout.createSequentialGroup()
.addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jTextField7,
javax.swing.GroupLayout.DEFAULT_SIZE, 191, Short.MAX_VALUE)
.addGroup(jPanel6Layout.createSequentialGroup()
.addComponent(jButton10, javax.swing.GroupLayout.PREFERRED_SIZE, 82,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(jButton11, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jButton13, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
.addContainerGap(33, Short.MAX_VALUE))
.addGroup(jPanel6Layout.createSequentialGroup()
.addComponent(jLabel13)
.addContainerGap(63, Short.MAX_VALUE))))
);
jPanel6Layout.setVerticalGroup(
jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel6Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel13)
.addGap(18, 18, 18)
.addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton10)
.addComponent(jButton11))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 20,
Short.MAX_VALUE)
.addComponent(jButton13)
.addContainerGap())
);
jTabbedPane3.addTab("Filter Nama Barang", jPanel6);
jPanel3.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11)); // NOI18N
jButton15.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton15.setText("Sort");
jButton15.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton15ActionPerformed(evt);
}
});
jButton16.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton16.setText("End Sort");
jButton16.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton16ActionPerformed(evt);
}
});
jLabel22.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11)); // NOI18N
jLabel22.setText("Sort
berdasarkan Nama Barang =");
javax.swing.GroupLayout jPanel3Layout = new
javax.swing.GroupLayout(jPanel3);
jPanel3.setLayout(jPanel3Layout);
jPanel3Layout.setHorizontalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
jPanel3Layout.createSequentialGroup()
.addContainerGap(62, Short.MAX_VALUE)
.addComponent(jButton15)
.addGap(18, 18, 18)
.addComponent(jButton16)
.addGap(30, 30, 30))
.addGroup(jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel22)
.addContainerGap(66, Short.MAX_VALUE))
);
jPanel3Layout.setVerticalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel22)
.addGap(10, 10, 10)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton16)
.addComponent(jButton15))
.addContainerGap(100, Short.MAX_VALUE))
);
jTabbedPane3.addTab("Sort", jPanel3);
jButton19.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton19.setText("Siap
Delete All");
jButton19.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton19ActionPerformed(evt);
}
});
jButton20.setFont(new
java.awt.Font("Microsoft Sans Serif", 0, 11));
jButton20.setText("Delete All");
jButton20.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton20ActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel9Layout = new
javax.swing.GroupLayout(jPanel9);
jPanel9.setLayout(jPanel9Layout);
jPanel9Layout.setHorizontalGroup(
jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel9Layout.createSequentialGroup()
.addGroup(jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel9Layout.createSequentialGroup()
.addGap(65, 65, 65)
.addComponent(jButton19))
.addGroup(jPanel9Layout.createSequentialGroup()
.addGap(77, 77, 77)
.addComponent(jButton20)))
.addContainerGap(68, Short.MAX_VALUE))
);
jPanel9Layout.setVerticalGroup(
jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel9Layout.createSequentialGroup()
.addGap(21, 21, 21)
.addComponent(jButton19)
.addGap(18, 18, 18)
.addComponent(jButton20)
.addContainerGap(73, Short.MAX_VALUE))
);
jTabbedPane3.addTab("Delete All", jPanel9);
jLabel15.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel15.setText("Record/ baris ke =");
jLabel12.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel12.setText("0");
jLabel17.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel18.setFont(new
java.awt.Font("Microsoft Sans Serif", 0, 11));
jLabel18.setText("Record");
jLabel19.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jLabel19.setText("Ada :");
javax.swing.GroupLayout jPanel7Layout = new javax.swing.GroupLayout(jPanel7);
jPanel7.setLayout(jPanel7Layout);
jPanel7Layout.setHorizontalGroup(
jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel7Layout.createSequentialGroup()
.addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 222,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel7Layout.createSequentialGroup()
.addComponent(jLabel15)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel12, javax.swing.GroupLayout.PREFERRED_SIZE, 93,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(10, 10, 10)
.addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel7Layout.createSequentialGroup()
.addComponent(jLabel19)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel17, javax.swing.GroupLayout.PREFERRED_SIZE, 117,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel18)
.addContainerGap(38, Short.MAX_VALUE))
.addComponent(jTabbedPane3,
javax.swing.GroupLayout.DEFAULT_SIZE, 239, Short.MAX_VALUE)))
);
jPanel7Layout.setVerticalGroup(
jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel7Layout.createSequentialGroup()
.addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTabbedPane3)
.addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 186,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel12)
.addComponent(jLabel15)
.addComponent(jLabel19))
.addComponent(jLabel17, javax.swing.GroupLayout.PREFERRED_SIZE, 14,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel18)))
);
jTabbedPane1.getAccessibleContext().setAccessibleName("Cari");
jTabbedPane3.getAccessibleContext().setAccessibleName("");
jPanel1.add(jPanel7, new
org.netbeans.lib.awtextra.AbsoluteConstraints(410, 99, -1, -1));
jButton5.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton5.setText("Add");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
jButton6.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton6.setText("Save");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton6ActionPerformed(evt);
}
});
jButton7.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton7.setText("Edit");
jButton7.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton7ActionPerformed(evt);
}
});
jButton8.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton8.setText("Delete");
jButton8.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton8ActionPerformed(evt);
}
});
jButton1.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/javaapplicationpenjualantunai/ico/top.gif")));
// NOI18N
jButton1.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButton2.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/javaapplicationpenjualantunai/ico/previous.gif")));
// NOI18N
jButton2.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jButton3.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/javaapplicationpenjualantunai/ico/next.gif")));
// NOI18N
jButton3.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jButton4.setIcon(new
javax.swing.ImageIcon(getClass().getResource("/javaapplicationpenjualantunai/ico/bottom.gif")));
// NOI18N
jButton4.addActionListener(new
java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
jButton12.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton12.setText("Report");
jButton12.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton12ActionPerformed(evt);
}
});
jButton9.setFont(new java.awt.Font("Microsoft Sans Serif", 0,
11));
jButton9.setText("Exit");
jButton9.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton9ActionPerformed(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, null, null},
{null,
null, null, null, null, null}
},
new String
[] {
"Kode Barang", "Nama
Barang", "Type Barang", "Image File ", "Va
Barang", "Image File Web"
}
) {
Class[]
types = new Class [] {
java.lang.String.class, java.lang.String.class, java.lang.String.class,
java.lang.String.class, java.lang.String.class, java.lang.String.class
};
public
Class getColumnClass(int columnIndex) {
return
types [columnIndex];
}
});
jTable1.addMouseListener(new java.awt.event.MouseAdapter() {
public
void mouseClicked(java.awt.event.MouseEvent evt) {
jTable1MouseClicked(evt);
}
});
jTable1.addFocusListener(new
java.awt.event.FocusAdapter() {
public
void focusGained(java.awt.event.FocusEvent evt) {
jTable1FocusGained(evt);
}
});
jScrollPane1.setViewportView(jTable1);
jLabel8.setAutoscrolls(true);
jLabel8.setBorder(javax.swing.BorderFactory.createCompoundBorder(javax.swing.BorderFactory.createLineBorder(new
java.awt.Color(0, 0, 0)), javax.swing.BorderFactory.createLineBorder(new
java.awt.Color(0, 0, 0))));
jScrollPane4.setViewportView(jLabel8);
jLabel16.setFont(new java.awt.Font("Arial", 1, 12));
javax.swing.GroupLayout jPanel5Layout = new
javax.swing.GroupLayout(jPanel5);
jPanel5.setLayout(jPanel5Layout);
jPanel5Layout.setHorizontalGroup(
jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel5Layout.createSequentialGroup()
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel5Layout.createSequentialGroup()
.addGap(52, 52, 52)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 62,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 58,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(jButton5)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton6, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(jButton7, javax.swing.GroupLayout.Alignment.TRAILING,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE)
.addComponent(jButton3,
javax.swing.GroupLayout.Alignment.TRAILING,
javax.swing.GroupLayout.PREFERRED_SIZE, 59,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 60,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton8))
.addGap(96, 96, 96)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jButton9)
.addComponent(jButton12)))
.addGroup(jPanel5Layout.createSequentialGroup()
.addGap(16, 16, 16)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel16, javax.swing.GroupLayout.PREFERRED_SIZE, 545,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 732,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(10, 10,
10)
.addComponent(jScrollPane4, javax.swing.GroupLayout.DEFAULT_SIZE, 128,
Short.MAX_VALUE)))))
.addContainerGap())
);
jPanel5Layout.setVerticalGroup(
jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
jPanel5Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(jPanel5Layout.createSequentialGroup()
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jButton4)
.addComponent(jButton3)
.addComponent(jButton2)
.addComponent(jButton1))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton5)
.addComponent(jButton6)
.addComponent(jButton7)
.addComponent(jButton8)))
.addGroup(jPanel5Layout.createSequentialGroup()
.addComponent(jButton12)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton9)))
.addGap(14, 14, 14)
.addComponent(jLabel16, javax.swing.GroupLayout.PREFERRED_SIZE, 13,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane4, javax.swing.GroupLayout.DEFAULT_SIZE, 131,
Short.MAX_VALUE)
.addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.TRAILING,
javax.swing.GroupLayout.PREFERRED_SIZE, 131,
javax.swing.GroupLayout.PREFERRED_SIZE)))
);
jPanel1.add(jPanel5, new
org.netbeans.lib.awtextra.AbsoluteConstraints(20, 440, -1, -1));
javax.swing.GroupLayout layout = new
javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, 680,
Short.MAX_VALUE))
);
pack();
}//
</editor-fold>
private void
jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
jButton6.setEnabled(true);
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField10.setText("");
jTextField1.requestFocus();
ref();
refnumber();
refjtable2();
refjtable4();
jLabel16.setText("");
jTextField7.setText("");
}
private void
jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
String vv =
jTextField7.getText();
refn();
refnumbern();
if
(vv.equals("")){
connect();
count++;
try{
connect2();
connectTodatabase();
try{
querystring();
for(int i=0;i<count;i++){
if (rs.next()){
tampildata();
if (count==1){
JOptionPane.showMessageDialog(this,"Berada di Awal
Record","Information",JOptionPane.INFORMATION_MESSAGE);
count=1;
}
} else
if(rs.last()){
JOptionPane.showMessageDialog(this,"Berada di Akhir
Record","Information",JOptionPane.INFORMATION_MESSAGE);
count=count-1;
rn();
} }
String ss =Integer.toString(count);
jLabel9.setText(ss);
int nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
refnumber();
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
} else {
refnfilter();
connect();
count2++;
try{
connect2();
connectTodatabase();
try{
querystringfilter();
for(int i=0;i<count2;i++){
if (rs.next()){
tampildata();
if (count2==1){
JOptionPane.showMessageDialog(this,"Berada di Awal
Record","Information",JOptionPane.INFORMATION_MESSAGE);
count2=1;
}
String ss =Integer.toString(count2);
jLabel9.setText(ss);
int nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
} else
if(rs.last()){
JOptionPane.showMessageDialog(this,"Berada di Akhir
Record","Information",JOptionPane.INFORMATION_MESSAGE);
count2=count2-1;
} }
refnumber2();
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
imagerecord();
}
private void
jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
String vv =
jTextField7.getText();
refn();
refnumbern();
if (vv.equals("")){
connect();
count=0;
try{
connect2();
connectTodatabase();
try{
querystring();
while (rs.next()){
tampildata();
count++;
String ss =Integer.toString(count);
jLabel9.setText(ss);
int nnnn =Integer.parseInt(jLabel11.getText());
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
} else {
connect();
count2=0;
try{
connect2();
connectTodatabase();
try{
querystringfilter();
while (rs.next()){
tampildata();
count2++;
}
refnfilter();
refnumber2();
String ssc = jLabel11.getText();
jLabel9.setText(ssc);
int nnnn =Integer.parseInt(ssc);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
imagerecord();
}
private void
jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
String vv =
jTextField7.getText();
refn();
refnumbern();
if
(vv.equals("")){
connect();
count=1;
try{
connect2();
connectTodatabase();
try{
querystring();
if
(rs.next()){
tampildata();
String ss =Integer.toString(count);
jLabel9.setText(ss);
jTable1.setRowSelectionInterval(0, 0);
jTable1.setLocation(0, 0);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
} else {
connect();
count2=1;
refnfilter();
try{
connect2();
connectTodatabase();
try{
querystringfilter();
if (rs.next()){
tampildata();
}
String ss =Integer.toString(count2);
jLabel9.setText(ss);
jTable1.setRowSelectionInterval(0, 0);
jTable1.setLocation(0, 0);
refnumber2();
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
imagerecord();
}
private void
jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
String vv =
jTextField7.getText();
refn();
refnumbern();
if (vv.equals("")){
connect();
count--;
if(count==-1){
JOptionPane.showMessageDialog(this,"Berada di Awal
Record","Information",JOptionPane.INFORMATION_MESSAGE);
count=1;
}
try{
connect2();
connectTodatabase();
try{
querystring();
for(int i=0;i<count;i++){
if (rs.next()){
tampildata();
if (count==1){
JOptionPane.showMessageDialog(this,"Berada di Awal
Record","Information",JOptionPane.INFORMATION_MESSAGE);
count=1;
}
String ss =Integer.toString(count);
jLabel9.setText(ss);
int nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
} else
if(rs.last()){
JOptionPane.showMessageDialog(this,"Berada di Akhir
Record","Information",JOptionPane.INFORMATION_MESSAGE);
} }
refnumber();
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
} else {
refnfilter();
connect();
count2--;
if(count2==-1){
JOptionPane.showMessageDialog(this,"Berada di Awal
Record","Information",JOptionPane.INFORMATION_MESSAGE);
count2=1;
}
try{
connect2();
connectTodatabase();
try{
querystringfilter();
for(int i=0;i<count2;i++){
if (rs.next()){
tampildata();
// if (count2==1){
//
JOptionPane.showMessageDialog(this,"Berada di Awal
Record","Information",JOptionPane.INFORMATION_MESSAGE);
// count2=1;
// }
String ss =Integer.toString(count2);
jLabel9.setText(ss);
int nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
} else
if(rs.last()){
JOptionPane.showMessageDialog(this,"Berada di Akhir
Record","Information",JOptionPane.INFORMATION_MESSAGE);
} }
refnumber2();
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
imagerecord();
}
private void
jTextField4ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
}
private void
jButton7ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
String vv =
jTextField7.getText();
if
(vv.equals("")){
connect();
try{
connect2();
connectTodatabase();
try{
String
tk=jTextField1.getText();
String
t1=jTextField1.getText();
String
t2=jTextField2.getText();
String
t3=jTextField3.getText();
String
t4=jTextField4.getText();
String
t5=jTextField5.getText();
String
t6=jTextField6.getText();
String
t7=jTextField10.getText();
String
tk4=jTextField4.getText();
if
(tk4.equals("")){
int result =JOptionPane.showConfirmDialog(this,"Apakah dihapus
dengan gambarnya juga
?","Information",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(result==JOptionPane.OK_OPTION){
PreparedStatement pre=con.prepareStatement("UPDATE brgptun SET kbrgptun=?,nmbrgptun=?,typebrgptun=?,pictfilebrgptun=?,vabrgptun=?,pictfilewebbrgptun=?,pictbrgptun=?,barcode=?
WHERE kbrgptun=? ");
pre.setString(1, t1);
pre.setString(2, t2);
pre.setString(3, t3);
pre.setString(4, t4);
pre.setString(5, t5);
pre.setString(6, t6);
pre.setString(7, t4);
pre.setString(8, t7);
pre.setString(9, tk);
pre.executeUpdate();
pre.close();
con.close();
}else{
PreparedStatement pre=con.prepareStatement("UPDATE brgptun SET
kbrgptun=?,nmbrgptun=?,typebrgptun=?,pictfilebrgptun=?,vabrgptun=?,pictfilewebbrgptun=?,barcode=?
WHERE kbrgptun=? ");
pre.setString(1, t1);
pre.setString(2, t2);
pre.setString(3, t3);
pre.setString(4, t4);
pre.setString(5, t5);
pre.setString(6,
t6);
pre.setString(7, t7);
pre.setString(8, tk);
pre.executeUpdate();
pre.close();
con.close();
}
}
else {
File
imgFile= new File(t4);
FileInputStream fin =new FileInputStream(imgFile);
PreparedStatement pre=con.prepareStatement("UPDATE brgptun SET
kbrgptun=?,nmbrgptun=?,typebrgptun=?,pictfilebrgptun=?,vabrgptun=?,pictfilewebbrgptun=?,pictbrgptun=?,barcode=?
WHERE kbrgptun=? ");
pre.setString(1, t1);
pre.setString(2, t2);
pre.setString(3, t3);
pre.setString(4, t4);
pre.setString(5, t5);
pre.setString(6, t6);
pre.setString(8, t7);
pre.setString(9, tk);
pre.setBinaryStream(7,fin,(int)imgFile.length());
pre.executeUpdate();
pre.close();
con.close();
}
ref();
refnumber();
refjtable2();
refjtable3();
refjtable4();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
catch(FileNotFoundException ss){
JOptionPane.showMessageDialog(this,"Penulisan URL Imagenya salah
...!","Perhatian",JOptionPane.WARNING_MESSAGE);
jTextField4.requestFocus();
}
}catch(Exception e){
e.printStackTrace();
}
String ss =jLabel9.getText();
int nnnn =Integer.parseInt(ss);
count=nnnn;
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
} else {
connect();
try{
connect2();
connectTodatabase();
try{
String
tk=jTextField1.getText();
String
t1=jTextField1.getText();
String t2=jTextField2.getText();
String
t3=jTextField3.getText();
String
t4=jTextField4.getText();
String
t5=jTextField5.getText();
String
t6=jTextField6.getText();
String t7=jTextField10.getText();
String
tk4=jTextField4.getText();
if
(tk4.equals("")){
int result =JOptionPane.showConfirmDialog(this,"Apakah dihapus
dengan gambarnya juga ?","Information",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(result==JOptionPane.OK_OPTION){
PreparedStatement pre=con.prepareStatement("UPDATE brgptun SET
kbrgptun=?,nmbrgptun=?,typebrgptun=?,pictfilebrgptun=?,vabrgptun=?,pictfilewebbrgptun=?,pictbrgptun=?
WHERE kbrgptun=?");
pre.setString(1, t1);
pre.setString(2,
t2);
pre.setString(3, t3);
pre.setString(4, t4);
pre.setString(5, t5);
pre.setString(6, t6);
pre.setString(7, t4);
pre.setString(8, t7);
pre.setString(9, tk);
pre.executeUpdate();
pre.close();
con.close();
}else{
PreparedStatement pre=con.prepareStatement("UPDATE brgptun SET
kbrgptun=?,nmbrgptun=?,typebrgptun=?,pictfilebrgptun=?,vabrgptun=?,pictfilewebbrgptun=?
WHERE kbrgptun=? ");
pre.setString(1, t1);
pre.setString(2, t2);
pre.setString(3, t3);
pre.setString(4, t4);
pre.setString(5, t5);
pre.setString(6, t6);
pre.setString(7, t7);
pre.setString(8, tk);
pre.executeUpdate();
pre.close();
con.close();
}
}
else {
File
imgFile= new File(t4);
FileInputStream fin =new FileInputStream(imgFile);
PreparedStatement pre=con.prepareStatement("UPDATE brgptun SET
kbrgptun=?,nmbrgptun=?,typebrgptun=?,pictfilebrgptun=?,vabrgptun=?,pictfilewebbrgptun=?,pictbrgptun=?
WHERE kbrgptun=?");
pre.setString(1, t1);
pre.setString(2, t2);
pre.setString(3, t3);
pre.setString(4, t4);
pre.setString(5, t5);
pre.setString(6, t6);
pre.setString(8, t7);
pre.setString(9, tk);
pre.setBinaryStream(7,fin,(int)imgFile.length());
pre.executeUpdate();
pre.close();
con.close();
}
refnfilter();
refnumber2();
refjtable2();
refjtable3();
refjtable4();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
catch(FileNotFoundException ss){
JOptionPane.showMessageDialog(this,"Penulisan URL Imagenya salah
...!","Perhatian",JOptionPane.WARNING_MESSAGE);
jTextField4.requestFocus();
}
}catch(Exception e){
e.printStackTrace();
}
String ss =jLabel9.getText();
int nnnn =Integer.parseInt(ss);
count2=nnnn;
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
}
}
private void
jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
String
tk1=jTextField1.getText();
if
(tk1.equals("")){
JOptionPane.showMessageDialog(this,"Masukkan Kode Barangnya
!","Information",JOptionPane.WARNING_MESSAGE);
jTextField1.requestFocus();
jButton6.setEnabled(false);
}
else {
connect();
try{
connect2();
connectTodatabase();
try{
String
t1=jTextField1.getText();
String
t2=jTextField2.getText();
String
t3=jTextField3.getText();
String
t4=jTextField4.getText();
String
t5=jTextField5.getText();
String
t6=jTextField6.getText();
String t7=jTextField10.getText();
String
tk4=jTextField4.getText();
if
(tk4.equals("")){
PreparedStatement pre=con.prepareStatement("INSERT into
brgptun(kbrgptun,nmbrgptun,typebrgptun,pictfilebrgptun,vabrgptun,pictfilewebbrgptun,barcode)VALUES(?,?,?,?,?,?,?)");
pre.setString(1, t1);
pre.setString(2, t2);
pre.setString(3, t3);
pre.setString(4, t4);
pre.setString(5, t5);
pre.setString(6, t6);
pre.setString(7, t7);
pre.executeUpdate();
pre.close();
con.close();
}
else {
File
imgFile= new File(t4);
FileInputStream fin =new
FileInputStream(imgFile);
PreparedStatement pre=con.prepareStatement("INSERT into
brgptun(kbrgptun,nmbrgptun,typebrgptun,pictfilebrgptun,vabrgptun,pictfilewebbrgptun,pictbrgptun,barcode)VALUES(?,?,?,?,?,?,?,?)");
pre.setString(1, t1);
pre.setString(2, t2);
pre.setString(3, t3);
pre.setString(4, t4);
pre.setBinaryStream(7,fin,(long)imgFile.length());
pre.setString(5, t5);
pre.setString(6, t6);
pre.setString(8, t7);
pre.executeUpdate();
pre.close();
con.close();
}
ref();
refnumber();
refjtable2();
refjtable3();
refjtable4();
jButton6.setEnabled(false);
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
catch(FileNotFoundException ss){
JOptionPane.showMessageDialog(this,"Penulisan URL Imagenya salah
...!","Perhatian",JOptionPane.WARNING_MESSAGE);
jTextField4.requestFocus();
}
}catch(Exception e){
e.printStackTrace();
}
}
jTextField9.setText(jTextField1.getText());
this.jButton14ActionPerformed(evt);
jTextField9.setText("");
}
private void
jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
String vv =
jTextField7.getText();
if
(vv.equals("")){
int result =JOptionPane.showConfirmDialog(this,"Apakah
yakin data ini akan dihapus
?","Information",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(result==JOptionPane.OK_OPTION){
connect();
try{
connect2();
connectTodatabase();
try{
String
tk=jTextField1.getText();
PreparedStatement pre=con.prepareStatement("DELETE from brgptun
WHERE kbrgptun=? ");
pre.setString(1, tk);
pre.executeUpdate();
pre.close();
con.close();
ref();
refjtable2();
refjtable3();
refjtable4();
int
ccn =Integer.parseInt(jLabel11.getText());
if
(ccn==1){
jLabel9.setText("0");
jLabel11.setText("0");
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][]
oo={{"","","","","","",""}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
String[] data = new String[7];
data [0]="";
data [1]="";
data [2]="";
data [3]="";
data [4]="";
data [5]="";
data
[6]="";
tableModel.addRow(data);
jTable1.setModel(tableModel);
lebarkolomgrid();
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField10.setText("");
jLabel8.setIcon(null);
jTextField1.requestFocus();
String[] jj1={"Kode Barang"};
Object[][] oo1={{""}};
DefaultTableModel tableModel1 = new DefaultTableModel(oo1,jj1);
String[]
data1 = new String[1];
data1 [0]="";
tableModel1.addRow(data1);
jTable2.setModel(tableModel1);
String[] jj2={"Nama Barang"};
Object[][] oo2={{""}};
DefaultTableModel tableModel2
= new DefaultTableModel(oo2,jj2);
String[] data2 = new String[1];
data2 [0]="";
tableModel2.addRow(data2);
jTable3.setModel(tableModel2);
}
else {
int ccc =Integer.parseInt(jLabel9.getText());
count=ccc;
connect();
try{
connect2();
connectTodatabase();
try{
querystring();
for(int
i=0;i<count;i++){
if
(rs.next()){
tampildata();
}
}
refnumber();
String ss =Integer.toString(count);
int
cr=jTable1.getRowCount()+1;
if(count==cr){
count=count-1;
String sss =Integer.toString(count);
jLabel9.setText(sss);
int
nnnn =Integer.parseInt(sss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
}
else{
jLabel9.setText(ss);
int
nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}else
if(result==JOptionPane.NO_OPTION)
{
}
}
else{
int result
=JOptionPane.showConfirmDialog(this,"Apakah yakin data ini akan dihapus
?","Information",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(result==JOptionPane.OK_OPTION){
connect();
try{
connect2();
connectTodatabase();
try{
String
tk=jTextField1.getText();
PreparedStatement pre=con.prepareStatement("DELETE from brgptun
WHERE kbrgptun=? ");
pre.setString(1, tk);
pre.executeUpdate();
pre.close();
con.close();
ref();
refjtable2();
refjtable3();
refjtable4();
int
ccn =Integer.parseInt(jLabel11.getText());
if
(ccn==1){
jLabel9.setText("0");
jLabel11.setText("0");
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][]
oo={{"","","","","","",""}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
String[] data = new String[7];
data [0]="";
data [1]="";
data [2]="";
data [3]="";
data [4]="";
data [5]="";
data [6]="";
tableModel.addRow(data);
jTable1.setModel(tableModel);
lebarkolomgrid();
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField10.setText("");
jTextField1.requestFocus();
}
else {
int ccc =Integer.parseInt(jLabel9.getText());
count2=ccc;
refnumber2();
String ss =Integer.toString(count2);
int
cr2=Integer.parseInt(jLabel11.getText());
if(count2>cr2){
count2=count2-1;
String sss =Integer.toString(count2);
f1();
jLabel9.setText(sss);
int
nnnn =Integer.parseInt(sss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
}
else{
f1();
jLabel9.setText(ss);
int
nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
}
int
ccc2 =Integer.parseInt(jLabel9.getText());
count2=ccc2;
connect();
try{
connect2();
connectTodatabase();
try{
querystringfilter();
for(int
i=0;i<count2;i++){
if
(rs.next()){
tampildata();
}
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}else
if(result==JOptionPane.NO_OPTION)
{
}
}
imagerecord();
}
private void
jButton9ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
FormBarang.this.dispose();
}
private void
jButton12ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
connect();
try{
connect2();
connectTodatabase();
try{
String
jj ="C:/Documents and Settings/agus/My
Documents/NetBeansProjects/JavaApplicationPenjualanTunai/src/javaapplicationpenjualantunai/reportbrgptun.jasper";
Map
parameters = new HashMap();
JasperPrint jp = JasperManager.fillReport(jj, parameters, con);
JasperViewer.viewReport(jp,false);
//JasperPrintManager.printReport(jp, true); //Kalau ingin nge-PRINT
langsung
//JRXlsExporter exporter = new JRXlsExporter();
//exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp);
//exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,
"C:/mm.xls" );
//exporter.exportReport();
//JasperExportManager.exportReportToPdfFile(jp, "C://dd.pdf");
}catch(Exception e){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
private void
jTable1MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add
your handling code here:
String vvs =
jTextField8.getText();
if
(vvs.equals("")){
String vv =
jTextField7.getText();
if
(vv.equals("")){
mouseklik1();
} else {
mouseklik2filter();
refnumber2();
}
} else {
mousekliksort();
}
String vvv =
jTextField7.getText();
if
(vvv.equals("")){
refnumbern();
refn();
String ss
=Integer.toString(count);
jLabel9.setText(ss);
int nnnn
=Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
} else {
refnfilter();
String
ssc = jLabel9.getText();
int nnnn
=Integer.parseInt(ssc);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
}
}
private void
jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {
}
private void
jTextField7ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
}
private void
jButton10ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
jLabel16.setText("Data di bawah ini sedang di filter ...........,
Perhatian !!! untuk mengakhirinya klik
End Filter");
refn();
connect();
count2=0;
try{
connect2();
connectTodatabase();
try{
querystringfilter();
while
(rs.next()){
String t1=rs.getString(1);
String t2=rs.getString(2);
String t3=rs.getString(3);
String t4=rs.getString(4);
String t5=rs.getString(5);
String t6=rs.getString(6);
String t7=rs.getString(7);
jTextField1.setText(t1);
jTextField2.setText(t2);
jTextField3.setText(t3);
jTextField4.setText(t4);
jTextField5.setText(t5);
jTextField6.setText(t6);
jTextField10.setText(t7);
count2++;
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][] oo={{t1,t2,t3,t4,t5,t6,t7}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
while (rs.next()){
count2++;
String[] data = new String[7];
data [0]=rs.getString(1);
data [1]=rs.getString(2);
data [2]=rs.getString(3);
data [3]=rs.getString(4);
data [4]=rs.getString(5);
data [5]=rs.getString(6);
data [6]=rs.getString(7);
tableModel.addRow(data);
}
jTable1.setModel(tableModel);
lebarkolomgrid();
}
refnumber2();
refjtable2();
refjtable4();
stat.close();
con.close();
countfilter();
String
tt=jLabel17.getText();
int
oo=Integer.parseInt(tt);
if
(oo==0){
jLabel16.setText("");
jTextField7.setText("");
ref();
refnumber();
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField10.setText("");
jTextField1.requestFocus();
refjtable2();
refjtable4();
jLabel17.setText("0");
JOptionPane.showMessageDialog(this,"Datanya tidak ada/
kosong","Information",JOptionPane.INFORMATION_MESSAGE);
}
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
imagerecord();
}
private void
jButton11ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
jLabel16.setText("");
jTextField7.setText("");
ref();
refnumber();
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField10.setText("");
jTextField1.requestFocus();
refjtable2();
refjtable4();
jLabel17.setText("0");
}
private void
jButton13ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
connect();
try{
connect2();
connectTodatabase();
try{
String
jj ="C:/Documents and Settings/agus/My
Documents/NetBeansProjects/JavaApplicationPenjualanTunai/src/javaapplicationpenjualantunai/reportbrgptunfilter.jasper";
Map
parameters = new HashMap();
parameters.put("pp", jTextField7.getText());
JasperPrint jp = JasperManager.fillReport(jj, parameters, con);
JasperViewer.viewReport(jp,false);
}catch(Exception e){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
private void
jButton14ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
String vv =
jTextField7.getText();
if
(vv.equals("")){
refn();
ref();
refnumber();
String
value = jTextField9.getText();
for (int row = 0; row <=
jTable2.getRowCount() - 1; row++) {
for
(int col = 0; col <= jTable2.getColumnCount() - 1; col++) {
if
(value.equals(jTable2.getValueAt(row, col))) {
// this will automatically set the view of the scroll in the location of
the value
jTable2.scrollRectToVisible(jTable2.getCellRect(row, 0, true));
// this will automatically set the focus of the searched/selected
row/value
jTable2.setRowSelectionInterval(row, row);
String ss =Integer.toString(row+1);
jLabel12.setText(ss);
}
}
}
connect();
int ns
=Integer.parseInt( jLabel12.getText());
count= ns;
try{
connect2();
connectTodatabase();
try{
querystring();
for(int i=0;i<count;i++){
if (rs.next()){
tampildata();
}
}
String ss =Integer.toString(count);
jLabel9.setText(ss);
int nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
} else {
refnfilter();
refjtable2();
refjtable4();
refnumber2();
String
value = jTextField9.getText();
for (int
row = 0; row <= jTable2.getRowCount() - 1; row++) {
for
(int col = 0; col <= jTable2.getColumnCount() - 1; col++) {
if
(value.equals(jTable2.getValueAt(row, col))) {
// this will automatically set the view of the scroll in the location of
the value
jTable2.scrollRectToVisible(jTable2.getCellRect(row, 0, true));
// this will automatically set the focus of the searched/selected
row/value
jTable2.setRowSelectionInterval(row, row);
String ss =Integer.toString(row+1);
jLabel12.setText(ss);
}}
}
connect();
int ns
=Integer.parseInt( jLabel12.getText());
count= ns;
try{
connect2();
connectTodatabase();
try{
querystringfilter();
for(int i=0;i<count;i++){
if (rs.next()){
tampildata();
}
}
String ss =Integer.toString(count);
jLabel9.setText(ss);
int nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
imagerecord();
}
private void
jButton15ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
refsortnamabarang();
jTable1.setEnabled(false);
jButton1.setEnabled(false);
jButton2.setEnabled(false);
jButton3.setEnabled(false);
jButton4.setEnabled(false);
jButton5.setEnabled(false);
jButton6.setEnabled(false);
jButton7.setEnabled(false);
jButton8.setEnabled(false);
jButton10.setEnabled(false);
jButton11.setEnabled(false);
jButton12.setEnabled(false);
jButton13.setEnabled(false);
jButton14.setEnabled(false);
}
private void
jButton16ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
ref();
jTable1.setEnabled(true);
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(true);
jButton4.setEnabled(true);
jButton5.setEnabled(true);
jButton6.setEnabled(true);
jButton7.setEnabled(true);
jButton8.setEnabled(true);
jButton10.setEnabled(true);
jButton11.setEnabled(true);
jButton12.setEnabled(true);
jButton13.setEnabled(true);
jButton14.setEnabled(true);
}
private void
jButton17ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
refn();
refsortnamabarang();
String
value = jTextField8.getText();
for (int
row = 0; row <= jTable3.getRowCount() - 1; row++) {
for
(int col = 0; col <= jTable3.getColumnCount() - 1; col++) {
if
(value.equals(jTable3.getValueAt(row, col))) {
// this will automatically set the view of the scroll in the location of
the value
jTable3.scrollRectToVisible(jTable3.getCellRect(row, 0, true));
// this will automatically set the focus of the searched/selected
row/value
jTable3.setRowSelectionInterval(row, row);
String ss =Integer.toString(row+1);
jLabel12.setText(ss);
}
}
}
connect();
int ns
=Integer.parseInt( jLabel12.getText());
count= ns;
try{
connect2();
connectTodatabase();
try{
querystringsortnamabarang();
for(int i=0;i<count;i++){
if (rs.next()){
tampildata();
}
}
String ss =Integer.toString(count);
jLabel9.setText(ss);
int nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
connect();
count=1;
try{
connect2();
connectTodatabase();
try{
querystringsortnamabarang();
while
(rs.next()){
String t1=rs.getString(1);
String t2=rs.getString(2);
String t3=rs.getString(3);
String t4=rs.getString(4);
String t5=rs.getString(5);
String t6=rs.getString(6);
String t7=rs.getString(7);
count++;
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][] oo={{t1,t2,t3,t4,t5,t6,t7}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
//DefaultTableModel tableModel = new DefaultTableModel();
while (rs.next()){
count++;
String[] data = new String[7];
data [0]=rs.getString(1);
data [1]=rs.getString(2);
data [2]=rs.getString(3);
data [3]=rs.getString(4);
data [4]=rs.getString(5);
data [5]=rs.getString(6);
data [6]=rs.getString(7);
tableModel.addRow(data);
}
jTable1.setModel(tableModel);
lebarkolomgrid();
}
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
for (int
row = 0; row <= jTable1.getRowCount() - 1; row++) {
for
(int col = 0; col <= jTable1.getColumnCount() - 1; col++) {
if
(value.equals(jTable1.getValueAt(row, col))) {
// this will automatically set the view of the scroll in the location of
the value
jTable1.scrollRectToVisible(jTable1.getCellRect(row, 0, true));
// this will automatically set the focus of the searched/selected
row/value
jTable1.setRowSelectionInterval(row, row);
}
}}
jTable1.setEnabled(false);
jButton1.setEnabled(false);
jButton2.setEnabled(false);
jButton3.setEnabled(false);
jButton4.setEnabled(false);
jButton5.setEnabled(false);
jButton6.setEnabled(false);
jButton7.setEnabled(false);
jButton8.setEnabled(false);
jButton10.setEnabled(false);
jButton11.setEnabled(false);
jButton12.setEnabled(false);
jButton13.setEnabled(false);
jButton14.setEnabled(false);
imagerecord();
}
private void
jButton18ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
jTextField8.setText("");
ref();
jTable1.setEnabled(true);
jButton1.setEnabled(true);
jButton2.setEnabled(true);
jButton3.setEnabled(true);
jButton4.setEnabled(true);
jButton5.setEnabled(true);
jButton6.setEnabled(true);
jButton7.setEnabled(true);
jButton8.setEnabled(true);
jButton10.setEnabled(true);
jButton11.setEnabled(true);
jButton12.setEnabled(true);
jButton13.setEnabled(true);
jButton14.setEnabled(true);
r1();
}
private void
jButton19ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
jButton20.setEnabled(true);
}
private void
jButton20ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
String vv = jTextField7.getText();
if
(vv.equals("")){
int result
=JOptionPane.showConfirmDialog(this,"Apakah yakin data ini akan dihapus
semuanya
?","Information",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(result==JOptionPane.OK_OPTION){
connect();
try{
connect2();
connectTodatabase();
try{
PreparedStatement pre=con.prepareStatement("DELETE from
brgptun");
pre.executeUpdate();
pre.close();
con.close();
jLabel9.setText("0");
jLabel11.setText("0");
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][] oo={{"","","","","","","",""}};
String[] jj2={"Nama Barang"};
Object[][] oo2={{""}};
String[] jj3={"Nama Barang"};
Object[][] oo3={{""}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
DefaultTableModel tableModel2 = new DefaultTableModel(oo2,jj2);
DefaultTableModel tableModel3 = new DefaultTableModel(oo3,jj3);
String[] data = new String[7];
String[] data2 = new String[7];
String[] data3 = new String[7];
data [0]="";
data [1]="";
data [2]="";
data [3]="";
data [4]="";
data [5]="";
data [6]="";
tableModel.addRow(data);
data2 [0]="";
tableModel2.addRow(data2);
data3 [0]="";
tableModel3.addRow(data3);
jTable1.setModel(tableModel);
jTable2.setModel(tableModel2);
jTable3.setModel(tableModel3);
lebarkolomgrid();
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField10.setText("");
jTextField1.requestFocus();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception
e){
e.printStackTrace();
}
}else
if(result==JOptionPane.NO_OPTION)
{
}
}
else{
int result
=JOptionPane.showConfirmDialog(this,"Apakah yakin data yang di filter ini
akan dihapus
semuanya?","Information",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
if(result==JOptionPane.OK_OPTION){
connect();
try{
connect2();
connectTodatabase();
try{
String
tk=jTextField1.getText();
PreparedStatement pre=con.prepareStatement("DELETE from brgptun
WHERE nmbrgptun=? ");
pre.setString(1,
tk);
pre.executeUpdate();
pre.close();
con.close();
ref();
refjtable2();
refjtable3();
refjtable4();
int
ccn =Integer.parseInt(jLabel11.getText());
if
(ccn==1){
jLabel9.setText("0");
jLabel11.setText("0");
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][]
oo={{"","","","","","","",""}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
String[] data = new String[7];
data [0]="";
data [1]="";
data [2]="";
data [3]="";
data [4]="";
data [5]="";
data [6]="";
tableModel.addRow(data);
jTable1.setModel(tableModel);
lebarkolomgrid();
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField10.setText("");
jTextField1.requestFocus();
}
else {
int ccc =Integer.parseInt(jLabel9.getText());
count=ccc;
connect();
try{
connect2();
connectTodatabase();
try{
querystringfilter();
for(int
i=0;i<count;i++){
if
(rs.next()){
tampildata();
f1();
refnumber();
}
}
String ss =Integer.toString(count);
jLabel9.setText(ss);
int
nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
}else
if(result==JOptionPane.NO_OPTION)
{
}
}
jButton20.setEnabled(false);
imagerecord();
}
private void
jButton21ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
JFileChooser jj=
new JFileChooser("");
int vv
=jj.showOpenDialog(jj);
if
(vv==jj.OPEN_DIALOG){
jTextField4.setText(jj.getSelectedFile().getPath());
}
else if
(vv==jj.CANCEL_OPTION){
jTextField4.setText("");
}
}
private void
jTable1FocusGained(java.awt.event.FocusEvent evt) {
String vvs
= jTextField8.getText();
if
(vvs.equals("")){
String vv =
jTextField7.getText();
if
(vv.equals("")){
mouseklik1();
} else {
mouseklik2filter();
refnumber2();
}
} else {
mousekliksort();
}
String vvv =
jTextField7.getText();
if
(vvv.equals("")){
refnumbern();
refn();
String ss
=Integer.toString(count);
jLabel9.setText(ss);
int nnnn
=Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
} else {
refnfilter();
String
ssc = jLabel9.getText();
int nnnn
=Integer.parseInt(ssc);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
}
}
private void
jTextField7FocusLost(java.awt.event.FocusEvent evt) {
// TODO add
your handling code here:
String vv =
jTextField7.getText();
if
(vv.equals("")){
}else{
jLabel16.setText("Data di bawah ini sedang di filter ...........,
Perhatian !!! Untuk mengakhirinya klik
End Filter");
refn();
connect();
count2=0;
try{
connect2();
connectTodatabase();
try{
querystringfilter();
while
(rs.next()){
String t1=rs.getString(1);
String t2=rs.getString(2);
String t3=rs.getString(3);
String t4=rs.getString(4);
String t5=rs.getString(5);
String t6=rs.getString(6);
String t7=rs.getString(7);
jTextField1.setText(t1);
jTextField2.setText(t2);
jTextField3.setText(t3);
jTextField4.setText(t4);
jTextField5.setText(t5);
jTextField6.setText(t6);
jTextField10.setText(t7);
count2++;
String[] jj={"Kode Barang","Nama Barang","Type
Barang","Image File","VA Barang","Image File
Web","Barcode"};
Object[][]
oo={{t1,t2,t3,t4,t5,t6,t7}};
DefaultTableModel tableModel = new DefaultTableModel(oo,jj);
while (rs.next()){
count2++;
String[] data = new String[7];
data [0]=rs.getString(1);
data [1]=rs.getString(2);
data [2]=rs.getString(3);
data [3]=rs.getString(4);
data [4]=rs.getString(5);
data [5]=rs.getString(6);
data [6]=rs.getString(7);
tableModel.addRow(data);
}
jTable1.setModel(tableModel);
lebarkolomgrid();
}
refjtable2();
refjtable4();
stat.close();
con.close();
countfilter();
String
tt=jLabel17.getText();
int oo=Integer.parseInt(tt);
if
(oo==0){
jLabel16.setText("");
jTextField7.setText("");
ref();
refnumber();
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField10.setText("");
jTextField1.requestFocus();
refjtable2();
refjtable4();
jLabel17.setText("0");
JOptionPane.showMessageDialog(this,"Datanya tidak ada/
kosong","Information",JOptionPane.INFORMATION_MESSAGE);
}
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
imagerecord();
}
}
private void
jButton22ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
String vv =
jTextField7.getText();
if
(vv.equals("")){
refn();
ref();
refnumber();
String
value = jTextField11.getText();
for (int
row = 0; row <= jTable4.getRowCount() - 1; row++) {
for
(int col = 0; col <= jTable4.getColumnCount() - 1; col++) {
if
(value.equals(jTable4.getValueAt(row, col))) {
// this will automatically set the view of the scroll in the location of
the value
jTable4.scrollRectToVisible(jTable4.getCellRect(row, 0, true));
// this will automatically set the focus of the searched/selected
row/value
jTable4.setRowSelectionInterval(row, row);
String ss =Integer.toString(row+1);
jLabel12.setText(ss);
}
}
}
connect();
int ns
=Integer.parseInt( jLabel12.getText());
count= ns;
try{
connect2();
connectTodatabase();
try{
querystring();
for(int i=0;i<count;i++){
if (rs.next()){
tampildata();
}
}
String ss =Integer.toString(count);
jLabel9.setText(ss);
int nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
}
} else {
refnfilter();
refjtable2();
refjtable4();
refnumber2();
String
value = jTextField11.getText();
for (int
row = 0; row <= jTable4.getRowCount() - 1; row++) {
for
(int col = 0; col <= jTable4.getColumnCount() - 1; col++) {
if
(value.equals(jTable4.getValueAt(row, col))) {
// this will automatically set the view of the scroll in the location of
the value
jTable4.scrollRectToVisible(jTable4.getCellRect(row, 0, true));
// this will automatically set the focus of the searched/selected
row/value
jTable4.setRowSelectionInterval(row, row);
String ss =Integer.toString(row+1);
jLabel12.setText(ss);
}}
}
connect();
int ns
=Integer.parseInt( jLabel12.getText());
count= ns;
try{
connect2();
connectTodatabase();
try{
querystringfilter();
for(int i=0;i<count;i++){
if (rs.next()){
tampildata();
}
}
String ss =Integer.toString(count);
jLabel9.setText(ss);
int nnnn =Integer.parseInt(ss);
jTable1.setRowSelectionInterval(nnnn-1,nnnn-1);
jTable1.setLocation(0, -(nnnn-1)*16);
stat.close();
con.close();
}catch(SQLException s){
System.out.println("SQL Statement is not executed !");
}
}catch(Exception
e){
e.printStackTrace();
}
}
imagerecord();
}
/**
* @param args the
command line arguments
*/
public static void
main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public
void run() {
new
FormBarang().setVisible(true);
}
});
}
// Variables
declaration - do not modify
private
javax.swing.JButton jButton1;
private
javax.swing.JButton jButton10;
private
javax.swing.JButton jButton11;
private
javax.swing.JButton jButton12;
private
javax.swing.JButton jButton13;
private javax.swing.JButton
jButton14;
private
javax.swing.JButton jButton15;
private
javax.swing.JButton jButton16;
private
javax.swing.JButton jButton17;
private
javax.swing.JButton jButton18;
private
javax.swing.JButton jButton19;
private
javax.swing.JButton jButton2;
private
javax.swing.JButton jButton20;
private
javax.swing.JButton jButton21;
private
javax.swing.JButton jButton22;
private
javax.swing.JButton jButton3;
private
javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
private
javax.swing.JButton jButton6;
private
javax.swing.JButton jButton7;
private
javax.swing.JButton jButton8;
private
javax.swing.JButton jButton9;
private
javax.swing.JLabel jLabel1;
private
javax.swing.JLabel jLabel10;
private
javax.swing.JLabel jLabel11;
private
javax.swing.JLabel jLabel12;
private
javax.swing.JLabel jLabel13;
private
javax.swing.JLabel jLabel14;
private
javax.swing.JLabel jLabel15;
private javax.swing.JLabel
jLabel16;
private
javax.swing.JLabel jLabel17;
private
javax.swing.JLabel jLabel18;
private
javax.swing.JLabel jLabel19;
private
javax.swing.JLabel jLabel2;
private
javax.swing.JLabel jLabel20;
private
javax.swing.JLabel jLabel21;
private
javax.swing.JLabel jLabel22;
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.JPanel jPanel1;
private
javax.swing.JPanel jPanel10;
private
javax.swing.JPanel jPanel2;
private
javax.swing.JPanel jPanel3;
private javax.swing.JPanel
jPanel4;
private
javax.swing.JPanel jPanel5;
private
javax.swing.JPanel jPanel6;
private
javax.swing.JPanel jPanel7;
private
javax.swing.JPanel jPanel8;
private
javax.swing.JPanel jPanel9;
private
javax.swing.JScrollPane jScrollPane1;
private
javax.swing.JScrollPane jScrollPane2;
private
javax.swing.JScrollPane jScrollPane3;
private
javax.swing.JScrollPane jScrollPane4;
private
javax.swing.JScrollPane jScrollPane5;
private
javax.swing.JTabbedPane jTabbedPane1;
private
javax.swing.JTabbedPane jTabbedPane3;
private
javax.swing.JTable jTable1;
private
javax.swing.JTable jTable2;
private
javax.swing.JTable jTable3;
private
javax.swing.JTable jTable4;
private
javax.swing.JTextField jTextField1;
private
javax.swing.JTextField jTextField10;
private
javax.swing.JTextField jTextField11;
private
javax.swing.JTextField jTextField2;
private
javax.swing.JTextField jTextField3;
private
javax.swing.JTextField jTextField4;
private
javax.swing.JTextField jTextField5;
private
javax.swing.JTextField jTextField6;
private
javax.swing.JTextField jTextField7;
private
javax.swing.JTextField jTextField8;
private
javax.swing.JTextField jTextField9;
// End of variables
declaration
}
Tidak ada komentar:
Posting Komentar