Search in sources :

Example 26 with Member

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

the class MemberDao method selectById.

public Member selectById(String id) {
    String sql = "select * from member where member_id = ?";
    // select 값을 받아야하기 때문에 resultSet 와 비슷한 RowMaper를 사용 익명클래스 형태로 사용
    List<Member> result = jdbcTemplate.query(sql, new RowMapper<Member>() {

        @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.setPassword(rs.getString("password"));
            member.setRegdate(rs.getDate("regdate"));
            member.setPhoto(rs.getString("photo"));
            return member;
        }
    }, id);
    // null 이면 true반환
    return result.isEmpty() ? null : result.get(0);
}
Also used : SQLException(java.sql.SQLException) ResultSet(java.sql.ResultSet) Member(com.bitcamp.open.member.Model.Member)

Example 27 with Member

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

the class MemberListService method selectIdx.

// 리스트 개인정보 표기
public Member selectIdx(String idx) {
    dao = sqlSessionTemplate.getMapper(LoginDao.class);
    Member member = dao.selectIdx(idx);
    return member;
}
Also used : LoginDao(com.bitcamp.open.member.dao.LoginDao) Member(com.bitcamp.open.member.Model.Member)

Example 28 with Member

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

the class MemberViewService method viewMemberList.

public Member viewMemberList(String id) {
    Member member;
    dao = sqlSessionTemplate.getMapper(LoginDao.class);
    member = dao.viewInfo(id);
    return member;
}
Also used : LoginDao(com.bitcamp.open.member.dao.LoginDao) Member(com.bitcamp.open.member.model.Member)

Example 29 with Member

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

the class memberViewController method memberView.

@RequestMapping("/member/memberView")
public String memberView(@RequestParam("member_id") String member_id, Model model) {
    Member member = service.viewMemberList(member_id);
    model.addAttribute("member", member);
    return "member/memberView";
}
Also used : Member(com.bitcamp.open.member.model.Member) RequestMapping(org.springframework.web.bind.annotation.RequestMapping)

Example 30 with Member

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

the class memberUpdateController method memberUpdateForm.

@RequestMapping(method = RequestMethod.GET)
public String memberUpdateForm(@RequestParam("member_id") String member_id, Model model) {
    Member member = service.updateSelect(member_id);
    model.addAttribute("member", member);
    return "member/memberUpdateForm";
}
Also used : Member(com.bitcamp.open.member.model.Member) RequestMapping(org.springframework.web.bind.annotation.RequestMapping)

Aggregations

Member (com.bitcamp.open.member.model.Member)30 RequestMapping (org.springframework.web.bind.annotation.RequestMapping)22 Member (com.bitcamp.open.member.Model.Member)11 LoginDao (com.bitcamp.open.member.dao.LoginDao)10 ResultSet (java.sql.ResultSet)3 SQLException (java.sql.SQLException)3 List (java.util.List)2 HSSFSheet (org.apache.poi.hssf.usermodel.HSSFSheet)2 MemberDaoInter (com.bitcamp.open.member.dao.MemberDaoInter)1 MemberRowMapper (com.bitcamp.open.member.service.MemberRowMapper)1