package cn.ksource.test;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
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 org.springframework.transaction.annotation.Transactional;
|
|
import cn.ksource.core.dao.BaseDao;
|
import cn.ksource.core.dao.SqlParameter;
|
import cn.ksource.core.util.StringUtil;
|
|
@RunWith(SpringJUnit4ClassRunner.class)
|
@ContextConfiguration("/applicationContext_core.xml")
|
public class InPutData {
|
|
@Autowired
|
private BaseDao baseDao;
|
|
@Test
|
public void testInput() throws Exception {
|
String sql = "insert into REPORT_DATE_CONFIG (ID,YEAR,MONTH,END_TIME) values(:ID,:YEAR,:MONTH,:END_TIME)";
|
List<SqlParameter> paramList = new ArrayList<SqlParameter>();
|
|
for (int year = 2014; year < 2025; year++) {
|
for (int month = 1; month < 13; month++) {
|
paramList.add(new SqlParameter("ID",StringUtil.getUUID()).addValue("YEAR", year).addValue("MONTH", month)
|
.addValue("END_TIME", 10));
|
}
|
}
|
|
baseDao.executeBatch(sql, paramList);
|
}
|
}
|
