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

<resultMap id="ugroupsInfoResult"  class="Ugroups"> 
<result property="row_id" column="ROW_ID"/> 
<result property="group_name" column="GROUP_NAME"/> 
<result property="group_desc" column="GROUP_DESC"/> 
<result property="parten_id" column="PARTEN_ID"/> 
<result property="parten_name" column="PARTEN_NAME"/> 
<result property="create_by" column="CREATE_BY"/> 
<result property="create_time" column="CREATE_TIME"/> 
<result property="update_by" column="UPDATE_BY"/> 
<result property="update_time" column="UPDATE_TIME"/> 
 </resultMap> 
<insert id="insertUgroups" parameterClass="ugroups"> 
INSERT INTO 
Ugroups (
ROW_ID,
GROUP_NAME,
GROUP_DESC,
PARTEN_ID,
PARTEN_NAME,
CREATE_BY,
CREATE_TIME,
UPDATE_BY,
UPDATE_TIME
)
 values(
#row_id#,
#group_name#,
#group_desc#,
#parten_id#,
#parten_name#,
#create_by#,
#create_time#,
#update_by#,
#update_time#
) 
</insert> 
<select id="getUgroups" resultMap="ugroupsInfoResult" >
      select * from UGROUPS
</select>

<select id="getUgroupsByParID" resultMap="ugroupsInfoResult" parameterClass="java.lang.String">
      select * from UGROUPS where PARTEN_ID=#parten_id#
</select>

<select id="getUgroupsByID" resultMap="ugroupsInfoResult" parameterClass="java.lang.String">
      select * from UGROUPS where ROW_ID=#row_id#
</select>

<select id="getUgroupsByName" resultMap="ugroupsInfoResult" parameterClass="java.lang.String">
      select * from UGROUPS where group_name=#group_name#
</select>
 
 <select id="getUgroupsRoot" resultMap="ugroupsInfoResult" >
      select * from UGROUPS where PARTEN_ID='0'
</select>
 <select id="getGroupsByNotUserID" resultMap="ugroupsInfoResult" parameterClass="java.lang.String">
      select * from UGROUPS  where row_id not in (select GROUP_ID from USER_GROUP where user_id=#user_id#)
</select>
<select id="getGroupsByIsUserID" resultMap="ugroupsInfoResult" parameterClass="java.lang.String">
      select * from UGROUPS  where row_id in (select GROUP_ID from USER_GROUP where user_id=#user_id#)
</select>
</sqlMap>