<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.hao.mapper.IUserMapper">
<select id="login" parameterType="com.hao.dto.User" resultType="com.hao.dto.User">
select * from t_user0924 where username = #{username} and userpwd = #{userpwd}
</select>
<select id="findMenuList" parameterType="int" resultType="com.hao.dto.Menu">
select m.id id,m.pid pid,m.name name,m.url url,m.target target from t_user0924 u
left join t_ur0924 ur on u.id = ur.userid
left join t_role0924 r on ur.roleid = r.roleid
left join t_rm0924 rm on r.roleid = rm.roleid
left join t_menu0924 m on rm.menuid = m.id where u.id = #{id}
</select>
</mapper>
“人一辈子都在高潮-低潮中浮沉,惟有庸碌的人,生活才如死水一般”“只要高潮不过分使你紧张,低潮不过分是你颓废,就好了”
——傅雷《傅雷家书》