<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMap PUBLIC "-//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>