Question: private void SearchButtonActionPerformed ( java . awt.event.ActionEvent evt ) { try { String ssn = SsnText.getText ( ) ; Connection conn = DriverManager.getConnection (
private void SearchButtonActionPerformedjavaawt.event.ActionEvent evt
try
String ssn SsnText.getText;
Connection conn DriverManager.getConnectionjdbc:postgresql:localhost:postgres "postgres", ;
Prepare the SQL query with a placeholder for the SSN
String sql "SELECT FROM medicallab.CleanerStaff WHERE ssn ;
PreparedStatement stmt conn.prepareStatementsql;
int sInteger.parseIntssn;
stmtsetInt s;
Execute the query and retrieve the results
ResultSet rs stmtexecuteQuery;
Check if any results were found
if rsnext
Fill the text fields with the retrieved data
FNameText.setTextrsgetStringfname;
MnameText.setTextrsgetStringmname;
LNameText.setTextrsgetStringlname;
SsnText.setTextrsgetStringssn;
PhoneNumberText.setTextrsgetStringphonenumber";
CityText.setTextrsgetStringcity;
StreetText.setTextrsgetStringstreet;
SalaryTextField.setTextrsgetStringsalary;
SpecificWardField.setTextrsgetStringspecificward";
jPasswordFieldsetTextrsgetStringPassword;
GenderComboBox.setSelectedItemrsgetStringgender;
Display a message indicating a match was found
JOptionPane.showMessageDialognull "Medical staff member found.";
else
Display a message indicating no match was found
JOptionPane.showMessageDialognullNo medical staff member found with that SSN "Search Result", JOptionPane.INFORMATIONMESSAGE;
Close resources
rsclose;
stmtclose;
conn.close;
catch SQLException ex
Handle SQL errors gracefully
JOptionPane.showMessageDialognullAn error occurred while searching: exgetMessage "Error", JOptionPane.ERRORMESSAGE;
Logger.getLoggerMedicalStaffJframeclass.getNamelogLevelSEVERE, null, ex;
private void FNameTextActionPerformedjavaawt.event.ActionEvent evt
TODO add your handling code here:
private void StreetTextActionPerformedjavaawt.event.ActionEvent evt
TODO add your handling code here:
private void SalaryTextFieldActionPerformedjavaawt.event.ActionEvent evt
TODO add your handling code here:
private void jButtonActionPerformedjavaawt.event.ActionEvent evt
DirectorFrame fnew DirectorFrame;
this.setVisiblefalse;
fsetVisibletrue;
private void ShowAllStaffsButtonActionPerformedjavaawt.event.ActionEvent evt
try Connection con DriverManager.getConnectionjdbc:postgresql:localhost:postgres "postgres",
con.setAutoCommitfalse;
Use a prepared statement to prevent SQL injection
PreparedStatement stmt con.prepareStatementSELECT FROM medicallab.CleanerStaff;
ResultSet rs stmtexecuteQuery;
String gender GenderComboBox.getSelectedItemtoString;
ShowAllCleanerStaffJFrame f new ShowAllCleanerStaffJFramersgender; Pass the ResultSet
fsetVisibletrue;
this.setVisiblefalse;
catch SQLException ex
JOptionPane.showMessageDialognullAn error occurred: exgetMessage "Error", JOptionPane.ERRORMESSAGE;
private void UpdateButtonActionPerformedjavaawt.event.ActionEvent evt
private void UpdateButtonMouseClickedjavaawt.event.MouseEvent evt
give me the code for the UpdateButtonActionPerformed
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
