240502 숙제

[심지언]

SortList.java

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

package study.database;   import java.io.IOException; import java.util.ArrayList;   import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;   @SuppressWarnings("serial") @WebServlet("/SortList") public class SortList extends HttpServlet {     @Override     protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {         String sortType = request.getParameter("sort")==null ? "" : request.getParameter("sort");                  LoginDAO dao = new LoginDAO();                  ArrayList<LoginVO> vos = dao.getListSorted(sortType);         request.setAttribute("vos", vos);                  String viewPage = "/study/database/loginMain.jsp";         RequestDispatcher dispatcher = request.getRequestDispatcher(viewPage);         dispatcher.forward(request, response);     } }   Colored by Color Scripter

cs

LoginDAO.java

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

// 회원메인방의 회원 리스트 정렬 순서 선택     public ArrayList<LoginVO> getListSorted(String sortType) {         ArrayList<LoginVO> vos = new ArrayList<LoginVO>();         try {             sql = sortListCommonSqlQuery(sortType);              pstmt = conn.prepareStatement(sql);             rs = pstmt.executeQuery();             while (rs.next()) {                 LoginVO vo = new LoginVO();                 vo.setIdx(rs.getInt("idx"));                 vo.setMid(rs.getString("mid"));                 vo.setPwd(rs.getString("pwd"));                 vo.setName(rs.getString("name"));                 vo.setAge(rs.getInt("age"));                 vo.setGender(rs.getString("gender"));                 vo.setAddress(rs.getString("address"));                 vos.add(vo);             }         } catch (SQLException e) {             System.out.println("SQL 오류 : " + e.getMessage());         } finally {             rsClose();         }         return vos;     }          // 정렬 순서 선택을 위한 sql 공통 쿼리 + order by 필드명 desc or 생략     private String sortListCommonSqlQuery(String sortType) {         String baseSql = "SELECT * FROM hoewon ";         switch (sortType) {             case "latest": return baseSql + "ORDER BY idx DESC";             case "oldest": return baseSql + "ORDER BY idx";             case "midDesc": return baseSql + "ORDER BY mid DESC";             case "midAsc": return baseSql + "ORDER BY mid";             case "nameDesc": return baseSql + "ORDER BY name DESC";             case "nameAsc": return baseSql + "ORDER BY name";             case "ageDesc": return baseSql + "ORDER BY age DESC";             case "ageAsc": return baseSql + "ORDER BY age";             default: return baseSql;         }     } Colored by Color Scripter

cs

loginMain.jsp

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

<h2 class="text-center">회 원 메 인 방</h2>         <hr />         <div class="row">             <input type="button" value="전체조회"                 xxxxonclick="location.href='${ctp}/study/database/LoginList';"                 class="btn btn-success btn-sm ml-3 mb-3 mr-3" />                 <div class="dropdown">                     <button class="btn btn-primary btn-sm dropdown-toggle" data-toggle="dropdown">정렬선택</button>                     <div class="dropdown-menu">                         <a class="dropdown-item" xxxxonclick="location.href='${ctp}/SortList?sort=latest';">가입 최신순</a>                         <a class="dropdown-item" xxxxonclick="location.href='${ctp}/SortList?sort=oldest';">가입 오래된순</a>                         <a class="dropdown-item" xxxxonclick="location.href='${ctp}/SortList?sort=midDesc';">아이디 내림차순</a>                         <a class="dropdown-item" xxxxonclick="location.href='${ctp}/SortList?sort=midAsc';">아이디 오름차순</a>                         <a class="dropdown-item" xxxxonclick="location.href='${ctp}/SortList?sort=nameDesc';">이름 내림차순</a>                         <a class="dropdown-item" xxxxonclick="location.href='${ctp}/SortList?sort=nameAsc';">이름 오름차순</a>                         <a class="dropdown-item" xxxxonclick="location.href='${ctp}/SortList?sort=ageDesc';">나이 내림차순</a>                         <a class="dropdown-item" xxxxonclick="location.href='${ctp}/SortList?sort=ageAsc';">나이 오름차순</a>                     </div>                 </div> Colored by Color Scripter

cs

[행복]

다양한 정렬 아주 좋습니다.
dao의 다중선택부분을 조금 줄일수 있듯하네요. 수고하셨습니다.