DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");
Date now = new Date();

IDatabaseConnection conDbUnit = new DatabaseConnection(jdbc);
ReplacementDataSet dataSet = new ReplacementDataSet(new XlsDataSet(new File(excel)));
dataSet.addReplacementSubstring("[SYSDATE]", df.format(now));
dataSet.addReplacementSubstring("[SYSDATE-1]", df.format(DateUtils.addDays(now, -1)));
dataSet.addReplacementSubstring("[SYSDATE+2]", df.format(DateUtils.addDays(now, +2)));
dataSet.addReplacementSubstring("[SYSDATE+4]", df.format(DateUtils.addDays(now, +4)));
DatabaseOperation.CLEAN_INSERT.execute(conDbUnit, dataSet);

Java#xUNIT


Last-modified: 2013-11-19 (火) 21:10:45 (4748d)
Short-URL: https://pukiwiki.at-sushi.com/pukiwiki/?cmd=s&k=8972687d28
ISBN10
ISBN13
9784061426061