如何将图片BASE64加密保存到数据库BLOB类型中，并获取数据重新生成图片

怼烎@ 2022-04-08 11:43 490阅读 0赞

在实际项目运行中，我们需要将图片，world ,excel等信息保存到数据库，等需要用到的时候在从中读取出来，并使用。这些信息在oracle数据库中都保存在类型BLOB中，放入前可以进行信息的加密（BASE64）。

例如：oracle中新建表TEACHER![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1b3d3MQ_size_16_color_FFFFFF_t_70][]

Demo:

/**
    	 * 数据库中加入图片等文件
    	 */
    	public static void InsertPic() {
    		String sql = "insert into TEACHER(ID,NAME,PHOTO,BASE64PHOTO) values('1',?,?,?)";
    		try {
    			Class.forName("oracle.jdbc.driver.OracleDriver");
    			conn = DriverManager.getConnection(
    							"jdbc:oracle:thin:@//192.168.1.183:1521/orcl",
    							"LWW", "lww");
    			pStmt = conn.prepareStatement(sql);
    
    			pStmt.setString(1, "Lily");// 设置字段NAME值
    
    			// 数据库插入图片/word/excel等
    			File file = new File("src/pic.jpg");
    			FileInputStream fis = new FileInputStream(file);
    
    			//创建一个和文件大小一样的缓冲区
    			byte[] buffer = new byte[fis.available()];
    			fis.read(buffer);
    			pStmt.setBytes(2, buffer);//内容设置到字段PHOTO中
    			System.out.println("未加密图片长度："+fis.available());
    			
    			String base64 = new BASE64Encoder().encode(buffer);
    			
    			System.out.println("加密后图片长度：" +base64.length());
    			pStmt.setBytes(3, base64.getBytes());//内容设置到字段BASE64PHOTO中
    			int n = pStmt.executeUpdate();
    			System.out.println(n + "条记录插入");
    		} catch (SQLException e) {
    			e.printStackTrace();
    		} catch (ClassNotFoundException| IOException e) {
    			e.printStackTrace();
    		} finally {
    			try {
    				pStmt.close();
    			} catch (SQLException e) {
    				// TODO Auto-generated catch block
    				e.printStackTrace();
    			}
    			try {
    				conn.close();
    			} catch (SQLException e) {
    				// TODO Auto-generated catch block
    				e.printStackTrace();
    			}
    		}
    	}
    	/**
    	 * 从数据库中取出图片等文件
    	 */
    	public static void getPic() {
    		String sql = "select ID,NAME,PHOTO,BASE64PHOTO from TEACHER where ID=?";
    		try {
    			conn = DriverManager.getConnection(
    							"jdbc:oracle:thin:@//192.168.1.183:1521/orcl",
    							"LWW", "lww");
    			pStmt = conn.prepareStatement(sql);
    			pStmt.setString(1, "1");
    			ResultSet rs = pStmt.executeQuery();
    			if (rs.next()) {
    				//获取图片字段
    //				FileOutputStream fos = new FileOutputStream(new File("abc.jpg"));
    //				InputStream is = rs.getBinaryStream("photo");
    //
    //				byte[] buffer = new byte[4 * 1024];
    //				int length = 0;
    //				while ((length = is.read(buffer)) != -1) {
    //					fos.write(buffer, 0, length);
    //				}
    				
    				//获取图片加密字段内容，并进行base64解密
    				FileOutputStream fos = new FileOutputStream(new File("abcbase64.jpg"));
    				byte[] basebt = rs.getBytes("base64photo");
    				
    				System.out.println("加密：" +basebt.length);
    				byte[] by = new BASE64Decoder().decodeBuffer(new String(basebt));
    				System.out.println("解密：" +by.length);
    				fos.write(by, 0, by.length);			
    				fos.flush();
    				fos.close();
    //				is.close();
    			}
    
    		} catch (SQLException e) {
    			e.printStackTrace();
    		} catch (FileNotFoundException e) {
    			e.printStackTrace();
    		} catch (IOException e) {
    			e.printStackTrace();
    		} finally {
    			try {
    				pStmt.close();
    			} catch (SQLException e) {
    				// TODO Auto-generated catch block
    				e.printStackTrace();
    			}
    			try {
    				conn.close();
    			} catch (SQLException e) {
    				// TODO Auto-generated catch block
    				e.printStackTrace();
    			}
    		}
    	}

完整Demo下载:[https://download.csdn.net/download/luoww1/10848498][https_download.csdn.net_download_luoww1_10848498] (支持oracle)

[https://download.csdn.net/download/luoww1/10859333][https_download.csdn.net_download_luoww1_10859333] （支持mysql,oracle,sqlserver）

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1b3d3MQ_size_16_color_FFFFFF_t_70]: /images/20220405/f7ffc238cd2c40559a18cc065f42460f.png
[https_download.csdn.net_download_luoww1_10848498]: https://download.csdn.net/download/luoww1/10848498
[https_download.csdn.net_download_luoww1_10859333]: https://download.csdn.net/download/luoww1/10859333