구디아카데미/JAVA
1211 Javascript 중복 검사
COCO_develop
2024. 12. 11. 17:14
대륙 추가 시
중복 검사(대륙 확인) 후
- 중복: 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);
}
}