java 二进制 数据库_java如何将图片以2进制的形式存入数据库

存入图片

import java.sql.*;

import java.io.*;

public class InsertImg

{

public static void main(String args[])

{

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:DBImg");

String sql = "insert into DBImg (image) values (?)";

PreparedStatement pstmt=con.prepareStatement(sql);

FileInputStream fi=new FileInputStream("./room.jpg");

pstmt.setBinaryStream(1,fi,fi.available());

pstmt.execute();

fi.close();

pstmt.close();

con.close();

}catch(Exception e){System.out.println(e.getMessage());}

}

}

把图片取出输出到文件

import java.io.*;

import java.sql.*;

public class ImgRead

{

public static void main(String args[])

{

try

{

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

String url="jdbc:microsoft:sqlserver://BILLGATES:1433";

Connection cn=DriverManager.getConnection(url,"sa","8310");

Statement st=cn.createStatement();

String str = "select img from test where id=1";

ResultSet rs=st.executeQuery(str);

rs.next();

InputStream in=rs.getBinaryStream(1);

FileOutputStream file = new FileOutputStream("./88.mp3");

byte c[] = new byte[1024];

int r = 0;

while ((r = in.read(c)) != -1){

file.write(c,0,r);

}

file.close();

in.close();

}

catch(Exception e)

{

e.printStackTrace();

}

}

}

把图片输出到JLabel控件

import java.awt.*;

import java.applet.*;

import java.awt.image.BufferedImage;

import com.sun.image.codec.jpeg.*;

import javax.swing.*;

import java.sql.*;

import java.io.*;

public class DisplayImg

{

public DisplayImg(){

Image img=null;

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:DBImg");

Statement stmt=con.createStatement();

String sql = "select image from DBImg";

ResultSet rs=stmt.executeQuery(sql);

rs.next();

InputStream in = rs.getBinaryStream(1);

JPEGImageDecoder decoder = JPEGCodec.createJPEGDecoder(in);

img=decoder.decodeAsBufferedImage();

rs.close();

con.close();

}catch(Exception e){System.out.println(e.getMessage());}

JFrame f=new JFrame();

JLabel label=new JLabel();

ImageIcon icon=new ImageIcon(img);

label.setIcon(icon);

JScrollPane jsp=new JScrollPane(label);

Container content=f.getContentPane();

content.add(jsp);

f.setSize(535,400);

f.setVisible(true);

}

public static void main(String args[]){

DisplayImg di=new DisplayImg();

}

}

上面的程序数据库驱动不一致,自行修改一下.其中在Sqlserver中要存放图片的字段应选"image"类型