0427 spring웹페이지에서 이메일 입력해 회원정보조회

//MemberController

//회원 1명 조회(ajax)	(sqlSession.selectOne())
	@ResponseBody	//ajax응답시 사용
	@PostMapping("/selectOne")
	//*****방법1*****
//	public Member selectOne(@RequestParam("memberEmail") String memberEmail) {
//		
//		return service.selectOne(memberEmail);
//	}
	
	//*****방법2*****
	public String selectOne(@RequestParam("memberEmail") String memberEmail) {
		Member mem = service.selectOne(memberEmail);
		//Gson
		return new Gson().toJson(mem);
		
	}

//MemberServiceImpl

//이메일에 입력해 회원정보조회
	@Override
	public Member selectOne(String memberEmail) {
		return dao.selectOne(memberEmail);
	}

//MemberService

//회원정보 조회
	public Member selectOne(String memberEmail);

//MemberDAO

	/**회원정보조회
	 * @param memberEmail
	 * @return
	 */
	public Member selectOne(String memberEmail) {

		return sqlSession.selectOne("memberMapper.selectOne", memberEmail);
		//sqlSession.selectOne(" mapper에서 <select id="selectOne">의 id값")
	}

//member-mapper

 <!-- 이메일 입력해서 회원조회하기 -->
  <select id="selectOne" parameterType="string" resultMap="member_rm">
  	SELECT MEMBER_EMAIL, MEMBER_NICK, MEMBER_TEL, MEMBER_ADDR,
	TO_CHAR(ENROLL_DT, 'YYYY-MM-DD') AS ENROLL_DT
	FROM MEMBER_S
	WHERE MEMBER_EMAIL = #{memberEmail}
	AND SECESSION_FL = 'N'
  </select>