From 49f9bf946cc43ee5a3803da08f6ab30365ce2989 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期五, 31 五月 2024 18:08:19 +0800
Subject: [PATCH] 创建表和插入数据时增加记录时间
---
src/main/java/com/example/utils/DictionaryUtil.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/example/utils/DictionaryUtil.java b/src/main/java/com/example/utils/DictionaryUtil.java
index ad8c6ee..cc581e0 100644
--- a/src/main/java/com/example/utils/DictionaryUtil.java
+++ b/src/main/java/com/example/utils/DictionaryUtil.java
@@ -15,7 +15,9 @@
import java.net.URL;
import java.nio.charset.StandardCharsets;
import java.sql.*;
+import java.text.SimpleDateFormat;
import java.util.ArrayList;
+import java.util.Date;
import java.util.List;
import java.util.Map;
@@ -437,6 +439,9 @@
valueBuilder.append("'").append(entry.getValue()).append("', ");
selectSqlBuilder.append(entry.getKey()).append(" = '").append(entry.getValue()).append("' and ");
}
+ insertSqlBuilder.append("insert_time, ");
+ String time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
+ valueBuilder.append("'").append(time).append("'").append(", ");
insertSqlBuilder.delete(insertSqlBuilder.length() - 2, insertSqlBuilder.length());
valueBuilder.delete(valueBuilder.length() - 2, valueBuilder.length());
selectSqlBuilder.delete(selectSqlBuilder.length() - 5, selectSqlBuilder.length());
@@ -491,6 +496,7 @@
for (Map.Entry<String, Object> entry : resultDataIndex1.entrySet()) {
sql.append(entry.getKey()).append(" text null,");
}
+ sql.append("insert_time").append(" text null,");
sql = new StringBuilder(sql.substring(0, sql.length() - 1));
sql.append(");");
// log.info("鍒涘缓琛ㄦ牸 -> {}",sql.toString());
--
Gitblit v1.8.0