java mysql 传文件_Java文件上传到MySQL

参见英文答案 >

Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?                                    14个

我有这个问题从选择JFileChooser获取java.io.File将上述java.io.File对象上传到具有此表结构的MySQL表

COL_NAME COL_TYPE ATTRIBUTES EXTRA

(PK) idSample int(10) UNSIGNED ZEROFILL AUTO_INCREMENT

FileName varchar(250)

FileBin blob BINARY

从这个Java代码中,newConnection方法是该类的静态方法,其中它返回一个新的DriverManager默认实例到所述MySQL数据库.另一件事,我使用java.sql包而不是com.mysql.jdbc包.

public static boolean insert(final String filename, File file) throws SQLException, IOException {

boolean flag = false;

try {

Connection connection = newConnection();

PreparedStatement statement = connection.prepareStatement(SQL_INSERT);

statement.setString(1, filename);

statement.setBlob(2, new FileInputStream(file), file.length());

flag = statement.executeUpdate() > 0;

statement.close();

connection.close();

} catch (SQLException ex) {

throw ex;

} catch (IOException ex) {

throw ex;

}

return flag;

}

当我尝试运行该程序时,它返回一个错误,导致statement.setBlob行有这个堆栈跟踪：

Exception in thread "main" java.lang.AbstractMethodError: com.mysql.jdbc.PreparedStatement.setBlob(ILjava/io/InputStream;J)V

我该如何解决这个问题？