Package com.bleujin.framework.db.procedure

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

47
48
49
50
51
52
53
54
55
56
57
 
  public void testProcedure() throws Exception {
    IUserProcedure upt = dc.createUserProcedure("framework_test_select()") ;
    upt.setPage(Page.create(5, 1)) ;
   
    Rows rows = upt.execQuery() ;
    while(rows.next()){
      Debug.debug(rows.getString(1)) ;
    }
      assertEquals(5, rows.getRowCount()) ;
    }
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
 
  public void testProcedure() throws Exception {
    IUserProcedure cmd = dc.createUserProcedure("common@testBy()") ;
    cmd.setPage(Page.TEN) ;
   
    Rows rows = cmd.execQuery();
    assertEquals(10, rows.getRowCount()) ;
  }
 
  public void testHandleBean() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc") ;
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
 
  public void testHandleBeanProcedure() throws Exception {
    IUserProcedure cmd = dc.createUserProcedure("common@testBy()") ;
    cmd.setPage(Page.TEN) ;
   
    List<TestBean> beans =  (List<TestBean>)(cmd.execQuery().toHandle(new BeanListHandler(TestBean.class))) ;
    assertEquals(10, beans.size()) ;
  }
 
  public void test2Page() throws Exception {
    IUserProcedure cmd = dc.createUserProcedure("common@testBy()") ;
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
 
  public void test2Page() throws Exception {
    IUserProcedure cmd = dc.createUserProcedure("common@testBy()") ;
    cmd.setPage(Page.create(10, 2)) ;
   
    Rows rows = cmd.execQuery();
    assertEquals(10, rows.getRowCount()) ;
    Debug.debug(rows) ;
  }
 
  public void testUserProcedures() throws Exception {
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    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
20
21
22
23
24
25
26
27
28
29
30
    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
64
65
66
67
68
69
70
71
72
73
74
    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
10
11
12
13
14
15
16
17
18
19
20
  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);
  }

  public void testMultiCall() throws Exception {
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
          try {
            Debug.debug("start date :", new Date());
            IUserProcedure cmd = dc.createUserProcedure("common@sleepBy()");
            cmd.setPage(Page.create(10, 2));

            Rows rows = cmd.execQuery();
            Debug.debug("end date :", new Date());
          } catch (SQLException ignore) {

          }
        }
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.