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>

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

<![CDATA[

select * from t_board where deleted_yn='N' and board_idx=#{boardIdx}

]]>

</select>

<update id="updateHitCount">

update t_board set hit_cnt = hit_cnt + 1 where board_idx = #{boardIdx}

</update>

<update id="updateBoard" parameterType="web.dto.BoardDto">

update t_board set title = #{title}, contents = #{contents} where board_idx = #{boardIdx}

</update>

<update id="deleteBoard" parameterType="int">

update t_board set 

deleted_yn='Y' ,

updated_datetime = now(),

updater_id = 'admin'

where board_idx = #{boardIdx}

</update>

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

<![CDATA[

select * from t_board where deleted_yn='N' order by board_idx desc limit #{pageStart},#{perPageNum}

]]>

</select>

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

<![CDATA[

select * from t_board where deleted_yn='N' order by board_idx desc limit #{pageStart},#{perPageNum}

]]>

</select>

<select id="listCount" resultType="int">

<![CDATA[

select count(*) from t_board where deleted_yn='N'

]]>

</select>

</mapper>