Advertisement
Guest User

Untitled

a guest
May 5th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.47 KB | None | 0 0
  1. int Item = comboBoxTable.getSelectedIndex();
  2.  
  3. if (Item == 1) { /* Update table Computer List */
  4.  
  5.  
  6.  
  7. int selectedRow = table1.getSelectedRow();
  8.  
  9. Object value1 = table1.getModel().getValueAt(selectedRow, 1).toString();
  10. Object value2 = table1.getModel().getValueAt(selectedRow, 2).toString();
  11. Object value3 = table1.getModel().getValueAt(selectedRow, 3).toString();
  12. Object value4 = table1.getModel().getValueAt(selectedRow, 4).toString();
  13. Object value5 = table1.getModel().getValueAt(selectedRow, 5).toString();
  14. Object value6 = table1.getModel().getValueAt(selectedRow, 6).toString();
  15. Object value7 = table1.getModel().getValueAt(selectedRow, 7).toString();
  16. Object value8 = table1.getModel().getValueAt(selectedRow, 8).toString();
  17. Object value9 = table1.getModel().getValueAt(selectedRow, 9).toString();
  18. Object value10 = table1.getModel().getValueAt(selectedRow, 10).toString();
  19. Object value11 = table1.getModel().getValueAt(selectedRow, 11).toString();
  20. Object value12 = table1.getModel().getValueAt(selectedRow, 12).toString();
  21. JOptionPane.showMessageDialog(frmInventoryDatabaseManager,value2);
  22. try {
  23.  
  24. Connection lig = DriverManager.getConnection("jdbc:mysql://localhost/inventorydb", "root", "");
  25. PreparedStatement inst = lig.prepareStatement(
  26. "UPDATE computerlist SET Cpu_model = ?, Cpu_clock = ?, Ram = ?, Hdd = ?, "
  27. + "Os = ?, Archit = ?, Computer_name = ?, Computer_type = ?, Computer_brand = ?, "
  28. + "Computer_model = ?, Serial_number = ?, Status = ? WHERE ComputerID = ?");
  29.  
  30. inst.setString(1, (String) value1);
  31. inst.setDouble(2, (double) value2);
  32. inst.setFloat(3, (float) value3);
  33. inst.setDouble(4, (double) value4);
  34. inst.setString(5, (String) value5);
  35. inst.setString(6, (String) value6);
  36. inst.setString(7, (String) value7);
  37. inst.setString(8, (String) value8);
  38. inst.setString(9, (String) value9);
  39. inst.setString(10, (String) value10);
  40. inst.setString(11, (String) value11);
  41. inst.setString(12, (String) value12);
  42.  
  43. inst.setString(13, (String) table1.getValueAt(selectedRow, 0));
  44.  
  45. inst.executeUpdate();
  46. table1.repaint();
  47. lig.close();
  48.  
  49. } catch (SQLException e1) {
  50. JOptionPane.showMessageDialog(frmInventoryDatabaseManager,
  51. " Impossivel ligar á base de Dados \n" + e1.getLocalizedMessage());
  52. }
  53.  
  54. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement