9月25日 微服务架构 周二

<?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.IViewMapper">
	<select id="findShopList" resultType="com.hao.dto.Shop" parameterType="String">
		select * from t_shop0927 where name like concat(concat('%',#{mohu}),'%')
	</select>
	<insert id="add" parameterType="com.hao.dto.Shop">
		insert into t_shop0927 values(seq_t_shop0927.nextval,#{name},#{price},#{manname},#{manphone},#{saldate})
	</insert>
	
	<select id="getObj" parameterType="int" resultType="com.hao.dto.Shop">
		select * from t_shop0927 where id = #{id}
	</select>
	<update id="update" parameterType="com.hao.dto.Shop">
		update t_shop0927 set name = #{name},price = #{price},manname=#{manname},manphone=#{manphone},saldate=#{saldate} where id = #{id}
	</update>
	<delete id="del" parameterType="int">
		delete t_shop0927 where id = #{id}
	</delete>
	<select id="getSum" resultType="int">
		select sum(price) from t_shop0927
	</select>
	<select id="getData" resultType="map">
		select name,sum(price) sum from t_shop0927 group by name
	</select>
</mapper>

<?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_user0925 where username = #{username} and userpwd = #{userpwd}
	</select>
	<select id="findMenuList" parameterType="int" resultType="com.hao.dto.Menu">
		select m.id,m.pid,m.name,m.url,m.target from t_user0925 u 
       left join t_ur0925 ur on u.id = ur.userid
       left join t_role0925 r on ur.roleid = r.roleid
       left join t_rm0925 rm on r.roleid = rm.roleid
       left join t_menu0925 m on rm.menuid = m.id
       where u.id =  #{u.id}
	</select>
</mapper>

"世界上该做的事情何其之多，而一个人能做成的事情何其之少"。
《美国常春藤上的中国蜗牛》

——爱岑