build/classes/com/java1234/mappers/ProductMapper.xml

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.java1234.dao.ProductDao">

	<resultMap type="Product" id="ProductResult">
		<result property="id" column="id"/>
		<result property="productName" column="productName"/>
		<result property="model" column="model"/>
		<result property="unit" column="unit"/>
		<result property="price" column="price"/>
		<result property="store" column="store"/>
		<result property="remark" column="remark"/>
	</resultMap>
	
	<select id="findProduct" parameterType="Map" resultMap="ProductResult">
		select * from t_product
		<where>
		    <if test="productName!=null and productName!='' ">
				and productName like #{productName}
			</if>
		</where>
		<if test="start!=null and size!=null">
			limit #{start},#{size}
		</if>
	</select>
	
	<select id="getTotalProduct" parameterType="Map" resultType="Long">
		select count(*) from t_product
		<where>
		    <if test="productName!=null and productName!='' ">
				and productName like #{productName}
			</if>
		</where>
	</select>
	
</mapper>