10月8日 Spring Cloud 周一

<?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.IShopMapper">
	<select id="findShopList" resultType="com.hao.dto.Shop">
		select m.* from (select rownum rn,r.* from
 	(select * from good1008 where shopprice >=#{min} and shopprice &lt;=#{max} order by shopdate desc) r )m where m.rn >=#{pu.startIndex} and m.rn&lt;=#{pu.pageSize}
	</select>
	<select id="getObj" parameterType="int" resultType="com.hao.dto.Shop">
		select * from good1008 where id = #{id}
	</select>
	<update id="update" parameterType="com.hao.dto.Shop">
		update good1008 set shopdate = #{shopdate},shopname=#{shopname},shopnumber=#{shopnumber},shopprice=#{shopprice},shopother=#{shopother} where id = #{id}
	</update>
	<insert id="add" parameterType="com.hao.dto.Shop">
		insert into good1008 values(seq_good1008.nextval,#{shopdate},#{shopname},#{shopnumber},#{shopprice},#{shopother})
	</insert>
	<delete id="delete" parameterType="int">
		delete from good1008 where id = #{id}
	</delete>
	<select id="getCount" resultType="int">
		select count(*) from good1008
	</select>
</mapper>

你想要开战，起码要势均力敌，那样你才有机会赢!

——明楼《伪装者》