init

cy

2022-06-21 129904537f66509f97b285e7eb4f42b3dc349dd0

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
package cn.ksource.test.test;
 
import java.util.List;
import java.util.Map;
 
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
 
import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.util.DbPolicyUtil;
 
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("/applicationContext_core.xml")
public class ClearReportData {
 
    @Autowired
    private BaseDao baseDao;
    
    
    @Test
    public void clear() {
        baseDao.execute("delete from  REPORT_MAIN_TEMP", new SqlParameter());
        for (int i = 0; i < 30; i++) {
            baseDao.execute("delete from REPORT_INFO_ITEM"+ i +"", new SqlParameter());
            baseDao.execute("delete from REPORT_INFO_PRODUCT_TOTAL"+ i +"", new SqlParameter());
            baseDao.execute("delete from REPORT_INFO_PRODUCT"+ i +"", new SqlParameter());
        }
        baseDao.execute("delete from REPORT_EXCEPTION_INFO", new SqlParameter());
        baseDao.execute("delete from REPORT_EXCEPTION_LIST", new SqlParameter());
    }
}