Connection conn2 = DBUtil.getConnection();
PreparedStatement st2 = conn2.prepareStatement(sql_insert);
//下边可以加循环,赋值
Timestamp currentDateTime = new java.sql.Timestamp(System.currentTimeMillis());
st2.setString(1, "ysdycode"); //成本中心 ENTITY
st2.setString(2, "kmcode"); //科目 ACCOUNT
st2.setString(3, "year"); //年 YEARS
st2.setString(4, "month"); //月 PERIOD
st2.setString(5, "P99"); //产品 PRODUCT
st2.setString(6, "C001"); //周期 CYCLE
st2.setString(7, "S01"); //情景 SCENARIO
st2.setString(8, "V01"); //版本 VERSION
st2.setString(9, "P199"); //项目 PROJECT
st2.setString(10, "C107"); //自定义1 CUSTOM1
st2.setString(11, "C299"); //自定义2 CUSTOM2
st2.setString(12, "C399"); //自定义3 CUSTOM3
st2.setString(13, "S101"); //备用维1 REVERSE1
st2.setString(14, "S201"); //备用维2 REVERSE2
st2.setString(15, "S301"); //备用维3 REVERSE3
st2.setString(16, "je"); //数据DATA
st2.setString(17, data_type); //数据类型 DATA_TYPE
st2.setTimestamp(18, currentDateTime); //当前时间 CREATED
st2.addBatch();
//上边可以加循环,赋值
st2.executeBatch();
st2.close();
conn2.close();