Java ResultSet Closed how to fix it

Java ResultSet Closed how to fix it

The problem is when I click on the Update Button to Insert Form to textfield where I can edit Appointments but when I click the UpdateButton there was An error "Result Set Closed"

The problem is when I click on the Update Button to Insert Form to textfield where I can edit Appointments but when I click the UpdateButton there was An error "Result Set Closed"

try {
    int row = jTable5.getSelectedRow();
    String Table_Click = (jTable5.getModel().getValueAt(row,0).toString());
    String sql = "Select Ap.Appointment_ID,Ap.Doc_ID,(Ut.First_Name) As Doc_FirstName,Ut.Middle_Name As Doc_MiddleName,Ut.Last_Name As Doc_LastName,Ap.Department_ID,Dt.Department_Name,Ap.Patient_ID,Pr.First_Name,Pr.Middle_Name,Pr.Last_Name,Ap.SchedDate,Ap.Description,Ap.App_Date_Registered from Appointment_Table As Ap\n" +
                     "inner join User_Table As Ut on Ap.Doc_ID=Ut.ID\n" +
                     "inner join Patient_Records As Pr on Ap.Patient_ID=Pr.Patient_ID\n" +
                     "inner join Department_Table As Dt on Ap.Department_ID=Dt.Department_ID\n" +
                     "where Appointment_ID = '"+Table_Click+"'";
    pst = conn.prepareStatement(sql);
    rs = pst.executeQuery();

if (rs.next()) {
    String add0 = rs.getString("Appointment_ID");
    AppointmentID.setText(add0);
    String add1 = rs.getString("Department_Name");
    DoctorDep_Update.setSelectedItem(add1);
    String add2 = rs.getString("Doc_FirstName");
    DoctorName_Update3.setText(add2);
    ....
}

} catch(Exception e) { JOptionPane.showMessageDialog(null, e); } finally { try { rs.close(); pst.close(); } catch(Exception e) {

}

}

When I put

String add2 = rs.getString("Doc_FirstName");
DoctorName_Update3.setText(add2);

the error appears I think there is some mistake in my query but I cannot solve it.. when I try to run it on SQlite Browser result show up

Exception

java.sql.SQLException: ResultSet closed
at org.sqlite.RS.checkOpen(RS.java:57)
at org.sqlite.RS.findColumn(RS.java:103)
at org.sqlite.RS.getString(RS.java:247)
at Portal.ReceptionistPortal.Update_AppointmentsActionPerformed(ReceptionistPortal.java:7912)
at Portal.ReceptionistPortal.access$1900(ReceptionistPortal.java:32)
at Portal.ReceptionistPortal$24.actionPerformed(ReceptionistPortal.java:2256)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6539)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6304)
at java.awt.Container.processEvent(Container.java:2239)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2297)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
at java.awt.Container.dispatchEventImpl(Container.java:2283)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
at java.awt.EventQueue$4.run(EventQueue.java:733)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

it is saying that the error is on

String add2 = rs.getString("Doc_FirstName");
DoctorName_Update3.setText(add2);


java database

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Java Core (2020) | Java for beginners | Brush up your Java Skills | Get Hired

In this video we will learn about all the major concepts that come under Java Core . The course is very carefully designed and is made with keeping simplicit...

Database Caching With Redis and Java

Explore database caching with Redis and Java and see some of the different caching strategies.

Java Fundamentals: Learn Java for absolute beginners |Simpliv

Java Fundamentals: Learn Java for absolute beginners

Insert File Into MySQL Database In Java

Sometimes we have a requirement to insert file into database rather then storing it in the file system. For a developer, it is always hard to decide this. You can find good discussion in different forums on web over storing the file either in database or file system. I believe choosing the same depends on the project requirement rather than preferences. You can choose database over file system when file size is small and user’s file needs to be more tightly coupled, secured and confidential. Since this discussion is out of scope of this article, here is a good resource,&nbsp;<a href="https://habiletechnologies.com/blog/better-saving-files-database-file-system/" target="_blank">Which is Better ? Saving Files in Database or File System</a>&nbsp;for your reference.

Java Essentials : Learn Core Java From Basic to Advance

Learn Java Programming Using Practical Assignments. Start Building Back-end Web Applications Robust Test Automation Frameworks By End Of The Course. Learn More!