先讲废话
*首先我觉得这个方法走了弯路,因为我不是直接将本地的图片上传到数据库,而是现将本地的图片写入到一个固定的文件夹中,然后再将该文件夹中的图片上传到数据库中。
简单来说就是:我无法得到图片的原目录,只能得到图片的上传后的目录。ps:希望大佬可以提供一个思路,多多指教。
这是内容
第一步:建表
DROP TABLE IF EXISTS imgs
;
CREATE TABLE imgs
(
id
int(11) NOT NULL AUTO_INCREMENT,
img
longblob NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
注:1:图片的类型为 longblob;
2:给图片一个id,因为在表中图片显示不出来,有了id就知道有没有上传成功。
第二步:连接数据库的代码编写
package com.runoob.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBConn {
public static Connection getConn(){
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/try?useSSL = false","root","123");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println("数据库连接成功");
return conn;
}
//关闭资源
public void closeAll(ResultSet rs,Statement sta,Connection conn){
try {
if(rs != null){
rs.close();
}
if(sta != null){
sta.close();
}
if(conn != null){
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
第三步:upload.jsp上传页面和message.jsp成功页面的代码编写
upload.jsp
<body>
<form method="post" action="/UploadDemo01/UploadServlet" enctype="multipart/form-data">
选择一个文件:
<input type="file" name="uploadFile" />
<br/><br/>
<input type="submit" value="上传" />
</form>
</body>
message.jsp
<body>
<h2>${message}</h2>
</body>
第四步:图片上传到固定文件夹代码编写和上传到数据库代码编写
UploadServlet.java
package com.runoob.test;
import java.io.File;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
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.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import com.runoob.demo.UploadImgToDB;
/**
* Servlet implementation class UploadServlet
*/
@WebServlet("/UploadServlet")
public class UploadServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
// 上传文件存储目录
private static final String UPLOAD_DIRECTORY = "upload";
// 上传配置
private static final int MEMORY_THRESHOLD = 1024 * 1024 * 3; // 3MB
private static final int MAX_FILE_SIZE = 1024 * 1024 * 40; // 40MB
private static final int MAX_REQUEST_SIZE = 1024 * 1024 * 50; // 50MB
/**
* 上传数据及保存文件
*/
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
// 检测是否为多媒体上传
if (!ServletFileUpload.isMultipartContent(request)) {
// 如果不是则停止
PrintWriter writer = response.getWriter();
writer.println("Error: 表单必须包含 enctype=multipart/form-data");
writer.flush();
return;
}
// 配置上传参数
DiskFileItemFactory factory = new DiskFileItemFactory();
// 设置内存临界值 - 超过后将产生临时文件并存储于临时目录中
factory.setSizeThreshold(MEMORY_THRESHOLD);
// 设置临时存储目录
factory.setRepository(new File(System.getProperty("java.io.tmpdir")));
ServletFileUpload upload = new ServletFileUpload(factory);
// 设置最大文件上传值
upload.setFileSizeMax(MAX_FILE_SIZE);
// 设置最大请求值 (包含文件和表单数据)
upload.setSizeMax(MAX_REQUEST_SIZE);
// 中文处理
upload.setHeaderEncoding("UTF-8");
String yuanmulu = request.getParameter("uploadFile");
System.out.println(yuanmulu);
// 构造临时路径来存储上传的文件
// 这个路径相对当前应用的目录
String uploadPath = getServletContext().getRealPath("/") + File.separator + UPLOAD_DIRECTORY;
// 如果目录不存在则创建
File uploadDir = new File(uploadPath);
if (!uploadDir.exists()) {
uploadDir.mkdir();
}
try {
// 解析请求的内容提取文件数据
@SuppressWarnings("unchecked")
List<FileItem> formItems = upload.parseRequest(request);
if (formItems != null && formItems.size() > 0) {
// 迭代表单数据
for (FileItem item : formItems) {
// 处理不在表单中的字段
if (!item.isFormField()) {
String fileName = new File(item.getName()).getName();
String filePath = uploadPath + File.separator + fileName;
File storeFile = new File(filePath);
// 在控制台输出文件的上传路径
System.out.println(filePath);
// 保存文件到硬盘
item.write(storeFile);
request.setAttribute("message",
"文件上传成功!");
UploadImgToDB up = new UploadImgToDB();
File img = new File(filePath);
up.uploadImg(img);
}
}
}
} catch (Exception ex) {
request.setAttribute("message",
"错误信息: " + ex.getMessage());
}
/*// 跳转到 message.jsp
request.getRequestDispatcher("message.jsp").forward(request, response);*/
getServletContext().getRequestDispatcher("/message.jsp").forward(
request, response);
}
}
UploadImgToDB.java
package com.runoob.demo;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.runoob.util.DBConn;
public class UploadImgToDB extends DBConn{
//将图片上传到数据库
public boolean uploadImg(File img) {
Connection conn = super.getConn();
PreparedStatement ps = null;
// 编写sql语句
String sql = "insert into imgs(img) values(?)";
System.out.println("执行了sql");
try {
// 预编译处理sql语句
ps = conn.prepareStatement(sql);
//读取图片
/* File img = new File("C:/Users/Administrator/Desktop/images/brand.png");
*/
FileInputStream fis = new FileInputStream(img);
ps.setBlob(1, fis);
ps.executeUpdate();
fis.close();
} 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();
}
System.out.println("上传图片成功");
return false;
}
//读取图片
public boolean readImg() {
Connection conn = super.getConn();
PreparedStatement ps = null;
ResultSet rs = null;
// 编写sql语句
String sql = "select id,img from imgs";
try {
// 预编译处理sql语句
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()) {
Blob img = rs.getBlob("img");
//存放图片
//给图片命名
String fileName = rs.getString("id")+"_brand.png";
File saveImg = new File("C:/Users/Administrator/Desktop/images/"+fileName);
FileOutputStream fos = new FileOutputStream(saveImg);
fos.write(img.getBytes(1, (int)img.length()));
fos.flush();
fos.close();
}
} 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();
}
System.out.println("读取图片成功");
return false;
}
}
其中,UploadServlet.java中的下面部分指的是,在得到文件上传到固定文件夹的位置后,调用uploadImg(File img)方法,并且将得到的地址当做参数传入。
UploadImgToDB up = new UploadImgToDB();
File img = new File(filePath);
up.uploadImg(img);
最后运行项目,打开数据库可以看到图片上传成功。
**注:本文大部分代码来自(https://www.runoob.com/jsp/jsp-file-uploading.html)