Search in sources :

Example 36 with Member

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

the class MemberUpdateService method UpdateSelect.

public Member UpdateSelect(String idx) {
    Member member;
    dao = sqlSessionTemplate.getMapper(LoginDao.class);
    member = dao.selectIdx(idx);
    return member;
}
Also used : LoginDao(com.bitcamp.open.member.dao.LoginDao) Member(com.bitcamp.open.member.Model.Member)

Example 37 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(value = "member_id", defaultValue = "0") String id, Model model) {
    Member member = memberInfoService.memberInfo(id);
    model.addAttribute("member", member);
    return "member/memberUpdateForm";
}
Also used : Member(com.bitcamp.open.member.model.Member) RequestMapping(org.springframework.web.bind.annotation.RequestMapping)

Example 38 with Member

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

the class MemberDao method selectAll.

public List<Member> selectAll() {
    String sql = "select * from member";
    List<Member> results = 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_name(rs.getString("member_name"));
            member.setMember_id(rs.getString("member_id"));
            member.setMember_pw(rs.getString("member_pw"));
            member.setMember_date(rs.getDate("member_date"));
            member.setMember_photo(rs.getString("member_photo"));
            return member;
        }
    });
    return results.isEmpty() ? null : results;
}
Also used : SQLException(java.sql.SQLException) ResultSet(java.sql.ResultSet) Member(com.bitcamp.open.member.model.Member)

Example 39 with Member

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

the class MemberUpdateController method memberUpdate.

@RequestMapping(method = RequestMethod.GET)
public String memberUpdate(@RequestParam("member_id") String id, Model model) {
    // sql문을 가져옴
    Member members = memberUpdateService.selectById(id);
    model.addAttribute("members", members);
    return "/member/memberUpdate";
}
Also used : Member(com.bitcamp.open.member.model.Member) RequestMapping(org.springframework.web.bind.annotation.RequestMapping)

Example 40 with Member

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

the class MemberInfoController method memberInfo.

@RequestMapping("/member/memberInfo")
public String memberInfo(@RequestParam(value = "member_id", defaultValue = "0") String id, Model model) {
    Member member = memberInfoService.memberInfo(id);
    model.addAttribute("member", member);
    return "member/mypage";
}
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