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

<resultMap id="user_roleInfoResult"  class="User_Role"> 
<result property="row_id" column="ROW_ID"/> 
<result property="user_id" column="USER_ID"/> 
<result property="role_id" column="ROLE_ID"/> 
 </resultMap> 
<insert id="insertUser_Role" parameterClass="user_role"> 
INSERT INTO 
User_Role (
ROW_ID,
USER_ID,
ROLE_ID
)
 values(
#row_id#,
#user_id#,
#role_id#
) 
</insert>
<delete id="delRoleByUserID" parameterClass="java.lang.String">
      delete from User_Role where USER_ID=#user_id#
</delete> 
</sqlMap>