회원정보 찾기
select.jsp
<nav id="Update">
<h2>회원관리페이지</h2>
<form class = "form-inline" onsubmit="return fasle">
<!-- onsubmit : js로 처리 하기 위해 언터 또는 새로고침 이후 서버로 전송 -->
<div class="dropdown">
<table>
<tr>
<td><label for="search">검색 : </label></td>
<td><input type="text" id = "search" class="form-control" place-holder="검색어 입력">
<ul class="dropdown-menu">
<li><a href=""></a></li>
</ul>
</td>
</tr>
</table>
</div>
</form>
...
<script>
// DOM(문서 객체 모델) 으로 가져오기
$("#search").on("keyup",()=>{
// keyup 이벤트 등록
// 이벤트가 발생할때마다 input태그 안쪽에 있는 글자 가져오기
let search = $("#search").val();
// console 에 출력해보기
console.log(search);
//ajax
$.ajax({
url:"${cpath}/searchMember"
data : data,
dataType : ,
success : () => {
},
error : () =>{
}
})
})
</script>
controller
@ResponseBody
@GetMapping("/searchMember")
public List<MemberVO> searchMember(@RequestParam String search, HttpSession session) {
List<MemberVO> result = mapper.searchMember(search);
if (result != null) {
session.setAttribute("user_List", result);
} else {
System.out.println("유저 정보를 찾을수없습니다");
}
return result;
}
mapper.xml
<select id="searchMember" parameterType="String" resultType="com.smhrd.model.MemberVO">
select * from member where email = #{email}
select * from member where email like concat('%',#{search},'%')
</select>
bootstrap
<!-- jQuery library -->
<script src="<https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js>"></script>
<!-- Latest compiled JavaScript -->
<script src="<https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js>"></script>
REST API 주요 특징