Examples of execQuery()

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

112
113
114
115
116
117
118
119
120
121
122
    IUserProcedure upt = dc.createUserProcedure("common@testBy()") ;
    upt.setPage(Page.create(10, 2)) ;
   
    upts.add(cmd).add(upt) ;
   
    Rows rows = upts.execQuery() ;
    assertEquals(10, rows.getRowCount()) ;
   
    Rows nextRows = rows.getNextRows() ;
    assertEquals(10, nextRows.getRowCount()) ;
  }
View Full Code Here

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

40
41
42
43
44
45
46
47
48
49
50
    IUserCommand cmd2 = dc.createUserCommand("select 3 from dept_sample") ;
   
    UserProcedures upts = dc.createUserProcedures("Multi Query") ;
    upts.add(cmd1).add(cmd2) ;
   
    Rows first = upts.execQuery() ;  // first query result ;
    assertEquals(true, first.getRowCount() == 10) ;
   
    Rows second = first.getNextRows() ; // second query result ;
    assertEquals(3, second.firstRow().getInt(1)) ;
   
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.