package?org.pic;

import?java.io.File;
import?java.io.FileInputStream;
import?java.io.FileNotFoundException;
import?java.io.FileOutputStream;
import?java.io.IOException;
import?java.io.InputStream;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

import?sun.misc.base64Decoder;
import?sun.misc.base64Encoder;

public?class?SavePic?{
	public?static?Connection?conn?=?null;
	public?static?PreparedStatement?pStmt?=?null;

	/**
	?*?數據庫中加入圖片等文件
	?*/
	public?static?void?InsertPic（）?{
		String?sql?=?“insert?into?TEACHER（IDNAMEPHOTObase64PHOTO）?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?IDNAMEPHOTObase64PHOTO?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（））?{
				System.out.println（“ssssssssss“）;
				//獲取圖片字段
//				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.pr

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????457??2018-12-13?14:43??Total\.classpath

?????文件????????381??2018-11-29?16:22??Total\.project

?????文件????????598??2018-11-29?16:22??Total\.settings\org.eclipse.jdt.core.prefs

?????文件???????5035??2018-12-13?17:02??Total\bin\org\pic\SavePic.class

?????文件????5369934??2018-08-10?09:13??Total\bin\pic.jpg

?????文件????2111220??2018-12-13?11:01??Total\lib\ojdbc6.jar

?????文件???????3971??2018-12-13?17:02??Total\src\org\pic\SavePic.java

?????文件??????24535??2018-12-13?11:59??Total\src\pic.jpg

?????目錄??????????0??2018-12-13?14:43??Total\bin\org\pic

?????目錄??????????0??2018-12-13?17:02??Total\src\org\pic

?????目錄??????????0??2018-12-13?17:02??Total\bin\org

?????目錄??????????0??2018-12-13?17:02??Total\src\org

?????目錄??????????0??2018-11-29?16:22??Total\.settings

?????目錄??????????0??2018-12-13?17:02??Total\bin

?????目錄??????????0??2018-12-13?11:01??Total\lib

?????目錄??????????0??2018-12-13?17:03??Total\src

?????目錄??????????0??2018-12-13?17:03??Total

-----------?---------??----------?-----??----

??????????????7516131????????????????????17