67,513
社区成员
发帖
与我相关
我的任务
分享
public static List ls3 = new ArrayList<>();
public static void main(String[] args) {
cronJob(15, 00, 00);
cronJob(15, 01, 00);
}
public static void cronJob(int shi, int fen, int miao) {
Calendar cal = Calendar.getInstance();
// 每天定点执行
cal.set(Calendar.HOUR_OF_DAY, shi);
cal.set(Calendar.MINUTE, fen);
cal.set(Calendar.SECOND, miao);
Timer timer = new Timer();
timer.schedule(new TimerTask() {
public void run() {
Workbook wb = null;
Sheet sheet = null;
Row row = null;
List<Map<String, String>> list = null;
String cellData = null;
String files = "C:\\Users\\Administrator\\Desktop\\tt";
File file = new File(files);
// 取得文件列表
File[] dir = file.listFiles();
// 删除单条数据
if (ls3.size() > 0) {
for (int l = 0; l < ls3.size(); l++) {
Map<String, String> deleteResult = api.deleteData((String) ls3.get(l));
System.out.println("删除单条数据:");
System.out.println(deleteResult);
}
}
// 遍历文件夹下的所有文件
for (int i = 0; i < dir.length; i++) {
// 取得文件名称
String filePath = files + "\\" + dir[i].getName();
String columns[] = { "Shift&Line", "Order No", "Item No.", "Mat des", "MRP ctrlor", "Group",
"Priority", "order qty.", "output", "plan hours", "Operators", "Credit Time", "Start Date",
"Start time", "Weight", "Week", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun", "Remark" };
wb = readExcel(filePath);
if (wb != null) {
// 用来存放表中数据
list = new ArrayList<Map<String, String>>();
// 获取第一个sheet
sheet = wb.getSheetAt(0);
// 获取最大行数
int rownum = sheet.getPhysicalNumberOfRows();
// 获取第一行
row = sheet.getRow(0);
// 获取最大列数
int colnum = row.getPhysicalNumberOfCells();
for (int j = 1; j < rownum; j++) {
Map<String, String> map = new LinkedHashMap<String, String>();
row = sheet.getRow(j);
if (row != null) {
cellData = (String) getCellFormatValue(row.getCell(0));
if ("Shift&Line".equals(cellData) || "".equals(cellData)) {
continue;
}
for (int k = 0; k < colnum; k++) {
cellData = (String) getCellFormatValue(row.getCell(k));
map.put(columns[k], cellData);
}
} else {
break;
}
list.add(map);
}
}
// 遍历解析出来的list
final List<String> ls2 = new ArrayList<String>();
for (Map<String, String> map : list) {
for (Entry<String, String> entry : map.entrySet()) {
ls2.add(entry.getValue());
}
}
// 拆分
List<List<String>> result = createList(ls2, 24);
// 创建单条数据
for (int m = 0; m < (ls2.size() / 24); m++) {
List ls = new ArrayList<>();
for (int n = 0; n < 24; n++) {
ls.add(result.get(m).get(n));
}
Map<String, Object> create = new HashMap<String, Object>() {
{
// 线号
put("_widget_1526028234352", new HashMap<String, Object>() {
{
put("value", ls.get(0));
}
});
。
。省略
。
// Sun
put("_widget_1530256865998", new HashMap<String, Object>() {
{
put("value", ls.get(22));
}
});
// Remark
put("_widget_1526026292045", new HashMap<String, Object>() {
{
put("value", ls.get(23));
}
});
}
};
Map<String, Object> createData = api.createData(create);
ls3.add(createData.get("_id"));
System.out.println("创建单条数据:");
System.out.println(createData);
}
}
}
}, cal.getTime(), 24 * 60 * 60 * 1000);
}