jsp表单上传mysql数据库中

<%@ page import="java.io.*, java.sql.*" %>
<%@ page import="org.apache.commons.fileupload.*" %>
<%@ page import="org.apache.commons.fileupload.disk.*" %>
<%@ page import="org.apache.commons.fileupload.servlet.*" %>

<%
// 设置存储上传文件的目录路径
String savePath = "上传文件的保存路径";
File fileSaveDir = new File(savePath);
if (!fileSaveDir.exists()) {
    fileSaveDir.mkdir();
}

// 创建FileUpload对象
DiskFileItemFactory factory = new DiskFileItemFactory();
ServletFileUpload upload = new ServletFileUpload(factory);

try {
    // 解析请求中的所有文件
    List<FileItem> items = upload.parseRequest(request);
    for (FileItem item : items) {
        // 如果当前是文件字段
        if (!item.isFormField()) {
            String fileName = new File(item.getName()).getName();
            String filePath = savePath + File.separator + fileName;
            item.write(new File(filePath));

            // 连接MySQL数据库
            Connection conn = null;
            String url = "jdbc:mysql://localhost:3306/数据库名";
            String username = "数据库用户名";
            String password = "数据库密码";
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(url, username, password);

            // 向MySQL数据库插入数据
            String sql = "INSERT INTO 表名 (文件名, 文件路径) VALUES (?, ?)";
            PreparedStatement statement = conn.prepareStatement(sql);
            statement.setString(1, fileName);
            statement.setString(2, filePath);
            statement.executeUpdate();

            // 关闭数据库连接
            conn.close();
        }
    }
    out.println("文件上传成功！");
} catch (Exception ex) {
    out.println("文件上传失败：" + ex.getMessage());
}
%>