返回复杂对象

来源：互联网发布：java简单工厂模式缺点编辑：程序博客网时间：2024/05/17 07:46

<typeAlias alias="Customer" type="com.example.domain.Customer"/>
<resultMap id="getCustomerResult" class="Customer">
<result property="id" column="C_ID"/>
<result property="name" column="C_NAME"/>
<result property="birthday" column="C_BIRTHDAY"/>
<result property="gender" column="C_GENDER"/>
<result property="identityType" column="C_IDENTITYTYPE"/>
<result property="identityId" column="C_IDENTITYID"/>
<result property="consumePoint" column="C_CONSUMEPOINT"/>
<result property="lastGetDate" column="C_LASTGETDATE"/>
<result property="lastUseDate" column="C_LASTUSEDATE"/>
</resultMap>
<select id="getCustomerById" resultMap="getCustomerResult" parameterClass="string"/>
SELECT
`CUMAS`.`ID` AS `C_ID`, `CUMAS`.`NAME` AS `C_NAME`, `CUMAS`.`BIRTHDAY` AS
`C_BIRTHDAY`, `CUMAS`.`GENDER` AS `C_GENDER`, `CUMAS`.`IDTYPE` AS `C_IDENTITYTYPE`,
`CUMAS`.`IDNO` AS `C_IDENTITYID`, `CUSPT`.`POINT` AS `C_CONSUMEPOINT`, `CUSPT`.`LASTGET`
AS `C_LASTGETDATE`, `CUSPT`.`LASTUSE` AS `C_LASTUSEDATE`
FROM `CUMAS`, `CUSPT` WHERE `ID` = #id# AND `CUMAS`.`ID` = `CUSPT`.`CUSID`
<select/>

0 0