zhanghua
2025-04-14 1cad14bca191807e18705c3a5526eda8151be439
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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
package com.ycl;
 
import com.aliyun.oss.OSS;
import com.aliyun.oss.OSSClientBuilder;
import com.aliyun.oss.OSSException;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.entity.resources.ImageResources;
import com.ycl.mapper.resources.ImageResourcesMapper;
import com.ycl.service.oss.OssService;
import com.ycl.util.SpringContextUtil;
import com.ycl.utils.ConstantPropertiesUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Service;
 
import javax.annotation.Resource;
import java.io.IOException;
import java.io.InputStream;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.Date;
 
@Component
public class OSSImageMove extends Thread {
 
    @Resource
    ImageResourcesMapper imageResourcesMapper;
 
    @Autowired
    OssService ossService;
 
    public void run() {
 
        System.out.println("---------------OSSImageMove running");
 
        imageResourcesMapper = SpringContextUtil.getBean("imageResourcesMapper", ImageResourcesMapper.class);
        ossService = SpringContextUtil.getBean("ossServiceImpl", OssService.class);
 
        System.out.println("---------------OSSImageMove start");
        int i = 1;
        while (true) {
            IPage<ImageResources> page = new Page<>(i, 10);
            LambdaQueryWrapper<ImageResources> queryWrapper = new LambdaQueryWrapper<>();
            queryWrapper.isNull(ImageResources::getUrl1).orderByDesc(ImageResources::getId);
            imageResourcesMapper.selectPage(page, queryWrapper);
            System.out.println("page-current:" + page.getCurrent() + "--page-total:" + page.getTotal());
            if (page.getRecords().size() > 0) {
                for (ImageResources imageResources : page.getRecords()) {
                    try {
 
                        System.out.println("source-url:" + imageResources.getUrl());
 
                        String backUrl = extracted(imageResources.getUrl());
 
                        System.out.println("new-url:" + imageResources.getUrl());
                        imageResources.setUrl1(backUrl);
                        imageResourcesMapper.updateById(imageResources);
 
                    } catch (Exception e) {
                        System.out.println("OSSImageMove-error:" + e.getMessage());
                    }
                }
            } else {
                break;
            }
            i++;
        }
 
        System.out.println("---------------OSSImageMove  Over");
    }
 
    private String extracted(String imageUrl) {
        String[] urls = imageUrl.split(",");
        StringBuilder backUrl = new StringBuilder();
        for (int j = 0; j < urls.length; j++) {
 
            URL url = translateOSSUrl(urls[j]);
 
            HttpURLConnection conn = null;
            try {
                conn = (HttpURLConnection) url.openConnection();
 
                conn.setRequestMethod("GET");
                conn.setConnectTimeout(10 * 1000);
                conn.setRequestProperty("User-Agent", "Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)");
 
                InputStream inputStream = conn.getInputStream();// 通过输入流获取图片数据
 
                if (inputStream != null) {
                    String picData = ossService.uploadImages(inputStream, ".png", 0);
                    backUrl.append(picData);
                }
            } catch (IOException e) {
                System.out.println("OSSImageMove-translateOSSUrl-error:" + e.getMessage());
                // throw new RuntimeException(e);
            }
        }
        return backUrl.toString();
    }
 
 
    private URL translateOSSUrl(String fileUrl) {
        OSS ossClient = null;
        try {
            String endpoint = ConstantPropertiesUtils.END_POINT;
            String accessKeyId = ConstantPropertiesUtils.ACCESS_KEY_ID;
            String accessKeySecret = ConstantPropertiesUtils.ACCESS_KEY_SECRET;
            String bucketName = ConstantPropertiesUtils.BUCKET_NAME;
 
            String[] urlArray = fileUrl.split("Expires=");
 
            String objectName = urlArray[0].replace(ConstantPropertiesUtils.PREFIX_URL, "");
            objectName = objectName.replace("?", "");
 
            ossClient = new OSSClientBuilder().build(endpoint, accessKeyId, accessKeySecret);
 
            // 设置签名URL过期时间,单位为毫秒。本示例以设置过期时间为1小时为例。
            Date expiration = new Date(new Date().getTime() + 3600 * 1000L);
            // 生成以GET方法访问的签名URL。本示例没有额外请求头,其他人可以直接通过浏览器访问相关内容。
            URL url = ossClient.generatePresignedUrl(bucketName, objectName, expiration);
 
            return url;
        } catch (OSSException oe) {
            System.out.println("Caught an OSSException, which means your request made it to OSS, "
                    + "but was rejected with an error response for some reason.");
            System.out.println("Error Message:" + oe.getErrorMessage());
            System.out.println("Error Code:" + oe.getErrorCode());
            System.out.println("Request ID:" + oe.getRequestId());
            System.out.println("Host ID:" + oe.getHostId());
        } finally {
            if (ossClient != null) {
                ossClient.shutdown();
            }
        }
        return null;
    }
}