src/com/java1234/mappers/CustomerMapper.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.CustomerDao">

	<resultMap type="Customer" id="CustomerResult">
		<result property="id" column="id"/>
		<result property="name" column="name"/>
		<result property="area" column="area"/>
		<result property="cusManager" column="cusManager"/>
		<result property="level" column="level"/>
		<result property="myd" column="myd"/>
		<result property="xyd" column="xyd"/>
		<result property="address" column="address"/>
		<result property="postCode" column="postCode"/>
		<result property="phone" column="phone"/>
		<result property="fax" column="fax"/>
		<result property="webSite" column="webSite"/>
		<result property="yyzzzch" column="yyzzzch"/>
		<result property="fr" column="fr"/>
		<result property="zczj" column="zczj"/>
		<result property="nyye" column="nyye"/>
		<result property="khyh" column="khyh"/>
		<result property="khzh" column="khzh"/>
		<result property="dsdjh" column="dsdjh"/>
		<result property="gsdjh" column="gsdjh"/>
	</resultMap>
	
	<resultMap type="CustomerGx" id="CustomerGxResult">
		<result property="name" column="name"/>
		<result property="gx" column="gx"/>
	</resultMap>
	
	<resultMap type="CustomerGc" id="CustomerGcResult">
		<result property="customerLevel" column="customerLevel"/>
		<result property="customerNum" column="customerNum"/>
	</resultMap>
	
	<resultMap type="CustomerFw" id="CustomerFwResult">
		<result property="serveType" column="serveType"/>
		<result property="num" column="num"/>
	</resultMap>
	
	<select id="findCustomer" parameterType="Map" resultMap="CustomerResult">
		select * from t_customer
		<where>
		    <if test="khno!=null and khno!='' ">
				and khno like #{khno}
			</if>
			<if test="name!=null and name!='' ">
				and name like #{name}
			</if>
		</where>
		<if test="start!=null and size!=null">
			limit #{start},#{size}
		</if>
	</select>
	
	<select id="getTotalCustomer" parameterType="Map" resultType="Long">