2011. 9. 16. 11:44

jstl(foreach)을 사용하여 리스트 보여주기

-------------------------- SearchServlet.java ------------------------------

public class SearchServlet extends HttpServlet {
private static final long serialVersionUID = 1L;

    public SearchServlet() {
        super();
    }

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
processRequest(request, response);
}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
processRequest(request, response);
}

protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        SearchList list = new SearchList();
        ArrayList<Map<String,String>> SearchFAQList = list.selectFAQList();
request.setAttribute("SearchFAQDList", SearchFAQList);
        RequestDispatcher view = request.getRequestDispatcher("SearchList.jsp");
        view.forward(request, response);
}
}

---------------------------- SearchList.java --------------------------------

public class SearchList {
DBHandler db = null;
ArrayList<Map<String,String>> retList = null;
public ArrayList<Map<String,String>> selectFAQList(){
db = new DBHandler();

    StringBuffer selQuery = new StringBuffer();
    selQuery.append("select * from faqBoar");
   
    retList = db.selectQueryData(selQuery.toString());
    return retList;
}
}

---------------------------- SearchList.jsp ---------------------------------

<c:forEach items="${SearchFAQDList}" var="searchFAQMap" varStatus="idx">
<tr>
<td>${idx.count}</td>
<td>${searchFAQMap.category_name}</td>
<td>${searchFAQMap.type_name}</td>
</tr>
</c:forEach>