article.xml.svn-base

一个实用的CMS管理

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" 
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="Article">
	<typeAlias alias="article" type="com.suncms.domain.Article" />

	<resultMap id="articleInfoResult" class="Article">
		<result property="row_id" column="ROW_ID" />
		<result property="artclass_id" column="ARTCLASS_ID" />
		<result property="artclass_name" column="ARTCLASS_NAME" />
		<result property="article_title" column="ARTICLE_TITLE" />
		<result property="article_desc" column="ARTICLE_DESC" />
		<result property="article_content" column="ARTICLE_CONTENT"
			jdbcType="CLOB" javaType="java.lang.String" />
		<result property="article_status" column="ARTICLE_STATUS" />
		<result property="article_overdue" column="ARTICLE_OVERDUE" />
		<result property="article_author_id" column="ARTICLE_AUTHOR_ID" />
		<result property="article_author_name"
			column="ARTICLE_AUTHOR_NAME" />
		<result property="article_editor_id" column="ARTICLE_EDITOR_ID" />
		<result property="article_editor_name"
			column="ARTICLE_EDITOR_NAME" />
		<result property="article_read_count"
			column="ARTICLE_READ_COUNT" />
		<result property="article_attach" column="ARTICLE_ATTACH" />
		<result property="create_by" column="CREATE_BY" />
		<result property="create_time" column="CREATE_TIME" />
		<result property="modify_by" column="MODIFY_BY" />
		<result property="modify_time" column="MODIFY_TIME" />
		<result property="article_file" column="ARTICLE_FILE" />
	</resultMap>
	<insert id="insertArticle" parameterClass="article">
		INSERT INTO Article ( ROW_ID, ARTCLASS_ID, ARTCLASS_NAME,
		ARTICLE_TITLE, ARTICLE_DESC, ARTICLE_CONTENT, ARTICLE_STATUS,
		ARTICLE_OVERDUE, ARTICLE_AUTHOR_ID, ARTICLE_AUTHOR_NAME,
		ARTICLE_EDITOR_ID, ARTICLE_EDITOR_NAME, ARTICLE_READ_COUNT,
		ARTICLE_ATTACH, CREATE_BY, CREATE_TIME, MODIFY_BY, MODIFY_TIME,
		ARTICLE_FILE ) values( #row_id#, #artclass_id#, #artclass_name#,
		#article_title#, #article_desc#, #article_content#,
		#article_status#, #article_overdue#, #article_author_id#,
		#article_author_name#, #article_editor_id#,
		#article_editor_name#, #article_read_count#, #article_attach#,
		#create_by#, #create_time#, #modify_by#, #modify_time#,
		#article_file# )
	</insert>

	<select id="getArtByClass" resultMap="articleInfoResult"
		parameterClass="java.lang.String">
		select * from ARTICLE where ARTCLASS_ID = #artclass_id#
	</select>
	
	<select id="getArtById" resultMap="articleInfoResult"
		parameterClass="java.lang.String">
		select * from ARTICLE where ROW_ID = #row_id#
	</select>

	<select id="getArtByClassNum" resultMap="articleInfoResult"
		parameterClass="java.lang.String">
		SELECT A.*, ROWNUM FROM (SELECT * FROM ARTICLE where
		ARTCLASS_ID = #artclass_id# order by modify_time desc ) A WHERE
		ROWNUM &lt; 6
	</select>

	<select id="getTotalCount" resultClass="java.lang.Integer"
		parameterClass="java.util.Map">
		select count(*) from ARTICLE
		<dynamic prepend="WHERE">
			<isNotNull prepend="AND" property="artclass_id">
				(ARTCLASS_ID = #artclass_id#)
			</isNotNull>
			<isNotNull prepend="AND" property="article_title">
				(ARTICLE_TITLE like '%'||#article_title#||'%')
			</isNotNull>
			<isNotNull prepend="AND" property="article_status">
				(ARTICLE_STATUS like '%'||#article_status#||'%')
			</isNotNull>
			<isNotNull prepend="AND" property="article_overdue">
				(ARTICLE_OVERDUE &lt; #article_overdue#)
			</isNotNull>


		</dynamic>
	</select>
	<select id="getTotalCountByClass" resultClass="java.lang.Integer"
		parameterClass="java.lang.String">
		select count(*) from ARTICLE where ARTCLASS_ID=#artclass_id#
	</select>

	<select id="limitQuery" resultMap="articleInfoResult"
		parameterClass="java.util.Map">
		select * from (select a.*,rownum row_num from (select * from
		ARTICLE
		<dynamic prepend="WHERE">
			<isNotNull prepend="AND" property="artclass_id">
				(ARTCLASS_ID = #artclass_id#)
			</isNotNull>
			<isNotNull prepend="AND" property="article_title">
				(ARTICLE_TITLE like '%'||#article_title#||'%')
			</isNotNull>
			<isNotNull prepend="AND" property="article_status">
				(ARTICLE_STATUS like '%'||#article_status#||'%')
			</isNotNull>
			<isNotNull prepend="AND" property="article_overdue">
				(ARTICLE_OVERDUE &lt; #article_overdue#)
			</isNotNull>
		</dynamic>
		<dynamic>
			<isNotEmpty property="sortfield">
				ORDER BY $sortfield$ $sorttype$
			</isNotEmpty>
		</dynamic>
		) a WHERE rownum &lt;= #end# ) b where row_num &gt; #start#

	</select>
	<update id="artupdateById" parameterClass="article">
      update ARTICLE set 
      ARTICLE_TITLE=#article_title#,ARTICLE_CONTENT=#article_content#,ARTICLE_OVERDUE=#article_overdue#,MODIFY_TIME=#modify_time#,ARTICLE_FILE=#article_file#
      where ROW_ID=#row_id#
</update>
</sqlMap>