private void TableMouseClicked(
java.awt.event.MouseEvent evt) { // GEN-FIRST:event_TableMouseClicked
try {
ResultSet rs2;
PreparedStatement ps2;
Connection con;
con = DbConn.dbConnection();
int row = Table.getSelectedRow();
String table_click = Table.getModel().getValueAt(row, 1).toString();
String sql =
"select item_name,item_category,item_code,selling_rate,purchase_rate,warranty,supplier_name,opening_stock,re_order,brand_company from item where item_code like '"
+ table_click
+ "'";
ps2 = con.prepareStatement(sql);
rs2 = ps2.executeQuery();
if (rs2.next()) {
String add1 = rs2.getString("item_name");
itemName.setText(add1);
String add2 = rs2.getString("item_category");
itemCombo.setSelectedItem(add2);
String add3 = rs2.getString("item_code");
itemcode.setText(add3);
String add4 = rs2.getString("selling_rate");
sellR.setText(add4);
String add5 = rs2.getString("purchase_rate");
purchaseR.setText(add5);
String add6 = rs2.getString("warranty");
warranty.setText(add6);
String add7 = rs2.getString("supplier_name");
supplierNa.setSelectedItem(add7);
String add8 = rs2.getString("opening_stock");
openSto.setText(add8);
String add9 = rs2.getString("re_order");
reOrder.setText(add9);
String add10 = rs2.getString("brand_company");
brandCompany.setSelectedItem(add10);
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(this, ex);
}
} // GEN-LAST:event_TableMouseClicked
public int getSelectedRow() {
return mainTable.getSelectedRow();
}
