单库库数据导入/爬虫

admin

2024-09-14 5356cfea4f3238be5fd14a2d8ea8108d22a1b25e

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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
package com.everyday.word.service.impl;
 
import com.everyday.word.dao.EnglishWordsMapper;
import com.everyday.word.entity.EnglishWords;
import com.everyday.word.exception.EnglishWordsException;
import com.everyday.word.service.EnglishWordsService;
import org.springframework.stereotype.Service;
import org.yeshi.utils.StringUtil;
 
import javax.annotation.Resource;
import java.util.Date;
import java.util.List;
 
/**
 * @author hxh
 * @title: EnglishWordsServiceImpl
 * @description:
 * @date 2024/9/14 13:40
 */
@Service
public class EnglishWordsServiceImpl implements EnglishWordsService {
 
    @Resource
    private EnglishWordsMapper englishWordsMapper;
 
    @Override
    public void addEnglishWords(EnglishWords word) throws EnglishWordsException {
        if(word==null|| StringUtil.isNullOrEmpty(word.getSpelling())){
            throw new EnglishWordsException("数据不完整");
        }
        EnglishWords oldWord =    selectBySpelling(word.getSpelling());
        if(oldWord!=null){
            word.setId(oldWord.getId());
            word.setUpdateTime(new Date());
            englishWordsMapper.updateByPrimaryKeySelective(word);
        }else{
            if(word.getCreateTime()==null){
                word.setCreateTime(new Date());
            }
            englishWordsMapper.insertSelective(word);
        }
    }
 
    @Override
    public EnglishWords selectBySpelling(String spelling) {
        EnglishWordsMapper.DaoQuery daoQuery=new EnglishWordsMapper.DaoQuery();
        daoQuery.spelling=spelling;
        daoQuery.count = 1;
        List<EnglishWords> list = englishWordsMapper.list(daoQuery);
        if(!list.isEmpty()){
            return list.get(0);
        }
        return null;
    }
 
    @Override
    public List<EnglishWords> list(EnglishWordsMapper.DaoQuery query, int page, int pageSize) {
        query.start=(page-1)*pageSize;
        query.count = pageSize;
        return englishWordsMapper.list(query);
    }
 
    @Override
    public long count(EnglishWordsMapper.DaoQuery query) {
        return englishWordsMapper.count(query);
    }
}