Java操作mysql存储图片转载

最新推荐文章于 2024-02-14 18:09:24 发布

东东车

最新推荐文章于 2024-02-14 18:09:24 发布

阅读量114

点赞数

分类专栏： Java备忘录文章标签： java 数据库移动开发

本文链接：https://blog.csdn.net/macleo/article/details/84387402

版权

Java备忘录专栏收录该内容

52 篇文章 0 订阅

订阅专栏

[url]http://hi.baidu.com/xxfaxy/item/4c44f6fd4539dd5cc8f33705[/url]

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存储图片转载
[url]http://www.cnblogs.com/5211314WL/archive/2011/03/24/JavaAndMysqlIn.html[/url]
好用，收集下


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