[番外]-练习MySQL没素材？来一波字符串操作

痛定思痛。 2022-01-20 04:13 183阅读 0赞

> 个人所有文章整理在此篇，将陆续更新收录:[知无涯，行者之路莫言终（我的编程之路）][Link 1]

--------------------

##### 本文聚焦 #####

> 好了，又到了玩字符串的时间了，先讲一下本文要务  
> 将一个文件夹里的图片归整一下,生成一个插入的sql语句，然后cv一下，插入数据库

|-- 先确定一下几个字段：
    pic_id  主键，自增长
    pic_path 路径           以img文件夹为开始,如android/0f3bf63796ac370a08ee97b056b0587b.png
    pic_length 大小         byte 字节数
    pic_mime 类型
    pic_width宽
    pic_height 高
    
    |--- 建表 -----------------------
    CREATE TABLE pic(
       id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
       pic_path  VARCHAR(120)   NOT NULL,
       pic_length  INT UNSIGNED  DEFAULT 0,
       pic_mime TINYINT UNSIGNED,
       pic_width SMALLINT UNSIGNED,
       pic_height SMALLINT UNSIGNED
     );
    复制代码

--------------------

##### 2.使用Filer 回忆一下 ： 详见[杂篇-从整理文件发起的杂谈\[-File-\]][-_-File-] #####

> 先打印下目录树，以表敬意

public class PictureFilter {
        public static void main(String[] args) {
            Filer filer = new Filer("E:\\SpringBootFiles\\imgs");
            StructureBuilder builder = new StructureBuilder();
            filer.addFilter(builder);
            filer.scan();
            System.out.println(builder.getStructure());
        }
    }
    复制代码

--------------------

##### 3.获取文件的MIME 类型 #####

|-- 获取文件的MIME类型
    public static String getMimeType(String path) {
        String type = null;
        Path p = Paths.get(path);
        try {
            type = Files.probeContentType(p);
        } catch (IOException e) {
            e.printStackTrace();
        }
        return type;
    }
    
    |--- 使用方法
    Filer filer = new Filer("E:\\SpringBootFiles\\imgs");
    filer.addFilter(new FileFilter() {
        @Override
        public boolean iCanGo(File path) {
            System.out.println(file + "----" + getContentType(file.getAbsolutePath()));
            return true;
        }
        @Override
        public void filter(File file, int deep) {
        }
    });
    filer.scan();
    
    |--- 来看一下这个文件夹中有哪些MIME类型，思路很简单，用Set集合装一下，去重
    HashSet<String> set = new HashSet<>();
    filer.addFilter(new FileFilter() {
        @Override
        public boolean iCanGo(File file) {
            String mimeType = getMimeType(file.getAbsolute
            set.add(mimeType);
            return true;
        }
        @Override
        public void filter(File file, int deep) {
        }
    });
    ...
    System.out.println(set);//[null, image/png, image/jpeg, image/svg+xml, text/plain, video/mp4]
    这里只取image/png,image/jpeg两种
    复制代码

--------------------

##### 4.过滤掉其他文件 #####

filer.addFilter(new FileFilter() {
        @Override
        public boolean iCanGo(File file) {
            String mimeType = getMimeType(file.getAbsolutePath());
            return mimeType != null && (mimeType.equals("image/png") || mimeType.equals("image/jpeg"));
        }
        @Override
        public void filter(File file, int deep) {
        }
    });
    filer.scan();
    复制代码

--------------------

##### 5.获取图片的尺寸 #####

> 方法挺耗时的,有种杀鸡焉用牛刀的感觉。不知有没有快速点的api

BufferedImage pic = ImageIO.read(new FileInputStream(file));
    pic.getWidth();
    pic.getHeight();
    复制代码

--------------------

##### 6.获取图片字节数 #####

file.length()
    复制代码

--------------------

#### 二、封装数据，产生插入的sql语句 ####

##### 1.实体类 #####

public class Picture {
        public int pic_id;
        public String pic_path;
        public int pic_length;
        public int pic_mime;
        public int pic_width;
        public int pic_height;
    }
    复制代码

--------------------

##### 2.数据封装 #####

> 为了尽量减小数据库的村相互空间，这里讲路径截取重点，MIME 类型用0表示`image/png`

Filer filer = new Filer("E:\\SpringBootFiles\\imgs");
    ArrayList<Picture> pictures = new ArrayList<>();
    filer.addFilter(new FileFilter() {
        @Override
        public boolean iCanGo(File file) {
            String mimeType = getMimeType(file.getAbsolutePath());
            return mimeType != null && (mimeType.equals("image/png") || mimeType.equals("image/jpeg"));
        }
        @Override
        public void filter(File file, int deep) {
            try {
                BufferedImage pic = ImageIO.read(new FileInputStream(file));
                Picture picture = new Picture();
                picture.pic_length = (int) file.length();
                picture.pic_height = pic.getHeight();
                String mimeType = getMimeType(file.getAbsolutePath());
                picture.pic_mime = mimeType.equals("image/png") ? 0 : 1;
                picture.pic_width = pic.getWidth();
                picture.pic_path = file.getAbsolutePath().replace("E:\\SpringBootFiles\\imgs\\", "");
                pictures.add(picture);
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    });
    filer.scan();
    复制代码

--------------------

##### 3.重点来了:sql插入语句的拼接 #####

StringBuilder sb = new StringBuilder("INSERT INTO pic(pic_path,pic_length,pic_mime,pic_width,pic_height) VALUES\n");
    String q = "\'";
    String dou = ",";
    for (Picture pic : pictures) {
        sb.append("(");
        sb
                .append(q).append(pic.pic_path).append(q).append(dou)
                .append(pic.pic_length).append(dou)
                .append(pic.pic_mime).append(dou)
                .append(pic.pic_width).append(dou)
                .append(pic.pic_height);
        sb.append("),\n");
    }
    sb.replace(sb.length() - 2, sb.length()-1, ";");
    System.out.println(sb);
    复制代码

--------------------

##### 4.白花花的数据就这么出来了 #####

> 如果想做一个磁盘上文件的数据表,按照这个思路也不难,  
> 好了,番外篇完毕，去玩MySQL吧，

INSERT INTO pic(pic_path,pic_length,pic_mime,pic_width,pic_height) VALUES
    ('30000X20000.jpg',116342886,1,30000,20000),
    ('3000X2000.jpg',3404969,1,3000,2000),
    ('300X200.jpg',99097,1,300,200),
    ('30X20.jpg',10158,1,30,20),
    ('6dc9e8455c47d964e1a8a4ef04cf9477.jpg',236254,1,974,319),
    ('AgwbiQhskkfNGJFe.jpg',320574,1,800,1131),
    ('android\\008525ebc2b7d434070e74c00841a30f.png',107019,0,544,544),
    ('android\\054d98e2d96dc42d9b2b036126fccf49.png',175842,0,544,544),
    ('android\\05baf2d03651d1110d7a403f14aee877.png',154059,0,544,544),
    ('android\\0655e07d6717847489cd222c9c9e0b1d.png',53764,0,500,500),
    ('android\\079c4cb46c95b2365b5bc5150e7d5213.png',86996,0,544,544),
    ('android\\07a4dc9b4b207cb420a71cbf941ad45a.png',46270,0,544,544),
    ('android\\07abb7972a5638b53afa3b5eb98b19c1.png',43360,0,500,500),
    ('android\\0951ef0be68f0c498ca34ffcd7fc7faa.png',175842,0,544,544),
    ('android\\0f3bf63796ac370a08ee97b056b0587b.png',178849,0,544,544),
    ('android\\0f74322f762579e6cb2ece6a3d4bbe85.png',341813,0,544,544),
    ('android\\0ff7cf7bff05bcd33ba289f9a7bc63a1.png',126504,0,544,544),
    ('android\\12284e5f7197d8be737fa967c8b00fbe.png',829338,0,544,544),
    ('android\\12a9ef9dbf5f285605b152daa02da0d2.png',80766,0,492,537),
    ('android\\131bf95e2a7caba49141cb6a88437329.png',95992,0,544,544),
    ('android\\136915347caf7a4cc9a62976906070ae.png',363255,0,544,544),
    ('android\\13ae46802eebaee530d4521d3da438c1.png',171522,0,544,544),
    ('android\\17804890ee0c1002cac0f1d2bab5a9f5.png',75520,0,544,544),
    ('android\\1846b75d02542e35b344cc9f15bebc65.png',53764,0,500,500),
    ('android\\1884300e67d236ab355998d0a498e040.png',223639,0,544,544),
    ('android\\19092dfb52149bbeaa9f574f685a8da9.png',147129,0,544,544),
    ('android\\1bf57b1af31865ac8879bbb269e44651.png',63060,0,500,500),
    ('android\\1c03d41265e586b7c65f391a0fe5da89.png',70726,0,544,544),
    ('android\\1c938a729281b585e472819708d4dd28.png',46270,0,544,544),
    ('android\\1cff06008539e275cd0dabc18cfc7bb8.png',319730,0,544,544),
    ('android\\1ee55d427fb835032efb10c6b9ce051e.png',68261,0,544,544),
    ('android\\1f767fe4f3022ff878a269fc91f87243.png',208682,0,544,544),
    ('android\\2073630c7664248142c338ccdb0234a2.png',162484,0,544,544),
    ('android\\209de5f997821ece504f7ac96fd140f5.png',208682,0,544,544),
    ('android\\22c312ae4f29dd17e1a4ef7bbe88d9c4.png',196615,0,544,544),
    ('android\\23b14584bfcfc9a58ce9ce07004933ee.png',147129,0,544,544),
    ('android\\2405587c737713a362909c7a9388b356.png',43360,0,500,500),
    ('android\\2415f775345f1d925b2bdd57d156340c.png',80766,0,492,537),
    ('android\\252b49270e81fb27790c9964e06dc52c.png',341813,0,544,544),
    ('android\\260ac773c4bec0c5cc9968db40e07e32.png',183671,0,544,544),
    ('android\\2840059d78a228aec1dcf144c31aa018.png',154059,0,544,544),
    ('android\\29c04788f0dd59b0a93e9164bcc62ccc.png',53764,0,500,500),
    ('android\\2c482e37490b79daeadbbb8c9444dbc0.png',13794,0,130,130),
    ('android\\2d736bf2d83bb79074772615f233c534.png',13794,0,130,130),
    ('android\\2fbf313517d262255bdb412a66ff1942.png',60039,0,500,500),
    ('android\\300c6156cdcce992238145f31329e70a.png',80766,0,492,537),
    ('android\\305f91b6d7d782214c4c645692fcadcc.png',156162,0,544,544),
    ('android\\31b9f4c043369670f2660e25da3e6ba5.png',66135,0,544,544),
    ('android\\31c2a153abec3f24c7334f498a527b4c.png',43641,0,500,500),
    ('android\\3213e3421443c33e471f9a649c47ed4f.png',13794,0,130,130),
    ('android\\3219c6d372892c19f6395aacb0507bac.png',117630,0,544,544),
    ('android\\33bb2ecd80b0c230c056c45ae176e579.png',158277,0,545,543),
    ('android\\3493c31191e877a2371924d69b931bf3.png',184443,0,544,544),
    ('android\\34c44a8d2cf5f38a430b65e13c0b9053.png',68261,0,544,544),
    ('android\\35d689ab3105afd740be05be0b090e22.png',175842,0,544,544),
    ('android\\3602c670a09d83bf424ef6b7dd0c07af.png',175842,0,544,544),
    ('android\\362d8774eca6054c2cf11ffde12760f9.png',100310,0,544,544),
    ('android\\36f6b8b6ce40a0b200d2ea59cd15262c.png',58971,0,544,544),
    ('android\\3a01bac526ea531162018223ee8f46f4.png',63060,0,500,500),
    ('android\\3b0ba40a5d2c6f1cd84749340f1d39fd.png',208682,0,544,544),
    ('android\\3c1e5e434af813b3b5c929d7b3d464cc.png',223639,0,544,544),
    ('android\\3c902e275861d34b74b1de6c3989b660.png',93736,0,544,544),
    ('android\\3d326f758984199ab50f4d6442740547.png',93331,0,544,544),
    ('android\\3de3f46b6bf483964651fa67471c31d0.png',225147,0,544,544),
    ('android\\3df70686240a9ad119889fc5f757c765.png',99812,0,544,544),
    ('android\\3ecec1f812b12717f19c6b5e5ad02455.png',60924,0,544,544),
    ('android\\3f701612ffab852e7f19e25b8233d019.png',60924,0,544,544),
    ('android\\4078201c7f251aec97188026a85976cc.png',184443,0,544,544),
    ('android\\40964f881d20d00a3bf1579f3aee35df.png',208682,0,544,544),
    ('android\\418d235a65b49e4c5518a39467fac2ab.png',107488,0,544,544),
    ('android\\45ba91cf6d97abdbe56b86e01d5121f1.png',203565,0,544,544),
    ('android\\470b03847f9e7c8dbc666f4f555efd5c.png',203565,0,544,544),
    ('android\\4b4e7e5f8b2a88cbc677a4776f6d9b05.png',194276,0,500,500),
    ('android\\4f59a987976369de290db8e7ab22963e.png',117630,0,544,544),
    ('android\\511809679b53c2a96456497d7555d5aa.png',60039,0,500,500),
    ('android\\525a9e4846d1578a9085d620683bc8bf.png',53764,0,500,500),
    ('android\\536fb858dc04cbd77fdd19f57b861260.png',138810,0,544,544),
    ('android\\55f61863900718e909e7df5467bb3c7c.png',171008,0,544,544),
    ('android\\5831f2b33870f76c83ef63844441d510.png',183671,0,544,544),
    ('android\\594665add495ac9da8b6bbee1c63f1b8.png',598974,0,544,544),
    ('android\\5a7978fc9760107b2b0d9ca7db1039b4.png',319730,0,544,544),
    ('android\\5b16bb9db4ca1f67065b085c0384338d.png',155472,0,544,544),
    ('android\\5b4c3ce5657091602a1d479053f096b5.png',100310,0,544,544),
    ('android\\5bcb10e317b8ebfa6453d38f64bc28af.png',225147,0,544,544),
    ('android\\5bff784d1e71aef5dd77410aa7741da2.png',204633,0,544,544),
    ('android\\60ab20c6eb0be02a45571cb89e0ed057.png',53601,0,500,500),
    ('android\\613f2b8f0eaa8f63bedce9781527c9ab.png',4001,0,140,140),
    ('android\\625dbabe7747887597ff4ac1aa52cb20.png',183671,0,544,544),
    ('android\\626a2300839624271392301270b1aecb.png',184443,0,544,544),
    ('android\\644f01ef94313a66580d9d6c23d53077.png',194276,0,500,500),
    ('android\\64be5bec8d6d68610dc160afbe05e784.png',99812,0,544,544),
    ('android\\65340a6e83f36b899f98e01e88faca19.png',225147,0,544,544),
    ('android\\673c25fcc5ca89869044f96fe9da7261.png',99812,0,544,544),
    ('android\\677ba00ce4896465a0a30b34f405bc8e.png',61170,0,500,500),
    ('android\\691de4244eab1d3af57ff3463e833ff1.png',48598,0,500,500),
    ('android\\6927eef7b3e80c5529fbc93b9841f330.png',196615,0,544,544),
    ('android\\6ae879d5341e30b2cc64cfa324ffc202.png',204633,0,544,544),
    ('android\\6baad5a0b550c141dfb545351ff80407.png',107019,0,544,544),
    ('android\\6db13ba02a137de55da787b10f9601e5.png',55998,0,544,544),
    ('android\\6dbb69c7754f89b9db557612f7af6626.png',341813,0,544,544),
    ('android\\717c527b769e63eea362991f730657e7.png',60924,0,544,544),
    ('android\\71e89aa6150186fe8f7f5a156e9688dd.png',80766,0,492,537),
    ('android\\725629d7e89d052db0c3d0bcd8262e79.png',196615,0,544,544),
    ('android\\727abbd422f528bce31b14b6ef2d1a9e.png',117630,0,544,544),
    ('android\\7486160bb6dd580712d5c0103e2a34ee.png',158277,0,545,543),
    ('android\\74ea6e95030e60698db8793eb618beb7.png',75520,0,544,544),
    ('android\\7737520f63b9e92ddf4187a9896d45f0.png',194276,0,500,500),
    ('android\\77d784be7c22ea9253dae10ebc1fdab7.png',154059,0,544,544),
    ('android\\77dee819a585cf99256bc123b3f46b20.png',147129,0,544,544),
    ('android\\78764a69368ff97c870e2aab89252dd9.png',162484,0,544,544),
    ('android\\7cc97458727e23f7d161b8a1a7c6b453.png',559420,0,544,544),
    ('android\\7ee0bafa34e15ad6df77f610db54a64b.png',93736,0,544,544),
    ('android\\8046b86fc28b792ee49e741c8f7e04e1.png',87864,0,544,544),
    ('android\\804ca6bd84f95c4eabb42314c0e034ba.png',156162,0,544,544),
    ('android\\83a311ea9e28049e4e68d74015036182.png',147129,0,544,544),
    ('android\\83a4b2b8ef3335f4cfb4e483674ac504.png',194276,0,500,500),
    ('android\\83ab38456549a43286317ddec5996509.png',68190,0,500,500),
    ('android\\85bea92634944f59938fac71cd334b37.png',55998,0,544,544),
    ('android\\85f2e269722a6ce20da838ad1de1663c.png',204633,0,544,544),
    ('android\\867ba7e3584cfe94fc42e47734aa53f6.png',183671,0,544,544),
    ('android\\89d284081076b374a42e24700b351a2f.png',48598,0,500,500),
    ('android\\8a11d27d58f4c1fa4488cf39fdf68e76.png',126504,0,544,544),
    ('android\\8cb3dfe36bb922f613695c1a165d65cd.png',46544,0,500,500),
    ('android\\90ac037091be988ef81a4126423b8c4a.png',363255,0,544,544),
    ('android\\91deed361fad38a026cb0c8ec3969624.png',32459,0,349,350),
    ('android\\9394ea193bbbd0be4bf8463bef32ec37.png',156162,0,544,544),
    ('android\\94b5c41232f9761403890c09c2b1aae3.png',4001,0,140,140),
    ('android\\95377140447ed00df57e59a889832842.png',196615,0,544,544),
    ('android\\95a410197316a991ece3bb1ea4b7fb9d.png',208682,0,544,544),
    ('android\\97907ecb7714ef0044e7367260d8db37.png',184443,0,544,544),
    ('android\\997b9d866ef53672b193e58f1c6633b1.png',60039,0,500,500),
    ('android\\99a2184acbd9ec442be6358beea6b21a.png',180828,0,544,544),
    ('android\\9a71d8737bce1b0636f6aa5e022e73bc.png',86996,0,544,544),
    ('android\\9afbcbf212ca3d584256b132fcfea010.png',204633,0,544,544),
    ('android\\a38a0d84ad15b8ab5d939d518ada1a37.png',53601,0,500,500),
    ('android\\a657a7c96d1a2421a93a219af4b65e1c.png',180828,0,544,544),
    ('android\\a717abc64d23307fa85eda210fc8f61b.png',68190,0,500,500),
    ('android\\a72e0c5090a567e138b13535da7d53b1.png',158277,0,545,543),
    ('android\\a802906b74d632c89ed750d6115751e5.png',178849,0,544,544),
    ('android\\ab1adf5570e3f9b8eb6c9fc637fb7838.png',93331,0,544,544),
    ('android\\ac1e5f4f4e0e100ce252c4241c6f29af.png',46270,0,544,544),
    ('android\\acd3c956ca0ba760cf7326d387e15eb2.png',155472,0,544,544),
    ('android\\b043328c78c0c791bb94374a9c077387.png',203565,0,544,544),
    ('android\\b2e2b6f10ada24893ee95008cf8d7e4b.png',180828,0,544,544),
    ('android\\b59df7564ab38266c1ac78b03b5ea9f9.png',66135,0,544,544),
    ('android\\b5cef9abfc7429e83140afccc1bca111.png',117630,0,544,544),
    ('android\\b5e3c91f35c055293981d3352a21381e.png',80766,0,492,537),
    ('android\\b73ad72c6645f2f41ea6646170cc5d4d.png',93331,0,544,544),
    ('android\\b9a07892052f0f6f9be04bc53abdbb7b.png',61170,0,500,500),
    ('android\\ba3080ca9ed155df90dc33cac0104dc6.png',51350,0,500,500),
    ('android\\ba321a377c1ed90aa0eb54089da5d152.png',203565,0,544,544),
    ('android\\ba421e1ecac8e0195e402700d5081f06.png',70726,0,544,544),
    ('android\\ba63bf19a5dc037d44ca7930f417d39b.png',63060,0,500,500),
    ('android\\bae53dbfddd62617b5eeb68653f931b5.png',100310,0,544,544),
    ('android\\bb095ab012395896ae0231d00a565d36.png',93736,0,544,544),
    ('android\\bd57b77992593d97cbd87b678c540975.png',138810,0,544,544),
    ('android\\bd729c09e221b9e6792841ec7e5d8ff9.png',58971,0,544,544),
    ('android\\bda9f659d64beba3362724b624336c0e.png',68190,0,500,500),
    ('android\\bdfe1e5289ac9c628b0c489ef282a1de.png',223639,0,544,544),
    ('android\\bdff76ec38f779b76b04fac74a012f5d.png',138810,0,544,544),
    ('android\\bf9145cf5e2542fe92a8c949ce447be9.png',107019,0,544,544),
    ('android\\c0645347065368730de18f03f190c6c7.png',48598,0,500,500),
    ('android\\c08db1a7446eb52f0e5b8e4a5357df5a.png',138810,0,544,544),
    ('android\\c0af15cabc6ca4f3dc524730175369f3.png',80766,0,492,537),
    ('android\\c261dc6d880884188383728b702098f2.png',53601,0,500,500),
    ('android\\c3af376135a7abe0655c908195b271db.png',107488,0,544,544),
    ('android\\c66401d5101418ccd45912316b96cc69.png',100310,0,544,544),
    ('android\\c67929cf6d71b16261e1c879a1f7ccb3.png',43641,0,500,500),
    ('android\\c6f87600d8be6fd4d7f8a41001dfb28f.png',68261,0,544,544),
    ('android\\c8785cf74ebccf07bcd21c8ba8f4f869.png',95992,0,544,544),
    ('android\\c8ca37553ea133d94670855199bca614.png',223639,0,544,544),
    ('android\\ca0c4da752fb7002c9aed780036bee63.png',60039,0,500,500),
    ('android\\cbb1524f5ab4266698f3a6fc2992ccae.png',829338,0,544,544),
    ('android\\cd20e5ec5db961046dee2108c91a22ba.png',171522,0,544,544),
    ('android\\d0874dd978bd02380622315c77a7dbc2.png',13794,0,130,130),
    ('android\\d0d1ed389ed4c57f39161e51e109566a.png',63060,0,500,500),
    ('android\\d2263497d3e66a43dceee96a46683766.png',341813,0,544,544),
    ('android\\d3fd676f224f0734beb48d0c0d2f4e66.png',4001,0,140,140),
    ('android\\d4cb57efc75b804b48b7b56cad42b7cd.png',70726,0,544,544),
    ('android\\d52539b1b508a594d1f2865037ff50c5.png',598974,0,544,544),
    ('android\\d526ab9d08a51ae1bfe6a73c7442af3a.png',48598,0,500,500),
    ('android\\d6171ded6dd230bfb6e76b203d4c089b.png',58971,0,544,544),
    ('android\\d9582479df68bd175d8059a3dfc49957.png',53601,0,500,500),
    ('android\\da28cf556566aec13bd360c942ee696e.png',86996,0,544,544),
    ('android\\db3e1624c23e0efb1fc23068f6c6e3c1.png',126504,0,544,544),
    ('android\\dd6ed65d5d46a62d270bc5e49747e41a.png',171008,0,544,544),
    ('android\\ddf97251e61899e372fc614b69b2c61c.png',70726,0,544,544),
    ('android\\dfe6bf09d00056e2a380cc328c9c9268.png',155472,0,544,544),
    ('android\\e28eae9aa29648a69f9dfabc336029a9.png',68190,0,500,500),
    ('android\\e7047e39b8a8231d429b2fa868ab44e3.png',363255,0,544,544),
    ('android\\e9df352159033368d96cace99c2770ae.png',87864,0,544,544),
    ('android\\eb855c69258f86f3ee3a492c0bceda0b.png',208682,0,544,544),
    ('android\\ec696ec9803911873d77502f2b068a05.png',46544,0,500,500),
    ('android\\efc8070545fc00fb291fc724f18f28e3.png',107488,0,544,544),
    ('android\\f01884798075eeb42f66a068c101ac12.png',107488,0,544,544),
    ('android\\f07ddfe5a103e4a024e14e2569f1d70e.png',829338,0,544,544),
    ('android\\f0d1e7713d5557a8f9c74c9904843e09.png',559420,0,544,544),
    ('android\\f1229dbb6ca94d18ada5453e4e84d7a8.png',194276,0,500,500),
    ('android\\f593dab6a21907dec2dfed6ffc39b7e4.png',194276,0,500,500),
    ('android\\f65891689556606f466866ba61b28e51.png',107019,0,544,544),
    ('android\\fc872207b13acd4852ffbcc2632f1e09.png',32459,0,349,350),
    ('android\\ff63331ac8448bf3d5868c73181f1e34.png',51350,0,500,500),
    ('bg.png',688207,0,630,354),
    ('BGgvAyaxjEgrKToL.jpg',31685,1,337,554),
    ('dQXbnTRjUdNxhiyl.jpg',47714,1,640,520),
    ('ecNKedygCmSjTWWF.jpg',180075,1,700,1352),
    ('express.png',146065,0,1063,526),
    ('FbyullXPMdUgisRw.jpg',106881,1,724,1024),
    ('gtQiXnRfkvvTLinw.jpg',771187,1,2880,2025),
    ('HXqqASHJETSlvpnc.jpg',329492,1,3600,2400),
    ('HXqqASHJETSlvpnc1.jpg',59511,1,1024,768),
    ('ibvPAvQMVcVPypIW.jpg',54844,1,500,768),
    ('ITbczQcJFtxbWXsf.jpg',43637,1,480,800),
    ('jRfgXToTreAKRNiy.png',26369,0,1136,410),
    ('JsXHWmKqOlziKmeA.jpg',129866,1,378,300),
    ('kceytNtHmWmoGuEy.jpg',88096,1,520,711),
    ('klvPBjuakWwSKXXR.jpg',517146,1,827,1169),
    ('knGTBfIoqrnblwbg.jpg',33324,1,440,537),
    ('logo\\Activity.jpg',33214,1,300,200),
    ('logo\\android\\Android关于Canvas你所知道的和不知道的一切.png',178940,0,611,268),
    ('logo\\android\\Android关于Paint你所知道的和不知道的一切.png',66398,0,553,254),
    ('logo\\android\\Android关于Path你所知道的和不知道的一切.png',111035,0,625,171),
    ('logo\\android\\Android原生下载（上篇）基本逻辑+断点续传.png',21597,0,422,100),
    ('logo\\android\\Android原生下载（下篇）多文件下载+多线程下载.png',290892,0,540,495),
    ('logo\\android\\Android原生绘图之一起画个表.png',128371,0,511,505),
    ('logo\\android\\Android原生绘图之炫酷倒计时.png',148600,0,644,189),
    ('logo\\android\\Android原生绘图之让你了解View的运动.png',28683,0,277,215),
    ('logo\\android\\Android原生绘图进度条+简单自定义属性代码生成器.png',39700,0,667,265),
    ('logo\\android\\Android粒子篇之Bitmap像素级操作.png',302329,0,655,370),
    ('logo\\BroadcastReceiver.jpg',37552,1,300,200),
    ('logo\\ContentProvider.jpg',35889,1,300,200),
    ('logo\\database.jpg',11861,1,150,150),
    ('logo\\head.jpg',51922,1,1023,682),
    ('logo\\head.png',47031,0,150,150),
    ('logo\\java.jpg',37630,1,200,200),
    ('logo\\logo-50.png',26035,0,90,50),
    ('logo\\logo-text-50.png',18296,0,50,30),
    ('logo\\logo-text.png',52152,0,759,460),
    ('logo\\logo.png',124508,0,829,460),
    ('logo\\me.png',21070,0,50,50),
    ('logo\\python.jpg',19732,1,200,200),
    ('logo\\Service.jpg',32928,1,300,200),
    ('logo\\前端三剑.png',68446,0,200,200),
    ('MkoMoBpPaWrnyhPW.jpg',16247,1,425,240),
    ('myfile-1533692099160.jpg',59511,1,1024,768),
    ('NalGguFUuFicfBqP.jpg',111176,1,302,302),
    ('NBdIaiGwlREyfGBS.jpg',75739,1,300,600),
    ('ndbMXlwKuCpiiVqC.jpg',161241,1,1701,2268),
    ('nDIOWvyAadpUzNBE.jpg',203741,1,700,984),
    ('okvRGxzWABIRfQev.png',35576,0,1072,566),
    ('oQttHzCOUqeOatEH.jpg',94888,1,679,960),
    ('poem\\世界·绽放.jpg',234604,1,1148,712),
    ('poem\\我爱你，是火山岩的缄默.jpg',42307,1,690,397),
    ('poem\\枝·你是树的狂舞.jpg',31973,1,500,333),
    ('poem\\海与鹿王.jpg',194231,1,799,499),
    ('poem\\游梦人·诗的诞生.jpg',196012,1,800,444),
    ('poem\\珊瑚墓地.jpg',984472,1,1104,719),
    ('pxTVCPjJmQSmAaEa.jpg',58221,1,565,800),
    ('RfhDAbOybWlPmuUo.jpg',35468,1,500,707),
    ('screen.png',103901,0,1080,1920),
    ('sea.jpg',83603,1,1024,640),
    ('TBVuDWTIEMOhFxUw.jpg',22097,1,236,254),
    ('timg (1).jpg',29045,1,450,451),
    ('timg (2).jpg',162919,1,1196,788),
    ('timg (3).jpg',36960,1,500,327),
    ('timg (4).jpg',115181,1,1200,837),
    ('timg (5).jpg',29002,1,450,450),
    ('timg (6).jpg',125295,1,1024,687),
    ('timg (7).jpg',25505,1,600,306),
    ('timg.jpg',28934,1,350,447),
    ('udp发送与接收消息_控制台.png',9184,0,609,123),
    ('up.png',134478,0,799,443),
    ('UqDTXLFzlsAOgGOD.jpg',35577,1,482,624),
    ('VLeeUxBNGCSbwkHP.png',413234,0,375,600),
    ('WHhHgUqaXEblAnfg.jpg',233664,1,687,690),
    ('xMCPIxxQfbfyMSVk.jpg',258602,1,537,747),
    ('XoazFNMQROveEPQn.jpg',795364,1,1280,800),
    ('XQWGrglfjGVuJfzJ.jpg',270741,1,1200,1696),
    ('ywUTicdrCBfqhskf.jpg',69705,1,716,698),
    ('zSCdVsWWfvSxoGgv.jpg',64102,1,540,800),
    ('共享变量可见性.png',24556,0,622,314),
    ('可达性分析.png',41434,0,804,414),
    ('复制算法.png',37083,0,1196,663),
    ('对象的访问定位.png',32182,0,748,380),
    ('服务器通过响应传递数据.png',31042,0,723,315),
    ('标记整理.png',29288,0,894,445),
    ('洛天依.jpg',42117,1,500,417),
    ('统一返回.png',29485,0,889,393),
    ('虚拟机栈.png',63723,0,1208,493);
    复制代码

[Link 1]: https://juejin.im/post/5c2881c95188252b5627475b
[-_-File-]: https://juejin.im/post/5c641130f265da2deb6a8d55