实习第三天

不想加班啊 昨天加班到十点

maven版本冲突

飘红 把他删掉 再加上就ok了

    <plugins>
      <plugin>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-maven-plugin</artifactId>
        <version>2.0.2.RELEASE</version>
        <configuration>
          <!-- 没有该配置，devtools 不生效 -->
          <fork>true</fork>
          <!-- 将外部jar打包入工程，否则libs下面的jar打包的时候进不来 -->
          <includeSystemScope>true</includeSystemScope>
        </configuration>
      </plugin>
    </plugins>

一对多

查到的id重复导致 集合为一
遇到两个坑
（1）一对多的多 要加表明在数据库中不存在

    @TableField(exist = false)
    @ApiModelProperty(value = "明细", required = false)
    private List<QuotationDetails> quotationDetails;

（2）一对多的多只有 一个条数据 两张表 字段id 重复 ， 使用别名

<select id="queryMesAndDetails" parameterType="java.lang.Integer" resultMap="mesAndDetails">
        select *,d.id did from quotation_mes m,quotation_details d where   m.id = d.userId   and  m.id = #{id}
    </select>

具体实现
（1）在类中加集合
（2）mapper.java写方法名
（3）写mapper.xml映射写sql

<?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="cn.com.huake.mapper.QuotationMesMapper">

    <select id="queryMesAndDetails" parameterType="java.lang.Integer" resultMap="mesAndDetails">
        select *,d.id did from quotation_mes m,quotation_details d where   m.id = d.userId   and  m.id = #{id}
    </select>

    <resultMap id="mesAndDetails" type="cn.com.huake.entity.QuotationMes">
        <id property="id" column="id" />
        <result property="aboutCustomer" column="aboutCustomer"/>
        <result property="quotationNumber" column="quotationNumber"/>
        <result property="quoteTime" column="quoteTime"/>
        <result property="quoteName" column="quoteName"/>
        <result property="otherRepresenTative" column="otherRepresenTative"/>
        <result property="inquiryPrice" column="inquiryPrice"/>
        <result property="quoteClassify" column="quoteClassify"/>
        <result property="quotePeople" column="quotePeople"/>
        <result property="currency" column="currency"/>
        <result property="quoteLimit" column="quoteLimit"/>
        <result property="preferentialQuota" column="preferentialQuota"/>
        <result property="discount" column="discount"/>
        <result property="discountQuota" column="discountQuota"/>
        <result property="relatedProjects" column="relatedProjects"/>
        <result property="payment" column="payment"/>
        <result property="deliveryDate" column="deliveryDate"/>
        <result property="deliveryType" column="deliveryType"/>
        <result property="deliveryAddress" column="deliveryAddress"/>
        <result property="quotereMark2" column="quotereMark2"/>
        <result property="quotereMark3" column="quotereMark3"/>
        <collection property="quotationDetails" ofType="cn.com.huake.entity.QuotationDetails" >
            <id property="id" column="did"></id>
            <result property="productId" column="productId"/>
            <result property="productImg" column="productImg"/>
            <result property="productName" column="productName"/>
            <result property="productNumber" column="productNumber"/>
            <result property="productModel" column="productModel"/>
            <result property="unit" column="unit"/>
            <result property="quantity" column="quantity"/>
            <result property="unitPrice" column="unitPrice"/>
            <result property="paperType" column="paperType"/>
            <result property="taxRate" column="taxRate"/>
            <result property="tax" column="tax"/>
            <result property="quotereMark1" column="quotereMark1"/>
            <result property="suggest" column="suggest"/>
            <result property="customerId" column="customerId"/>
            <result property="userId" column="userId"/>
            <result property="deleted" column="deleted"/>
        </collection>
    </resultMap>
</mapper>

又写了一些其他的 CRUD去处理业务逻辑
排序就 .last拼sql
小八点 下班 人太少了 业务根本理不清 很复杂，什么审批 ，审批规则，一级二级三级十级审批，共享，各种权限。。。