fileupload图片上传并把地址保存到数据库

GetFile.java(处理上传请求的servlet)

package com.servlet;

import java.io.File;

import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUploadException;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;

import com.util.ConnDB;

public class GetFile extends HttpServlet {

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String str=(String) request.getSession().getAttribute("id");		
		System.out.println("拿到的id值为"+str);
		int id=Integer.parseInt(str);		
		
		String path=this.getServletContext().getRealPath("/")+"userFile";
		System.out.println("WebRoot的根路径:"+path);
		
		File file=new File(path);
		if(!file.exists()){
			file.mkdir();
		}
		
		DiskFileItemFactory factory=new DiskFileItemFactory();
		
		ServletFileUpload upload=new ServletFileUpload(factory);
		
		upload.setHeaderEncoding("utf-8");
		
		//判断提交的数据是否是表单数据
		if(!ServletFileUpload.isMultipartContent(request)){
			System.out.println("提交的不是表单数据");
			return;
		}
		try {
			List<FileItem> items=upload.parseRequest(request);
			
			for(FileItem item :items){
				
				if(item.isFormField()){
					String name=item.getString();
					String value=new String(name.getBytes("ISO-8859-1"),"utf-8");
					System.out.println("文本框中的值:"+value);
					
					
				}else{					
					System.out.println("提交的是文件");
					//item.getFieldName();
					String filename=item.getName();
					System.out.println("获取到的上传文件名:"+filename);					
					
					String prefix=filename.substring(filename.lastIndexOf(".")+1);
					
					String fName=id+"."+prefix;					
					
					InputStream is=item.getInputStream();
					FileOutputStream fos=new FileOutputStream(path+"/"+fName);
					int index=0;
					
					while((index=is.read())!=-1){
						fos.write(index);
					}
					is.close();
					fos.close();
					item.delete();		
					
					Connection conn=ConnDB.getConn();
					String sql="update user set photo=? where id=?";
					PreparedStatement psta;			
					psta = conn.prepareStatement(sql);
					
					psta.setString(1, "userFile/"+fName);
					psta.setInt(2, id);
					psta.executeUpdate();				
				}
			}
			
			
		} catch (FileUploadException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		response.sendRedirect("showOne.jsp?id="+id);
		
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		this.doGet(request, response);
	}

}

 用户自定义图像
  <form action="GetFile" method="post" enctype="multipart/form-data" >
  			<input type="file" name="myfile"><br/> 
  			<input type="text" name="uname"> <br/> 			
 			<input type="submit" value="上传">
  </form> 


  • 1
    点赞
  • 13
    收藏
    觉得还不错? 一键收藏
  • 3
    评论
好的,我可以为您解答这个问题。 首先,您需要在您的 Spring Boot 项目中引入相关依赖,如下所示: ```xml <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-thymeleaf</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-validation</artifactId> </dependency> <dependency> <groupId>commons-fileupload</groupId> <artifactId>commons-fileupload</artifactId> <version>1.3.3</version> </dependency> ``` 接下来,您需要编写一个控制器来处理文件上传的请求和保存文件地址数据库的操作,如下所示: ```java @RestController public class FileUploadController { @Autowired private ImageRepository imageRepository; @PostMapping("/upload") public ResponseEntity<String> handleFileUpload(@RequestParam("file") MultipartFile file) { String fileName = StringUtils.cleanPath(file.getOriginalFilename()); try { if (fileName.contains("..")) { throw new FileStorageException("Invalid file name: " + fileName); } Image image = new Image(); image.setName(fileName); image.setType(file.getContentType()); image.setData(file.getBytes()); imageRepository.save(image); return ResponseEntity.ok().body("File uploaded successfully: " + fileName); } catch (IOException ex) { throw new FileStorageException("Could not store file " + fileName + ". Please try again!", ex); } } } ``` 在上面的控制器中,我们使用了 `MultipartFile` 类型的参数来接收文件上传请求,同时也使用了 `ImageRepository` 来保存文件地址数据库中。 最后,您需要编写一个 JPA 实体类来映射数据库中的 Image 表,如下所示: ```java @Entity @Table(name = "image") public class Image { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @Column(name = "name") private String name; @Column(name = "type") private String type; @Lob @Column(name = "data") private byte[] data; // getter 和 setter 方法略 } ``` 在上面的实体类中,我们使用了 `@Lob` 注解来将文件内容以二进制形式保存数据库中。 至此,您就完成了 Spring Boot 框架实现图片上传显示并保存地址数据库的操作。
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值