demo1_version2

最新推荐文章于 2022-09-11 18:19:44 发布

gududelang0

最新推荐文章于 2022-09-11 18:19:44 发布

阅读量279

点赞数

分类专栏： Public Bus Service Simulator 文章标签： image exception file string templates null

本文链接：https://blog.csdn.net/gududelang0/article/details/5278907

版权

Public Bus Service Simulator 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
import java.sql.*;
import java.io.*;
import java.lang.*;
/**
*
* @author MichaelChan
*/
public class StoreImage {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws SQLException {
        // TODO code application logic here
        Connection connection=null;
        String connectionURL="jdbc:mysql://127.0.0.1:3306/map";
        PreparedStatement psmnt=null;
        try{
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            connection=DriverManager.getConnection(connectionURL, "root","19880818");
            File image=new File("E://START//207//Project//chipmunk.jpg");                //need to change
            insertfile(connection,psmnt,image);
            getfile(connection,"chipmunk.jpg");
            //update(connection,psmnt,"image");
        }
        catch(Exception ex){
            System.out.println("Found some error: "+ex);
        }
        finally{
            connection.close();
        }
    }

    public static void insertfile(Connection connection, PreparedStatement psmnt, File image) throws SQLException{
        try{
                psmnt=connection.prepareStatement
                        ("insert into image(name,image,size,timestamp) values(?,?,?,?)" );
                psmnt.setString(1, image.getName());
                psmnt.setLong(3, image.length());
                java.util.Date now=new java.util.Date();
                psmnt.setTimestamp(4, new java.sql.Timestamp(now.getTime()));
                FileInputStream fis=new FileInputStream(image);
                psmnt.setBinaryStream(2,(InputStream)fis,(int)(image.length()));
                int s=psmnt.executeUpdate();

                if(s>0){
                    System.out.println("Uploaded successfully!");
                }
                else{
                    System.out.println("Unsuccessfully to upload image");
                }
        }catch(Exception e){
            System.out.println("Found some error:");
            e.printStackTrace();
        }finally{
            psmnt.close();
        }
    }

    public static void update(Connection connection, PreparedStatement psmnt,String tablename) throws SQLException{
        psmnt=connection.prepareStatement("update "+tablename);
        psmnt.executeUpdate();
    }

    public static void getfile(Connection connection, String filename) throws SQLException, FileNotFoundException, IOException{
        ResultSet rs = null;
        PreparedStatement psmnt=null;
        try{
            psmnt=connection.prepareStatement("select image from image where name = ?");
            psmnt.setString(1, filename);
            rs=psmnt.executeQuery();
            while(rs.next()){
                Blob blob=rs.getBlob("image");
                File file=new File(filename);
                FileOutputStream outStream=new FileOutputStream(file);
                InputStream inStream=blob.getBinaryStream();

                int length=-1;
                int size=(int)blob.length();
                byte [] bytefile=new byte[size];

                while ((length = inStream.read(bytefile)) != -1)
                {
                    outStream.write(bytefile, 0, length);
                    outStream.flush();
                }

                inStream.close();
                outStream.close();
            }

        }
        finally{
            rs.close();
            psmnt.close();
        }
    }
}