[JSP]아이템 구매 리스트 구현

 

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

    }else if(command.equals("/item/itemList.do")) {
            
            
            
            ItemDao iv = new ItemDao();
            
            
            
            
            ArrayList<ItemVo> alist = iv.itemselectAll();
            
            
            
            System.out.println("alist = " +alist);
            
            request.setAttribute("alist", alist);
            
            
            
            
        
            
            RequestDispatcher rd = request.getRequestDispatcher("/item/itemList.jsp");
            
            rd.forward(request, response);
        

    public ArrayList<ItemVo> itemselectAll(){
        ArrayList<ItemVo> alist = new ArrayList<ItemVo>();
        
        System.out.println("리스트 다오");
        ResultSet rs = null;
        
        String sql = "SELECT * FROM item ORDER BY itemidx DESC";
        
        
        try {
            pstmt = conn.prepareStatement(sql);
            rs = pstmt.executeQuery();
            
            System.out.println("rs =" +rs);
            // while 문을 사용해야함
            while(rs.next()) {
                
                ItemVo iv = new ItemVo();
                iv.setItemidx(rs.getInt("itemidx"));
                iv.setItemName(rs.getString("itemName"));
                iv.setItemQuantity(rs.getInt("itemQuantity"));
                iv.setMidx(rs.getInt("midx"));
                iv.setWriteday(rs.getString("writeday"));
                iv.setMemberName(rs.getString("membername"));
                iv.setItemPriceSum(rs.getInt("itempricesum"));
                iv.setItemPrice(rs.getInt("itemprice"));
                alist.add(iv);
                
                System.out.println("iv =" + iv);
                
            }
            
        } catch (Exception e) {
            e.printStackTrace();
        }
        
        return alist;
    }