Examples with Member com.bitcamp.open.member.Model.Member used on opensource projects

Example 6 with Member

use of com.bitcamp.open.member.Model.Member in project bitcampSCOpen2017 by ryuyj.

the class MemberDao method selectMembers.

public List<Member> selectMembers() {
    String sql = "select * from member";
    // select 값을 받아야하기 때문에 resultSet 와 비슷한 RowMaper를 사용 익명클래스 형태로 사용
    List<Member> result = jdbcTemplate.query(sql, new MemberRowMapper());
    // null 이면 true반환
    return result.isEmpty() ? null : result;
}

Example 7 with Member

use of com.bitcamp.open.member.Model.Member in project bitcampSCOpen2017 by ryuyj.

the class MemberRowMapper method mapRow.

@Override
public Member mapRow(ResultSet rs, int rowNum) throws SQLException {
    Member member = new Member();
    member.setIdx(rs.getInt("idx"));
    member.setMember_id(rs.getString("member_id"));
    member.setMember_name(rs.getString("member_name"));
    member.setPhoto(rs.getString("photo"));
    return member;
}

Example 8 with Member

use of com.bitcamp.open.member.Model.Member in project bitcampSCOpen2017 by ryuyj.

the class PageRanksView method buildExcelDocument.

@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request, HttpServletResponse response) throws Exception {
    // 1. 시트 생성
    HSSFSheet sheet = createFirstSheet(workbook);
    // 2. 라벨 처리
    createColumnLabel(sheet);
    // 3. 각 행별 데이터 처리
    List<Member> list = (List<Member>) model.get("member");
    int rowNum = 1;
    for (Member e : list) {
        createPageRankRow(e, sheet, rowNum++);
    }
    // 파일 이름설정
    response.setHeader("Content-Disposition", "attachment; filename=\"Member.xls\";");
}

Example 9 with Member

use of com.bitcamp.open.member.Model.Member in project bitcampSCOpen2017 by ryuyj.

the class MemberUpdateController method UpdateForm.

@RequestMapping(method = RequestMethod.GET)
public String UpdateForm(@RequestParam(value = "member_id", defaultValue = "0") String member_id, Model model) {
    // db 값 받아와서 jsp에 보내주기
    Member memberupdate = memberUpdateService.selectById(member_id);
    model.addAttribute("memberupdate", memberupdate);
    return "member/updateForm";
}

Example 10 with Member

use of com.bitcamp.open.member.Model.Member in project bitcampSCOpen2017 by ryuyj.

the class MemberLoginController method login.

@RequestMapping(method = RequestMethod.POST)
public // RequestParam 을 이용 넘어오는 파라미터를 처리
String login(@RequestParam(value = "member_id", defaultValue = "0") String member_id, // 값이 들어 오지 않아도(null) 에러안남 required=false
@RequestParam(value = "password", required = false) String password, HttpSession session) {
    Member member = memberLoginService.loginChk(member_id, password);
    if (member == null) {
        return "member/loginFail";
    }
    // 로그인시 로그인성공 메일 전송
    simpleRegistrationNotifier.sendMail(member.getMember_id(), "회원님 로그인이 성공적으로 처리 되었습니다 ");
    member.setPassword("");
    // 세션에 데이터 저장
    session.setAttribute("loginInfo", member);
    // 리다이렉트 처리 :mypage로 이동
    // /member/mypage ";//로그인 실패할시 이동할 경로
    String view = "redirect:mypage";
    return view;
}