src/com/java1234/mappers/SaleChanceMapper.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.SaleChanceDao">

	<resultMap type="SaleChance" id="SaleChanceResult">
		<result property="id" column="id"/>
		<result property="chanceSource" column="chanceSource"/>
		<result property="cgjl" column="cgjl"/>
		<result property="overView" column="overView"/>
		<result property="linkMan" column="linkMan"/>
		<result property="linkPhone" column="linkPhone"/>
		<result property="description" column="description"/>
		<result property="createMan" column="createMan"/>
		<result property="createTime" column="createTime"/>
		<result property="assignMan" column="assignMan"/>
		<result property="assignTime" column="assignTime"/>
		<result property="state" column="state"/>
		<result property="devResult" column="devResult"/>
	</resultMap>
	
	<select id="findSaleChance" parameterType="Map" resultMap="SaleChanceResult">
		select * from t_sale_chance
		<where>
			<if test="customerName!=null and customerName!='' ">
				customerName like #{customerName}
			</if>
			<if test="overView!=null and overView!='' ">
				and overView like #{overView}
			</if>
			<if test="createMan!=null and createMan!='' ">
				and createMan like #{createMan}
			</if>
			<if test="state!=null and state!=' ' ">
				and state = #{state}
			</if>
			<if test="devResult!=null and devResult!=' ' ">
				and devResult = #{devResult}
			</if>
		</where>
		<if test="start!=null and size!=null">
			limit #{start},#{size}
		</if>
	</select>
	
	<select id="getTotalSaleChance" parameterType="Map" resultType="Long">
		select count(*) from t_sale_chance
		<where>
			<if test="customerName!=null and customerName!='' ">
				customerName like #{customerName}
			</if>
			<if test="overView!=null and overView!='' ">
				and overView like #{overView}
			</if>
			<if test="createMan!=null and createMan!='' ">
				and createMan like #{createMan}
			</if>
			<if test="state!=null and state!=' ' ">
				and state = #{state}