No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
1 Posted Topic
UPDATE empDetail SET [Emp Name] = ?, Address = ?, Suburb = ?, PostCode =?, DOB = ?, [Home Phone] = ?, Extension = ?, Mobile =?, Email=? WHERE [Emp ID]=?"); try{ pst.setString(1,txtName.getText()); pst.setString(2,txtAddress.getText()); pst.setString(3,txtSuburb.getText()); pst.setString(4,txtPostCode.getText()); pst.setString(5,txtDOB.getText()); pst.setString(6,txtPhone.getText()); pst.setString(7,txtWorkExt.getText()); pst.setString(8,txtMobile.getText()); pst.setString(9,txtEmail.getText()); pst.setString(10, txtEmpNo.getText()); //or pst.setInt(10,Integer.parseInt(txtEmpNo.getText())); pst.executeUpdate(); JOptionPane.showMessageDialog(null, "Update"); } catch …
The End.