個人所有文章整理在此篇，將陸續更新收錄:知無涯，行者之路莫言終（我的程式設計之路）
本文聚焦
好了，又到了玩字串的時間了，先講一下本文要務
將一個資料夾裡的圖片歸整一下,生成一個插入的sql語句，然後cv一下，插入資料庫
![[番外]-練習MySQL沒素材？來一波字串操作](https://i.iter01.com/images/6badf1483cbe3cfde526fef377f8e8e2ab6fa9c158369850e47436a4a7363c83.png)
|-- 先確定一下幾個欄位：
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-]
先列印下目錄樹，以表敬意
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);
複製程式碼