ibatis 映射

<select id="getAllUsers" resultClass="com.air.Account">SELECT * FROM USER_ACCOUNT order by USERID </select><!--无映射 --><select id="getAllUsers1" resultClass="com.air.Account"parameterClass="string">SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#</select><!--内联映射->实体类--><select id="getAllUsers2" resultClass="com.air.Account"parameterClass="string">SELECT USERID as userid, USERNAME as username, PASSWORD aspassword, GROUPNAME as groupname FROM USER_ACCOUNT WHEREGROUPNAME=#groupName#</select><!--内联映射->MAP类--><select id="getAllUsers3" resultClass="hashmap"parameterClass="string">SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#</select><!--显示映射->实体类--><resultMap id="accoutResult" class="com.air.Account"><result property="userid" column="USERID" /><result property="username" column="USERNAME" /><result property="password" column="PASSWORD" /><result property="groupname" column="GROUPNAME" /></resultMap><select id="getAllUsers4" resultMap="accoutResult"parameterClass="string">SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#</select><!--显示映射->MAP类--><resultMap id="mapResult" class="hashmap"><result property="userid" column="USERID" /><result property="username" column="USERNAME" /><result property="password" column="PASSWORD" /><result property="groupname" column="GROUPNAME" /></resultMap><select id="getAllUsers5" resultMap="mapResult"parameterClass="string">SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#</select><!--XML--><select id="selectXML" parameterClass="string" resultClass="xml"xmlResultName="log">SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#</select><select id="getOneUser" resultClass="com.air.Account"parameterClass="string">SELECT * FROM USER_ACCOUNT WHERE GROUPNAME=#groupName#</select><!--自动参数映射--><insert id="insertOneUser1" parameterClass="com.air.Account">INSERT INTO USER_ACCOUNT ( USERNAME, PASSWORD, GROUPNAME)VALUES(#username#,#password#,#groupname# )</insert><!--内联参数映射--><insert id="insertOneUser2" parameterClass="com.air.Account">INSERT INTO USER_ACCOUNT ( USERNAME, PASSWORD, GROUPNAME)VALUES(#username:VARCHAR#,#password:VARCHAR#,#groupname:VARCHAR# )</insert><!--外联参数映射--><parameterMap id="parameterMapEx" class="com.air.Account"><parameter property="username" jdbcType="VARCHAR"/><parameter property="password" jdbcType="VARCHAR"/><parameter property="groupname" jdbcType="VARCHAR"/></parameterMap><insert id="insertOneUser3" parameterMap="parameterMapEx">INSERT INTO USER_ACCOUNT ( USERNAME, PASSWORD, GROUPNAME)VALUES(?,?,? )</insert><!--自动生成的键--><insert id="insertOneUser4" parameterClass="com.air.Account">INSERT INTO USER_ACCOUNT ( USERID,USERNAME, PASSWORD, GROUPNAME)VALUES(#userid#,#username#,#password#,#groupname# )<selectKeykeyProperty="userid"resultClass="int">SELECT LAST_INSERT_ID() </selectKey></insert>