Package com.bleujin.framework.db.procedure

Examples of com.bleujin.framework.db.procedure.IUserProcedure.addParam()

68
69
70
71
72
73
74
75
76
77
78
        UserProcedures case1 = dc.createUserProcedures("noneBatch") ;

        long start = System.currentTimeMillis() ;
        for (int i = 0, last = limit; i < last; i++) {
            IUserProcedure upt = dc.createUserProcedure("bleujin@lobTest(?,?,?)") ;
            upt.addParam(0, i); ;
            upt.addParam(1, "abcdefg"); ;
            upt.addClob(2, longString); ;
            case1.add(upt) ;
        }
        case1.execUpdate() ;
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
        long start = System.currentTimeMillis() ;
        for (int i = 0, last = limit; i < last; i++) {
            IUserProcedure upt = dc.createUserProcedure("bleujin@lobTest(?,?,?)") ;
            upt.addParam(0, i); ;
            upt.addParam(1, "abcdefg"); ;
            upt.addClob(2, longString); ;
            case1.add(upt) ;
        }
        case1.execUpdate() ;
        long end = System.currentTimeMillis() ;
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
        command.execUpdate() ;
    }

    public void xtestClobProcedure() throws Exception {
        IUserProcedure upt = dc.createUserProcedure("bleujin@lobTest2(?,?,?,?)") ;
        upt.addParam(0, 1); ;
        upt.addParam(1, "������"); ;
        upt.addClob(2, getLongString()); ;
        upt.addBlob(3, new FileInputStream("c:/temp/article.csv"));

        upt.execUpdate() ;
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
    }

    public void xtestClobProcedure() throws Exception {
        IUserProcedure upt = dc.createUserProcedure("bleujin@lobTest2(?,?,?,?)") ;
        upt.addParam(0, 1); ;
        upt.addParam(1, "������"); ;
        upt.addClob(2, getLongString()); ;
        upt.addBlob(3, new FileInputStream("c:/temp/article.csv"));

        upt.execUpdate() ;
    }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    for (int i = 0; i < 200; i++) {
      textString.append("01234567890123456789012345678901234567890123456789") ; // 10k
    }
    // insert into lob_sample(a, c) values(v_a, v_b) ;
    IUserProcedure upt = dc.createUserProcedure("Sample@insertLobWith(?,?)") ;
    upt.addParam(1).addClob(textString.toString()) ;
   
    assertEquals(1, upt.execUpdate()) ;
  }
 
 
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
        System.out.println("result="+result);
    }

    public void xtestClobBeforeProcedure() throws Exception {
        IUserProcedure upt = dc.createUserProcedure("bleujin@lobTest4(?,?,?)") ;
        upt.addParam(0, 1); ;
        upt.addParam(1, "������"); ;
        upt.addClob(2, getLongString()); ;

        upt.execUpdate() ;
    }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
 
  public void testGetClob() throws Exception {
    testSetClob() ;

    IUserProcedure upt = dc.createUserProcedure("Sample@selectLobBy(:a)") ;
    upt.addParam("a", 1);
   
    Rows rows = upt.execQuery();
    assertEquals(true, rows.firstRow().getString("c").length() > 9000) ;

    dc.execUpdate("delete from lob_sample") ;
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
    }

    public void xtestClobBeforeProcedure() throws Exception {
        IUserProcedure upt = dc.createUserProcedure("bleujin@lobTest4(?,?,?)") ;
        upt.addParam(0, 1); ;
        upt.addParam(1, "������"); ;
        upt.addClob(2, getLongString()); ;

        upt.execUpdate() ;
    }
View Full Code Here
17
18
19
20
21
22
23
24
25
26
27
  }
 
  public void testProcedure() throws Exception {
    IUserProcedure upt = dc.createUserProcedure("framework@viewPlan(?)") ;
    upt.setPage(Page.create(3, 1)) ;
    upt.addParam("select") ;
   
   
    Rows rows = dc.getRows(upt) ;
    Debug.debug(rows) ;
  }
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
    UserProcedures upts = dc.createUserProcedures("procedure batch") ;
    int max = 1000 ;
    for (int i = 0; i < max; i++) {
      IUserProcedure upt = dc.createUserProcedure(query) ;
      upt.addParam(0, RandomUtil.nextRandomString(25, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      upt.addParam(1, RandomUtil.nextRandomString(10, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      upt.addParam(2, RandomUtil.nextRandomString(10, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      upt.addParam(3, RandomUtil.nextRandomString(20, RandomUtil.DOWNCASE_CHAR_TYPE)) ;
      upt.addParam(4, "NORMAL") ;
      upt.addParam(5, RandomUtil.nextInt()) ;
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.