src/com/java1234/mappers/CustomerLossMapper.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.CustomerLossDao">

	<resultMap type="CustomerLoss" id="CustomerLossResult">
		<result property="id" column="id"/>
		<result property="cusNo" column="cusNo"/>
		<result property="cusName" column="cusName"/>
		<result property="cusManager" column="cusManager"/>
		<result property="lastOrderTime" column="lastOrderTime"/>
		<result property="confirmLossTime" column="confirmLossTime"/>
		<result property="state" column="state"/>
		<result property="lossReason" column="lossReason"/>
	</resultMap>
	
	<select id="findCustomerLoss" parameterType="Map" resultMap="CustomerLossResult">
		select * from t_customer_loss
		<where>
		    <if test="cusName!=null and cusName!='' ">
				cusName like #{cusName}
			</if>
			<if test="cusManager!=null and cusManager!='' ">
				and cusManager like #{cusManager}
			</if>
			<if test="state!=null and state!=' ' ">
				and state = #{state}
			</if>
		</where>
		<if test="start!=null and size!=null">
			limit #{start},#{size}
		</if>
	</select>
	
	<select id="getTotalCutomerLoss" parameterType="Map" resultType="Long">
		select count(*) from t_customer_loss
		<where>
		    <if test="cusName!=null and cusName!='' ">
				cusName like #{cusName}
			</if>
			<if test="cusManager!=null and cusManager!='' ">
				and cusManager like #{cusManager}
			</if>
			<if test="state!=null and state!=' ' ">
				and state = #{state}
			</if>
		</where>
	</select>
	

	<select id="findById" parameterType="Integer" resultMap="CustomerLossResult">
		select * from t_customer_loss where id=#{id}
	</select>
	
	<insert id="addCustomerLoss" parameterType="CustomerLoss">
		insert into t_customer_loss values(null,#{cusNo},#{cusName},#{cusManager},#{lastOrderTime},null,0,null);
	</insert>
	
	<update id="updateCustomerLoss" parameterType="CustomerLoss">