我有一个问题,java.io.File从选择a JFileChooser获取将上述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方法是该类的静态方法,其中它向所述MySQL数据库返回默认的DriverManager的新实例。另一件事,我使用的是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
我该如何解决这个问题?