將圖片以 BLOB 二進位儲存於資料庫,透過獨立 JSP 輸出圖片二進位流,前端 <img src="showImage.jsp?id=123"> 引用,實現動態圖片顯示、權限控制、防盜鏈。
CREATE TABLE pic_table (
pic_id INT PRIMARY KEY AUTO_INCREMENT,
pic_name VARCHAR(100),
pic_data LONGBLOB -- MySQL;Oracle 用 BLOB,SQL Server 用 VARBINARY(MAX)
);
<%@ page contentType="text/html;charset=UTF-8" %>
<form action="uploadImage.jsp" method="POST" enctype="multipart/form-data">
圖片標題:<input type="text" name="picName"><br>
選擇圖片:<input type="file" name="picFile" accept="image/*"><br>
<input type="submit" value="上傳">
</form>
<%@ page import="java.sql.*, java.io.*, javax.servlet.*, javax.servlet.http.*" %>
<%@ page import="org.apache.commons.fileupload.*, org.apache.commons.fileupload.disk.*, org.apache.commons.fileupload.servlet.*" %>
<%
// 解析 multipart 請求
DiskFileItemFactory factory = new DiskFileItemFactory();
ServletFileUpload upload = new ServletFileUpload(factory);
List<FileItem> items = upload.parseRequest(request);
String picName = "";
InputStream picStream = null;
for (FileItem item : items) {
if (item.isFormField()) {
if ("picName".equals(item.getFieldName())) picName = item.getString("UTF-8");
} else {
picStream = item.getInputStream();
}
}
// 存入資料庫
Connection conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASS);
PreparedStatement ps = conn.prepareStatement("INSERT INTO pic_table(pic_name, pic_data) VALUES (?, ?)");
ps.setString(1, picName);
ps.setBinaryStream(2, picStream, (int) item.getSize());
ps.executeUpdate();
ps.close(); conn.close();
out.print("上傳成功");
%>
<%@ page import="java.sql.*, java.io.*" %>
<%
String id = request.getParameter("id");
Connection conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASS);
PreparedStatement ps = conn.prepareStatement("SELECT pic_data, pic_name FROM pic_table WHERE pic_id = ?");
ps.setString(1, id);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
response.setContentType("image/jpeg"); // 或根據檔名動態判斷
response.setHeader("Content-Disposition", "inline; filename=\"" + rs.getString("pic_name") + "\"");
try (InputStream is = rs.getBinaryStream("pic_data");
OutputStream os = response.getOutputStream()) {
byte[] buf = new byte[8192];
int len;
while ((len = is.read(buf)) != -1) os.write(buf, 0, len);
}
}
rs.close(); ps.close(); conn.close();
%>
<img src="showImage.jsp?id=1" alt="資料庫圖片" style="max-width:100%;" />
| 技術點 | 處理方式 |
|---|---|
| 檔案上傳解析 | Commons FileUpload / Servlet 3.0 request.getPart() |
| 二進位寫入 | PreparedStatement.setBinaryStream() 流式寫入,避免大圖 OOM |
| 二進位讀取 | ResultSet.getBinaryStream() 直接輸出至 response.getOutputStream() |
| Content-Type | 根據副檔名或檔頭魔數動態設定(image/jpeg, image/png, image/gif) |
| 快取控制 | Cache-Control: max-age=31536000 靜態圖片長期快取;動態權限圖片 no-store |
| 防盜鏈 | 檢查 Referer 或 Token 參數驗證 |
src/
├── dao/
│ └── PicDao.java # 封裝 CRUD
├── service/
│ └── PicService.java # 業務邏輯、事務
├── web/
│ ├── upload.jsp # 上傳頁面
│ ├── uploadAction.jsp # 上傳處理(建議改 Servlet)
│ ├── showImage.jsp # 圖片輸出(建議改 Servlet)
│ └── list.jsp # 圖片列表
└── util/
└── DBUtil.java # 連線池工具