Updating Database Problem...
i want to be able to update individual contacts in my table but ive run into a problem: when i update 1 contact ALL contacts in the table get updated with the same info as the contact that i updated. i know where im going wrong and i need ur help to fix it :)
publicvoid updateContact(ContactPanel updatePanel){
try{
preparedStatement = connection.prepareStatement("update A set NAME = ?, NUMBER = ?, EMAIL = ?");
preparedStatement.setString(1, updatePanel.getName());
preparedStatement.setString(2, updatePanel.getNumber());
preparedStatement.setString(3, updatePanel.getEMail());
preparedStatement.executeUpdate();
}catch(SQLException ex){
ex.printStackTrace();
}
}
its this line of code thats causing the problem:
preparedStatement = connection.prepareStatement("update A set NAME = ?, NUMBER = ?, EMAIL = ?");
im updating the whole table and not just a single contact. any1 got ideas of how i could update a single contact? thnx :)
