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(); }