From 2a5cdf98e669f724758865135f5fefabf7c8f185 Mon Sep 17 00:00:00 2001
From: ‘liusuyi’ <1951119284@qq.com>
Date: 星期一, 04 九月 2023 09:23:51 +0800
Subject: [PATCH] 井业务修改井号唯一性验证 电子围栏报警时间改为alarmTime
---
ard-work/src/main/java/com/ruoyi/test/ReadAccessDatabase.java | 65 ++++++++++++++++++--------------
1 files changed, 36 insertions(+), 29 deletions(-)
diff --git a/ard-work/src/main/java/com/ruoyi/test/ReadAccessDatabase.java b/ard-work/src/main/java/com/ruoyi/test/ReadAccessDatabase.java
index 7a69f81..4a93637 100644
--- a/ard-work/src/main/java/com/ruoyi/test/ReadAccessDatabase.java
+++ b/ard-work/src/main/java/com/ruoyi/test/ReadAccessDatabase.java
@@ -8,32 +8,37 @@
* @Version: 1.0
**/
-import com.ruoyi.app.position.domain.ArdAppPosition;
-import com.ruoyi.utils.websocket.util.WebSocketUtils;
+import com.ruoyi.common.utils.ConfigUtils;
+import com.ruoyi.common.utils.DictUtils;
+import com.ruoyi.common.utils.file.ImageUtils;
+import com.sun.imageio.plugins.common.ImageUtil;
import lombok.extern.slf4j.Slf4j;
+import org.springframework.stereotype.Component;
-import java.io.UnsupportedEncodingException;
-import java.nio.charset.StandardCharsets;
+import javax.annotation.PostConstruct;
import java.sql.*;
-import java.util.*;
-import java.util.concurrent.Executors;
-import java.util.concurrent.ScheduledExecutorService;
-import java.util.concurrent.TimeUnit;
+import java.util.Collection;
+import java.util.List;
+import java.util.Map;
+import java.util.Set;
+
@Slf4j
+@Component
public class ReadAccessDatabase {
public static void main(String[] args) {
-// // 澶氫釜鏁版嵁搴撴枃浠惰矾寰�
-// String[] dbPaths = {
-// "D:\\mdb\\閬撹矾涓績绾�.mdb",
-// "D:\\mdb\\闃查鏋�-鐏屾湪.mdb",
-// // 娣诲姞鏇村鐨勬暟鎹簱鏂囦欢璺緞
-// };
-//
-// // 閬嶅巻姣忎釜鏁版嵁搴撴枃浠�
-// for (String dbPath : dbPaths) {
-// readDataFromAccessDatabase(dbPath);
-// }
+
+ // 澶氫釜鏁版嵁搴撴枃浠惰矾寰�
+ String[] dbPaths = {
+ "D:\\Workspaces\\ard\\瀹夌憺杈惧伐浣滆祫鏂橽\mdb\\閬撹矾涓績绾�.mdb"
+// "D:\\Workspaces\\ard\\瀹夌憺杈惧伐浣滆祫鏂橽\mdb\\闃查鏋�-鐏屾湪.mdb",
+ // 娣诲姞鏇村鐨勬暟鎹簱鏂囦欢璺緞
+ };
+
+ // 閬嶅巻姣忎釜鏁版嵁搴撴枃浠�
+ for (String dbPath : dbPaths) {
+ readDataFromAccessDatabase(dbPath);
+ }
}
public static void readDataFromAccessDatabase(String dbPath) {
@@ -54,16 +59,16 @@
if (!tableName.equals("閬撹矾涓績绾�")) {
continue;
}
- System.out.println("琛ㄥ悕: " + tableName);
+ log.info("琛ㄥ悕: " + tableName);
// 鑾峰彇琛ㄧ殑瀛楁鍏冩暟鎹�
- // ResultSet column = metaData.getColumns(null, null, tableName, null);
+ ResultSet column = metaData.getColumns(null, null, tableName, null);
// 閬嶅巻瀛楁
-// while (column.next()) {
-// String columnName = column.getString("COLUMN_NAME");
-// System.out.println("瀛楁鍚�: " + columnName);
-// }
-// column.close();
+ while (column.next()) {
+ String columnName = column.getString("COLUMN_NAME");
+ log.info("瀛楁鍚�: " + columnName);
+ }
+ column.close();
// 鎵ц鏌ヨ鎿嶄綔
String sql = "SELECT * FROM " + tableName; // 鏇挎崲涓轰綘瑕佹煡璇㈢殑琛ㄥ悕
Statement statement = connection.createStatement();
@@ -72,12 +77,12 @@
while (resultSet.next()) {
// 璇诲彇姣忎竴琛屾暟鎹�
String id = resultSet.getString(1); // 鏍规嵁琛ㄤ腑鐨勫垪鍚嶈幏鍙栨暟鎹�
- String name = resultSet.getString("缂栧彿");
-
+ String no = resultSet.getString("缂栧彿");
+ String name = resultSet.getString("閬撹矾鍚嶇О");
// 鍙互鏍规嵁鍏蜂綋鐨勮〃缁撴瀯缁х画鑾峰彇鍏朵粬瀛楁鐨勬暟鎹�
// 鍦ㄨ繖閲屽鐞嗚幏鍙栧埌鐨勬暟鎹紝渚嬪杈撳嚭鍒版帶鍒跺彴鎴栦繚瀛樺埌闆嗗悎涓�
- System.out.println("ID: " + id + ", Name: " + name);
+ log.info("ID: " + id + ", No: " + no+ ", Name: " + name);
}
// 鍏抽棴杩炴帴
resultSet.close();
@@ -89,5 +94,7 @@
e.printStackTrace();
}
}
+
+
}
--
Gitblit v1.9.3