Question: private void SearchButtonActionPerformed ( java . awt.event.ActionEvent evt ) { try { String ssn = SsnText.getText ( ) ; Connection conn = DriverManager.getConnection (

private void SearchButtonActionPerformed(java.awt.event.ActionEvent evt){
try {
String ssn = SsnText.getText();
Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres", "postgres", "112233445");
// Prepare the SQL query with a placeholder for the SSN
String sql = "SELECT * FROM medical_lab.\"Cleaner_Staff\" WHERE ssn =?";
PreparedStatement stmt = conn.prepareStatement(sql);
int s=Integer.parseInt(ssn);
stmt.setInt(1, s);
// Execute the query and retrieve the results
ResultSet rs = stmt.executeQuery();
// Check if any results were found
if (rs.next()){
// Fill the text fields with the retrieved data
FNameText.setText(rs.getString("fname"));
MnameText.setText(rs.getString("mname"));
LNameText.setText(rs.getString("lname"));
SsnText.setText(rs.getString("ssn"));
PhoneNumberText.setText(rs.getString("phone_number"));
CityText.setText(rs.getString("city"));
StreetText.setText(rs.getString("street"));
SalaryTextField.setText(rs.getString("salary"));
SpecificWardField.setText(rs.getString("specific_ward"));
jPasswordField1.setText(rs.getString("Password"));
GenderComboBox.setSelectedItem(rs.getString("gender"));
// Display a message indicating a match was found
JOptionPane.showMessageDialog(null, "Medical staff member found.");
} else {
// Display a message indicating no match was found
JOptionPane.showMessageDialog(null,"No medical staff member found with that SSN.", "Search Result", JOptionPane.INFORMATION_MESSAGE);
}
// Close resources
rs.close();
stmt.close();
conn.close();
} catch (SQLException ex){
// Handle SQL errors gracefully
JOptionPane.showMessageDialog(null,"An error occurred while searching: "+ ex.getMessage(), "Error", JOptionPane.ERROR_MESSAGE);
Logger.getLogger(MedicalStaffJframe.class.getName()).log(Level.SEVERE, null, ex);}
}
private void FNameTextActionPerformed(java.awt.event.ActionEvent evt){
// TODO add your handling code here:
}
private void StreetTextActionPerformed(java.awt.event.ActionEvent evt){
// TODO add your handling code here:
}
private void SalaryTextFieldActionPerformed(java.awt.event.ActionEvent evt){
// TODO add your handling code here:
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt){
DirectorFrame f=new DirectorFrame();
this.setVisible(false);
f.setVisible(true);
}
private void ShowAllStaffsButtonActionPerformed(java.awt.event.ActionEvent evt){
try (Connection con = DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres", "postgres", "112233445")){
con.setAutoCommit(false);
// Use a prepared statement to prevent SQL injection
PreparedStatement stmt = con.prepareStatement("SELECT * FROM medical_lab.\"Cleaner_Staff\"");
ResultSet rs = stmt.executeQuery();
String gender = GenderComboBox.getSelectedItem().toString();
ShowAllCleanerStaffJFrame f = new ShowAllCleanerStaffJFrame(rs,gender); // Pass the ResultSet
f.setVisible(true);
this.setVisible(false);
} catch (SQLException ex){
JOptionPane.showMessageDialog(null,"An error occurred: "+ ex.getMessage(), "Error", JOptionPane.ERROR_MESSAGE);
}
}
private void UpdateButtonActionPerformed(java.awt.event.ActionEvent evt){
}
private void UpdateButtonMouseClicked(java.awt.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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!