6 Replies Latest reply on Sep 2, 2013 7:31 AM by Asim Shaikh

    How to fetch Selected Date Records from Rich:Calender

    Asim Shaikh Novice

      Hi Everyone I have some problem in fetching Data through calender  My Question is How I can go to records of selected date using rich calender what I want my code to do is after selecting any date from the calender It will search the Date in Table and showing me the related records. present in the table

       

      <------------------Jsp------------------------------------------>

       

      <rich:calendar value="#{eventMaster.eventDate}"

                                               popup="#{eventMaster.popup}" datePattern="#{eventMaster.pattern}"

                                               showApplyButton="#{eventMaster.showApply}" cellWidth="24px" cellHeight="22px" style="width:200px"

                                               disabled="#{eventMaster.disabled or eventMaster.viewMode}"

                                               ondateselect="eventMaster.searchOutputScreenRecords">

                                </rich:calendar>

       

      <-----Bean----->

       

      public Date getEventDate() {

       

          return eventDate;

       

        }

       

        public void setEventDate(Date eventDate) {

       

          this.eventDate = eventDate;

       

        }

       

      <-----action ----->

       

      public String searchOutputScreenRecords() {

       

          try {

       

            this.searchVariableAvailable = true;

       

            EventMasterOps opsObj = new EventMasterOps();

       

            if (this.outputSearch != null) {

       

              this.outputList = opsObj.searchRecordsInDatabase(this.outputSearch, ConstantsUtility.searchOutputForm);

       

              if (this.outputList == null) {

       

                this.massage = "No Search Record is found.";

       

              }

       

            }

       

          } catch (Exception e) {

       

            log.info("exception in EventMaster:searchOutputScreenRecords()::" + e.getMessage());

       

          }

       

          return "outputClient";

       

        }

       

      <-----Operation file from where I am calling query---------------->

       

      public List<EventMasterBean> searchRecordsInDatabase(String searchValue, String formType) {

       

          FindDescriptionHelper fdHelp = new FindDescriptionHelper();

       

          PreparedStatement pstmt = null;

       

          ResultSet rs = null;

       

       

       

          try {

       

            this.eventmaster = new ArrayList<EventMasterBean>();

       

            SqlSearchQuriesUtil searchqueryUtil = new SqlSearchQuriesUtil();

       

            String query = "";

       

      if (formType.equals(ConstantsUtility.searchInputForm)) {

       

              query = searchqueryUtil.getEventSearchInputQuery(searchValue);

       

        

       

            }