mybatis级联(关联)查询
??????? <result property="id" column="id"/>
??????? <result property="loginName" column="login_name"/>
??????? <result property="userName" column="user_name"/>
??????? <result property="password" column="password"/>
??????? <result property="email" column="email"/>
??????? <result property="status" column="status"/>
??????? <result property="userType" column="user_type"/>
??????? <result property="memberType" column="member_type"/>
??????? <result property="imgPath" column="img_path"/>
??????? <result property="imgStatus" column="img_status"/>
??????? <result property="identification" column="identification"/>
??????? <result property="certificateCode" column="certificate_code"/>
??????? <result property="countyCode" column="county_code"/>
??????? <result property="schoolId" column="school_id"/>
??????? <result property="classId" column="class_id"/>
??????? <result property="grade" column="grade"/>
??????? <result property="sex" column="sex"/>
??????? <result property="birthday" column="birthday"/>
??????? <result property="mobile" column="mobile"/>
??????? <result property="inviteCode" column="invite_code"/>
??????? <result property="subjectId" column="subject_id"/>
??????? <result property="certificationStatus" column="Certification_status"/>
??????? <result property="createTime" column="create_time"/>
??????? <result property="validTime" column="valid_time"/>
??????? <result property="institutionId" column="institution_id"/>
??????? <result property="depName" column="dep_name"/>
??????? <result property="jobName" column="job_name"/>
??????? <association column="school_id" property="school"
??????? javaType="com.zlwh.member.model.School" select="getSchoolById" />
??? </resultMap>
???
??? ???? <resultMap id="schoolResult" type="com.zlwh.member.model.School">
??????? <result property="id" column="id"/>
??????? <result property="schoolName" column="school_name"/>
??????? <result property="schoolCode" column="school_code"/>
??????? <result property="county" column="county"/>
??????? <result property="address" column="address"/>
??????? <result property="phase" column="phase"/>
??? </resultMap>
??? ???
??? <select id="getSchoolById" resultMap="schoolResult">
??? ??? SELECT * FROM school WHERE id = #{id}
??? </select>
???
??? <resultMap id="usersResultForT" type="com.zlwh.member.model.Users">
??????? <result property="id" column="id"/>
??????? <result property="loginName" column="login_name"/>
??????? <result property="userName" column="user_name"/>
??????? <result property="inviteCode" column="invite_code"/>
??????? <collection property="userSubscriptions" column="id" select="getUserSubscriptionsByUserId" ></collection>
??? </resultMap>
???
?
???
??? <resultMap id="userSubscriptionResult" type="com.zlwh.member.model.UserSubscription">
??????? <result property="id" column="id"/>
??????? <result property="userId" column="user_id"/>
??????? <result property="subscriptionId" column="subscription_id"/>
??????? <result property="beginDate" column="begin_date"/>
??????? <result property="endDate" column="end_date"/>
??????? <result property="status" column="status"/>
??????? <result property="createTime" column="create_time"/>
??????? <result property="orderId" column="order_id"/>
??????? <result property="orderPrice" column="order_price"/>
??????? <result property="payTime" column="pay_time"/>????
??? </resultMap>
???
??? <select id="getStudentsByInviteCode" resultMap="usersResultForT">
?? ???? <![CDATA[SELECT id,login_name,user_name,invite_code FROM users?? ?WHERE invite_code = #{inviteCode} and member_type=1]]>
?? ?</select>
?
<select id="getById" resultMap="usersResult">
??? ??? SELECT <include refid="commonColumns" />
??? ??? <![CDATA[
??? ??? ??? FROM users
??? ??????? WHERE
??? ??? ??????? id = #{id}
??? ??? ]]>
??? </select>
???
??? <!-- 查所有已支付的订阅 -->
??? ?<select id="getUserSubscriptionsByUserId" resultMap="userSubscriptionResult">
??? ??? SELECT * FROM user_subscription WHERE (status=1 or status=3) and user_id = #{userId} order by subscription_id asc
??? </select>
???
?
??? <!-- 用于select查询公用抽取的列 -->
??? <sql id="commonColumns">
??? ??? <![CDATA[
??????? ??? id ,
??????? ??? login_name ,
??????? ??? user_name ,
??????? ??? password ,
??????? ??? email ,
??????? ??? status ,
??????? ??? user_type ,
??????? ??? member_type ,
??????? ??? img_path ,
??????? ??? img_status ,
??????? ??? identification ,
??????? ??? certificate_code ,
??????? ??? county_code ,
??????? ??? school_id ,
??????? ??? class_id ,
??????? ??? grade ,
??????? ??? sex ,
??????? ??? birthday ,
??????? ??? mobile ,
??????? ??? invite_code ,
??????? ??? subject_id ,
??????? ??? Certification_status ,
??????? ??? create_time ,
??????? ??? valid_time ,
??????? ??? institution_id ,
??????? ??? dep_name ,
??????? ??? job_name
??? ??? ]]>
??? </sql>
???
??
