Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- int Item = comboBoxTable.getSelectedIndex();
- if (Item == 1) { /* Update table Computer List */
- int selectedRow = table1.getSelectedRow();
- Object value1 = table1.getModel().getValueAt(selectedRow, 1).toString();
- Object value2 = table1.getModel().getValueAt(selectedRow, 2).toString();
- Object value3 = table1.getModel().getValueAt(selectedRow, 3).toString();
- Object value4 = table1.getModel().getValueAt(selectedRow, 4).toString();
- Object value5 = table1.getModel().getValueAt(selectedRow, 5).toString();
- Object value6 = table1.getModel().getValueAt(selectedRow, 6).toString();
- Object value7 = table1.getModel().getValueAt(selectedRow, 7).toString();
- Object value8 = table1.getModel().getValueAt(selectedRow, 8).toString();
- Object value9 = table1.getModel().getValueAt(selectedRow, 9).toString();
- Object value10 = table1.getModel().getValueAt(selectedRow, 10).toString();
- Object value11 = table1.getModel().getValueAt(selectedRow, 11).toString();
- Object value12 = table1.getModel().getValueAt(selectedRow, 12).toString();
- JOptionPane.showMessageDialog(frmInventoryDatabaseManager,value2);
- try {
- Connection lig = DriverManager.getConnection("jdbc:mysql://localhost/inventorydb", "root", "");
- PreparedStatement inst = lig.prepareStatement(
- "UPDATE computerlist SET Cpu_model = ?, Cpu_clock = ?, Ram = ?, Hdd = ?, "
- + "Os = ?, Archit = ?, Computer_name = ?, Computer_type = ?, Computer_brand = ?, "
- + "Computer_model = ?, Serial_number = ?, Status = ? WHERE ComputerID = ?");
- inst.setString(1, (String) value1);
- inst.setDouble(2, (double) value2);
- inst.setFloat(3, (float) value3);
- inst.setDouble(4, (double) value4);
- inst.setString(5, (String) value5);
- inst.setString(6, (String) value6);
- inst.setString(7, (String) value7);
- inst.setString(8, (String) value8);
- inst.setString(9, (String) value9);
- inst.setString(10, (String) value10);
- inst.setString(11, (String) value11);
- inst.setString(12, (String) value12);
- inst.setString(13, (String) table1.getValueAt(selectedRow, 0));
- inst.executeUpdate();
- table1.repaint();
- lig.close();
- } catch (SQLException e1) {
- JOptionPane.showMessageDialog(frmInventoryDatabaseManager,
- " Impossivel ligar á base de Dados \n" + e1.getLocalizedMessage());
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement