Ibatis配置文件几种配置方式

来源：互联网发布：淘宝助理5.0官方编辑：程序博客网时间：2024/05/21 08:29

<?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><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><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><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><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><parameterMap id="pro" class="java.util.Map"><parameter property="name" jdbcType="VARCHAR"      javaType="string" mode="IN"/></parameterMap><procedure id="pro_insert" parameterMap="pro">{call new_proc(?)}</procedure></sqlMap>