๊ฐ๋ฐํ๊ฒฝ
์ธ์ด : JAVA (JDK 11)
์๋ฒ : Apache Tomcat 9.0
ํ๋ ์์ํฌ : Spring Framework 3.9.18, MyBatis 3.5.8, Bootstrap 5.2.3
DB : OracleXE 11gR2
IDE : sts-3.9.18.RELEASE, SQL Developler
๊ตฌํ๋ด์ฉ
- ๋ฉ์ธํ์ด์ง / ๊ฒ์ํ ๋ชฉ๋ก ๊ตฌํ
- CREATE : ๊ฒ์๊ธ ์์ฑ
- READ : ๊ฒ์๊ธ ๋ณด๊ธฐ + ์กฐํ์ ์ฆ๊ฐ
- UPDATE : ๊ฒ์๊ธ ์์
- DELETE : ๊ฒ์๊ธ ์ญ์
<select id="list" resultType="board.dto.BoardDTO">
SELECT * FROM boardBasic
ORDER BY num DESC
</select>
read.jsp์์ '์ญ์ '๋ฅผ ๋๋ฅด๋ฉด delete.do๊ฐ ์์ฒญ๋๊ณ ๊ฒ์๊ธ์ ์ญ์ ํ ํ, list.jsp๋ก ์ด๋
<a href="delete.do?num=${dto.num}">์ญ์ </a>
<delete id="delete" parameterType="int">
DELETE FROM boardBasic
WHERE num=#{num}
</delete>
@Override
public void delete(int num) {
sqlSession.delete("board.delete", num);
}
@Override
public void deleteProcess(int num) {
boardDao.delete(num);
}
@RequestMapping(value="/delete.do")
public String deleteExecute(int num) {
boardService.deleteProcess(num);
return "redirect:/list.do";
}