<select id="selectPersonById" parameterType="Integer" resultMap="IdCardWithPersonResult">
-- select p.*,idCard.CODE from t_person p,t_idcard idCard
-- where p.card_id=idCard.id and p.id=#{id}
select * from t_person where id=#{id}
</select>
09-26
5085
10-12
512
02-05
2721