1 定义mybatis对象
其实association 跟hibernate的对象有些类似,而hibernate确实比较难用,搞了hql、二级缓存需要深入进去,模式比较笨重。我们做应用开发的,为啥要讲orm框架钻的那么深呢。权衡利弊,我觉得mybatis的实操占有优势。关于mybatis的二级缓存,可以参考MyBatis缓存策略之二级缓存,写的比较详细。
<resultMap id="SmsHouseholdOrderDto" type="com.dzmsoft.sms.base.dto.SmsHouseholdOrderDto">
<id column="id_smsOrder" jdbcType="VARCHAR" property="id" />
<association column="id_smsHouseholdOrder" javaType="com.dzmsoft.sms.base.pojo.SmsHouseholdOrder" property="smsHouseholdOrder" resultMap="com.dzmsoft.sms.base.dao.SmsHouseholdOrderMapper.BaseResultUdfMap">
</association>
<association column="id_smsOrder" javaType="com.dzmsoft.sms.base.pojo.SmsOrder" property="smsOrder" resultMap="com.dzmsoft.sms.base.dao.SmsOrderMapper.BaseResultUdfMap">
</association>
</resultMap>
2 SmsHouseholdOrderDto
SmsHouseholdOrder 、SmsOrder 是mybatis generator根据单表生成的pojo,这里可以组装了一下,那个id是用作主键。
这样可以复用很多代码。
public class SmsHouseholdOrderDto {
private String id;
private SmsHouseholdOrder smsHouseholdOrder;
private SmsOrder smsOrder;
public String getId() {
return id;
}