article_class.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_Class"> 
<typeAlias alias="article_class" type="com.suncms.domain.Article_Class"/>
<typeAlias alias="index" type="com.suncms.domain.Index"/>  

<resultMap id="article_classInfoResult"  class="Article_Class"> 
<result property="row_id" column="ROW_ID"/> 
<result property="class_name" column="CLASS_NAME"/> 
<result property="if_check" column="IF_CHECK"/> 
<result property="if_valid" column="IF_VALID"/> 
<result property="par_class_id" column="PAR_CLASS_ID"/> 
<result property="par_class_name" column="PAR_CLASS_NAME"/> 
<result property="if_navigation" column="IF_NAVIGATION"/> 
<result property="picture" column="PICTURE"/> 
<result property="if_index" column="IF_INDEX"/>
<result property="if_bulletin" column="IF_BULLETIN"/>
</resultMap> 

<resultMap id="IndexInfoResult"  class="index"> 
<result property="row_id" column="ROW_ID"/> 
<result property="class_name" column="CLASS_NAME"/> 
<result property="if_navigation" column="IF_NAVIGATION"/>
<result property="picture" column="PICTURE"/>
<result property="if_index" column="IF_INDEX"/>
<result property="if_bulletin" column="IF_BULLETIN"/>
<result property="artlist" column="row_id" select="getArtByClassNum" />
</resultMap> 

<insert id="insertArticle_Class" parameterClass="article_class"> 
INSERT INTO 
Article_Class (
ROW_ID,
CLASS_NAME,
IF_CHECK,
IF_VALID,
PAR_CLASS_ID,
PAR_CLASS_NAME,
IF_NAVIGATION,
PICTURE,
IF_INDEX,
IF_BULLETIN
)
 values(
#row_id#,
#class_name#,
#if_check#,
#if_valid#,
#par_class_id#,
#par_class_name#,
#if_navigation#,
#picture#,
#if_index#,
#if_bulletin#
) 
</insert> 

<select id="getArticleClass" resultMap="article_classInfoResult" >
      select * from ARTICLE_CLASS
</select>
<select id="getIndexClass" resultMap="IndexInfoResult" >
      select * from ARTICLE_CLASS where if_valid='Y'
</select>
<select id="getIndexClassByPar" resultMap="IndexInfoResult" parameterClass="java.lang.String">
      select * from ARTICLE_CLASS where if_valid='Y' and PAR_CLASS_ID=#par_class_id#
</select>

<select id="getValidArtClass" resultMap="article_classInfoResult" >
      select * from ARTICLE_CLASS where if_valid = 'Y'
</select>

<select id="getArtClassByParID" resultMap="article_classInfoResult" parameterClass="java.lang.String">
      select * from ARTICLE_CLASS where PAR_CLASS_ID=#par_class_id#
</select>

<select id="getArtClassByID" resultMap="article_classInfoResult" parameterClass="java.lang.String">
      select * from ARTICLE_CLASS where ROW_ID=#row_id#
</select>
 
 <select id="getArtClassRoot" resultMap="article_classInfoResult" >
      select * from ARTICLE_CLASS where PAR_CLASS_ID='0'
</select>

 <update id="updateById" parameterClass="article_class">
      update Article_Class set 
      CLASS_NAME=#class_name#,IF_CHECK=#if_check#,IF_VALID=#if_valid#,PAR_CLASS_ID=#par_class_id#,PAR_CLASS_NAME=#par_class_name#,IF_NAVIGATION=#if_navigation#,PICTURE=#picture#,IF_INDEX=#if_index#,IF_BULLETIN=#if_bulletin#
      where ROW_ID=#row_id#
</update>
    
</sqlMap>