Package com.bleujin.framework.db.procedure

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

7
8
9
10
11
12
13
14
15
16
17
public class TestPage extends MySQLMother{

  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 testLimit() throws Exception {
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
  }
 
  public void testLimit() throws Exception {
    final IUserCommand cmd = dc.createUserCommand("select * from millon_tblt limit ?,?") ;
    cmd.addParam(10).addParam(10) ;
    Rows rows = cmd.execQuery();
   
    assertEquals(10, rows.getRowCount()) ;
  }
 
 
View Full Code Here
8
9
10
11
12
13
14
15
  public void testParameter() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from millon_tblt limit ?");
    cmd.addParam(10) ;

    Debug.debug(cmd) ;
    Debug.debug(cmd.execQuery().firstRow());
  }
}
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
  public void testRowsPageMethod2() throws Exception {
    String query = "select * from copy_sample" ;
   
    IUserCommand cmd = dc.createUserCommand(query) ;
    cmd.setPage(Page.create(1, 1)) ;
    Rows rows = cmd.execQuery() ;
    assertEquals(1, rows.getRowCount()) ;
  }

 
 
View Full Code Here
18
19
20
21
22
23
24
25
26
27
28
 
  public void testNamedParameter() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_sample where no1 >= :no1 and no1 <= :no1") ;
    cmd.addParam("no1", 20) ;
   
    Rows rows = cmd.execQuery() ;
    assertEquals(1, rows.getRowCount()) ;
 
  }

  public void testNamedParameterConflict() throws Exception {
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
  public void testNamedParameterConflict() throws Exception {
    try {
      IUserCommand cmd = dc.createUserCommand("select ':abc' from copy_sample where no1 >= :no1 and no1 <= :no1") ;
      cmd.addParam("no1", 20) ;
      cmd.execQuery() ;
      fail() ;
    } catch (IllegalArgumentException ignore){}

    IUserCommand cmd = dc.createUserCommand("select 'a:1' from copy_sample where no1 >= :no1 and no1 <= :no1") ;
    cmd.addParam("no1", 20) ;
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
    } catch (IllegalArgumentException ignore){}

    IUserCommand cmd = dc.createUserCommand("select 'a:1' from copy_sample where no1 >= :no1 and no1 <= :no1") ;
    cmd.addParam("no1", 20) ;

    Rows rows = cmd.execQuery() ;
    assertEquals(1, rows.getRowCount()) ;
  }

  public void testNamedParameter2() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_sample where no1 >= ? and no1 <= :no1") ;
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
  public void testNamedParameter2() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_sample where no1 >= ? and no1 <= :no1") ;
    cmd.addParam(0, 19) ;
    cmd.addParam("no1", 20) ;
   
    Rows rows = cmd.execQuery() ;
    assertEquals(2, rows.getRowCount()) ;
  }
 
 
 
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
    assertEquals(0, page.getStartLoc()) ;
  }
 
  public void testDefault() throws Exception {
    IUserCommand cmd = dc.createUserCommand("select * from copy_tblc") ;
    Rows rows = cmd.execQuery();

    assertEquals(true, rows.getRowCount() > 10) ;
  }


View Full Code Here
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
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.