the below code display the bill date fields empty when testing the code.can someone assist in identifying the error?
String custId = request.getParameter("customerId");
String emailId = request.getParameter("emailId");
String phoneNumber = request.getParameter("phoneNumber");
String[] dateStr = new String[3];
String[] status = new String[3];
try { //Code to connect to the database
String sql = "select bill_id, customer_id, bill_date, status from customer_bills where customer_id=? and status='Paid'";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, custId);
ResultSet rs = stmt.executeQuery();
}
conn.close();
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//Code to display the details
}