MyBatis多对一配置

  <resultMap id="orderInfoByDoctorId" type="cn.cslg.model.OrderInfo">
        <!--往orders的模型匹配数据-->
          <id column="order_id" property="order_id"></id>
          <id column="patient_id" property="patient_id"></id>
          <id column="doctor_id" property="doctor_id"></id>
          <id column="order_info" property="order_info"></id>
          <id column="order_time" property="order_time"></id>
          <id column="user_id" property="user_id"></id>
        <association property="patient" javaType="cn.cslg.model.Patient">
            <id column="patient_id" property="patient_id"></id>
            <id column="patient_name" property="patient_name"></id>
            <id column="patient_sex" property="patient_sex"></id>
            <id column="patient_age" property="patient_age"></id>
        </association>
        <association property="doctor" javaType="cn.cslg.model.Doctor">
            <id column="doctor_id" property="doctor_id"></id>
        </association>
    </resultMap>
    <select id="findOrderByDoctorId"  resultMap="orderInfoByDoctorId" parameterType="String">
       SELECT
           patient.patient_name,
           patient.patient_sex,
           patient.patient_age,
           orderinfo.order_id,
           orderinfo.doctor_id,
           orderinfo.order_info,
           orderinfo.order_time
       FROM
           patient,
           doctor,
           orderinfo
       where
             orderinfo.doctor_id=#{orderinfo.doctor_id}
             and patient.patient_id=orderinfo.patient_id
             and doctor.doctor_id=orderinfo.doctor_id;
    </select>


```java
public class OrderInfo {
    private Integer order_id;
    private Integer patient_id;
    private String doctor_id;
    private  String order_info;
    private String order_time;
    private  Integer user_id;
    private Patient patient;
    private  Doctor doctor;

get(){
.........................
}插入代码片
```set(){
................................................
}
}