Java操作mysql储存图片转载

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
好用，收集下

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();        }    }}