How to handle Add button click event to save patient data in hospital management system?

1 week ago 15
ARTICLE AD BOX

I am working on a Java hospital management system project.

I have an Add button on a form.
When I click the button, I want to save patient details to the database.

I am not sure how to correctly handle the button click event.

Below is the code I have tried.

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: String pid=patientid.getText(); int patientId=Integer.parseInt(pid); String pname=patientName.getText(); String page=patientAge.getText(); int patientAge=Integer.parseInt(page); String dname=doctorName.getText(); try { Class.forName("com.mysql.cj.jdbc.driver"); try (Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/HospitalManagementSystem","root","0000")) { String query="insert into patient values(?,?,?,?)"; PreparedStatement pstmt=con.prepareStatement(query); pstmt.setInt(1, patientId); pstmt.setString(2, pname); pstmt.setInt(3, patientAge); pstmt.setString(4, dname); pstmt.executeUpdate(); } JOptionPane.showMessageDialog(this,"Data Inserted......"); } catch(HeadlessException | ClassNotFoundException | SQLException e) { JOptionPane.showMessageDialog(this,e); } }
Read Entire Article