<select id="InsertUserPrivilegeTemp" parameterType="Integer"
resultMap="userPrivilegeTemp">
insert into userPrivilegeTemp
select ui.UserID, rp.PrivilegeID
from UserInfo ui
left join UserRole ur on ur.UserID=ui.UserID
left join RolePrivilege rp on rp.RoleID=ur.RoleID
<where>
and ui.UserID=#{id}
</where>
</select>
当mybaties执行到 insert into userPrivilegeTemp这里的时候,进程就卡死了,
后来我改为insert into userPrivilegeTemp(UserID,PrivilegeID)就不会卡了,
应该是mybaties不认识insert into userPrivilegeTemp代表insert into userPrivilegeTemp(UserID,PrivilegeID)
注意:userPrivilegeTemp表就UserID,PrivilegeID2个字段。