WebRoot/WEB-INF/classes/com/chhj/customer/mapper/ICustomerMapper.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.chhj.customer.dao.ICustomerDao">
	<resultMap type="Customer" id="customerResultMap">
		<!-- id -->
		<id property="id" column="id" />
		<!-- 创建时间 -->
		<result property="createDate" column="y_create_date" />
		<!-- 更新时间 -->
		<result property="updateDate" column="y_update_date" />
		<!-- 删除状态 -->
		<result property="deteleState" column="y_detele_state" />
		<!-- 操作人 -->
		<result property="operatorId" column="y_operator_id" />
		<!-- 姓名 -->
		<result property="name" column="y_name" />
		<!-- 图片 -->
		<result property="photo" column="y_photo_url" />
	</resultMap>

	<sql id="allColumnSql">
		id,
		y_create_date,
		y_update_date,
		y_detele_state,
		y_operator_id,
		y_name,
		y_photo_url
	</sql>
	
	<!-- 分页查询 -->
	<select id="listCustomerByPage" resultMap="customerResultMap">
		SELECT <include refid="allColumnSql"/>
		FROM y_customer
		WHERE y_detele_state = 0
		<if test="name !='' and name != null">
			AND y_name like '%${name}%'
		</if>
		ORDER BY y_create_date DESC
	</select>
	<select id="listCustomerByPageCount" resultType="int">
		SELECT count(id)
		FROM y_customer
		WHERE y_detele_state = 0
	</select>
	<!-- 通过ID查询 -->
	<select id="listCustomerById" resultMap="customerResultMap">
		SELECT <include refid="allColumnSql"/>
		FROM y_customer
		WHERE y_detele_state = 0
		AND id = #{id} 
		ORDER BY y_create_date DESC
	</select>
	<!-- 通过ID查询 -->
	<select id="listCustomerAll" resultMap="customerResultMap">
		SELECT <include refid="allColumnSql"/>
		FROM y_customer
		WHERE y_detele_state = 0
		ORDER BY y_create_date DESC
	</select>