Package com.bleujin.framework.db.procedure

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch.execUpdate()

174
175
176
177
178
179
180
181
182
183
184
        command.addParam(0, new int[]{1,2,3}); ;
        command.addParamSize(1, "abcdefg", 3); ;
        command.addClobSize(2, getLongString(), 3);
        command.addBlobSize(3, "c:/temp/article.csv", 3);

        int result = command.execUpdate() ;
    }

    private String getLongString(){
        StringBuffer buffer = new StringBuffer() ;
        for (int i = 0, last = 500 ; i < last; i++) {
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
      for (int i = 0; i < unitCount; i++) {
        cmd.addBatchParam(0, k * unitCount + i) ;
        cmd.addBatchParam(1, "No." + (k * unitCount + i) + ".....") ;
        cmd.addBatchParam(2, RandomUtil.nextRandomString(RandomUtil.nextRandomInt(10, 50), RandomUtil.NUMBER_CHAR_TYPE)) ;
      }
      cmd.execUpdate() ;
      cmd.clearParam() ;
      assertEquals(true, unitCount > sw.getTime()) ;
      sw.stop() ;
      sw.reset() ;
      sw.start() ;
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
        // 10000 -> 4.1 sec
        // 100000 -> 33.547 sec
        batch.addBatchParam(0, i + " Batch ..............................................................................................................") ;
      }
      Debug.line() ;
      batch.execUpdate() ;
      batch.clearParam() ;
    }
  }

 
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
        a[j] = j + i * iMax + aMax + 1;
        b[j] = "0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789:" + j;
      }
      batch.addParam(a).addParam(b);

      batch.execUpdate();
    }
    watch.stop();
    System.out.println("time(ms):" + watch.getTime());
  }

View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
      batch.addBatchParam(5, RandomUtil.nextInt()) ;
      batch.addBatchParam(6, RandomUtil.nextRandomString(12, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      batch.addBatchParam(7, RandomUtil.nextRandomString(10, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      batch.addBatchParam(8, RandomUtil.nextInt()) ;
    }
    batch.execUpdate() ;
    dc.destroySelf() ;
  }


  public void testProcedureBatch() throws Exception {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.