Package com.bleujin.framework.db.procedure

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

247
248
249
250
251
252
253
254
255
   

   
    // **** impl
    public IUserProcedure createUserProcedure(String proc) {
        IUserProcedure upt = getService().createUserProcedure(this, proc);
        upt.setPage(Page.create(getLimitedRows(), 1)) ;
        return upt ;
    }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
    IUserCommand cmd = dc.createUserCommand("delete from update_sample") ;
    cmd.execUpdate() ;
  }
 
  public void testProcedureUpdate() throws Exception {
    IUserProcedure upt = dc.createUserProcedure("Sample@insertWith(?,?)") ;
    upt.addParam(1).addParam("abc") ;
   
    upt.execUpdate() ;
  }
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
59
60
  }
 
  public void testProcedureQuery() throws Exception {
    testProcedureUpdate() ;
   
    IUserProcedure upt = dc.createUserProcedure("Sample@selectBy(?)") ;
    upt.addParam(1);
   
    Rows rows = upt.execQuery() ;
   
    assertEquals(1, rows.getRowCount()) ;
    assertEquals("abc", rows.firstRow().getString("b")) ;
  }
View Full Code Here
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
 
  public void testDefault() throws Exception {
   
    // example 1
    DBController dc = DBController.getTestInstance() ;
    IUserProcedure u1 = dc.createUserProcedure("emp@add(?,?)") ;
    u1.addParam(110).addParam("bleujin") ;
    u1.execUpdate() ;

    // example
    IUserProcedure u2 = dc.createUserProcedure("emp@list()") ;
    Rows rows = u2.execQuery() ;
    while(rows.next()){
      rows.getString("name") ;
    }
  }
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
78
79
80
    private long execProcedureArray(int limit, String longString) throws SQLException {
        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() ;
        long end = System.currentTimeMillis() ;
        return end - start ;
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
140
141
        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
51
52
53
54
55
56
57
58
59
60
    StringBuilder textString = new StringBuilder() ;
    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
158
159
160
161
162
163
164
165
166
167
168
169
        int result = batch.execUpdate() ;
        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
61
62
63
64
65
66
67
68
69
70
71
72
73
 
 
  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
7
8
9
10
11
12
13
14
15
16
17
18
import com.bleujin.framework.util.Debug;

public class TestThread extends DBTestCase {

  public void testSleep() throws Exception {
    IUserProcedure cmd = dc.createUserProcedure("common@sleepBy()");
    cmd.setPage(Page.create(10, 2));

    Rows rows = cmd.execQuery();
    assertEquals(10, rows.getRowCount());
    Debug.debug(rows);
  }
View Full Code Here
TOP

Related Classes of com.bleujin.framework.db.procedure.IUserProcedure

  • com.bleujin.dbfs.common.JSONParser
  • com.bleujin.framework.db.DBController
  • com.bleujin.framework.db.function.TestPage
  • com.bleujin.framework.db.h2.TestH2ChainProcedure
  • com.bleujin.framework.db.mssql.TestSQL2005
  • com.bleujin.framework.db.mysql.TestFirst
  • com.bleujin.framework.db.sample.extend.NamedParameter
  • com.bleujin.framework.db.sample.first.P4_UserProcedure
  • com.bleujin.framework.db.sample.rows.RowsGet
  • com.bleujin.framework.db.servant.TraceOfLateProcServant
    • Copyright © 2018 www.massapicom. 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.