日期:2014-05-16  浏览次数:20718 次

Java操作mysql存储图片转载
http://hi.baidu.com/xxfaxy/item/4c44f6fd4539dd5cc8f33705

android自带的base64编码
首先导入包
import android.util.Base64;
String 变量=android.util.Base64.encodeToString(字符串.getBytes(),Base64.DEFAULT);

也可简写为
String 变量=Base64.encodeToString(字符串.getBytes(),Base64.DEFAULT);

至于解码
byte b[]=android.util.Base64.decode(字符串,Base64.DEFAULT);

String 变量=new String(b);
byte b[]=android.util.Base64.decode(字符串,Base64.DEFAULT);






Java操作mysql存储图片转载
http://www.cnblogs.com/5211314WL/archive/2011/03/24/JavaAndMysqlIn.html
好用,收集下
mport 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();
        }
    }
}