반복되는 쿼리 묶기

반복되는 쿼리 묶기

• 설정

      <!-- 공통된 쿼리를 boardSelectFromSql라는 id로 지정하여 <include refid="boardSelectFromSql" /> 로 사용한다. -->
      <mapper>
          ...
  
          <sql id="boardSelectFromSql">
              SELECT
                  BOARD_NO,
                  GROUP_NO,
                  SORT_SEQ,
                  BOARD_LVL,
                  BOARD_TITLE,
                  BOARD_CONTENTS,
                  SYS_REGR_ID,
                  SYS_REG_DTIME,
                  SYS_MODR_ID,
                  SYS_MOD_DTIME
              FROM TB_USER_BOARD
          </sql>
  
          <select id="selectBoardList" resultMap="boardResultMap" parameterType="map">
              <include refid="boardSelectFromSql" />
              ORDER BY GROUP_NO DESC, SORT_SEQ ASC
  
              <if test="size != null and offset != null">
                  LIMIT #{size} OFFSET #{offset}
              </if>
          </select>
  
          <select id="selectBoard" resultMap="boardResultMap" parameterType="map">
              <include refid="boardSelectFromSql" />
              WHERE BOARD_NO = #{boardNo}
          </select>
  
          ...
      </mapper>