ADD CSV

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);


}