Examples of execQuery()

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

63
64
65
66
67
68
69
70
71
72
73

  public void testPage() throws Exception {
    final IUserCommand cmd = dc.createUserCommand("select * from millon_tblt") ;
    cmd.setPage(Page.TEN) ;
    Rows rows = cmd.execQuery();
   
    assertEquals(10, rows.getRowCount()) ;
  } 
 
  public void testProcedure() throws Exception {
View Full Code Here

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

80
81
82
83
84
85
86
87
88
89
90
 
  public void testHandleBean() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc") ;
    cmd.setPage(Page.TEN) ;
   
    List<TestBean> beans =  (List<TestBean>)(cmd.execQuery().toHandle(new BeanListHandler(TestBean.class))) ;
    assertEquals(10, beans.size()) ;
  }

 
  public void testHandleBeanProcedure() throws Exception {
View Full Code Here

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

123
124
125
126
127
128
129
130
131
132
133
 
  public void testNextPage() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc") ;
    cmd.setPage(Page.TEN) ;

    Rows rows = cmd.execQuery();
    assertEquals(10, rows.getRowCount()) ;
   
   
    Rows nextPageRows = rows.nextPageRows() ;
    assertEquals(11, nextPageRows.firstRow().getInt(2)) ;
View Full Code Here

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

35
36
37
38
39
40
41
42
43
44
45
 
 
  public void testParameter() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select ? from copy_sample") ;
    cmd.addParam(0, "abc") ; // start index of param is 0 (zero)
    Rows rows = cmd.execQuery() ;
   
    rows.next() ;
    assertEquals("abc", rows.getString(1)) ;
  }
 
View Full Code Here

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

11
12
13
14
15
16
17
18
19
20
21
 
  public void testDefaultLimit() throws Exception {
    dc.setLimitedRows(20) ;
    IUserCommand cmd = dc.createUserCommand(query1) ;
   
    Rows rows = cmd.execQuery() ;
    assertEquals(20, rows.getRowCount()) ;

    rows.absolute(20) ;
    assertEquals(20, rows.getInt("no2")) ;
  }
View Full Code Here

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

23
24
25
26
27
28
29
30
31
32
33
 
  public void testNextPage() throws Exception {
    IUserCommand cmd = dc.createUserCommand(query1) ;
    cmd.setPage(Page.create(10, 1)) ; 
   
    Rows rows = cmd.execQuery() ; // 1page
    assertEquals(10, rows.getRowCount()) ;
    assertEquals(1, rows.firstRow().getInt("no2")) ;
   
   
    Rows nextRows = rows.nextPageRows() ; // 2page
View Full Code Here

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

38
39
40
41
42
43
44
45
46
47
48
 
  public void testPrePage() throws Exception {
    IUserCommand cmd = dc.createUserCommand(query1) ;
    cmd.setPage(Page.create(10, 2)) ;  // 2page
   
    Rows rows = cmd.execQuery() ;
    assertEquals(10, rows.getRowCount()) ;
    assertEquals(11, rows.firstRow().getInt("no2")) ;
   
   
    Rows preRows = rows.prePageRows() ;  // 1page
View Full Code Here

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

6
7
8
9
10
11
12
13
14
15
public class TestModify extends DBTestCase{

  public void testCallMethod() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc") ;
   
    Rows rows = cmd.execQuery() ;
    Debug.debug(rows) ;
   
  }
}
View Full Code Here

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

39
40
41
42
43
44
45
46
47
48
49
    Thread[] ts = new Thread[20] ;
    for (int i = 0; i < ts.length; i++) {
      ts[i] = new Thread(){
        public void run(){
          try {
            cmd.execQuery();
          } catch (SQLException e) {
            e.printStackTrace();
          }
        }
      } ;
View Full Code Here

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