1211 Javascript 중복 검사

대륙 추가 시

중복 검사(대륙 확인) 후

• 중복: alert('중복')
• 중복X: 대륙추가 <input>에 자동 입력

<h2>대륙 추가</h2>
	<br>
	<div>
		대륙 입력 <br>
		<input type="text" id="continentNameConfirm" name="continentNameConfirm" placeholder="중복 검사">
		<button id="btnConfirm" type="button">대륙 확인</button> <!-- 중복 체크 -->
	</div>
	
	<form>
		<input type="text" id="continentName" readonly>
		<button type="button">대륙 추가</button>
	</form>
	
	<script>
		$('#btnConfirm').click(function(){
			$.ajax({
				url:'addContinent/'+$('#continentNameConfirm').val()
				, method:'GET' // 디폴트
			}).done(function(result){
				if(result == 1){
					alert('중복입니다');
				} else {
					$('#continentName').val($('#continentNameConfirm').val());
				}
			}).fail(function(){
				alert('비동기호출(ajax) 실패');
			});
		})
	</script>

result = Integer continentCnt (컨트롤러)

result = 1 = count = 같은 값이 존재 -> 중복

 

***

@Mapper
public interface DBMapper {
	Integer continentCnt(String continentName);
}

count 값 받기위해 Integer

<select id="continentCnt" parameterType="String" resultType="Integer">
    SELECT COUNT(*)
    FROM continent
    WHERE continent_name = #{continentName}
</select>

@Controller
public class HomeController {
	@GetMapping("/addContinent")
	public String addContinent() {
		return "addContinent";
	}
}

@RestController
public class HomeRest {
	@Autowired DBMapper dbMapper;
    
	@GetMapping("/addContinent/{continentNameConfirm}")
	public Integer continentCnt(@PathVariable String continentNameConfirm) {
		return dbMapper.continentCnt(continentNameConfirm);
	}
}