Examples of IUserCommandBatch

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch

15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
    dc.execUpdate("drop table if exists copy_tblc") ;
    dc.execUpdate("create table copy_tblc(no1 varchar(4), no2 integer)") ;
    dc.execUpdate("alter table copy_tblc add primary key (no2)") ;
    dc.execUpdate("create unique index copy_idx on copy_tblc(no1)") ;
   
    IUserCommandBatch b = dc.createUserCommandBatch("insert into copy_tblc values(?, ?)") ;
   
    for(int i = 1 ; i <= 99 ; i++){
      b.addBatchParam(0, StringUtil.leftPad(i + "", 2, '0')) ;
      b.addBatchParam(1, i) ;
    }
   
    int result = b.execUpdate() ;
    Debug.debug(result);
  }
View Full Code Here

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch

63
64
65
66
67
68
69
70
71
72
73
74
75
76
  }
 
 
  public void testBatch() throws Exception {
   
    IUserCommandBatch cmd = dc.createUserCommandBatch("insert into performance_sample(a, b, c) values(?, ?, ?)") ;
    for (int i = 0; i < 10; i++) {
      cmd.addBatchParam(0, i) ;
      cmd.addBatchParam(1, "No." + i + ".....") ;
      cmd.addBatchParam(2, RandomUtil.nextRandomString(RandomUtil.nextRandomInt(10, 50), RandomUtil.NUMBER_CHAR_TYPE)) ;
    }
 
    cmd.execUpdate() ;
  }
View Full Code Here

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch

75
76
77
78
79
80
81
82
83
84
85
86
87
88
    cmd.execUpdate() ;
  }
 
  public void testNamedBatch() throws Exception {
   
    IUserCommandBatch cmd = dc.createUserCommandBatch("insert into performance_sample(a, b, c) values(:a, :b, :c)") ;
    for (int i = 0; i < 10; i++) {
      cmd.addBatchParam("a", i) ;
      cmd.addBatchParam("b", "No." + i + ".....") ;
      cmd.addBatchParam("c", RandomUtil.nextRandomString(RandomUtil.nextRandomInt(10, 50), RandomUtil.NUMBER_CHAR_TYPE)) ;
    }
   
    cmd.execUpdate() ;
  }
View Full Code Here

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch

22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
   * ��������� 10���Ǵ����� ��ġ ó���� ������ �� 10���� insert�� 1-3�� ������ �Ҹ�ȴ�.
   * P4_UserProcedurs���� �����ϴ� UserProcedures�� �⺻������ MDL���� �ٸ� �͵��� �ѹ��� �����Ҷ� ����Ѵ�.
   */
 
  public void testBatchDefault() throws Exception {
    IUserCommandBatch cmd = dc.createUserCommandBatch("insert into update_sample values(?, ?)") ;
   
    int max = 10 ;
    for (int i = 0; i < max; i++) {
      cmd.addBatchParam(0, i) ;
      cmd.addBatchParam(1, i + "th ..") ;
    }
   
    int count = cmd.execUpdate() ;
    assertEquals(max, count) ;
    cmd.clearParam() ; // param ojbect resource ��ȯ
  }
View Full Code Here

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch

37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
    cmd.clearParam() ; // param ojbect resource ��ȯ
  }
 

  public void testAddParamCase1() throws Exception {
    IUserCommandBatch cmd = dc.createUserCommandBatch("insert into update_sample values(?, ?)") ;
   
    int max = 10 ;
    int[] a = new int[max];
    String[] b = new String[max] ;
    for (int i = 0; i < max; i++) {
      a[i] = i ;
      b[i] = i + "th .." ;
    }
    cmd.addParam(a).addParam(b) ;
    int count = cmd.execUpdate() ;
    assertEquals(max, count) ;
  }
View Full Code Here

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch

53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
    assertEquals(max, count) ;
  }
 

  public void testAddParamCase2() throws Exception {
    IUserCommandBatch cmd = dc.createUserCommandBatch("insert into update_sample values(?, ?)") ;
   
    int max = 10 ;
    int[] a = new int[max];
    String[] b = new String[max] ;
    for (int i = 0; i < max; i++) {
      a[i] = i ;
      b[i] = i + "th .." ;
    }
   
    cmd.addParam(0, a) ;
    cmd.addParam(1, b) ;
    int count = cmd.execUpdate() ;
    assertEquals(max, count) ;
  }
View Full Code Here

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch

71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
    assertEquals(max, count) ;
  }

 
  public void testAddParamCase3() throws Exception {
    IUserCommandBatch cmd = dc.createUserCommandBatch("insert into update_sample values(?, ?)") ;
   
    int max = 10 ;
    int[] a = new int[max];
    for (int i = 0; i < max; i++) {
      a[i] = i ;
    }
   
    cmd.addParam(0, a) ;
    cmd.addParamSize(1, "SameValue", max) ;  // SameValue * max
    int count = cmd.execUpdate() ;
    assertEquals(max, count) ;
  }
View Full Code Here

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch

87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
    assertEquals(max, count) ;
  }

 
  public void testTransaction() throws Exception {
    IUserCommandBatch cmd = dc.createUserCommandBatch("insert into update_sample values(?, ?)") ;

    int max = 10 ;
    int[] a = new int[max];
    String[] b = new String[max] ;
    for (int i = 0; i < max; i++) {
      a[i] = i ;
      b[i] = i + "th .." ;
    }
    b[max-1] = "01234567890123546789" ; // over maxLength
   
   
    cmd.addParam(a).addParam(b) ;
   
    try {
      cmd.execUpdate() ;
      fail() ;
    } catch(SQLException ignore){
     
    }
View Full Code Here

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch

106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
        for (int i = 0, last = limit; i < last; i++) {
            a[i] = i ;
            b[i] = "abcdefg" ;
            c[i] = longString ;
        }
        IUserCommandBatch case2 = dc.createUserCommandBatch("insert into BLEU## values(?,?,?)") ;
        case2.addParam(0, a); ;
        case2.addParam(1, b); ;
        case2.addClob(2, c); ;
        case2.execUpdate() ;

        long end = System.currentTimeMillis() ;
        return end - start ;

    }
View Full Code Here

Examples of com.bleujin.framework.db.procedure.IUserCommandBatch

139
140
141
142
143
144
145
146
147
148
149
150
        upt.execUpdate() ;
    }

    public void xtestClobInsertBatch() throws Exception {
        IUserCommandBatch command = dc.createUserCommandBatch("insert into BLEU## values(?,?,?)") ;
        command.addParam(0, new int[]{1,2,3}); ;
        command.addParamSize(1, "abcdefg", 3); ;
        command.addClobSize(2, getLongString(), 3); ;

        command.execUpdate() ;
    }
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.