从数据库(mysql)存取图片

2008-09-04 10:26:10|  分类： 默认分类 |  标签：mysql  图片  存取  jsp   |字号大中小 订阅

为了使用JSP灵活，需要把各种文件储存到数据库中，然后需要的时候把它读取出来显示到客户端。这些文件包括音乐，图片，文本等，人们统称为二进制文件。 首先，二进制文件储存到数据库的过程：打开文件，将内容读到缓冲区，然后直接联线创建jdbc语句对象，使用该缓冲区的数据，并执行更新，就完成了储存。 例子：      首先在mysql中创建一个表 picture_db create table picture_db( file_name varchar(255) not null, content longblob, primary key (file_name)); 接下来就是用java写储存文件的代码： 假设要储存的图片名称是：01.jpg (放在同一个目录下） import java.sql.*; import java.io.*; import java.nio.*; public class UploadImage {     protected Connection dbConnection;     protected String driverName = "com.mysql.jdbc.Driver";     protected String dbURL = "jdbc:mysql://localhost:3306/sample_db";   protected String userID = "root";   protected String passwd = "yourpassword";     public boolean storeImage(String sqlstr,File file){         try{             FileInputStream fin = new FileInputStream(file);             ByteBuffer nbf = ByteBuffer.allocate((int)file.length());             byte[] array = new byte[1024];             int offset =0,length=0;             while((length=fin.read(array))>0){                 if(length!=1024)                      nbf.put(array,0,length);                 else                      nbf.put(array);                  offset+=length;                              }              fin.close();             byte[] content = nbf.array();             return setImage(sqlstr,content);                      }catch(FileNotFoundException e){              e.printStackTrace();             }catch (IOException e){                  e.printStackTrace();                 }             return false;          }          private boolean setImage(String sqlstr,byte[]in){         boolean flag = false;         if(sqlstr==null)              sqlstr="select * from picture_db";         try{              Class.forName(driverName);               dbConnection = DriverManager.getConnection(dbURL,userID,passwd);              Statement stmt = dbConnection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);              ResultSet rs = stmt.executeQuery(sqlstr);              if(rs.next()){                rs.updateBytes(2,in);               rs.updateRow();              }              else{                  rs.moveToInsertRow();                  rs.updateString(1,"01");                  rs.updateBytes(2,in);                  rs.insertRow();              }               rs.close();               flag=true;                       }catch(Exception e){              e.printStackTrace();         }         return flag;              }          public static void main(String[] args){          UploadImage upload = new UploadImage();         try{             File file = new File("01.jpg");             if(upload.storeImage(null, file))             System.out.print("ture");             else                 System.out.print("False");                      }catch(Exception e){              e.printStackTrace();         }     } }