public void display(ResultSet rs) {
try {
boolean recordNumber = rs.next();
if (recordNumber) {
payNo = rs.getString(1);
pasNo = rs.getString(2);
pasName = rs.getString(3);
mode = rs.getString(4);
dt = rs.getString(5);
amount = rs.getString(6);
rev = rs.getString(7);
text1.setText(payNo);
combo1.setSelectedItem(pasNo);
combo2.setSelectedItem(pasName);
combo4.setSelectedItem(mode);
p_date.setText(dt);
combo8.setSelectedItem(amount);
combo3.setSelectedItem(rev);
} else {
JOptionPane.showMessageDialog(
null, "Record Not found", "ERROR", JOptionPane.DEFAULT_OPTION);
}
} catch (SQLException sqlex) {
sqlex.printStackTrace();
}
}
/**
* Set calendar to this week's Monday; set year and week combo boxes to the currently set date;
* set the date labels appropriately; and, refresh the review table.
*/
private void updateYearWeekDates() {
yearWeekCalendar.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY);
yearWeekCalendar.set(Calendar.HOUR_OF_DAY, 0);
yearWeekCalendar.set(Calendar.MINUTE, 0);
yearWeekCalendar.set(Calendar.SECOND, 0);
yearWeekCalendar.set(Calendar.MILLISECOND, 0);
yearCB.setSelectedItem(yearWeekCalendar.get(Calendar.YEAR));
weekCB.setSelectedItem(yearWeekCalendar.get(Calendar.WEEK_OF_YEAR));
fromDate.setDate(yearWeekCalendar);
yearWeekCalendar.add(Calendar.DAY_OF_MONTH, 7);
toDate.setDate(yearWeekCalendar);
yearWeekCalendar.add(Calendar.DAY_OF_MONTH, -7);
refreshReviewTable();
}
