2023.4.5每日总结

二进制存储

package pdf;

import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class out {
    public boolean in(File file) throws Exception {
        Class.forName("com.mysql.jdbc.Driver");
        String url="jdbc:mysql://localhost:3306/pdf";
        String username="root";
        String password="Njx200259";
        Connection connection= DriverManager.getConnection(url,username,password);
        Statement statement=connection.createStatement();

        InputStream inputStream=new FileInputStream(file);
        int b;
        String FILE="";
        while((b=inputStream.read())!=-1){
            FILE=FILE+String.valueOf(b);
        }
        String sql="insert into pdf ('name','pdf') values ('first','"+FILE+"'";
        statement.executeQuery(sql);
        return true;
    }
}