java 图片导出_java-查询图片url导出到本地

public voidimport1() {/*** SELECT

* imc.id,imc.img_md5,imc.img_url,imc.thumb_width,imc.thumb_height

* ,imc.img_url_thumb,c.serial_number from img_center imc left join

* img_case c on imc.case_id=c.id where

* source_id='8310f5b97fe54a6495688263fa6ca928' and c.create_user =

* '2-2-1'

*

* SELECT

* imc.id,imc.img_md5,imc.img_url,imc.thumb_width,imc.thumb_height

* ,imc.img_url_thumb from img_center imc left join img_case c on

* imc.case_id=c.id where source_id='8310f5b97fe54a6495688263fa6ca928'

* and c.create_user='正常'

*

* SELECT

* imc.id,imc.img_md5,imc.img1024_url,imc.thumb_width,imc.thumb_height

* ,imc.img_url_thumb,c.img_info from img_center imc left join img_case

* c on imc.case_id=c.id where

* c.source_id='8310f5b97fe54a6495688263fa6ca928' and imc.img_md5

* in(SELECT img_md5 FROM tag_img WHERE

* type_id='740bc5fb849f451fad666dae1dcbb0f0' AND tag_json IS NOT NULL)*/

//TagImgFilter filter = new TagImgFilter();//filter.setEq_typeId("413f225ed6a745c2b88cfb5d6053fc1d");//filter.setNull_tagJson(false);//List> list = jdbcTemplate//.queryForList("SELECT t.img_md5,imc.img1024_url FROM tag_img t LEFT JOIN img_center imc ON t.img_md5=imc.img_md5 WHERE t.type_id='5d8f5f9aecb14e54aef64f55aec57b5b' and t.del_flag=1 and t.tag_flag=1 and imc.del_flag=1");

/*List> list = jdbcTemplate

.queryForList("SELECT t.id,imc.img1024_url FROM tag_img t LEFT JOIN img_center imc ON t.img_md5=imc.img_md5 WHERE type_id='5976d4dda1e141c181d3e7bdaba7ae9f' AND t.del_flag=1 AND t.img_md5 NOT IN (SELECT img_md5 FROM tag_img WHERE set_id='6f2b4c77fdab4137aeabda9282c0c597' AND del_flag=1)");*/List> list =jdbcTemplate

.queryForList("SELECT id,img_url FROM tag_img WHERE type_id='672497aee4a84a49b78a60b78602166e' and del_flag=1 and tag_flag=1");int i = 0;for (Maptagimg : list) {//String img1024Url = tagimg.get("img1024_url").toString();//获取img1024_url

String imgUrl = tagimg.get("img_url").toString();//String imgMD5 = tagimg.get("img_md5").toString();

String id = tagimg.get("id").toString();

i++;

System.out.println(i);//System.out.println(i+ "_" +imgMD5);

System.out.println(imgUrl);

String path= "D:/downloadjpg/yang";//String localPath = path + "/" + imgMD5 + ".jpg";//String localPath = path + "/" + i + "_" +imgMD5 + ".jpg";

String localPath = path + "/" + id +".jpg";//fastdfsService.copyFileFromDfs(img1024Url, localPath);

fastdfsService.copyFileFromDfs(imgUrl, localPath);

}