Package com.bleujin.framework.db

Examples of com.bleujin.framework.db.Rows

63
64
65
66
67
68
69
70
71

  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()) ;
  } 
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
      this.stmtSQL = stmtSQL ;
    }

    @Override
    protected Rows myQuery(Connection conn) throws SQLException {
        Rows result = null ;
        ResultSet rs = null ;

        try {
            pstmt = conn.prepareStatement(getStmtSQL(),  ResultSet.TYPE_SCROLL_INSENSITIVE,  ResultSet.CONCUR_READ_ONLY) ;
View Full Code Here
72
73
74
75
76
77
78
79
 
  public void testProcedure() throws Exception {
    IUserProcedure cmd = dc.createUserProcedure("common@testBy()") ;
    cmd.setPage(Page.TEN) ;
   
    Rows rows = cmd.execQuery();
    assertEquals(10, rows.getRowCount()) ;
  }
View Full Code Here
97
98
99
100
101
102
103
104
105
 
  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) ;
  }
View Full Code Here
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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
 
  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)) ;

    assertEquals(true, rows.firstRow().getInt(2) < nextPageRows.firstRow().getInt(2)) ;

    Rows prePageRows = rows.prePageRows() ;
    assertEquals(1, prePageRows.firstRow().getInt(2)) ;
  }
View Full Code Here
13
14
15
16
17
18
19
20
21
22
23
24
public class UseHandler extends SampleTestBase {

  String query = "select * from copy_sample order by no1" ;
 
  public void testMapHandler() throws Exception {
    Rows rows = dc.getRows(query, 10, 1) ;
    Map results = (Map)rows.toHandle(new MapHandler()) ;
   

    assertEquals(2, results.size()) ;

    assertEquals("1", results.get("no1").toString()) ;
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
38
39
    assertEquals("01", results.get("no2")) ;
  }
 
 
  public void testMapList() throws Exception {
    Rows rows = dc.getRows(query, 10, 1) ;
   
    List<Map> results = (List<Map>)rows.toHandle(new MapListHandler()) ;
   
    assertEquals(10, results.size()) ;
    Map row = results.get(0);
   
    assertEquals("1", row.get("no1").toString()) ;
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
52
    assertEquals("01", row.get("no2")) ;
  }
 
 
  public void testBeanList() throws Exception {
    Rows rows = dc.getRows(query, 10, 1) ;
   
    List<TestBean> results = (List<TestBean>)rows.toHandle(new BeanListHandler(TestBean.class)) ;
    assertEquals(10, results.size()) ;

    TestBean row = results.get(0);
    assertEquals(1, row.getNo1()) ;
    assertEquals("01", row.getNo2()) ;
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
    assertEquals("02", results.get(1).getNo2()) ;
 
  }
 
  public void testScalar() throws Exception {
    Rows rows = dc.getRows(query, 10, 1) ;
    Object value = rows.toHandle(new ScalarHandler()) ;
   
    assertEquals("1", value.toString()) ;
   
   
    rows = dc.getRows(query, 10, 1) ;
    Object secondValue = rows.toHandle(new ScalarHandler(2)) ;
    assertEquals("01", secondValue) ;
  }
View Full Code Here
TOP

Related Classes of com.bleujin.framework.db.Rows

  • com.bleujin.dbfs.common.QueryObj
  • com.bleujin.framework.db.async.AsyncDBController
  • com.bleujin.framework.db.bean.handlers.JSONHandler
  • com.bleujin.framework.db.function.TestController
  • com.bleujin.framework.db.function.TestFirstQuery
  • com.bleujin.framework.db.function.TestHandler
  • com.bleujin.framework.db.function.TestPage
  • com.bleujin.framework.db.function.TestPlan
  • com.bleujin.framework.db.function.TestServant
  • com.bleujin.framework.db.function.TestUserProcedures
    • Copyright © 2018 www.massapicom. 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.