From bf5b01b14dc7bfc214e646425a62f5593890d7e3 Mon Sep 17 00:00:00 2001
From: jinlin <jinlin>
Date: 星期六, 08 十一月 2025 22:05:37 +0800
Subject: [PATCH] 清洗数据库日期错误，并且导入日期通用化处理
---
src/main/java/com/example/client/service/ImportDataService.java | 28 +++++++++++++++++++---------
1 files changed, 19 insertions(+), 9 deletions(-)
diff --git a/src/main/java/com/example/client/service/ImportDataService.java b/src/main/java/com/example/client/service/ImportDataService.java
index eb77b26..f17b5cb 100644
--- a/src/main/java/com/example/client/service/ImportDataService.java
+++ b/src/main/java/com/example/client/service/ImportDataService.java
@@ -39,6 +39,8 @@
public JPanel FileUpload(JFrame frame, Integer width, Integer heigth) {
JPanel jPanel = new JPanel();
+ /*GridBagLayout layout = new GridBagLayout();
+ jPanel.setLayout(layout);*/
jPanel.setPreferredSize(new Dimension(width, heigth));
JTable table = new JTable();
@@ -48,13 +50,15 @@
JScrollPane scrolltable = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_ALWAYS, JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
-
+ scrolltable.setPreferredSize(new Dimension(width-150,heigth));
scrolltable.setViewportView(table);
scrolltable.getViewport().setBackground(Color.WHITE);
JButton browseButton = new JButton("閫夋嫨鏂囦欢");
- jPanel.add(browseButton);
+
jPanel.add(scrolltable);
+ jPanel.add(browseButton);
+
browseButton.addActionListener(new ActionListener() {
@Override
@@ -110,8 +114,8 @@
model.setDataVector(data, columnIdentifiers);
table.setModel(model);
- table.getColumnModel().getColumn(0).setPreferredWidth(600);
- table.getColumnModel().getColumn(1).setPreferredWidth(100);
+ table.getColumnModel().getColumn(0).setPreferredWidth(550);
+ table.getColumnModel().getColumn(1).setPreferredWidth(150);
table.getColumnModel().getColumn(0).setCellRenderer(new TableViewRenderer());
@@ -161,8 +165,8 @@
}
model.setDataVector(data, columnIdentifiers);
table.setModel(model);
- table.getColumnModel().getColumn(0).setPreferredWidth(650);
- table.getColumnModel().getColumn(1).setPreferredWidth(80);
+ table.getColumnModel().getColumn(0).setPreferredWidth(550);
+ table.getColumnModel().getColumn(1).setPreferredWidth(150);
table.getColumnModel().getColumn(0).setCellRenderer(new TableViewRenderer());
table.getColumnModel().getColumn(1).setCellRenderer(new TableCellRendererButton());
@@ -186,16 +190,21 @@
});
return jPanel;
}
- public String UnzipFile(){
+ public String UnzipFile(JTextArea tips){
+ String massage = "";
String filePath = model.getValueAt(0, 0).toString();
String outputDirectory = UnzipPath;
try {
File zipFile = new File(filePath);
if (!zipFile.exists()) {
+ massage = "ZIP鏂囦欢涓嶅瓨鍦細" + filePath;
+ tips.setText(tips.getText() + massage);
throw new FileNotFoundException("ZIP鏂囦欢涓嶅瓨鍦細" + filePath);
}
if (!zipFile.canRead()) {
+ massage = "鏃犳硶璇诲彇ZIP鏂囦欢锛岃妫�鏌ユ枃浠舵潈闄愶細" + filePath;
+ tips.setText(tips.getText() + massage);
System.err.println("鏃犳硶璇诲彇ZIP鏂囦欢锛岃妫�鏌ユ枃浠舵潈闄愶細" + filePath);
return "false";
}
@@ -236,8 +245,9 @@
}
}
}
- System.out.println("鏂囦欢瑙ｅ帇瀹屾垚锛岀洰鏍囩洰褰曪細" + outputDirectory);
- dataSyncService.importData();
+ massage = "鏂囦欢瑙ｅ帇瀹屾垚锛岀洰鏍囩洰褰曪細" + outputDirectory;
+ tips.setText(tips.getText() + massage);
+ dataSyncService.importData(tips);
} catch (IOException e) {
e.printStackTrace();
return "false";
--
Gitblit v1.9.1