4.15

第二阶段的接口

 

传入三个参数：开始日期，结束日期（下一篇文章修改了这里，输入的是想查的日期，如果输入为空，则默认查找数据库中最新更新的数据（1条/2条））

{
  "fromDate": "1515686400000",
  "toDate": "string",
  "type": "HSI"
}

IndexHistoryMapper.xml文件     分别对三张表查询

<select id="findManyByHk" resultMap="BaseResultMap" parameterType="com.simnectzbank.lbs.systemlayer.stockinfo.entity.IndexHistoryEntity" >
     select * from stockindex_hk
     where 1=1
    <if test="type != null and type != ''" >
      and Type = #{type}
    </if>
    <if test="fromDate != null and fromDate != ''">
      and UpdateTime &gt;= #{fromDate}
    </if>
    <if test="toDate != null and toDate != ''">
      and UpdateTime &lt;= #{toDate}
    </if>
    order by UpdateTime
  </select>

  <select id="findManyByChina" resultMap="BaseResultMap" parameterType="com.simnectzbank.lbs.systemlayer.stockinfo.entity.IndexHistoryEntity" >
    select * from stockindex_china
    where 1=1
    <if test="type != null and type != ''" >
      and Type = #{type}
    </if>
    <if test="fromDate != null and fromDate != ''">
      and UpdateTime &gt;= #{fromDate}
    </if>
    <if test="toDate != null and toDate != ''">
      and UpdateTime &lt;= #{toDate}
    </if>
    order by UpdateTime
  </select>

  <select id="findManyByWorld" resultMap="BaseResultMap" parameterType="com.simnectzbank.lbs.systemlayer.stockinfo.entity.IndexHistoryEntity" >
    select * from stockindex_world
    where 1=1
    <if test="type != null and type != ''" >
      and Type = #{type}
    </if>
    <if test="fromDate != null and fromDate != ''">
      and UpdateTime &gt;= #{fromDate}
    </if>
    <if test="toDate != null and toDate != ''">
      and UpdateTime &lt;= #{toDate}
    </if>
    order by UpdateTime
  </select>

其他的基本上和上一个接口一样。

但是输入的日期需要转换一下，转换成时间戳！（未完成）