[MYSQL] 삭제된 행 수 리턴

<delete id="deleteGuestBook" parameterType="int">
	<![CDATA[
	    DELETE FROM guestbook WHERE id = #{id}
	]]>
</delete>

<select id="getDeletedCount" resultType="int">
	<![CDATA[
		SELECT ROW_COUNT() as deletedCount
	]]>
</select>

 

이후 Repository에서

public int deleteGuestBook(int id) {
	sqlsession.delete("guestbook.deleteGuestBook", id);
	int count = sqlsession.selectOne("guestbook.getDeletedCount");
	return count;
}

따로 리턴