Examples of execQuery()

Examples of com.bleujin.framework.db.fake.FakeUserCommand.execQuery()

8
9
10
11
12
13
14
15
16
17
18
public class TestH2ChainProcedure extends TestCaseH2 {

  public void xtestBatch() throws Exception {

    FakeUserCommand stmt = new FakeUserCommand(dbm.getConnection(), "select count(*) from uri");
    Rows rows = stmt.execQuery();
    rows.next();

    System.out.println("count:" + rows.getInt(1));
  }

View Full Code Here

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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