1

zj

2025-06-25 a0361e762fc672d844ef15e18db5971893cce2bf

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
package project.hobi.internal;
 
import java.util.List;
 
import org.springframework.jdbc.core.JdbcTemplate;
 
import kernel.util.StringUtils;
import kernel.web.ApplicationUtil;
import kernel.web.Page;
import project.data.model.Symbols;
import project.hobi.AdminContractSymbolsService;
import project.hobi.HobiDataService;;
 
public class AdminContractSymbolsServiceImpl implements AdminContractSymbolsService {
    
    private HobiDataService hobiDataService;
    
    @Override
    public void saveReload() {
        List<Symbols> list = hobiDataService.symbols();
        if (list.size() <=0) return;
        
        ApplicationUtil.executeSQL("TRUNCATE TABLE T_SYMBOLS");
        
        list.forEach(symbols->{if(null==symbols.getId())symbols.setId(ApplicationUtil.getCurrentTimeUUID());});
        ApplicationUtil.executeBatchInsert(list);
    }
 
    @Override
    public Page pagedQuery(int pageNo, int pageSize, String quote_currency, String base_currency) {
        if (StringUtils.isNullOrEmpty(quote_currency)) {
            String tmp=null;
            List<String> list=ApplicationUtil.getBean(JdbcTemplate.class).queryForList("SELECT DISTINCT(QUOTE_CURRENCY) FROM T_SYMBOLS LIMIT 1",String.class);
            if(null!=list && !list.isEmpty() && null!=(tmp=list.get(0)) && !(tmp=tmp.trim()).isEmpty()) quote_currency=tmp;
        }
        
        Page page = new Page(pageNo, pageSize, Integer.MAX_VALUE);
        List<Symbols> list=ApplicationUtil.executeSelect(Symbols.class,"WHERE QUOTE_CURRENCY=? AND BASE_CURRENCY LIKE ? LIMIT ?,?",
                new Object[] {quote_currency,"%"+base_currency+"%",page.getFirstElementNumber(),pageSize});
        page.setElements(list);
        
        return page;
    }
 
    public List<String> getQuoteList() {
        return ApplicationUtil.getBean(JdbcTemplate.class).queryForList("SELECT DISTINCT(QUOTE_CURRENCY) FROM T_SYMBOLS", String.class);
    }
 
    public void setHobiDataService(HobiDataService hobiDataService) {
        this.hobiDataService = hobiDataService;
    }
}