Package com.bleujin.framework.db

Examples of com.bleujin.framework.db.Rows

79
80
81
82
83
84
85
86
87
88
89
            if (query_type == UPDATE_COMMAND){
                int updateRow = query.myUpdate(conn);
                resultMap.put(name, new Integer(updateRow)) ;
            } else if (query_type == QUERY_COMMAND) {
                Rows rows = query.myQuery(conn) ;
                resultMap.put(name, rows) ;
            } else {
              throw new IllegalArgumentException(query_type + " is not defined type\n" + query) ;
            }
        }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
            }

            rs = pstmt.executeQuery();
            // rs.setFetchSize(DEFAULT_FETCHSIZE);

            Rows result = populate(rs) ;

            return result;
        } catch (SQLException ex) {
            throw new SQLException(getExceptionMessage(ex, this), ex.getSQLState(), ex.getErrorCode());
        } finally {
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
        return this.cstmt ;
    }

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

        try {
            cstmt = ( OracleCallableStatement )conn.prepareCall( "{? = call " + getProcedureSQL() + "}", ResultSet.TYPE_SCROLL_INSENSITIVE,  ResultSet.CONCUR_READ_ONLY );
            cstmt.setMaxRows(getMaxRows());
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
    public Data getRows(final IQueryable query) {
        final FutureData future = new FutureData(query) ;
        new Thread() {
            public void run(){
                try{
                    Rows rows = query.execQuery() ;
                    RealData realdata = new RealData(query, rows) ;
                    future.setRealData(realdata);
                } catch(Exception ex){
                    future.setException(ex) ;
                }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
  private void setCurrentQuery(IQueryable query) {
    this.currQuery = query;
  }

  protected Rows myQuery(Connection conn) throws SQLException {
    Rows result = null;
    Rows nextRows = null;
    for (int i = 0; i < querys.size(); i++) {
      Queryable query = getQuery(i);
      setCurrentQuery(query);
      if (i == 0) {
        result = query.myQuery(conn);
        nextRows = result;
      } else {
        nextRows = nextRows.setNextRows(query.myQuery(conn));
      }
    }
    return result;
  }
View Full Code Here
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
    this.dc = new DBController(dc.getDBManager()) ; // none servant
    this.cmd = cmd ;
  }

  public void printPlan(OutputStream output) throws SQLException {
    Rows rows = execQuery();
   
    PrintWriter writer = new PrintWriter(new OutputStreamWriter(output)) ;
    while(rows.next()) {
      writer.printf("%s", rows.getString("query_plan")) ;
      writer.println() ;
    }
    writer.flush() ;
    writer.close() ;
  }
View Full Code Here
21
22
23
24
25
26
27
28
 
  public void testRowsPage() throws Exception {
    String query = "select * from copy_sample" ;
    // listNum = 1 -> count per page
    // No = 1      -> page no
    Rows rows = dc.getRows(query, 1, 1) ;
    assertEquals(1, rows.getRowCount()) ;
  }
View Full Code Here
30
31
32
33
34
35
36
37
  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
25
26
27
28
29
30
31
32
33
34
35
        return cstmt ;
    }

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

        try {
            cstmt = conn.prepareCall( "{ call " + getProcedureSQL() + "}", ResultSet.TYPE_SCROLL_INSENSITIVE,  ResultSet.CONCUR_READ_ONLY );
            cstmt.setMaxRows(getMaxRows()) ;
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
            }

            rs = pstmt.executeQuery();
            // rs.setFetchSize(DEFAULT_FETCHSIZE);

            Rows result = populate(rs) ;

            return result;
        } catch (SQLException ex) {
            throw new SQLException(getExceptionMessage(ex, this), ex.getSQLState(), ex.getErrorCode());
        } finally {
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.