sql-board.xml > SPRINGBOOT

<?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">

<!-- web.mapper.BoardMapper : web프로젝트 mapper패키지 BoardMapper인터페이스명 매칭 --> 

<mapper namespace="web.mapper.BoardMapper">

<select id="selectBoardList" resultType="web.dto.BoardDto">

<![CDATA[

select * from t_board where deleted_yn='N' order by board_idx desc

]]>

</select>

<insert id="insertBoard" parameterType="web.dto.BoardDto">

insert into t_board 

(title,contents,created_datetime,creator_id) 

values 

(#{title},#{contents},now(),'admin')

</insert>

</mapper>

[설명]

parameterType="web.dto.BoardDto" 

가독성을 높여주기 위해 작성한다. ( 생략 가능하다. )