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/utils/CommonTable.java | 20 ++++++++++++++++----
1 files changed, 16 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/example/client/utils/CommonTable.java b/src/main/java/com/example/client/utils/CommonTable.java
index 6321b72..84892be 100644
--- a/src/main/java/com/example/client/utils/CommonTable.java
+++ b/src/main/java/com/example/client/utils/CommonTable.java
@@ -45,6 +45,7 @@
public static void setColumnType(List<ColumnDto> dtoList, JTable table) {
for (int j = 0; j < dtoList.size(); j++) {
table.getColumnModel().getColumn(j).setPreferredWidth(dtoList.get(j).getColumnWidth());
+ table.getColumnModel().getColumn(j).setMinWidth(2);
if (dtoList.get(j).getButtonList() != null) {
CreateTableButton.AcceptRejectRenderer renderer = new CreateTableButton.AcceptRejectRenderer(dtoList.get(j).getButtonList());
table.getColumnModel().getColumn(j).setCellRenderer(renderer);
@@ -62,7 +63,7 @@
});
table.getColumnModel().getColumn(j).setCellEditor(new DatePickerEditor(datePicker));
}
- if ("dict".equals(dtoList.get(j).getColumnType())) {
+ if ("dict".equals(dtoList.get(j).getColumnType()) || "dicts".equals(dtoList.get(j).getColumnType())) {
Map<Long, JComboBoxItem> itemMap = new HashMap<>();
JComboBoxItem[] dictList = dtoList.get(j).getDictList();
for (JComboBoxItem item : dictList) {
@@ -86,6 +87,9 @@
});
table.getColumnModel().getColumn(j).setCellRenderer(new CellComboBoxRenderer(itemMap));
table.getColumnModel().getColumn(j).setCellEditor(new CellComboBoxEditor(comboBox, itemMap));
+ }
+ if ("Circle".equals(dtoList.get(j).getColumnType())) {
+ table.getColumnModel().getColumn(j).setCellRenderer(new CircleRenderer());
}
}
}
@@ -117,6 +121,10 @@
if (StringUtils.isBlank(dtoList.get(j).getColumnType()) || dtoList.get(j).getColumnType().equals("selectDate")) {
rowData[i][j] = valueStr;
} else if (dtoList.get(j).getColumnType().equals("dict")) {
+ rowData[i][j] = valueStr;
+ } else if (dtoList.get(j).getColumnType().equals("dicts")) {
+ rowData[i][j] = valueStr;
+ } else if (dtoList.get(j).getColumnType().equals("Circle")) {
rowData[i][j] = valueStr;
} else if (dtoList.get(j).getColumnType().equals("autoCreate")) {
rowData[i][j] = "" + (i + 1);
@@ -151,16 +159,18 @@
if (StringUtils.isNotBlank(fieldName)) {
if ("dict".equals(dtoList.get(j).getColumnType())) {
method = c1azz.getMethod("set" + StringUtils.capitalize(fieldName), Long.class);
+ } else if ("dicts".equals(dtoList.get(j).getColumnType())) {
+ method = c1azz.getMethod("set" + StringUtils.capitalize(fieldName), Integer.class);
} else {
method = c1azz.getMethod("set" + StringUtils.capitalize(fieldName), String.class);
}
Object value = table.getModel().getValueAt(i, j);
- if (value != null) {
+ if (value != null && !value.equals("") ) {
if ("selectDate".equals(dtoList.get(j).getColumnType())) {
method.invoke(object, value.toString());
System.out.println(value.toString().length());
String valueStr = value.toString();
- Method method2 = c1azz.getMethod("set" + StringUtils.capitalize(fieldName) + "Digit", Long.class);
+ //Method method2 = c1azz.getMethod("set" + StringUtils.capitalize(fieldName) + "Digit", Long.class);
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
Date date = null;
try {
@@ -169,9 +179,11 @@
e.printStackTrace();
}
Long timestamp = date.getTime();
- method2.invoke(object, timestamp);
+ // method2.invoke(object, timestamp);
} else if ("dict".equals(dtoList.get(j).getColumnType())) {
method.invoke(object, Long.parseLong(value.toString()));
+ } else if ("dicts".equals(dtoList.get(j).getColumnType())) {
+ method.invoke(object, Integer.valueOf(value.toString()));
} else {
method.invoke(object, value.toString());
}
--
Gitblit v1.9.1