1.
Copy another CSV,
change it to a fit name,
move it to a fit location(project.package).
2. @BeforeClass
public static void setUpOnce() {
/**mockDataGenerationUtil = new MockDataGenerationUtil(
* "net/atpco/dds/offline/distribution/task/TestDistributionAdhocControllerTask.xml");**/
dbDataGenerationUtil = new DBDataGenerationUtil(
"/net/atpco/dds/offline/distribution/task/testDistributionAdhocControllerTask.csv");
}
****Take care: XML:"net/atpco..."and CSV:"/net/atpco..."
XML:"new MockDataGenerationUtil("...");" and CSV: " new DBDataGenerationUtil("...")"
3. @Test
public void testBuildControllerResponseEventSuccess() throws Exception{
...
...
//1.清除
//2.把CSV文件插入到数据库,提交
try {
CommonUtil.cleanWorKUnitAndChildTables(jdbcTemplate, wuOrgCD,
wuCreateDT, wuIDNum);
} catch (Exception e) {
LOGGER.error(e);
}
dbDataGenerationUtil.exceuteStatementWithoutClean("WORK_UNIT_ADH4",
jdbcTemplate);
dbDataGenerationUtil.exceuteStatementWithoutClean("ALL_ADD_CS_ADH4",
jdbcTemplate);
dbDataGenerationUtil.exceuteStatementWithoutClean("ALL_ADD_QRY_CTRIA_ADH4",
jdbcTemplate);
CommonUtil.commitCommond(jdbcTemplate);
//3.从数据库中取出 从CSV中插入到数据库中的某一数据
//******每次更改CSV,就相当于更改数据库的数据***************************
Integer workUnitSg = CommonUtil.getWorkUnitSg(jdbcTemplate, wuOrgCD,
wuCreateDT, wuIDNum);
}
change it to a fit name,
move it to a fit location(project.package).
2. @BeforeClass
public static void setUpOnce() {
/**mockDataGenerationUtil = new MockDataGenerationUtil(
* "net/atpco/dds/offline/distribution/task/TestDistributionAdhocControllerTask.xml");**/
dbDataGenerationUtil = new DBDataGenerationUtil(
"/net/atpco/dds/offline/distribution/task/testDistributionAdhocControllerTask.csv");
}
****Take care: XML:"net/atpco..."and CSV:"/net/atpco..."
XML:"new MockDataGenerationUtil("...");" and CSV: " new DBDataGenerationUtil("...")"
3. @Test
public void testBuildControllerResponseEventSuccess() throws Exception{
...
...
//1.清除
//2.把CSV文件插入到数据库,提交
try {
CommonUtil.cleanWorKUnitAndChildTables(jdbcTemplate, wuOrgCD,
wuCreateDT, wuIDNum);
} catch (Exception e) {
LOGGER.error(e);
}
dbDataGenerationUtil.exceuteStatementWithoutClean("WORK_UNIT_ADH4",
jdbcTemplate);
dbDataGenerationUtil.exceuteStatementWithoutClean("ALL_ADD_CS_ADH4",
jdbcTemplate);
dbDataGenerationUtil.exceuteStatementWithoutClean("ALL_ADD_QRY_CTRIA_ADH4",
jdbcTemplate);
CommonUtil.commitCommond(jdbcTemplate);
//3.从数据库中取出 从CSV中插入到数据库中的某一数据
//******每次更改CSV,就相当于更改数据库的数据***************************
Integer workUnitSg = CommonUtil.getWorkUnitSg(jdbcTemplate, wuOrgCD,
wuCreateDT, wuIDNum);
}