<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个字段。

posted on 2017-08-08 17:48  2637282556  阅读(177)  评论(0)    收藏  举报