[스프링 게시판 만들기] - 7 - BoardMapper, BoardMapper.xml

* BoardMapper.java 인터페이스

package edu.bit.board.mapper;

import java.util.List;


import edu.bit.board.vo.BoardVO;

public interface BoardMapper {
	
	public List<BoardVO> getList();

	public void insert(BoardVO boardVO);

	public BoardVO read(int bno);
	
	public int delete(int bId);

	public void reply(BoardVO boardVO);

	public void modify(BoardVO boardVO);
	
}

* Boardmapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="edu.bit.board.mapper.BoardMapper">
   
   <select id="getList" resultType="edu.bit.board.vo.BoardVO">
   <![CDATA[
      select bId, bName, bTitle, bContent, bDate, bHit, bGroup, bStep, bIndent from mvc_board order by bGroup desc, bStep asc
   ]]>
   </select>
   
   <insert id="insert" >
   <![CDATA[
     insert into mvc_board (bId, bName, bTitle, bContent, bHit, bGroup, bStep, bIndent) values (mvc_board_seq.nextval, #{bName}, #{bTitle}, #{bContent}, 0, mvc_board_seq.currval, 0, 0)
   ]]>
   </insert>
   
	<select id="read" resultType="edu.bit.board.vo.BoardVO">
	<![CDATA[
		select * from mvc_board where bId = #{bId}
	]]>
	</select>
	
	<delete id="delete" >
	<![CDATA[
		delete from mvc_board where bId = #{bId}
	]]>
	</delete>
   
   	<insert id="reply" >
	<![CDATA[
		insert into mvc_board (bId, bName, bTitle, bContent, bGroup, bStep, bIndent) values (mvc_board_seq.nextval, #{bName}, #{bTitle},#{bContent}, #{bGroup}, #{bStep}+1, #{bIndent}+1)
	]]>
	</insert>
	
	<insert id="modify" >
	<![CDATA[
		update mvc_board set bName = #{bName}, bTitle = #{bTitle},bContent = #{bContent} where bId = #{bId}
	]]>
	</insert>
	
   
</mapper>