구글맵 지도퍼가기

구글맵 → 검색 → 공유 → 지도퍼가기 → HTML 복사

• 아이디 중복체크 sql

서비스

• boot.data.service 패키지 생성

  → MemberServiceInter 인터페이스, MemberService 클래스 생성(인터페이스 상속 필요)

• mapper

  <mapper namespace="boot.data.mapper.MemberMapperInter">
  	<select id="getAllMembers" resultType="MemberDto">
  		select * from bootmember
  		order by id
  	</select>
  </mapper>
  

• mapperinter / serviceinter

  @Mapper
  public interface MemberMapperInter {
  	public List<MemberDto> getAllMembers();
  }
  

• service

  호출 단

  @Service
  public class MemberService implements MemberServiceInter {
  
  		@Autowired
  		MemberMapperInter mapper;
  	
  		@Override
  		public List<MemberDto> getAllMembers() {
  			return mapper.getAllMembers();
  		}
  
  }
  

• controller

  @Autowired
  	MemberService service;
  
  	@GetMapping("/member/list")
  	public String memberList(Model model) {
  
  		model.addAttribute("count", service.getAllMembers().size());
  		model.addAttribute("list", service.getAllMembers());
  
  		return "/member/memberList";
  	}
  

return check()

회원가입