Why is my second dropdown menu not getting populated?

Question

I am using JSP, STRUTS2, AJAX, jQuery, and MySQL to populate dependent dropdowns. I would like to know why my second dropdown is not getting populated? Please let me know what I am missing here.

AjaxJsonAction.java

package com.action;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import org.json.JSONArray;


import com.opensymphony.xwork2.Action;
public class AjaxJsonAction implements Action{

    private Map stateMap = new LinkedHashMap();
    private String dummyMsg;
    //Parameter for Jquery
    private String countryName;
    private String eventName;
//
//  private Map eventList = new LinkedHashMap();
//  private Map eventDateList = new LinkedHashMap();
    private ArrayList eventList;
    private ArrayList eventShowList;
    private Map edList = new LinkedHashMap();

    public Map getStateMap() {
        return stateMap;
    }

    public String getDummyMsg() {
        return dummyMsg;
    }

    public String getCountryName() {
        return countryName;
    }


    public void setStateMap(Map stateMap) {
        this.stateMap = stateMap;
    }

    public void setDummyMsg(String dummyMsg) {
        this.dummyMsg = dummyMsg;
    }

    public void setCountryName(String countryName) {
        this.countryName = countryName;
    }

//  public Map getEventList() {
//      return eventList;
//  }
//  public void setEventList(Map eventList) {
//      this.eventList = eventList;
//  }
//  
//  public Map getEventDateList() {
//      return eventDateList;
//  }
//  public void setEventDateList(Map eventDateList) {
//      this.eventDateList = eventDateList;
//  }
    public String getEventName() {
        return eventName;
    }

    public void setEventName(String eventName) {
        this.eventName = eventName;
    }
    public ArrayList getEventList() {
        return eventList;
    }

    public void setEventList(ArrayList eventList) {
        this.eventList = eventList;
    }

    public ArrayList getEventShowList() {
        return eventShowList;
    }

    public void setEventShowList(ArrayList eventShowList) {
        this.eventShowList = eventShowList;
    }

public Map getedList() {
    return edList;
}
public void setedList(Map edList) {
    this.edList = edList;
}


private List eventShows;

public List getEventShows() { return eventShows; }

    public String execute() {

//      dummyMsg = "Ajax action Triggered";
//      return SUCCESS;
        System.out.println("inside execute.");
        populateEvent();
         System.out.println("eventList Count="+eventList.size());
//      populateShow(eventName);
        return "success";
    }

    public void populateEvent() {
        System.out.println("inside populateEvent.");
        Connection conn = null;

          try {
             String URL = "jdbc:mysql://localhost:3306/bookmyshow_dates";
             Class.forName("com.mysql.jdbc.Driver");
             conn = DriverManager.getConnection(URL, "dra2", "dr@2");
             String sql = "SELECT DISTINCT * FROM EVENTS";
//           String sql ="SELECT * FROM user3333";
         PreparedStatement ps = conn.prepareStatement(sql);

             ResultSet rs = ps.executeQuery();

             eventList = new ArrayList();
             while (rs.next()) {
//               eventList.put(rs.getString("EventId"),rs.getString("EventName"));
                 eventList.add(new Event(rs.getInt("EventId"),rs.getString("EventName")));
             }
          } catch (Exception e) {
//            return "error";
          } 
          finally {
             if (conn != null) {
                try {
                   conn.close();
                } catch (Exception e) {
                }
             }
          }
          System.out.println("inside populateEvent End.");

//        return "getEventList";
    }

//  public void populateShow(String eventName) {
//  public ArrayList populateShow() {
//  public Map populateShow() {
    public void populateShow() {
        String eventId="1";
        System.out.println("parameter:"+eventId);
        Connection conn = null;

          try {
             String URL = "jdbc:mysql://localhost:3306/bookmyshow_dates";
             Class.forName("com.mysql.jdbc.Driver");
             conn = DriverManager.getConnection(URL, "dra2", "dr@2");


             String sql="SELECT ShowId,EventDate,
" + 
                    "CASE 
" + 
                    "   WHEN DATEDIFF(EventDate,NOW()) = 0 THEN CONCAT('Today',', ',DAY(EventDate),' ',MONTHNAME(EventDate))
" + 
                    "   WHEN DATEDIFF(EventDate,NOW()) = 1 THEN CONCAT('Tomorrow',', ',DAY(EventDate),' ',MONTHNAME(EventDate))
" + 
                    "   WHEN DATEDIFF(EventDate,NOW()) > 1 THEN CONCAT(DAYNAME(EventDate),', ',DAY(EventDate),' ',MONTHNAME(EventDate))
" + 
                    "END AS EventDay
" + 
                    ",es.EventId
" + 
                    "FROM EventShows es
" + 
                    "INNER JOIN EVENTS e ON es.EventId = e.EventId AND (EventDate>=NOW())
" + 
                    "WHERE e.EventId='"+eventId+" ';";
//           String sql ="SELECT * FROM user3333";
         PreparedStatement ps = conn.prepareStatement(sql);

             ResultSet rs = ps.executeQuery();

             eventShowList = new ArrayList();
             while (rs.next()) {
                 eventShowList.add(new EventShow(rs.getInt("ShowId"),rs.getString("EventDay"),rs.getInt("EventId")));
//               eventDateList.put(rs.getString("EventId"), rs.getString("EventName"));
                 edList.put(rs.getString("EventId"), rs.getString("EventName"));
             }
          } catch (Exception e) {
//            return "error";
          } 
          finally {
             if (conn != null) {
                try {
                   conn.close();
                } catch (Exception e) {
                }
             }
          }
System.out.println("eventShowList:"+eventShowList.size());
//      JSONArray jsArray = new JSONArray(eventShowList);

        // Converts JSON string into a List of Product object
//      List eventShows = ((List) eventShowList);
//       return eventShowList;
    }

}

Event.java

package com.action;

public class Event {
    private int eventId;

    private String eventName;

    Event(int eventId, String eventName)
    {
        this.eventId = eventId;
        this.eventName = eventName;
    }

    public int getEventId() {
        return eventId;
    }
    public void setEventId(int eventId) {
        this.eventId = eventId;
    }
    public String getEventName() {
        return eventName;
    }
    public void setEventName(String eventName) {
        this.eventName = eventName;
    }

}

EventShow.java

package com.action;

public class EventShow {

    private int showId;
    private String eventDate;
    private int eventId;

    EventShow(int showId, String eventDate, int eventId)
    {
        this.showId = showId;
        this.eventId = eventId;
        this.eventDate = eventDate;
    }

    public int getshowId() {
        return showId;
    }

    public void setShowId(int showId) {
        this.showId = showId;
    }
    public String getEventDate() {
        return eventDate;
    }

    public void setEventDate(String eventDate) {
        this.eventDate = eventDate;
    }
    public int getEventId() {
        return eventId;
    }
    public void setEventId(int eventId) {
        this.eventId = eventId;
    }

}

struts.xml






    
        /index.jsp
        /error.jsp
    

    

            /index.jsp

web.xml



  Struts2
  
    struts2
    
            org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
  
  
    struts2
    /*
  
  
    index.jsp

index.jsp

<%@ taglib prefix="s" uri="/struts-tags"%>


AJAX in Struts 2 using JSON and jQuery




    AJAX calls to Struts 2 using JSON and jQuery

Also, I am getting JSON response as NULL in the function: $('#event').change(function(event).

prem30488 · Accepted Answer

You need to make some corrections.

Step 1: In struts.xml file


  /index.jsp

Step 2: In AjaxJsonAction.java

public String populateShow() {
    edList.put("1", "Monday");// Fill this map with your database values
    return "success";
}

Step 3: In index.jsp -> Use jquery js from cdn and use below code

Provide me reply if you get any more error.

Why is my second dropdown menu not getting populated?

Answers (2)

Related Questions