向数据库中插入一个文件流

最新推荐文章于 2019-05-25 09:29:00 发布

伤神v

最新推荐文章于 2019-05-25 09:29:00 发布

阅读量651

点赞数

分类专栏： Java_Database 文章标签：数据库 string file insert jdbc sql

本文链接：https://blog.csdn.net/DGenerationX/article/details/3514719

版权

Java_Database 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

public void insertDB() throws FileNotFoundException,ClassNotFoundException,
IllegalAccessException, InstantiationException, SQLException {
String filePathFrom = "D://my.jpg" ;
File file = new File(filePathFrom);
FileInputStream fis = new FileInputStream(file);

Class.forName("com.mysql.jdbc.Driver").newInstance();
String url = "jdbc:mysql://localhost:3306/test?user=root&password=";
Connection conn = DriverManager.getConnection(url);

String sql = "insert into user(id,image) values(?,?)";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setInt(1,88);
stmt.setBinaryStream(2,fis,(int)file.length());
stmt.executeUpdate();

conn.close();
System.out.println("ok0");
}