<sqlMap namespace="bulletin">
    <!-- 获取公告 -->
    <typeAlias alias="bulletinVo" type="com.gzedu.portal.vo.BulletinVo"/>
    <resultMap id="bulletinResult" class="bulletinVo">
        <result property="id" column="ID"/>
        <result property="title" column="TITLE"/>
          <result property="content" column="CONTENT"  jdbcType="CLOB" javaType= "java.lang.String" /> 
        <result property="bulType" column="BUL_TYPE"/>
        <result property="author" column="AUTHOR"/>
        <result property="origin" column="ORIGIN"/>
        <result property="createDate" column="CREATED_DT"/>                
      </resultMap>       
 
      
    <select id="getBulletin" resultClass="bulletinResult">
        select ID,BUL_TYPE ,TITLE,CONTENT,AUTHOR,ORIGIN,to_char(CREATED_DT,'YYYY-MM-DD')as CREATED_DT from xl_bulletin where BUL_STATUS='1'
        and IS_DELETED='N' and SYSDATE BETWEEN START_DT AND END_DT 
    </select>
    
</sqlMap>