users.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="Users"> 
<typeAlias alias="users" type="com.suncms.domain.Users"/> 
<resultMap id="usersInfoResult"  class="Users"> 
<result property="row_id" column="ROW_ID"/> 
<result property="user_login" column="USER_LOGIN"/> 
<result property="user_pass" column="USER_PASS"/> 
<result property="user_name" column="USER_NAME"/> 
<result property="user_status" column="USER_STATUS"/> 
<result property="user_role" column="USER_ROLE"/> 
<result property="user_group" column="USER_GROUP"/> 
<result property="user_org" column="USER_ORG"/> 
</resultMap> 
<insert id="insertUsers" parameterClass="users"> 
INSERT INTO 
Users (
ROW_ID,
USER_LOGIN,
USER_PASS,
USER_NAME,
USER_STATUS
)
 values(
#row_id#,
#user_login#,
#user_pass#,
#user_name#,
#user_status#
) 
</insert> 
<select id="getAllUsers" resultMap="usersInfoResult" >
      select * from USERS
</select>
<select id="getUserByID" resultMap="usersInfoResult" parameterClass="java.lang.String">
      select * from USERS where ROW_ID=#row_id#
</select>
<update id="updateuserById" parameterClass="users">
      update Users set 
      USER_LOGIN=#user_login#,USER_PASS=#user_pass#,USER_NAME=#user_name#,USER_STATUS=#user_status#,USER_ROLE=#user_role#,USER_GROUP=#user_group#,USER_ORG=#user_org# where ROW_ID=#row_id#
 </update>
</sqlMap>