我需要在mysql数据库中存储一个pdf(每个pdf最多<5页)。列定义为mediumblob。测试pdf是198kb。我得到错误“errors occurred in addmedicalplan:java.io.filenotfoundexception:”后面是文件“jvberi0xljckcqgmcbvymokelkzw50axr5kqplbmrvymokns…”的转储,最后是“(文件名或扩展名太长)”。
我已经设法做到这一点与图像,并一直试图重新使用的代码来存储pdf;通过研究有关stackoverflow的文章和其他问题。不幸的是,对我来说,大多数示例都与php有关。我已经能够阅读pdf并在页面中显示它,代码如下:
html格式:
<div class="form-group">
<embed width="191" height="207" id="image" src="" type="application/pdf">
<input class="form-control-file col-lg-12 col-md-12 col-sm-12 col-xs-12 photo-input" type="file" id="photo" name="photo" placeholder="PDF">
</div>
jquery查询:
$(document).on('change', '.photo-input', function(){
//Check for a valid image extension
var img1 = this.files[0].type;
alert("img1: " + img1);
var mySubString = img1.substring(
img1.lastIndexOf("image") + 13
);
alert("mySubString: " + mySubString)
if($.inArray(mySubString, ['pdf']) == -1) {
alert('Add invalid extension 1!');
$('#image').attr('src', '');
}else{
//Check for a valid image size
if (this.files[0].size < 10000000){
readURL(this, this.id);
}else{
alert("This image is to large (must be < 1 MB).")
$('#image').attr('src', '');
}
var img1 = document.getElementById('image');
img2 = (img1.getAttribute('src')).replace(/^data:application\/(pdf);base64,/, "");
}
});
function readURL(input, id) {
if (input.files && input.files[0]) {
var reader = new FileReader();
reader.onload = function (e) {
$('#image').attr('src', e.target.result);
}
reader.readAsDataURL(input.files[0]);
}
}
然后我将pdf传递给ajax存储:
$.ajax({
type: "POST",
url: "MedicalPlanAddView",
cache: false,
data : {
ssAccountLevel : sessionStorage.getItem('ssAccountLevel'),
ssAccountID : sessionStorage.getItem('ssAccountID'),
ssNameID : sessionStorage.getItem('ssNameID'),
image : img2,
mpNameAdd: $("#mpNameAdd").val(),
},
})
服务器端java是:
private static byte[] getByteArrayFromFile(final String handledDocument) throws IOException {
final ByteArrayOutputStream baos = new ByteArrayOutputStream();
final InputStream in = new FileInputStream(handledDocument);
final byte[] buffer = new byte[500];
int read = -1;
while ((read = in.read(buffer)) > 0) {
baos.write(buffer, 0, read);
}
in.close();
return baos.toByteArray();
}
ps.setString(1, nameId);
ps.setString(2, medicalPlanName);
ByteArrayInputStream bais = new
ByteArrayInputStream(getByteArrayFromFile(medicalPlan)); //pdf image
ps.setBlob(3, bais);
ps.setString(4, updateDate);
ps.executeUpdate();
1条答案
按热度按时间tsm1rwdh1#
这就是我最后要做的。
html格式:
jquery查询:
sql语句: