Package com.bleujin.framework.db

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

52
53
54
55
56
57
58
59
60
61
62
   
    rows.next() ;
   
    long fileSize = k100File.length();
    assertEquals(true, fileSize == rows.getString("c").length()) ;
    assertEquals(true, fileSize == rows.firstRow().getString("c").length()) ;
   
    InputStream input = rows.getBinaryStream("d") ;
    int bcount = 0;
    while(input.read() != -1) bcount++ ;
    assertEquals(true, fileSize == bcount) ;
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
   
    int rowcount = (Integer)result.get("ins") ;
    Rows rows = (Rows)result.get("sel") ;
   
    assertEquals(1, rowcount) ;
    assertEquals("abc", rows.firstRow().getString("b")) ;
  }

 
  public void testSecond() throws Exception {
    IUserCommand ins = dc.createUserCommand("insert into update_sample values(?,?)") ;
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
    int inscount = (Integer)result.get("ins") ;
    Rows rows = (Rows)result.get("sel") ;
    int delcount = (Integer)result.get("del") ;
   
    assertEquals(1, inscount) ;
    assertEquals("abc", rows.firstRow().getString("b")) ;
    assertEquals(1, delcount) ;
   
   
    Rows crows = dc.createUserCommand("select * from update_sample where a = ?").addParam(1).execQuery() ;
    assertEquals(false, crows.next()) ;
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
    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
130
131
132
133
134
135
136
137
138
139
140
   
   
    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
133
134
135
136
137
138
139
140
141
142
143
    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
109
110
111
112
113
114
115
116
117
    } catch(SQLException ignore){
     
    }

    Rows rows = dc.getRows("select count(*) from update_sample") ;
    assertEquals(0, rows.firstRow().getInt(1)) ;
  }
 
}
View Full Code Here
44
45
46
47
48
49
50
51
52
53
   
    Rows first = upts.execQuery() ;  // first query result ;
    assertEquals(true, first.getRowCount() == 10) ;
   
    Rows second = first.getNextRows() ; // second query result ;
    assertEquals(3, second.firstRow().getInt(1)) ;
   
  }
 
}
View Full Code Here
12
13
14
15
16
17
18
19
20
21
22
    assertEquals(1, rows.getRowCount()) ;
  }
 
  public void testRow() throws Exception {
    Rows rows = dc.getRows("select * from dual") ;
    Row row = rows.firstRow() ;
   
    assertNotNull(row.getString(1)) ;
  }
 
  public void testProcedure() throws Exception {
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
 

  public void testFirstRow() throws Exception {
    Rows rows = dc.getRows(query1) ;
   
    assertEquals(1, rows.firstRow().getInt("no1")) ;
   
    try {
      rows = dc.getRows("select * from copy_sample where 1 = 2") ;
      rows.firstRow() ;
      fail() ;
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.