build/classes/com/java1234/mappers/CustomerServiceMapper.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.java1234.dao.CustomerServiceDao">

	<resultMap type="CustomerService" id="CustomerServiceResult">
		<result property="id" column="id"/>
		<result property="serveType" column="serveType"/>
		<result property="overview" column="overview"/>
		<result property="customer" column="customer"/>
		<result property="state" column="state"/>
		<result property="servicerequest" column="servicerequest"/>
		<result property="createPeople" column="createPeople"/>
		<result property="createTime" column="createTime"/>
		<result property="assigner" column="assigner"/>
		<result property="assignTime" column="assignTime"/>
		<result property="serviceProce" column="serviceProce"/>
		<result property="serviceProcePeople" column="serviceProcePeople"/>
		<result property="serviceProceTime" column="serviceProceTime"/>
		<result property="serviceProceResult" column="serviceProceResult"/>
		<result property="myd" column="myd"/>
	</resultMap>
	
	<select id="findCustomerService" parameterType="Map" resultMap="CustomerServiceResult">
		select * from t_customer_service
		<where>
		    <if test="customer!=null and customer!='' ">
				and customer like #{customer}
			</if>
			<if test="overview!=null and overview!='' ">
				and overview like #{overview}
			</if>
			<if test="serveType!=null and serveType!='' ">
				and serveType = #{serveType}
			</if>
			<if test="state!=null and state!='' ">
				and state = #{state}
			</if>
			<if test="createTimefrom!=null and createTimefrom!='' ">
				and createTime &gt;= #{createTimefrom}
			</if>
			<if test="createTimeto!=null and createTimeto!='' ">
				and createTime &lt;= #{createTimeto}
			</if>
		</where>
		<if test="start!=null and size!=null">
			limit #{start},#{size}
		</if>
	</select>
	
	<select id="getTotalCustomerService" parameterType="Map" resultType="Long">
		select count(*) from t_customer_service
		<where>
			 <if test="customer!=null and customer!='' ">
				and customer like #{customer}
			</if>
			<if test="overview!=null and overview!='' ">
				and overview like #{overview}
			</if>