public void listRecordByPrescribedDate(String start_date, String end_date,
			int employee_no) {
		String selectQuery = "SELECT r.PATIENT_NO, t.TEST_NAME, p.NAME, r.PRESCRIBE_DATE "
				+ "FROM TEST_RECORD r, PATIENT p, TEST_TYPE t "
				+ "WHERE r.PATIENT_NO = p.HEALTH_CARE_NO "
				+ "AND r.TYPE_ID = t.TYPE_ID "
				+ "AND r.PRESCRIBE_DATE BETWEEN TO_DATE('"
				+ start_date
				+ "','DD/MM/YYYY') "
				+ "AND TO_DATE('"
				+ end_date
				+ "','DD/MM/YYYY') " + "AND r.EMPLOYEE_NO =" + employee_no;

		try {
			rs = stmt.executeQuery(selectQuery);
			System.out
					.println("PATIENT NO \t TEST NAME \t\t\t PATIENT NAME \t\t PRESCRIBE DATE");
			while (rs.next()) {
				System.out
						.println(rs.getInt(1) + "\t\t" + rs.getString(2)
								+ "\t\t\t" + rs.getString(3) + "\t\t\t"
								+ rs.getDate(4));
			}
		} catch (SQLException e) {
			System.out.println("Could not execute the query.");
		}
	}