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

<resultMap id="urolesInfoResult"  class="Uroles"> 
<result property="row_id" column="ROW_ID"/> 
<result property="role_name" column="ROLE_NAME"/> 
<result property="role_desc" column="ROLE_DESC"/> 
<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="insertUroles" parameterClass="uroles"> 
INSERT INTO 
Uroles (
ROW_ID,
ROLE_NAME,
ROLE_DESC,
CREATE_BY,
CREATE_TIME,
UPDATE_BY,
UPDATE_TIME
)
 values(
#row_id#,
#role_name#,
#role_desc#,
#create_by#,
#create_time#,
#update_by#,
#update_time#
) 
</insert> 
<select id="getAllRoles" resultMap="urolesInfoResult" >
      select * from UROLES
</select>
<select id="getRolesByID" resultMap="urolesInfoResult" parameterClass="java.lang.String">
      select * from UROLES where ROW_ID=#row_id#
</select>
<select id="getRolesByName" resultMap="urolesInfoResult" parameterClass="java.lang.String">
      select * from UROLES where role_name=#role_name#
</select>
<select id="getRolesByNotUserID" resultMap="urolesInfoResult" parameterClass="java.lang.String">
      select * from uroles  where row_id not in (select role_id from user_role where user_id=#user_id#)
</select>
<select id="getRolesByIsUserID" resultMap="urolesInfoResult" parameterClass="java.lang.String">
      select * from uroles  where row_id in (select role_id from user_role where user_id=#user_id#)
</select>
</sqlMap>