二进制jpg图片上传小结

发布时间：2020-12-12 15:48:41 所属栏目：MsSql教程来源：网络整理

导读：?前台jsp页面：putImage.jsp body ??form action="putImage.do"? method="post" ???ENCTYPE="multipart/form-data" ???input name="file" type="file" ???input type="submit" name="submit" value="上传" ??/form ?/body ? Struts中action中的代码 FormFile

?前台jsp页面：putImage.jsp

<body>

??<form action="putImage.do"? method="post"
???ENCTYPE="multipart/form-data">
???<input name="file" type="file">
???<input type="submit" name="submit" value="上传">
??</form>
?</body>

Struts中action中的代码

FormFile file = pif.getFile();
?InputStream photoStream = file.getInputStream();//这里要特别注意和别的资料的区别
??try {
???new Image().putimg(file,photoStream,file.getFileSize());
??} catch (Exception e) {
???e.printStackTrace();
??}
??return mapping.findForward("success");

底层的一个dao方法

public void putimg(FormFile file,InputStream photoStream,int size) {???try {????Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");????String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=cmtony";????Connection conn = DriverManager.getConnection(url,"sa","sa");????PreparedStatement ps = null;????String sql = "insert into image(img) values (?)";????ps = conn.prepareStatement(sql);???????????? ps.setBinaryStream(1,size);???????????? ps.executeUpdate();???????????? ps.close();???????????? conn.close();???} catch (Exception e) {????e.printStackTrace();???}}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!