从数据库中获取图片

 

//PicGet.java

import java.sql.*;

public class PicGet {
 Connection con;
 String driver;
 String url;
 String username;
 String password;
 ResultSet rs;
 
 public Connection getCon() {
  return con;
 }
 public void setCon() {
 }
 public String getDriver() {
  return driver;
 }
 public void setDriver(String driver) {
  this.driver = driver;
 }
 public String getUrl() {
  return url;
 }
 public void setUrl(String url) {
  this.url = url;
 }
 public String getUsername() {
  return username;
 }
 public void setUsername(String username) {
  this.username = username;
 }
 public String getPassword() {
  return password;
 }
 public void setPassword(String password) {
  this.password = password;
 }
 public ResultSet getRs() {
  return rs;
 }
 public void setRs(ResultSet rs) {
  this.rs = rs;
 }
 public void setRs(String id){
  try {
  Statement stmt=con.createStatement();
  rs=stmt.executeQuery("select * from userpic where id='"+id+"'");
  
  rs.next();
  
 } catch (SQLException e) {
  // TODO Auto-generated catch block
  System.out.println("数据载入有误");
 }
 
 
 }
}
 

//PicGetTest.java

import java.io.BufferedOutputStream;
import java.io.File;
import java.io.InputStream;
import java.sql.ResultSet;

public class PicGetTest {

 /**
  * @param args
  */
 public static void main(String[] args) {
  
   PicGet s=new PicGet();
  
   s.setDriver("org.gjt.mm.mysql.Driver");
   s.setUrl("jdbc:mysql://localhost:3306/doordoor");
  
   s.setUsername("root");
   s.setPassword("root");
   s.setCon();
   s.setRs("as");
  
   ResultSet rs=s.getRs();
  
   try{
   InputStream is=rs.getBinaryStream("pic");
   byte[] buf=new byte[4000];
   int len=0;
  
   File f = new File("c:/2.gif");
   java.io.FileOutputStream outs=new java.io.FileOutputStream(f);
  
   BufferedOutputStream output=new BufferedOutputStream(outs);
   while((len=is.read(buf,0,4096))!=-1){
   
    output.write(buf, 0, len);
   
   }
   if(is!=null){
   is.close();
   }
   if(output!=null){
   output.close();
   }
   }catch(Exception e){
   //e.printStackTrace();
    System.out.println("获取数据异常");
   }

 }

}