user_org.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_Org"> 
<typeAlias alias="user_org" type="com.suncms.domain.User_Org"/> 

<resultMap id="user_orgInfoResult"  class="User_Org"> 
<result property="row_id" column="ROW_ID"/> 
<result property="user_id" column="USER_ID"/> 
<result property="org_id" column="ORG_ID"/> 
 </resultMap> 
<insert id="insertUser_Org" parameterClass="user_org"> 
INSERT INTO 
User_Org (
ROW_ID,
USER_ID,
ORG_ID
)
 values(
#row_id#,
#user_id#,
#org_id#
) 
</insert> 
<delete id="delOrgByUserID" parameterClass="java.lang.String">
      delete from User_Org where USER_ID=#user_id#
</delete>  
</sqlMap>