前序:如标题所示,主要是贴核心代码。基本能用。都可以用的,我亲测过了。
//方式一:将文件转成字节数组,采用原生sql存到数据库
if(StringUtils.isNotEmpty(multipartFile.getOriginalFilename())) {
//获取file文件
CommonsMultipartFile cmf = (CommonsMultipartFile) multipartFile;
DiskFileItem dfi = (DiskFileItem)cmf.getFileItem();
File file = dfi.getStoreLocation();
//转成流
InputStream ips = new FileInputStream(file);
byte[] byteData = new byte[(int) file.length()];
ips.read(byteData, 0, byteData.length);
DataSource ds = this.jdbcTemplate.getDataSource();
Connection conn = ds.getConnection();
String sql = "update tpm_plan set attachment = ? where id = ?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setBytes(1, byteData);
ps.setLong(2, 69);
int i=ps.executeUpdate();
if(i==0){
Boolean flag=false;
System.out.println(flag);
}
DataS