java保存图片到mysql_Java存储图片到Mysql

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

【1】视图层

action="${ctx}/web/UserInforServlet?method=userInforServlet" >

更换头像

立即提交

重置

var layer,upload,form;

//1-页面数据加载

$(function () {

//【1】加载&初始化layui模块-弹出层与table数据表格

layui.use(["layer", "upload","form"], function () {

layer = layui.layer;

laydate=layui.laydate;

upload = layui.upload;//layui的上传

form= layui.form;

uploadImage();

});

});

function uploadImage(){

var $ = layui.jquery;

upload.render({

elem: "#upImage"

,auto: false

,size:1024

,choose: function(obj){//使用choose选择文件后的回调函数

//预读本地文件示例，不支持ie8

obj.preview(function(index, file, result){

$("#userImge").attr("src",result); //图片链接(base64)

});

}

});

}

//提交form表单

$("#saveUserInfor").click(function(){

$("#frregister").ajaxSubmit(function(data) {

if(data="1"){

layer.msg("成功！");

}

});

});

【2】控制器

publicvoid userInforServlet(HttpServletRequest request,HttpServletResponseresponse) throws IOException {

request.setCharacterEncoding("utf-8");

response.setCharacterEncoding("utf-8");

response.setContentType("text/html;charset=UTF-8");//处理响应编码

Map map=new HashMap();

UserDetail userDetail=new UserDetail();

try {

//【1】解析数据

DiskFileItemFactory fac=new DiskFileItemFactory();

int sizeThreshold=1024*1024*10; //10MB

fac.setSizeThreshold(sizeThreshold);

fac.setRepository(new File(System.getProperty("java.io.tmpdir")));

ServletFileUpload upload=new ServletFileUpload(fac);//文件上传解析器

upload.setHeaderEncoding("utf-8");

Listlist=upload.parseRequest(request);

//【2】遍历集合

for(FileItem item :list){

//1)如果当前FileItem对象是普通项

if(item.isFormField()){

map.put(item.getFieldName(),item.getString());

}else{

//1)如果当前FileItem对象是上传项

//2)判断是否存在有该文件夹

String realPath=("D:/Mytouimage");

File uploadMkdir=new File(realPath);

if(!uploadMkdir.exists()){

uploadMkdir.mkdir();

}

//如果fileitem中封装的是上传文件，得到上传的文件名称，

String fileName = item.getName();//上传文件的名

//多个文件上传时，没有上传内容的问题异常处理

if(fileName==null||"".equals(fileName.trim())){ continue;

}

fileName =fileName.substring(fileName.lastIndexOf("\\")+1);

InputStream is=item.getInputStream();

File file=new File(realPath+"/"+fileName);

//3)先在本地存储图片，再读取保存到数据库

if(!file.isDirectory()){

userDetail.setImageName(realPath+"/"+item.getName());

OutputStream os=new FileOutputStream(file);

//IOUtils拷贝流

IOUtils.copy(is,os);

//关闭资源

IOUtils.closeQuietly(is);

IOUtils.closeQuietly(os);

item.delete();//删除处理文件上传时生成的临时文件

}

}

}

BeanUtils.populate(userDetail,map);

int flag =ids.insert(userDetail);

if(flag==1){

response.getWriter().write("1");

response.getWriter().close();

}

}

【3】dao层

@Override

publicint insert(UserDetail t) {

int flag=0;

InputStream fis=null;

String insert="INSERT INTOr_userdetail(userImage,imageName)" +

"VALUES(?,?);";

try {

con=JDBCUtil.getConnection();

ps=con.prepareStatement(insert);

if(t.getImageName()!=null){

//读取本地图片

fis=new FileInputStream(t.getImageName());

}

//将流写入Mysql

ps.setBinaryStream(1, fis, fis.available());

ps.setString(2, t.getImageName());

flag=ps.executeUpdate();

} catch (SQLException e) {

//TODO Auto-generated catch block

e.printStackTrace();

}

catch (FileNotFoundException e){

//TODO Auto-generated catch block

e.printStackTrace();

}

catch (IOException e) {

//TODO Auto-generated catch block

e.printStackTrace();

}

return flag;

}

【4】po层

publicclass UserDetail implements Serializable{

publicstaticfinallongserialVersionUID = 42L;

privateintuserDetailID;

private Blob userImage;

private String imageName;

public Blob getUserImage() {

returnuserImage;

}

publicvoid setUserImage(Blob userImage) {

this.userImage = userImage;

}

public String getImageName() {

returnimageName;

}

publicvoid setImageName(String imageName) {

this.imageName = imageName;

}

}

【5】总结

1)注意上传图片是form表单一定要加method="post" enctype="multipart/form-data" ，否则无法将数据上传到服务器。

2)Mysql存储图片的数据类型

TinyBlob最大 255

Blob 最大 65K

MediumBlob 最大 16M

LongBlob 最大 4G

3)在dao层向数据库添加数据

使用ps.setBinaryStream(1,fis, fis.available());

【6】显示图片

publicvoid selectUserImage(HttpServletRequest request, HttpServletResponseresponse) {

String id=request.getParameter("userID");

if(id!=null){

int userID=Integer.parseInt(id);

UserDetail userDetail=ids.findByUserid(userID);

BufferedOutputStream bufos=null;

BufferedInputStream bufis=null;;

try {

if(userDetail.getUserImage()!=null){

//读取缓冲区 userDetail.getUserImage().getBinaryStream()--读取源

bufis=new BufferedInputStream(userDetail.getUserImage().getBinaryStream());

//输出缓冲区 response.getOutputStream()--输出目的

bufos = new BufferedOutputStream(response.getOutputStream());

byte[] bt=newbyte[1024];

//【6】初始化实际长度的数组的长度

int count=0;

//【7】循环读取多媒体文件数据，将其读取的数据存储在byte数组

while((count=bufis.read(bt))!=-1){

//【8】截取数组从零到实际长度，循环写入多媒体的目标文件

bufos.write(bt,0,count);

}

}

bufis.close();

bufos.close();

} catch (SQLException e) {

//TODO Auto-generated catch block

e.printStackTrace();

}

catch (IOException e) {

//TODO Auto-generated catch block

e.printStackTrace();

}

}

}