SQLite/java的SQL查询。文本ParseException:无法解析的日期
我编译了这段代码,但这段代码来自java。sql。SQLException和java。文本resultSet上的ParseException。getDate()方法
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
class Main {
public static void main(String[] args) throws SQLException {
try {
Class.forName("org.sqlite.JDBC");
Connection connection = DriverManager.getConnection
("jdbc:sqlite:C:/sqlite-tools/test.db");
Statement statement = connection.createStatement();
String sql = "CREATE TABLE t1 (" +
"no INTEGER PRIMARY KEY, " +
"date DATE, " +
"content TEXT)";
statement.executeUpdate(sql);
sql = "INSERT INTO t1 (date, content)" +
"VALUES(DATETIME('NOW', 'LOCALTIME'), 'test');";
statement.executeUpdate(sql);
ResultSet resultSet = statement.executeQuery("SELECT * FROM t1;");
while(resultSet.next()) {
// here occurs exception ↓ :(
Date date = resultSet.getDate("date");
// here occurs exception ↑ :(
String text = resultSet.getString("content");
System.out.println(date + " " + text);
}
statement.close();
connection.close();
} catch(ClassNotFoundException e) {
e.printStackTrace();
}
}
}
例外解释如下
Exception in thread "main" java.sql.SQLException: Error parsing time stamp
at org.sqlite.jdbc3.JDBC3ResultSet.getDate(JDBC3ResultSet.java:327)
at org.sqlite.jdbc3.JDBC3ResultSet.getDate(JDBC3ResultSet.java:346)
at com.planb.main.Main.main(Main.java:35)
Caused by: java.text.ParseException: Unparseable date: "2016-12-20 17:08:07" does not match (\p{Nd}++)\Q-\E(\p{Nd}++)\Q-\E(\p{Nd}++)\Q \E(\p{Nd}++)\Q:\E(\p{Nd}++)\Q:\E(\p{Nd}++)\Q.\E(\p{Nd}++)
at org.sqlite.date.FastDateParser.parse(FastDateParser.java:299)
at org.sqlite.date.FastDateFormat.parse(FastDateFormat.java:490)
at org.sqlite.jdbc3.JDBC3ResultSet.getDate(JDBC3ResultSet.java:324)
... 2 more
两个小时内我找不到任何解决办法。请帮帮我(
# 1 楼答案
正如@Nurzhan所建议的,您必须定义日期格式,然后使用它将日期解析为来自
resultSet
的String
。举个例子:输出将是: