IBATIS项目配置（例）

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE sqlMapPUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN""http://www.ibatis.com/dtd/sql-map-2.dtd"><sqlMap namespace="Holding"><typeAlias alias="holding" type="cn.hdu.entity.Holding"/><typeAlias alias="userInfo" type="cn.hdu.entity.UserInfo"/><typeAlias alias="stock" type="cn.hdu.entity.Stock"/><resultMap id="HoldingResultMap" class="holding"><result property="holdingId" column="HOLDINGID"/><result property="stockId" column="STOCKID" select="getStockById"/><result property="num" column="NUM"/><result property="avgPrice" column="AVGPRICE"/><result property="userId" column="USERID" select="getUserByUserId"/></resultMap><resultMap id="UserInfoResultMap" class="userInfo"><result property="userId" column="USERID"/><result property="name" column="NAME"/><result property="email" column="EMAIL"/><result property="phone" column="PHONE"/><result property="address" column="ADDRESS"/><result property="regDate" column="REGDATE"/><result property="password" column="PASSWORD"/></resultMap><resultMap id="StockResultMap" class="stock"><result property="stockId" column="STOCKID"/><result property="name" column="NAME"/><result property="code" column="CODE"/><result property="price" column="PRICE"/></resultMap><select id="selectStock" resultMap="HoldingResultMap">SELECT * FROM HOLDING WHERE USERID=#userId#</select><select id="selectStockByHoldingId" resultMap="HoldingResultMap">SELECT * FROM HOLDING WHERE HOLDINGID=#holdingId#</select><select id="selectStockByStcokId" resultMap="HoldingResultMap">SELECT * FROM HOLDING WHERE STOCKID=#stockId#</select><update id="updateMyStock" parameterClass="cn.hdu.entity.Holding">UPDATE HOLDING SET NUM=#num#,AVGPRICE=#avgPrice# WHERE HOLDINGID=#holdingId#</update><delete id="deleteMyStock" parameterClass="cn.hdu.entity.Holding">DELETE HOLDING WHERE HOLDINGID=#holdingId#</delete><insert id="insertMyStock" parameterClass="cn.hdu.entity.Holding">INSERT INTO HOLDING( HOLDINGID ,STOCKID ,NUM ,AVGPRICE ,USERID ) VALUES(my_sequences.nextval,#stockId.stockId#,#num#,#avgPrice#,#userId.userId#)</insert><select id="getStockById" resultMap="StockResultMap">SELECT * FROM STOCK WHERE STOCKID=#stockId#</select><select id="getUserByUserId" resultMap="UserInfoResultMap">SELECT * FROM USERINFO WHERE USERID=#value#</select></sqlMap>