[JSP]예약한거 LIST 구현 (예약리스트구현)

 

jsp 회원등록,수정,삭제,리스트(CRUD) 로직 구현하기 예약 리스트 구현

    }else if(command.equals("/res/resList.do")) {
            
            
            
            ResDao rd = new ResDao();
            
            ArrayList<ResVo> alist = rd.ResselectAll();
            
            
            request.setAttribute("alist", alist);
            
            
            System.out.println("alist = "+alist);
            
            
            
            
            RequestDispatcher rd1 = request.getRequestDispatcher("/res/resList.jsp");
            rd1.forward(request, response);

public ArrayList<ResVo> ResselectAll(){
        ArrayList<ResVo> alist = new ArrayList<ResVo>();
        
        
        ResultSet rs = null;
        
        String sql = "select * from reservation order by ridx desc";
        
        
        
        try {
            pstmt = conn.prepareStatement(sql);
            rs = pstmt.executeQuery();
            
            
            while(rs.next()) {
                ResVo rv = new ResVo();
                
                
                rv.setRvname(rs.getString("rvname"));
                rv.setRvpeople(rs.getInt("rvpeople"));
                rv.setWritedayA(rs.getString("WRITEDAYA"));
                rv.setWriteday(rs.getString("writeday"));
                rv.setMidx(rs.getInt("midx"));
                rv.setMembername(rs.getString("membername"));
                rv.setRidx(rs.getInt("ridx"));
                rv.setRvPrice(rs.getInt("rvprice"));
                rv.setRvPriceSum(rs.getInt("rvpricesum"));
                
                
                
                alist.add(rv);
            }
            
        } catch (Exception e) {
            e.printStackTrace();
        }
        
        
        return alist;
    }