build/classes/com/shop/mapper/ProductMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

<?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.shop.mapper.ProductMapper">
	<resultMap id="BaseResultMap" type="com.shop.po.Product">
		<id column="pid" property="pid" jdbcType="INTEGER" />
		<result column="pname" property="pname" jdbcType="VARCHAR" />
		<result column="market_price" property="marketPrice" jdbcType="DOUBLE" />
		<result column="shop_price" property="shopPrice" jdbcType="DOUBLE" />
		<result column="image" property="image" jdbcType="VARCHAR" />
		<result column="pdesc" property="pdesc" jdbcType="VARCHAR" />
		<result column="is_hot" property="isHot" jdbcType="INTEGER" />
		<result column="pdate" property="pdate" jdbcType="TIMESTAMP" />
		<result column="csid" property="csid" jdbcType="INTEGER" />
	</resultMap>
	<sql id="Example_Where_Clause">
		<where>
			<foreach collection="oredCriteria" item="criteria" separator="or">
				<if test="criteria.valid">
					<trim prefix="(" suffix=")" prefixOverrides="and">
						<foreach collection="criteria.criteria" item="criterion">
							<choose>
								<when test="criterion.noValue">
									and ${criterion.condition}
								</when>
								<when test="criterion.singleValue">
									and ${criterion.condition} #{criterion.value}
								</when>
								<when test="criterion.betweenValue">
									and ${criterion.condition} #{criterion.value}
									and
									#{criterion.secondValue}
								</when>
								<when test="criterion.listValue">
									and ${criterion.condition}
									<foreach collection="criterion.value" item="listItem"
										open="(" close=")" separator=",">
										#{listItem}
									</foreach>
								</when>
							</choose>
						</foreach>
					</trim>
				</if>
			</foreach>
		</where>
	</sql>
	<sql id="fenye">
		<if test="beginPage !=null">
			<if test="end !=null">
				limit #{beginPage},#{end}
			</if>
		</if>
	</sql>
	<sql id="Update_By_Example_Where_Clause">
		<where>
			<foreach collection="example.oredCriteria" item="criteria"
				separator="or">
				<if test="criteria.valid">
					<trim prefix="(" suffix=")" prefixOverrides="and">
						<foreach collection="criteria.criteria" item="criterion">