在数据里存取图片

 

//PicStore

import java.io.File;
import java.io.FileInputStream;
import java.sql.*;

public class PicStore {
 

 Connection con;
 String driver;
 String url;
 String username;
 String password;
 
 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 void storePic(String id, File file){
  
  
  try {
   Class.forName(driver);
   con=DriverManager.getConnection(url,username,password);
   FileInputStream is=new FileInputStream(file);
   
   PreparedStatement pstmt=con.prepareStatement("insert into userpic values(?,?)");
   pstmt.setString(1, id);
   pstmt.setBinaryStream(2, is,is.available());
   pstmt.executeUpdate();
   
  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  
  
 }
}
//PicStoreTest

import java.io.File;

public class PicStoreTest {

 
  public static void main(String[] args){
   PicStore s = new PicStore();
   s.setDriver("org.gjt.mm.mysql.Driver");
   s.setUrl("jdbc:mysql://localhost:3306/doordoor");
  
   s.setUsername("root");
   s.setPassword("root");
  
   s.setCon();
   File f = new File("c:/1.gif");
   s.storePic("as", f);
  
  }
}