这个问题花了我3个小时,。先上图,以后再解释
<select id="getComJob" parameterType="List" resultType="hashMap">
select
job.*,
jobclass1.name as catname1,
jobclass2.name as catname2,
jobclass3.name as catname3,
province.area_name as addr_province,
city.area_name as addr_city,
area.area_name as addr_area,
jingyan.name as jingyan,
xueli.name as xueliname
from
mj_com_job job
left join mj_job_class jobclass1 on job.cat1=jobclass1.id
left join mj_job_class jobclass2 on job.cat2=jobclass2.id
left join mj_job_class jobclass3 on job.cat3=jobclass3.id
left join mj_area province on job.provinceid = province.id
left join mj_area city on job.cityid = city.id
left join mj_area area on job.three_cityid = area.id
left join mj_com_class jingyan on job.experience_id=jingyan.id
left join mj_com_class xueli on job.Education_id=xueli.id
<where>
${ew.sqlSegment}
</where>
</select>
public R detail(@RequestParam(value = "jobid") Integer jobid, Model model) {
QueryWrapper<ComJob> wrapper = new QueryWrapper<>();
wrapper.eq("job.id",jobid);
List<ComJob> comJob = jobService.getComJob(wrapper);