Database of Public Bus Service Simulator(Source Code)

最新推荐文章于 2024-08-29 20:24:08 发布

gududelang0

最新推荐文章于 2024-08-29 20:24:08 发布

阅读量284

点赞数

分类专栏： Public Bus Service Simulator 文章标签： database service image exception string import

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

版权

Public Bus Service Simulator 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

demo1:

import java.sql.*;
import java.io.*;

public class StoreImage {

    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";                          //??
        ResultSet rs=null;
        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//chipmunk1.jpg");                //need to change
            insertfile(connection,psmnt,image);
            //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();
    }


}