我需要帮助 . 我正在开发用于上传文本文件的应用程序 . 这一刻我遇到了一些我无法理解的错误 . 这是我的代码：
Index.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Servlet based API for querying text file</title>
<link rel="stylesheet" href="css/bootstrap.min.css" type="text/css">
</head>
<body>
<h3>Please choose file</h3>
<div class="container">
<form action="TextProccessing" method="post"
enctype="multipart/form-data">
<div class="form-group">
<label for="browseTxt">Upload file:</label>
<input type="file" name="browseTxt" id="browseTxt" value="select text file">
<p class="help-block">
<b>Note:</b> Please choose .txt file only
</p>
</div>
<BUTTON class="btn btn-default" type="submit">Upload</BUTTON>
</form>
</div>
<h2>Place for text</h2>
<div class="container"></div>
</body>
</html>
TextProccessing
package com.controller;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.MultipartConfig;
//import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.Part;
@MultipartConfig(maxFileSize = 16177215)
public class TextProccessing extends HttpServlet {
private static final long serialVersionUID = 1L;
private final static String RESULT_PAGE = "/result.jsp";
private final String dbURL = "jdbc:mysql://127.0.0.1:3306/textfilesdb";
private final String dbUser = "root";
private final String dbPassword = "root";
// for this moment
private String file_Name_test = "file_Name_test";
private String file_size_test = "file_size_test";
private String fileCreationDate_test = "fileCreationDate_test";
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
InputStream inputStream = null;
Part filePart = request.getPart("browseTxt");
if (filePart != null) {
// prints out some information for debugging
System.out.println(filePart.getName());
System.out.println(filePart.getSize());
System.out.println(filePart.getContentType());
// obtains input stream of the upload file
inputStream = filePart.getInputStream();
}
Connection conn = null; // connection to the database
String message = null; // message will be sent back to client
try {
// connects to the database
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
conn = DriverManager.getConnection(dbURL, dbUser, dbPassword);
// constructs SQL statement
String sql = "INSERT INTO files(file_Name, file_size, fileCreationDate, text_file) values (?, ?, ?, ?)";
PreparedStatement statement = conn.prepareStatement(sql);
statement.setString(1, file_Name_test);
statement.setString(2, file_size_test);
statement.setString(3, fileCreationDate_test);
if (inputStream != null) {
// fetches input stream of the upload file for the blob column
statement.setBlob(4, inputStream);
}
// sends the statement to the database server
int row = statement.executeUpdate();
if (row > 0) {
message = "File uploaded and saved into database";
}
} catch (SQLException ex) {
message = "ERROR: " + ex.getMessage();
ex.printStackTrace();
} finally {
if (conn != null) {
// closes the database connection
try {
conn.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
// sets the message in request scope
request.setAttribute("Message", message);
getServletContext().getRequestDispatcher(RESULT_PAGE).forward(request, response);
}
}
}
它似乎没问题，但我有这样的错误stacktrace
browseTxt 1189 text / plain com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException：SQL语法中有错误;查看与您的MySQL服务器版本对应的手册，以便在'？le_Name，file_size，？leCreationDate，text_file）值附近使用正确的语法（'？le_Name_test'，'file_'在第1行sun.reflect.NativeConstructorAccessorImpl.newInstance0（本地方法）at sun.reflect.NativeConstructorAccessorImpl.newInstance（Unknown Source）at sun.reflect.DelegatingConstructorAccessorImpl.newInstance（Unknown Source）at java.lang.reflect.Constructor.newInstance（Unknown Source）at com.mysql.jdbc.Util . com.mysql.jdbc.MysqlIO上的com.mysql.jdbc.Util.getInstance（Util.java:383）处于com.mysql.jdbc.SQLError.createSQLException（SQLError.java:980）的handleNewInstance（Util.java:400） .checkErrorPacket（MysqlIO.java:3847）在com.mysql.jdbc.MysqlIO.checkErrorPacket（MysqlIO.java:3783）的com.mysql.jdbc.MysqlIO.sendCommand（MysqlIO.java:2447）com.mysql.jdbc . 位于com.mysql.jdbc.PreparedStatement.executeInter的com.mysql.jdbc.ConnectionImpl.execSQL（ConnectionImpl.java:2545）中的MysqlIO.sqlQueryDirect（MysqlIO.java:2594） nal（PreparedStatement.java:1901）位于com.mysql.jdbc.PreparedStatement.executeUpdate（PreparedStatement.java:2113）的com.mysql.jdbc.PreparedStatement.executeUpdate（PreparedStatement.java:2049）com.mysql.jdbc.PreparedStatement .executeUpdate（PreparedStatement.java:2034）at com.controller.TextProccessing.doPost（TextProccessing.java:68）at javax.servlet.http.HttpServlet.service（HttpServlet.java:648）at javax.servlet.http.HttpServlet . 服务（HttpServlet.java:729）org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:291）atg.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206）org.apache .tomcat.websocket.server.WsFilter.doFilter（WsFilter.java:52）org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:239）org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain） .java：206）at org.apache.catalina.core.StandardWrapperValve.invoke（StandardWrapperVal） ve.java:219）org.apache.catalina.core.StandardContextValve.invoke（StandardContextValve.java:106）org.apache.catalina.authenticator.AuthenticatorBase.invoke（AuthenticatorBase.java:502）atg.apache.catalina .core.StandardHostValve.invoke（StandardHostValve.java:142）org.apache.catalina.valves.ErrorReportValve.invoke（ErrorReportValve.java:79）at org.apache.catalina.valves.AbstractAccessLogValve.invoke（AbstractAccessLogValve.java:616 ）org.apache.catalina.core.StandardEngineValve.invoke（StandardEngineValve.java:88）org.apache.catalina.connector.CoyoteAdapter.service（CoyoteAdapter.java:518）org.apache.coyote.http11.AbstractHttp11Processor . 进程（AbstractHttp11Processor.java:1091）org.apache.coyote.AbstractProtocol $ AbstractConnectionHandler.process（AbstractProtocol.java:673）org.apache.tomcat.util.net.NioEndpoint $ SocketProcessor.doRun（NioEndpoint.java:1526） at org.apache.tomcat.util.net.NioEndpoint $ SocketProcessor.run（NioEndpoint.java:1482）at java.util.concurrent.Thr edPoolExecutor.runWorker（未知来源）java.util.concurrent.ThreadPoolExecutor $ Worker.run（未知来源）atg.apache.tomcat.util.threads.TaskThread $ WrappingRunnable.run（TaskThread.java:61）at java.lang .Thread.run（未知来源）
而我的数据库结构
创建数据库TextFilesDB;
使用TextFilesDB;
CREATE TABLE文件（id int（11）NOT NULL AUTO_INCREMENT，fi le_Name varchar（45）NOT NULL，file_size varchar（45）DEFAULT NULL，fi leCreationDate varchar（45）DEFAULT NULL，text_file mediumblob，PRIMARY KEY（id））ENGINE = InnoDB DEFAULT CHARSET = utf16
1 回答
您似乎对列名称有一些格式问题 . 你能尝试更换吗？
通过