代码迁移推送

zj

2024-06-03 287ac389edd047696d956afafdb855a93830bc0c

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
package com.nq.dao;
 
import com.nq.pojo.RealTime;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
 
public interface RealTimeMapper {
    @Select({"select * from realtime where stockCode=#{stockCode}"})
    List<RealTime> findStock(String paramString);
 
    /*删除股票*/
    @Delete({"DELETE FROM realtime WHERE locate('hf_',`stockCode`)=0"})
    int deleteStockCode();
 
    /*删除期货*/
    @Delete({"DELETE FROM realtime WHERE locate('hf_',`stockCode`)=1"})
    int deleteStockFuturesCode();
 
    @Insert({"<script>", "insert into realtime (time,volumes,price,rates,averagePrice,amounts,stockCode) values ", "<foreach  collection='areaLists' item='realTime' index='index' separator=','>", "(#{realTime.time},#{realTime.volumes},#{realTime.price},#{realTime.rates},#{realTime.averagePrice},#{realTime.amounts},#{realTime.stockCode})", "</foreach>", "</script>"})
    int insertRealTime(@Param("areaLists") List<RealTime> paramList);
}