Package com.bleujin.framework.db

Examples of com.bleujin.framework.db.Rows.firstRow()

49
50
51
52
53
54
55
56
57
58
59
   
    assertEquals(1, rows.firstRow().getInt("no1")) ;
   
    try {
      rows = dc.getRows("select * from copy_sample where 1 = 2") ;
      rows.firstRow() ;
      fail() ;
    } catch (SQLException ignore){
     
    } catch (RepositoryException ignore){
     
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
    upt.addParam(1);
   
    Rows rows = upt.execQuery() ;
   
    assertEquals(1, rows.getRowCount()) ;
    assertEquals("abc", rows.firstRow().getString("b")) ;
  }
 
 
 
 
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
   
    int count = upts.add(cmd).add(cmd2).execUpdate() ;
    assertEquals(2, count) ;
   
    Rows rows = dc.getRows("select * from update_sample where a = 1") ;
    assertEquals("___", rows.firstRow().getString("b")) ;
  }
 
 
  public void testSimpleTransaction() throws Exception {
   
View Full Code Here
56
57
58
59
60
61
62
63
      fail() ;
    }catch(SQLException ignore){
    }
   
    Rows rows = dc.getRows("select count(*) from update_sample") ;
    assertEquals(0, rows.firstRow().getInt(1)) ;
  }
}
View Full Code Here
9
10
11
12
13
14
15
16
17
18
19
  String query = "select * from copy_sample" ;

  public void testFirstRow() throws Exception {
    Rows rows  = dc.getRows(query) ;
   
    Row row = rows.firstRow() ;
   
   
    assertEquals("01", row.getString(2)) ;
    assertEquals("1", row.getString(1)) ;

View Full Code Here
65
66
67
68
69
70
71
72
73
74
    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
25
26
27
28
29
30
31
32
33
34
35
    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
    assertEquals(10, nextRows.getRowCount()) ;
    assertEquals(11, nextRows.firstRow().getInt("no2")) ;
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
    assertEquals(1, rows.firstRow().getInt("no2")) ;
   
   
    Rows nextRows = rows.nextPageRows() ; // 2page
    assertEquals(10, nextRows.getRowCount()) ;
    assertEquals(11, nextRows.firstRow().getInt("no2")) ;
  }

 
  public void testPrePage() throws Exception {
    IUserCommand cmd = dc.createUserCommand(query1) ;
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
    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
    assertEquals(10, preRows.getRowCount()) ;
    assertEquals(1, preRows.firstRow().getInt("no2")) ;
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
    assertEquals(11, rows.firstRow().getInt("no2")) ;
   
   
    Rows preRows = rows.prePageRows() ;  // 1page
    assertEquals(10, preRows.getRowCount()) ;
    assertEquals(1, preRows.firstRow().getInt("no2")) ;
  }

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