java - UCAExc:::3.0.7 未知令牌:插入日期错误
问题描述
我的 .mdb 数据库中有一个表。我想在这个表中插入日期。所以我为此写了这段代码
public void main(String[] args) {
// TODO Auto-generated method stub
PreparedStatement state;
Connection connect;
DateFormat dateFormat=new SimpleDateFormat("dd/MM/yyyy");
Calendar cal=Calendar.getInstance();
String date=dateFormat.format(cal.getTime());
System.out.println(date);
try {
connect = DriverManager.getConnection("jdbc:ucanaccess://C:/Users/FTK1187/Desktop/eArchiveMaster.mdb","FTEC198","");
String sql="INSERT INTO LastUpdated (LastUpdatedDate) VALUES (#"+date+"#)";
state=connect.prepareStatement(sql);
state.execute();
state.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
它给了我这个错误
net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.7 unknown token:
at net.ucanaccess.jdbc.UcanaccessConnection.prepareStatement(UcanaccessConnection.java:528)
at org.solr.InsertLastUpdate.main(InsertLastUpdate.java:27)
at org.solr.updateServlet.doGet(updateServlet.java:40)
at org.solr.updateServlet.doPost(updateServlet.java:59)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: unknown token:
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
at net.ucanaccess.jdbc.UcanaccessConnection.prepareStatement(UcanaccessConnection.java:525)
... 27 more
Caused by: org.hsqldb.HsqlException: unknown token:
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.ParserBase.read(Unknown Source)
at org.hsqldb.ParserDQL.XreadSimpleValueExpressionPrimary(Unknown Source)
at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source)
at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source)
at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source)
at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source)
at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source)
at org.hsqldb.ParserDQL.XreadValueExpressionOrNull(Unknown Source)
at org.hsqldb.ParserDQL.XreadValueExpressionWithContext(Unknown Source)
at org.hsqldb.ParserDQL.readRow(Unknown Source)
at org.hsqldb.ParserDQL.XreadContextuallyTypedTable(Unknown Source)
at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
at org.hsqldb.Session.compileStatement(Unknown Source)
at org.hsqldb.StatementManager.compile(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 30 more
日期格式是我数据库中的一般日期。当我这样做时
System.out.println(date);
它给了我想要的东西,但是当我想在我的数据库中插入时出现错误。我不知道如何解决它。
解决方案
没有必要使用SimpleDateFormat
and Calendar
。要插入日期,我们可以简单地使用类似
String sql = "INSERT INTO LastUpdated (LastUpdatedDate) VALUES (?)";
state = connect.prepareStatement(sql);
state.setDate(1, java.sql.Date.valueOf(LocalDate.now()));
state.execute();
state.close();
或者,由于我们要插入当前日期,我们可以这样做
String sql = "INSERT INTO LastUpdated (LastUpdatedDate) VALUES (DATE())";
state = connect.prepareStatement(sql);
state.execute();
state.close();
推荐阅读
- angular - Angular Msal 访问令牌检索
- python - Django 无法加载数据并出现反序列化错误
- python - 相对翻译 - Aruco
- c# - EWS 读取电子邮件和文件夹 c#:权限和同意
- java - 应用在 Playstore 更新发布后崩溃,但从 android studio 运行正常(重复但无法找到解决方案)
- excel - Excel VBA代码将工作表向右或向左移动一个
- javascript - React - 工具提示使用字符串连接返回新行
- flutter - 在颤振 Material App 中构建 AnimatedTheme 时抛出了断言
- angular - 找不到名称“放大”-项目管道
- flutter - 使用 Flutter for Web 和 Mobile 的卡片高度/宽度