Spring #4 - List, Delete

1. MemberDB

1. 회원전체목록
   : selectListMember
   : public List<Member> selectListMember();
2. 회원삭제
   : deleteMember
   : public int deleteMember(String id);

2. MemberDBImpl.java

1. 목록

@Override
public List<Member> selectListMember() {
    try {
        Query query = new Query();
        return mongodb.find(query, Member.class);
        // return mongodb.find(new Query(), Member.class); // 이 한줄로 끝남
    } catch (Exception e) {
        e.printStackTrace();
        return null;
    }
}

2. 삭제

@Override
public int deleteMember(String id) {
    try {
        Member member = new Member();
        member.setId(id);

        DeleteResult result = mongodb.remove(member);
        System.out.println("result ===> " + result);
        if (result.getDeletedCount() == 1L) {
            return 1;
        }
        return 0;
    } catch (Exception e) {
        e.printStackTrace();
        return -1;
    }
}

3. MemberController.java

1. 목록

@GetMapping(value = { "/selectlist" })
public String selectlistGET(Model model) {
    // 1. DB에서 목록 받아오기
    List<Member> list = memberDB.selectListMember();
    // 2. jsp로 전달하기
    model.addAttribute("list", list);
    // 3. member폴더의 select.jsp를 표시하라
    return "member/select";
}

2. 삭제

@GetMapping(value = { "delete" })
public String deleteGET(@RequestParam(name = "id") String id) {
    int ret = memberDB.deleteMember(id);
    if (ret == 1) {
        return "redirect:/member/selectlist";
    }
    return "redirect:/member/selectlist";
}