@Test
public void test1() throws Exception {
//new一个URL对象
URL url = new URL(“https://image-c.weimobwmc.com/saas-wxbiz/24a3bf23e3ec4ea99391e508c3955d27.jpg”);
//打开链接
HttpURLConnection conn = (HttpURLConnection)url.openConnection();
//设置请求方式为"GET"
conn.setRequestMethod(“GET”);
//超时响应时间为5秒
conn.setConnectTimeout(5 * 1000);
//通过输入流获取图片数据
InputStream inStream = conn.getInputStream();
//得到图片的二进制数据,以二进制封装得到数据,具有通用性
byte[] data = readInputStream(inStream);
String encode = encode(data);
System.out.println(encode);
String str="
<img src=“https://image-c.weimobwmc.com/saas-wxbiz/cae85447270049bca4c6029c852c0c92.jpg” data-width=“750” data-height=“836” /><img src=“https://image-c.weimobwmc.com/saas-wxbiz/8c495ef55e884e299d663975187ad71b.jpg” data-width=“750” data-height=“563” /><img src=“https://image-c.weimobwmc.com/saas-wxbiz/7705091cef864a4aae0afb04c5702009.jpg” data-width=“750” data-height=“460” /><img src=“https://image-c.weimobwmc.com/saas-wxbiz/f896c40900ea45078af6f358530a6d99.jpg” data-width=“750” data-height=“1779” /><img src=“https://image-c.weimobwmc.com/saas-wxbiz/2ba45e1a00a24c8c9ee45e4d8fd6f5dc.jpg” data-width=“750” data-height=“1390” /><img src=“https://image-c.weimobwmc.com/saas-wxbiz/e5cbaf61b93b4b6c9802b09e1530dc96.jpg” data-width=“750” data-height=“1960” /><img src=“https://image-c.weimobwmc.com/saas-wxbiz/c989dad996344cea89f5d47ef7c7eccc.jpg” data-width=“750” data-height=“658” />
String sql=“insert into goodsDesc (goods_no,goods_desc) "
+ " values (‘BS18WJ589’,’”+str+"’)";
Connection conn1 = JdbcUtil.JDBC();
Statement stemt = null;
stemt = conn1.createStatement();
stemt.execute(sql);
// //new一个文件对象用来保存图片,默认保存当前工程根目录
// File imageFile = new File(“D:/img/BS18WJ589Z956.jpg”);
// //创建输出流
// FileOutputStream outStream = new FileOutputStream(imageFile);
写入数据
// outStream.write(data);
// //关闭输出流
// outStream.close();
stemt.close();
}
public static byte[] readInputStream(InputStream inStream) throws Exception{
ByteArrayOutputStream outStream = new ByteArrayOutputStream();
//创建一个Buffer字符串
byte[] buffer = new byte[1024];
//每次读取的字符串长度,如果为-1,代表全部读取完毕
int len = 0;
//使用一个输入流从buffer里把数据读取出来
while( (len=inStream.read(buffer)) != -1 ){
//用输出流往buffer里写入数据,中间参数代表从哪个位置开始读,len代表读取的长度
outStream.write(buffer, 0, len);
}
//关闭输入流
inStream.close();
//把outStream里的数据写入内存
return outStream.toByteArray();
}
//JDK封装的有base64,可以直接使用
public static String encode(byte[] bytes) throws Exception {
return new Base64().encodeToString(bytes);
}
public static byte[] decode(String base64) throws Exception {
return new Base64().decode(base64);
}
//把图片以base64格式从数据库读取出来
@Test
public void test2() throws Exception {
Connection conn = JdbcUtil.JDBC();
String sql="select * from imageTable";
PreparedStatement ps = null;
ResultSet rs = null;
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()) {
String imageBlob=rs.getString("image_blob");
byte[] decode = decode(imageBlob);
//new一个文件对象用来保存图片,默认保存当前工程根目录
File imageFile = new File("D:/img/BS18WJ589Z956.jpg");
//创建输出流
FileOutputStream outStream = new FileOutputStream(imageFile);
// 写入数据
outStream.write(decode);
//关闭输出流
outStream.close();
System.out.println(decode);
}
}