슾으링

비밀번호 체크하는 RequestMapping

@RequestMapping("/bimilcheck")
public String bimilcheck(BoardDto bdto)
{
	BoardDao bdao = sqlSession.getMapper(BoardDao.class);
	bdao.bimilcheck(bdto);
	
	if(bdao.bimilcheck(bdto)==1)
	{
		return "redirect:/readnum?id="+bdto.getId()+"&page="+bdto.getPage();
	}
	else
	{
		return "redirect:/list";
	}
}

비밀번호 체크 xml

<select id="bimilcheck" parameterType="kr.co.batis_page.dto.BoardDto" resultType="Integer">
	select count(*) from board where id=#{id} and pwd=#{pwd}
</select>

리스트에 게시글들 출력하는 과정에서 비밀글인지 아닌지 체크후 출력
secpwd script 매개변수 bdto.id를 보내줘서
form태그에서 id 받아 값을 넣어줘서 처리

<c:forEach items="${list}" var="bdto">
	<tr>
		<c:if test="${bdto.sec == 1}">
          <td><a href="#" onclick="secpwd(${bdto.id})"> ${bdto.title} </a></td>
		</c:if>
		<c:if test="${bdto.sec == 0}">
		<td><a href="readnum?id=${bdto.id}&page=${page}"> ${bdto.title} </a></td>
		</c:if>
		<td> ${bdto.name} </td>
		<td> ${bdto.readnum} </td>
		<td> ${bdto.writeday} </td>
	</tr>
    

list.jsp 비밀번호 form

<div id="secform">
	<form name="ppp"method="post" action="bimilcheck">
		<input type="hidden" name="id">
		<input type="hidden" name="page" value="${page}">
		<input type="password" name="pwd">
		<input type="submit" value="입력">
	</form>
</div>

list.jsp 비밀번호 script

<script>
function secpwd(id)
{
	var x = event.clientX;
	var y = event.clientY;
	
	document.getElementById("secform").style.left=(x+10)+"px";
	document.getElementById("secform").style.top=y+"px";
	document.getElementById("secform").style.visibility="visible";
	
	document.ppp.id.value=id;
}
</script>