图片存储到cassandra数据库的方案
<p><strong>1、创建一个测试的CF</strong></p> <br /> <pre class="brush:sql; toolbar: true; auto-links: false;">create Column family ImagesFile with comparator=UTF8Type and default_validation_class=UTF8Type and key_validation_class=UTF8Type and column_metadata= [ {column_name: ImagesFileId , validation_class: UTF8Type,index_type: KEYS}, {column_name: FileName, validation_class: UTF8Type}, {column_name: FileByteDatas, validation_class: UTF8Type} ];</pre> <strong>2、服务端代码如下:<pre class="brush:java; toolbar: true; auto-links: false;">package com.reach.leekexi.cassandra.hecter; import java.awt.image.BufferedImage; import java.io.BufferedInputStream; import java.io.ByteArrayOutputStream; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.io.InputStream; import java.io.RandomAccessFile; import java.net.HttpURLConnection; import java.net.URL; import java.net.URLConnection; import java.util.HashMap; import java.util.Map; import javax.imageio.ImageIO; public class ImagesCassandraClient { public static String hosts = "192.168.1.20:9160"; public static String clusterName = "Test Cluster"; public static String keyspaceName = "CasImage"; public static String columnFamily = "ImagesFile"; @SuppressWarnings({ "rawtypes" }) public static void main(String[] args) { // 参数装载 CassandraParas ps = new CassandraParas(); ps.setHosts(hosts); // 注解数据 ps.setClusterName(clusterName);// 群集名称 ps.setKeyspaceName(keyspaceName);// 键空间 ps.setColumnFamily(columnFamily);// 列族 // cassandra客户端API接口实例 CassandraClient cc = new CassandraClient(ps); boolean inf = false;// 插入标记 String key = "1";// 插入的Key // 测试多个字段插入和读取 String[] columnNames = { "ImagesFileId", "FileName" }; String[] columnValues = { "1", "http://avatar.csdn.net/3/1/8/3_jemlee2002.jpg" }; inf = cc.insertMultiColumn(key, columnNames, columnValues); if (inf)// 如果插入成功则测试打印出来 { Map map = new HashMap(); map = cc.getMultiColumn(key, columnNames); for (int i = 0; i < map.size(); i++) System.out.println(columnNames[i] + " : " + map.get(columnNames[i])); } else { System.out.println("操作数据失败,CF=" + columnFamily); } //把图片存储到Cassandra数据库 String columnName = "FileByteDatas"; String columnValue = parserFileNet("http://avatar.csdn.net/3/1/8/3_jemlee2002.jpg","jpg"); inf = cc.insertOneColumn(key, columnName, columnValue); if (inf) { System.out.println(cc.getOneColumn(key, columnName)); } //把数据库的种的图片数据还原成图片 //如果在C盘下看到了和http://avatar.csdn.net/3/1/8/3_jemlee2002.jpg一个样的图片数据,证明数据处理成功。 columnValue = cc.getOneColumn(key, columnName); String localpath = "c:\\3_jemlee2002.jpg"; String type = "png"; boolean ref = revertImage(columnValue,localpath,type); if(ref) System.out.println("创建文件:" + localpath + " 成功."); else System.out.println("创建文件:" + localpath + " 失败."); } /** * 网络文件存储 * @param URLName 网络图片地址 * @param type 图片类型 * @return String 转换结果 * @throws */ public static String parserFileNet(String URLName,String type) { String res = null; try { int HttpResult = 0; // 服务器返回的状态 URL url = new URL(URLName); // 创建URL URLConnection urlconn = url.openConnection(); // 试图连接并取得返回状态码 urlconn.connect(); HttpURLConnection httpconn = (HttpURLConnection) urlconn; HttpResult = httpconn.getResponseCode(); System.out.println(HttpResult); if (HttpResult != HttpURLConnection.HTTP_OK) // 不等于HTTP_OK则连接不成功 System.out.print("fail"); else { BufferedInputStream bis = new BufferedInputStream(urlconn.getInputStream()); BufferedImage bm = ImageIO.read(bis); ByteArrayOutputStream bos = new ByteArrayOutputStream(); ImageIO.write(bm, type, bos); bos.flush(); byte[] data = bos.toByteArray(); res = byte2hex(data); bos.close(); } } catch (Exception e) { e.printStackTrace(); } return res; } /** * 本地文件存储 * @param filepath 本地文件路径 * @return String 转换结果 */ public static String parserFileLocal(String filepath) { File file = new File(filepath); byte[] bfile = new byte[10240]; String filestr = ""; try { InputStream a = new FileInputStream(file); a.read(bfile); filestr = byte2hex(bfile); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } return filestr; } /** * 把Cassandra数据库中的图片数据还原成图片 * @param data 生成图片的二进制字符串 * @param fileName 图片名称(完整路径) * @param type 图片类型 * @return */ public static boolean revertImage(String data, String fileName,String type) { BufferedImage image = new BufferedImage(300, 300,BufferedImage.TYPE_BYTE_BINARY); ByteArrayOutputStream byteOutputStream = new ByteArrayOutputStream(); boolean rf = false; try { ImageIO.write(image, type, byteOutputStream); byte[] bytes = hex2byte(data); RandomAccessFile file = new RandomAccessFile(fileName, "rw"); file.write(bytes); file.close(); rf = true; } catch (IOException e) { rf = false; e.printStackTrace(); } return rf; } /** * 二进制转字符串 * @param * @return */ public static String byte2hex(byte[] b) { String hs = ""; String stmp = ""; for (int n = 0; n < b.length; n++) { stmp = (java.lang.Integer.toHexString(b[n] & 0XFF)); if (stmp.length() == 1) hs = hs + "0" + stmp; else hs = hs + stmp; } return hs; } /** * 字符串转二进制 * @param str * @return */ public static byte[] hex2byte(String str) { if (str == null) return null; str = str.trim(); int len = str.length(); if (len == 0 || len % 2 == 1) return null; byte[] b = new byte[len / 2]; try { for (int i = 0; i < str.length(); i += 2) { b[i / 2] = (byte) Integer .decode("0x" + str.substring(i, i + 2)).intValue(); } return b; } catch (Exception e) { return null; } } }</pre></strong> <strong>3、总结<br /> 以上代码高效的实现图片(含网络上的和本地的)存储到Cassandra数据的过程。特别提出,该方案中,中间并不需要中间暂存图片到本地,而是直接从http协议上获取图片流数据,这样极大的提高图片的处理速度。</strong> <br /> <h1><span style="font-size:13px;">4、需要Cassandra操作API请到我的下载资源获取<br /> <br /> 来自:http://blog.csdn.net/jemlee2002/article/details/7211216</span></h1>
本文由用户 fmms 自行上传分享,仅供网友学习交流。所有权归原作者,若您的权利被侵害,请联系管理员。
转载本站原创文章,请注明出处,并保留原始链接、图片水印。
本站是一个以用户分享为主的开源技术平台,欢迎各类分享!