readpic.java

java在oracle数据库中存取图片

package picture;

import java.awt.Container;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.ImageIcon;
import javax.swing.JFrame;
import javax.swing.JLabel;


class  ReadPic  extends JFrame{
	
	public ReadPic(){
		try{
			/*
			 * 建立数据库的连接
			 */
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:zgydb","jenny","888888");
			Statement stmt = conn.createStatement();
			/*
			 *执行数据查询语句
			 */
			ResultSet rs = stmt.executeQuery("select * from images");
			rs.next();
			/*
			 * 获取读取到的信息
			 */
			//String name = rs.getString(1);
			int length = rs.getInt(2);
			InputStream is = rs.getBinaryStream(3);	//准备字节流
			
			byte[] b = new byte[length];
			is.read(b);  //读取字节信息
			/*
			 * 显示图片
			 */
			ImageIcon icon = new ImageIcon(b);				
			Container cont = this.getContentPane();
			JLabel label = new JLabel(icon);			
			cont.add(label);
			this.setSize(300,200);
			this.setLocation(300,300);
			this.validate();
		}catch(Exception e){
			System.out.println("wrong!");
		}		
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		this.setVisible(true);
	}
	
	public static void main(String args[]){
		new ReadPic();	
	}
}