oracle表新建序列ID自增长

  1. create table "N_AS_RECORD"
  2. (
  3.     "AS_ID"        number(12) not null
  4.         constraint SEQ_N_AS_RECORD_AS_ID primary key,
  5.     "PT_ID"        number(12),
  6.     "AS_CREATOR"   number(12),
  7.     "AS_DP"        number(12),
  8.     "AS_TYPE"      char(2),
  9.     "AS_UNIT_NAME" CHAR(10),
  10.     "AS_TIME"      date,
  11.     "AS_MODEL_ID"  number(12)
  12. )
  13. /
  14. -- 创建序列
  15.   -- SEQ_N_AS_RECORD_AS_ID 序列名
  16. create sequence SEQ_N_AS_RECORD_AS_ID
  17.     increment by 1    -- 每次递增1
  18.     start with 1       -- 从1开始
  19.     nomaxvalue      -- 没有最大值
  20.     minvalue 1       -- 最小值=1
  21.     NOCYCLE;      -- 不循环
  22. /
  23. -- 创建触发器
  24.   -- "trig" 触发器名
  25.   -- N_AS_RECORD 表名
  26.   -- SEQ_N_AS_RECORD_AS_ID 序列名
  27.   -- AS_ID 要自增的字段名
  28. create or replace trigger "trig"
  29.     before insert on N_AS_RECORD
  30.     for each row
  31. begin
  32.     select SEQ_N_AS_RECORD_AS_ID.nextval into :new.AS_ID from dual;
  33. end;

oracle java批量插入

  1. public interface GOODService {
  2.     public void batchInsertGOOD_CUSTOM(BRAND bRAND,SHELL sHELL) throws IOException;
  3. }
  4. public class GOODServiceImpl implements GOODService {
  5.   @Override
  6.     public void batchInsertGOOD(BRAND bRAND, SHELL sHELL) throws IOException {
  7.         String[] good_string = null;
  8.         Integer CATEGORY_ID = 1;
  9.         for (int i = 0; i < 100000; i++) {
  10.             GOOD good = new GOOD();
  11.             good.setBRAND_ID(bRAND.getID());
  12.             good.setBRAND_UUID(bRAND.getBRAND_ID());
  13.             good.setSELLER_ID(sHELL.getID());
  14.             good.setSELLER_UUID(sHELL.getSHELL_ID());
  16.             if(i%500==0){
  17.                 good_string = CustomUtil.readTargetFileNum(RandomUtil.randomInt(1, 15),StrUtil.trim(bRAND.getBRAND_JC()));
  18.             String CATEGORY_Str = good_string[0];
  19.             if(CATEGORY_Str.equals("手机")){
  20.                 CATEGORY_ID=1;
  21.             }else if(CATEGORY_Str.equals("电脑")){
  22.                 CATEGORY_ID=2;
  23.             }
  24.             }
  25.             //产品类型
  26.             good.setCATEGORY_ID(CATEGORY_ID);
  28.             good.setGOOD_ID(CustomUtil.getUUID());
  29.             good.setNAME(i+good_string[2]);
  30.             good.setPRICE(new BigDecimal(good_string[1]));
  31.             good.setGOOD_DESC("这时商品介绍---"+i+"----"+good_string[2]);
  32.             good.setIS_DELETE(0);
  33.             gOODMapper.insert(good);
  34.         }
  36.     }
  38. }
  40. public interface GOODMapper extends BaseMapper<GOOD> {
  41.     void batchInsertList(List<GOOD> goodsList);
  42. }
  1.     <insert id="batchInsertList" parameterType="java.util.List" useGeneratedKeys="false">
  2.         insert into DM_GOODS(GOOD_ID, "NAME",PRICE,GOOD_DESC,BRAND_ID, BRAND_UUID, CATEGORY_ID, SELLER_ID, SELLER_UUID, IS_DELETE)
  4.         <foreach collection="goodsList" item="good" separator="union all">
  5.             select
  7.                 #{good.GOOD_ID,jdbcType=INTEGER},#{good.NAME,jdbcType=VARCHAR},#{good.PRICE,jdbcType=DOUBLE},#{good.GOOD_DESC,jdbcType=VARCHAR},
  8.                 #{good.BRAND_ID,jdbcType=INTEGER},#{good.BRAND_UUID,jdbcType=VARCHAR},#{good.CATEGORY_ID,jdbcType=VARCHAR},
  9.                 #{good.SELLER_ID,jdbcType=INTEGER},#{good.SELLER_UUID,jdbcType=VARCHAR},#{good.IS_DELETE,jdbcType=VARCHAR}
  11.             from dual
  12.         </foreach>
  13.     </insert>