Question

这个sql怎么在mybatis写出来？

select
ai.name,
ai.admin_id,
ar.role_id,
rm.module_id
from
admin_info ai left outer join admin_role ar
on ai.admin_id=ar.admin_id
left outer join role_module rm
on ar.role_id=rm.role_id
left outer join module_info mi
on rm.module_id=mi.module_id

Answer 1

在对应的.xml中添加insert标签，换掉中间的insert语句
<insert id="addUser" parameterType="User"
useGeneratedKeys="true" keyProperty="id">
insert into user(userName,userAge,userAddress)
values(#{userName},#{userAge},#{userAddress})
</insert>