MVC_상품정보 관리 문제

 

컨트롤러 패키지

---

ItemController.java

 

 

서비스 패키지

---

ItemService.java - 인터페이스

 

 

ItemWriteSevice.java - 상품 작성

 

 

ItemContentService.java - 목록

 

 

DAO

---

public class ItemDao {
    DataSource dataSource;
    
    public ItemDao() {
        try {
            Context ctx = new InitialContext();
            dataSource = (DataSource) ctx.lookup("java:comp/env/jdbc/oracle");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    
    //목록 불러오는 메서드
    public ArrayList<ItemDto> list() {
        ArrayList<ItemDto> dtos = new ArrayList<ItemDto>();
        Connection con = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        
        try {
            con = dataSource.getConnection();
            String sql = "select name, price, description from test_item order by name";
            pstmt = con.prepareStatement(sql);
            rs = pstmt.executeQuery();
            
            while (rs.next()) {
                String name = rs.getString("name");
                int price = rs.getInt("price");
                String description = rs.getString("description");
                
                ItemDto dto = new ItemDto(name, price, description);
                dtos.add(dto);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            try {
                if(rs != null)rs.close();
                if(pstmt != null)pstmt.close();
                if(con != null)con.close();
            } catch (Exception e2) {
                e2.printStackTrace();
            }
        }
        return dtos;        
    }
    
    //글 작성하는 메서드
    public void itemWrite(String name, String price, String description) {
        Connection con = null;
        PreparedStatement pstmt = null;
        
        try {
            con = dataSource.getConnection();
            String sql = "insert into test_item (name, price, description) values (?,?,?)";
            pstmt = con.prepareStatement(sql);
            //ItemWriteService에서 넘어온 값들을 넣어줌
            pstmt.setString(1, name);
            pstmt.setInt(2, Integer.parseInt(price));
            pstmt.setString(3, description);
            pstmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            try {
                if(pstmt != null)pstmt.close();
                if(con != null)con.close();
            } catch (Exception e2) {
                e2.printStackTrace();
            }
        }
    }
}

 

DTO

---

 

 

뷰

---

itemWrite.jsp - 상품등록 

 

 

writeResult.jsp - 결과 보기

 

 

content_view.jsp - 상품 목록