authority.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="Authority"> 
<typeAlias alias="authority" type="com.suncms.domain.Authority"/> 

<resultMap id="AuthorityClassResult"  class="Authority"> 
<result property="row_id" column="ROW_ID"/> 
<result property="role_id" column="ROLE_ID"/> 
<result property="class_id" column="CLASS_ID"/> 
<result property="class_name" column="CLASS_NAME"/> 
<result property="if_edit" column="IF_EDIT"/> 
<result property="if_check" column="IF_CHECK"/> 
<result property="if_publish" column="IF_PUBLISH"/> 
 </resultMap> 
 <resultMap id="AuthorityInfoResult"  class="Authority"> 
<result property="row_id" column="ROW_ID"/> 
<result property="role_id" column="ROLE_ID"/> 
<result property="class_id" column="CLASS_ID"/> 
<result property="if_edit" column="IF_EDIT"/> 
<result property="if_check" column="IF_CHECK"/> 
<result property="if_publish" column="IF_PUBLISH"/> 
 </resultMap> 
<insert id="insertAuthority" parameterClass="authority"> 
INSERT INTO 
Authority (
ROW_ID,
ROLE_ID,
CLASS_ID,
IF_EDIT,
IF_CHECK,
IF_PUBLISH
)
 values(
#row_id#,
#role_id#,
#class_id#,
#edit#,
#check#,
#publish#
) 
</insert> 
 <select id="getAuthorityClass" resultMap="AuthorityClassResult" parameterClass="java.lang.String">
     select t.row_id,t.role_id,f.row_id as CLASS_ID, f.class_name,t.if_edit,t.if_check,t.if_publish from (select * from authority where role_id=#role_id#) t ,article_class f where t.class_id(+) = f.row_id order by f.class_name
</select>
<delete id="delByRoleID" parameterClass="java.lang.String">
      delete from authority where ROLE_ID=#role_id#
</delete>

</sqlMap>