JAVA开发13--批量将数据insert插入oracle表

来源：互联网发布：白蜡杆淘宝编辑：程序博客网时间：2024/06/06 16:26

String sql_insert = "insert into T_BUDGET_FROM_OA(ENTITY,ACCOUNT,YEARS,PERIOD,PRODUCT,CYCLE,SCENARIO,VERSION,PROJECT,CUSTOM1,CUSTOM2,CUSTOM3,REVERSE1,REVERSE2,REVERSE3,DATA,DATA_TYPE,CREATED) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
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();

0 0