【正文】 olumn=oid/ result property=orderStatus column=orderStatus/ association property=tUser javaType=TUser result property=uid column=uid/ result property=trueName column=trueName/ result property=uimg column=uimg/ result property=sphone column=tel/ /association /association association property=tPeriods javaType=TPeriods result property=announceTime column=announceTime/ result property=luckgNo column=luckgNo/ result property=periods column=periods/ result property=uid column=uid/ result property=pid column=pid/ association property=tGood javaType=TGood result property=gid column=gid/ result property=gname column=gname/ result property=gprice column=gprice/ collection property=pics ofType=TPics result property=picUrl column=picUrl/ result property=isDefault column=isDefault/ /collection /association association property=tUser javaType=TUser result property=uid column=uid/ result property=trueName column=trueName/ result property=sphone column=sphone/ result property=uimg column=uimg/ /association /association /resultMap ! 根據(jù)電話（sphone）獲取用戶用訂單 select id=getOrderdetailListBy parameterType=String resultMap=orderdetailMap SELECT ,buynums, , ,sphone tel, , , FROM t_orderdetails od INNER JOIN t_periods p ON = INNER JOIN t_order o ON = INNER JOIN t_user u ON = INNER JOIN t_good g ON = INNER JOIN t_pics pic ON = WHERE sphone={sphone} AND =1 /select ! 根據(jù)電話（sphone）獲取用戶用曬單列表 select id=findShowluckListBy parameterType=TShowluck resultMap=showluckMap select ,content,title,lackTime, showpicUrl, ,sphone from t_showluck s inner join t_periods p on = inner join t_showpic sp on = inner join t_user u on = where =3 and sphone={sphone} order by lackTime desc /select resultMap type=TOrderdetails id=orderMap result property=DelId column=DelId/ result property=buyCount column=buyCount/ result property=paymentTime column=paymentTime/ association property=tOrder javaType=TOrder result property=oid column=oid/ result property=orderStatus column=orderStatus/ association property=tUser javaType=TUser result property=uid column=uid/ result property=trueName column=trueName/ result property=uimg column=uimg/ result property=sphone column=sphone/ /association /association association property=tPeriods javaType=TPeriods result property=pid column=pid/ result property=periods column=periods/ association property=tGood javaType=TGood result property=gid column=gid/ result property=gname column=gname/ result property=gtitle column=gtitle/ /association /association /resultMap ! 獲取最新購買記錄列表 select id=getNewOrderList parameterType=TOrder resultMap=orderMap select orderStauts, ,sphone, , , , from t_order o inner join t_user u on = INNER JOIN t_orderdetails od ON = inner join t_periods p on = inner join t_good g on = where =1 order by desc /select ! 獲取所有購買人次記錄 select id=getBuyCounts parameterType=TOrderdetails resultType=Integer select buyCount from t_orderdetails /select ! 根據(jù)用戶名查找用戶 select id=getUserBy parameterType=String resultType=TUser select trueName,uimg,uid,sphone from t_user where sphone={sphone} /select ! 根據(jù)用戶id查找用戶 select id=findUserBy parameterType=Integer resultType=TUser select * from t_user where uid={uid} /select resultMap type=TPeriods id=periodMap result property=pid column=pid/ result property=periods column=periods/ result property=announceTime column=announceTime/ result property=luckgNo column=luckgNo/ association property=tUser javaType=TUser result property=uid column=uid/ result property=trueName column=trueName/ result property=uimg column=uimg/ result property=sphone column=sphone/ /association association property=tAddress javaType=TAddress result property=adid column=adid/ result property=areaid column=areaid/ result property=address column=address/ association property=tArea javaType=TAreas result property=id column=id/ result property=area column=area/ association property=tCity javaType=TCities result property=cityid column=cityid/ result property=city column=city/ association property=tProvince javaType=TProvinces result property=provinceid column=provinceid/ result property=province column=province/ /association /association /association /association association property=pic javaType=TPics result property=picUrl column=picUrl/ result property=isDefault column=isDefault/ /association association property=tGood javaType=TGood result property=gid column=gid/ result property=gname column=gname/ result property=gtitle column=gtitle/ result property=gprice column=gprice/ collection property=pics ofType=TPics result property=picUrl column=picUrl/ result property=isDefault column=isDefault/ /collection /association association property=tOrderdetails javaType=TOrderdetails result property=DelId column=DelId/ result property=buyCount column=buyCount/ result property=buyNumS column=buyNumS/ /association /resultMap ! 根據(jù)用戶uid查找期數(shù)對象 select id=getUserPrizeBy parameterType=Integer resultMap=periodMap select ,sphone, , , from t_periods p inner join t_user u