Package com.bleujin.framework.db

Examples of com.bleujin.framework.db.Rows

92
93
94
95
96
97
98
99
100
101
102
      Connection conn = getConnection() ;
      long start = System.currentTimeMillis();
        conn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

        //
      Rows rows = myQuery(conn) ;

      long end = System.currentTimeMillis();
      getDBManager().freeConnection(conn) ;
      getDBController().handleServant(start, end, this, IQueryable.QUERY_COMMAND);
      return rows ;
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
 
  public void testProcedure() throws Exception {
    IUserProcedure upt = dc.createUserProcedure("framework_test_select()") ;
    upt.setPage(Page.create(5, 1)) ;
   
    Rows rows = upt.execQuery() ;
    while(rows.next()){
      Debug.debug(rows.getString(1)) ;
    }
      assertEquals(5, rows.getRowCount()) ;
    }
View Full Code Here
79
80
81
82
83
84
85
86
    assertEquals(1, rowcount) ;
  }
 
 
  public void testRowCount() throws Exception {
      Rows rows = dc.createUserCommand("select * from copy_tblc where 1 = 2").execQuery() ;
      assertEquals(0, rows.getRowCount()) ;
    }
View Full Code Here
7
8
9
10
11
12
13
14
15
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()) ;
  }
View Full Code Here
15
16
17
18
19
20
21
22
23
  }
 
  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
33
34
35
36
37
38
39
40
41
42
43
    }

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

        try {
//            ((OracleConnection) conn).setStmtCacheSize(40); // Set the Statement cache size to 40
//            ((OracleConnection) conn).setStatementCacheSize(40); // Set the Statement cache size to 40
//            ((OracleConnection) conn).setImplicitCachingEnabled(true); // Set the Statement cache size to 40
View Full Code Here
23
24
25
26
27
28
29
30
31
32
    dc.initSelf() ;
   
    dc.createUserCommand("create table if not exists test(a int, b varchar(20))").execUpdate() ;
    dc.createUserCommand("insert into test values(1, 'BlaBla')").execUpdate() ;
   
    Rows rows = dc.createUserCommand("select * from test" ).execQuery() ;
    Debug.debug(rows) ;
   
    dc.destroySelf() ;
  }
View Full Code Here
8
9
10
11
12
13
14
15
16
17
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
39
40
41
42
43
44
45
46
    dc.execUpdate("create procedure framework_test_select() begin select * from copy_tblc; end//");
  }
 
 
  public void testCommand() throws Exception {
    Rows rows = dc.createUserCommand("select 1 union all select 2").execQuery() ;
    assertEquals(2, rows.getRowCount()) ;
  }
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
  }


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