public Receipt getReceiptDetails(int receiptId) { Receipt receipt = new Receipt(); try { DBConnection receiptSc = (DBConnection) sc.getAttribute("dbConn"); receiptConn = receiptSc.getDBConnection(); receiptStmt = receiptConn.prepareStatement("SELECT * FROM tbl_student_fees_receipt where receipt_id=?"); receiptStmt.setInt(1, receiptId); receiptRs = receiptStmt.executeQuery(); receiptRs.next(); receipt.setReceiptId(receiptRs.getInt("receipt_id")); receipt.setStudentId(receiptRs.getInt("student_id")); receipt.setSemester(receiptRs.getInt("semester")); receipt.setTotalFees(receiptRs.getDouble("total_fees")); receipt.setPendingFees(receiptRs.getDouble("fees_pending")); receipt.setStatus(receiptRs.getInt("status")); } catch (Exception e) { System.out.println("Exception in getting receipt details of Receipt controller" + e); } finally { close(); } return receipt; }