src/main/resources/mapper/MaintainMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">


<!-- 不使用namespace的话sql搜索定位会比较方便 -->
<mapper namespace="Maintain">

	<resultMap id="RM.Maintain" type="com.zx.maintain.model.Maintain">
        <result property="id" column="Id"/>
        <result property="orderNumber" column="order_number"/>
        <result property="policyIds" column="policy_ids"/>
        <result property="name" column="name"/>
        <result property="idCard" column="id_card"/>
        <result property="mobile" column="mobile"/>
        <result property="area" column="area"/>
        <result property="address" column="address"/>
        <result property="description" column="description"/>
        <result property="imageUrl" column="image_url"/>
        <result property="expressId" column="express_id"/>
        <result property="expressNumber" column="express_number"/>
        <result property="postalAddressId" column="postal_address_id"/>
        <result property="status" column="status"/>
        <result property="imei" column="imei"/>
        <result property="phone" column="phone"/>
        <result property="createTime" column="create_time"/>
        <result property="videoUrl" column="video_url"/>
        <result property="screenStatus" column="screen_status"/>
        <result property="damageStatus" column="damage_status"/>
        <result property="damageReason" column="damage_reason"/>
        <result property="openid" column="openid"/>
        <result property="maintainType" column="maintain_type"/>
        <result property="bank" column="bank"/>
        <result property="bankNum" column="bank_num"/>
        <result property="bankName" column="bank_name"/>
        <result property="province" column="province"/>
        <result property="county" column="county"/>
        <result property="city" column="city"/>
        <result property="orderClaimsId" column="order_claims_id"/>
        <result property="remark" column="remark"/>
        <result property="sendType" column="send_type"/>
        <result property="phoneDamage" column="phone_damage"/>
        <result property="isSend" column="is_send"/>
        <result property="brandId" column="brand_id"/>
        <result property="modelId" column="model_id"/>
        <result property="brandName" column="brandName"/>
        <result property="modelName" column="modelName"/>
        <result property="accountId" column="account_id"/>
        <result property="networkName" column="networkName"/>
        <result property="contacts" column="contacts"/>
        <result property="phoneNumber" column="phoneNumber"/>
	</resultMap>
	
	<!-- 用于select查询公用抽取的列 -->
	<sql id="Maintain.columns">
	    <![CDATA[
		Id,order_number,policy_ids,name,id_card,mobile,area,address,description,image_url,express_id,express_number,postal_address_id,status,imei,phone,create_time,video_url,screen_status,damage_status,damage_reason,openid,maintain_type,bank,bank_num,bank_name,province,county,city,order_claims_id,remark,send_type,phone_damage,is_send
	    ]]>
	</sql>