
Code:
import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.JFrame;
import java.util.*;
import java.awt.BorderLayout;
import java.awt.Toolkit;
import java.applet.Applet;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.TableColumn;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Random;
import java.util.Vector;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;
import javax.swing.event.TableModelEvent;
import javax.swing.event.TableModelListener;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.TableCellRenderer;
import javax.swing.ListSelectionModel;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;
import javax.swing.table.DefaultTableModel;
import java.awt.Color;
import java.awt.Font;
import java.text.DecimalFormat;
import java.awt.Color;
import java.awt.Font;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.border.EmptyBorder;
import javax.swing.table.DefaultTableModel;
//Nazivi klasa pocinju velikim slovima, dakle FrmKategorije umesto frmKategorije.
public class FrmKategorije extends JFrame {
Connection conn = null;
ResultSet rs = null;
PreparedStatement pst = null;
ResultSet rss = null;
PreparedStatement psts = null;
Statement stmt = null;
private static final long serialVersionUID = 1L;
/** Creates new form frmKategorije */
//kad se prosledjuje parametar prvo ide tip klase (eto zasto nazivi klase pocinju VelikimSlovom), pa potom ide ime objekta, koji se pise malimSlovima
public FrmKategorije(final Roba frmRoba) {
//unutar metode initComponents nije vidljiva frmRoba pa je neophodno da se forma prosledi kao parametar
initComponents(frmRoba);
conn = javaconnect.ConnectDB();
Dimension dim = Toolkit.getDefaultToolkit().getScreenSize();
this.setLocation(dim.width / 2 - this.getSize().width / 2, dim.height / 2 - this.getSize().height / 2);
this.setResizable(false);
String z = "";
txt_id_robe.setText(z);
String y = txt_kategorija_pretraga.getText();
IspisiKategorije(y);
}
public void close() {
WindowEvent winClosingEvent = new WindowEvent(this, WindowEvent.WINDOW_CLOSING);
Toolkit.getDefaultToolkit().getSystemEventQueue().postEvent(winClosingEvent);
}
private void IspisiKategorije(String x) {
try {
String sqlr3 = "";
if (x.equals("")) {
sqlr3 = " SELECT IDKategorije AS ID, Kategorija FROM Kategorije ";
} else {
sqlr3 = " SELECT IDKategorije AS ID, Kategorija FROM Kategorije WHERE Kategorija like '%" + x + "%' ";
}
pst = conn.prepareStatement(sqlr3);
rs = pst.executeQuery();
System.out.println("sqk =: " + sqlr3);
while (rs.next()) {
Tbl_Kategorije.setModel(DbUtils.resultSetToTableModel(rs));
TableColumn col0 = Tbl_Kategorije.getColumnModel().getColumn(0);
col0.setPreferredWidth(10);
TableColumn col1 = Tbl_Kategorije.getColumnModel().getColumn(1);
col1.setPreferredWidth(90);
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex);
}
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents(final Roba frmRoba) {
jScrollPane1 = new javax.swing.JScrollPane();
Tbl_Kategorije = new javax.swing.JTable();
txt_kategorija_pretraga_id = new javax.swing.JTextField();
txt_kategorija_pretraga = new javax.swing.JTextField();
jLabel1 = new javax.swing.JLabel();
cmd_Trazi = new javax.swing.JToggleButton();
cmd_Izaberi = new javax.swing.JToggleButton();
txt_id_robe = new javax.swing.JTextField();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("Kategorije");
setAlwaysOnTop(true);
jScrollPane1.setName("jScrollPane1"); // NOI18N
Tbl_Kategorije.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Title 1", "Title 2", "Title 3", "Title 4"
}
));
Tbl_Kategorije.setName("Tbl_Kategorije"); // NOI18N
Tbl_Kategorije.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
Tbl_KategorijeMouseClicked(evt);
}
});
Tbl_Kategorije.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyReleased(java.awt.event.KeyEvent evt) {
Tbl_KategorijeKeyReleased(evt);
}
});
jScrollPane1.setViewportView(Tbl_Kategorije);
txt_kategorija_pretraga_id.setEditable(false);
txt_kategorija_pretraga_id.setName("txt_kategorija_pretraga_id"); // NOI18N
txt_kategorija_pretraga.setName("txt_kategorija_pretraga"); // NOI18N
jLabel1.setText("Pretraga");
jLabel1.setName("jLabel1"); // NOI18N
cmd_Trazi.setText("Traži");
cmd_Trazi.setName("cmd_Trazi"); // NOI18N
cmd_Trazi.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cmd_TraziActionPerformed(evt);
}
});
cmd_Izaberi.setText("Izaberi");
cmd_Izaberi.setName("cmd_Izaberi"); // NOI18N
cmd_Izaberi.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
//dakle metodi cmd_IzaberiActionPerformed() smo prosledili frmRoba ali dzaba kad ni initComponents() ne zna za frmRoba,
//znaci idemo u sam konstruktor klase i prosledjujemo frmRoba metodi initComponents(frmRoba)^^
cmd_IzaberiActionPerformed(evt, frmRoba);
}
});
txt_id_robe.setName("txt_id_robe"); // NOI18N
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()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 530, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(txt_kategorija_pretraga_id, javax.swing.GroupLayout.DEFAULT_SIZE, 65, Short.MAX_VALUE)
.addGap(51, 51, 51)
.addComponent(jLabel1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED))
.addGroup(layout.createSequentialGroup()
.addComponent(cmd_Izaberi)
.addGap(103, 103, 103)))
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(txt_kategorija_pretraga, javax.swing.GroupLayout.PREFERRED_SIZE, 301, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(cmd_Trazi))
.addComponent(txt_id_robe, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(cmd_Izaberi)
.addComponent(txt_id_robe, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 16, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txt_kategorija_pretraga_id, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txt_kategorija_pretraga, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1)
.addComponent(cmd_Trazi))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 280, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(62, 62, 62))
);
pack();
}// </editor-fold>
private void Tbl_KategorijeMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
int row = Tbl_Kategorije.getSelectedRow();
String Table_click = (Tbl_Kategorije.getModel().getValueAt(row, 0).toString());
try {
String sql_kom = "SELECT IDKategorije, Kategorija FROM Kategorije WHERE IDKategorije = " + Table_click + " ";
pst = conn.prepareStatement(sql_kom);
rs = pst.executeQuery();
if (rs.next()) {
String add1 = rs.getString("IDKategorije");
txt_kategorija_pretraga_id.setText(add1);
String add3 = rs.getString("Kategorija");
txt_kategorija_pretraga.setText(add3);
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex);
}
}
private void Tbl_KategorijeKeyReleased(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
int row = Tbl_Kategorije.getSelectedRow();
String Table_click = (Tbl_Kategorije.getModel().getValueAt(row, 0).toString());
try {
String sql_kom = "SELECT IDKategorije, Kategorija FROM Kategorije WHERE IDKategorije = " + Table_click + " ";
pst = conn.prepareStatement(sql_kom);
rs = pst.executeQuery();
if (rs.next()) {
String add1 = rs.getString("IDKategorije");
txt_kategorija_pretraga_id.setText(add1);
String add3 = rs.getString("Kategorija");
txt_kategorija_pretraga.setText(add3);
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex);
}
}
private void cmd_TraziActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String y = txt_kategorija_pretraga.getText();
IspisiKategorije(y);
}
//ova metoda ne zna za frmRoba, moras joj je proslediti Roba frmRoba
private void cmd_IzaberiActionPerformed(java.awt.event.ActionEvent evt, Roba frmRoba) {
// TODO add your handling code here:
int row = Tbl_Kategorije.getSelectedRow();
String Table_click = (Tbl_Kategorije.getModel().getValueAt(row, 0).toString());
frmRoba.izaberiKategoriju(Table_click); //** Ovde prijavljuje gresku frmRRobe??????? *///
//Naravno kad nije vidljivâ unutar metode, pogledaj gore ^^
setVisible(false);
dispose();
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/jav.../uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(frmKategorije.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(frmKategorije.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(frmKategorije.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(frmKategorije.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
// new frmKategorije(x).setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JTable Tbl_Kategorije;
private javax.swing.JToggleButton cmd_Izaberi;
private javax.swing.JToggleButton cmd_Trazi;
private javax.swing.JLabel jLabel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTextField txt_id_robe;
private javax.swing.JTextField txt_kategorija_pretraga;
private javax.swing.JTextField txt_kategorija_pretraga_id;
// End of variables declaration
}
import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.JFrame;
import java.util.*;
import java.awt.BorderLayout;
import java.awt.Toolkit;
import java.applet.Applet;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.TableColumn;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Random;
import java.util.Vector;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;
import javax.swing.event.TableModelEvent;
import javax.swing.event.TableModelListener;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.TableCellRenderer;
import javax.swing.ListSelectionModel;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;
import javax.swing.table.DefaultTableModel;
import java.awt.Color;
import java.awt.Font;
import java.text.DecimalFormat;
import java.awt.Color;
import java.awt.Font;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.border.EmptyBorder;
import javax.swing.table.DefaultTableModel;
//Nazivi klasa pocinju velikim slovima, dakle FrmKategorije umesto frmKategorije.
public class FrmKategorije extends JFrame {
Connection conn = null;
ResultSet rs = null;
PreparedStatement pst = null;
ResultSet rss = null;
PreparedStatement psts = null;
Statement stmt = null;
private static final long serialVersionUID = 1L;
/** Creates new form frmKategorije */
//kad se prosledjuje parametar prvo ide tip klase (eto zasto nazivi klase pocinju VelikimSlovom), pa potom ide ime objekta, koji se pise malimSlovima
public FrmKategorije(final Roba frmRoba) {
//unutar metode initComponents nije vidljiva frmRoba pa je neophodno da se forma prosledi kao parametar
initComponents(frmRoba);
conn = javaconnect.ConnectDB();
Dimension dim = Toolkit.getDefaultToolkit().getScreenSize();
this.setLocation(dim.width / 2 - this.getSize().width / 2, dim.height / 2 - this.getSize().height / 2);
this.setResizable(false);
String z = "";
txt_id_robe.setText(z);
String y = txt_kategorija_pretraga.getText();
IspisiKategorije(y);
}
public void close() {
WindowEvent winClosingEvent = new WindowEvent(this, WindowEvent.WINDOW_CLOSING);
Toolkit.getDefaultToolkit().getSystemEventQueue().postEvent(winClosingEvent);
}
private void IspisiKategorije(String x) {
try {
String sqlr3 = "";
if (x.equals("")) {
sqlr3 = " SELECT IDKategorije AS ID, Kategorija FROM Kategorije ";
} else {
sqlr3 = " SELECT IDKategorije AS ID, Kategorija FROM Kategorije WHERE Kategorija like '%" + x + "%' ";
}
pst = conn.prepareStatement(sqlr3);
rs = pst.executeQuery();
System.out.println("sqk =: " + sqlr3);
while (rs.next()) {
Tbl_Kategorije.setModel(DbUtils.resultSetToTableModel(rs));
TableColumn col0 = Tbl_Kategorije.getColumnModel().getColumn(0);
col0.setPreferredWidth(10);
TableColumn col1 = Tbl_Kategorije.getColumnModel().getColumn(1);
col1.setPreferredWidth(90);
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex);
}
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents(final Roba frmRoba) {
jScrollPane1 = new javax.swing.JScrollPane();
Tbl_Kategorije = new javax.swing.JTable();
txt_kategorija_pretraga_id = new javax.swing.JTextField();
txt_kategorija_pretraga = new javax.swing.JTextField();
jLabel1 = new javax.swing.JLabel();
cmd_Trazi = new javax.swing.JToggleButton();
cmd_Izaberi = new javax.swing.JToggleButton();
txt_id_robe = new javax.swing.JTextField();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("Kategorije");
setAlwaysOnTop(true);
jScrollPane1.setName("jScrollPane1"); // NOI18N
Tbl_Kategorije.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Title 1", "Title 2", "Title 3", "Title 4"
}
));
Tbl_Kategorije.setName("Tbl_Kategorije"); // NOI18N
Tbl_Kategorije.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
Tbl_KategorijeMouseClicked(evt);
}
});
Tbl_Kategorije.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyReleased(java.awt.event.KeyEvent evt) {
Tbl_KategorijeKeyReleased(evt);
}
});
jScrollPane1.setViewportView(Tbl_Kategorije);
txt_kategorija_pretraga_id.setEditable(false);
txt_kategorija_pretraga_id.setName("txt_kategorija_pretraga_id"); // NOI18N
txt_kategorija_pretraga.setName("txt_kategorija_pretraga"); // NOI18N
jLabel1.setText("Pretraga");
jLabel1.setName("jLabel1"); // NOI18N
cmd_Trazi.setText("Traži");
cmd_Trazi.setName("cmd_Trazi"); // NOI18N
cmd_Trazi.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cmd_TraziActionPerformed(evt);
}
});
cmd_Izaberi.setText("Izaberi");
cmd_Izaberi.setName("cmd_Izaberi"); // NOI18N
cmd_Izaberi.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
//dakle metodi cmd_IzaberiActionPerformed() smo prosledili frmRoba ali dzaba kad ni initComponents() ne zna za frmRoba,
//znaci idemo u sam konstruktor klase i prosledjujemo frmRoba metodi initComponents(frmRoba)^^
cmd_IzaberiActionPerformed(evt, frmRoba);
}
});
txt_id_robe.setName("txt_id_robe"); // NOI18N
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()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 530, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(txt_kategorija_pretraga_id, javax.swing.GroupLayout.DEFAULT_SIZE, 65, Short.MAX_VALUE)
.addGap(51, 51, 51)
.addComponent(jLabel1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED))
.addGroup(layout.createSequentialGroup()
.addComponent(cmd_Izaberi)
.addGap(103, 103, 103)))
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(txt_kategorija_pretraga, javax.swing.GroupLayout.PREFERRED_SIZE, 301, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(cmd_Trazi))
.addComponent(txt_id_robe, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(cmd_Izaberi)
.addComponent(txt_id_robe, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 16, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txt_kategorija_pretraga_id, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txt_kategorija_pretraga, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1)
.addComponent(cmd_Trazi))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 280, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(62, 62, 62))
);
pack();
}// </editor-fold>
private void Tbl_KategorijeMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
int row = Tbl_Kategorije.getSelectedRow();
String Table_click = (Tbl_Kategorije.getModel().getValueAt(row, 0).toString());
try {
String sql_kom = "SELECT IDKategorije, Kategorija FROM Kategorije WHERE IDKategorije = " + Table_click + " ";
pst = conn.prepareStatement(sql_kom);
rs = pst.executeQuery();
if (rs.next()) {
String add1 = rs.getString("IDKategorije");
txt_kategorija_pretraga_id.setText(add1);
String add3 = rs.getString("Kategorija");
txt_kategorija_pretraga.setText(add3);
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex);
}
}
private void Tbl_KategorijeKeyReleased(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
int row = Tbl_Kategorije.getSelectedRow();
String Table_click = (Tbl_Kategorije.getModel().getValueAt(row, 0).toString());
try {
String sql_kom = "SELECT IDKategorije, Kategorija FROM Kategorije WHERE IDKategorije = " + Table_click + " ";
pst = conn.prepareStatement(sql_kom);
rs = pst.executeQuery();
if (rs.next()) {
String add1 = rs.getString("IDKategorije");
txt_kategorija_pretraga_id.setText(add1);
String add3 = rs.getString("Kategorija");
txt_kategorija_pretraga.setText(add3);
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex);
}
}
private void cmd_TraziActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String y = txt_kategorija_pretraga.getText();
IspisiKategorije(y);
}
//ova metoda ne zna za frmRoba, moras joj je proslediti Roba frmRoba
private void cmd_IzaberiActionPerformed(java.awt.event.ActionEvent evt, Roba frmRoba) {
// TODO add your handling code here:
int row = Tbl_Kategorije.getSelectedRow();
String Table_click = (Tbl_Kategorije.getModel().getValueAt(row, 0).toString());
frmRoba.izaberiKategoriju(Table_click); //** Ovde prijavljuje gresku frmRRobe??????? *///
//Naravno kad nije vidljivâ unutar metode, pogledaj gore ^^
setVisible(false);
dispose();
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/jav.../uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(frmKategorije.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(frmKategorije.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(frmKategorije.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(frmKategorije.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
// new frmKategorije(x).setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JTable Tbl_Kategorije;
private javax.swing.JToggleButton cmd_Izaberi;
private javax.swing.JToggleButton cmd_Trazi;
private javax.swing.JLabel jLabel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTextField txt_id_robe;
private javax.swing.JTextField txt_kategorija_pretraga;
private javax.swing.JTextField txt_kategorija_pretraga_id;
// End of variables declaration
}