Package com.bleujin.framework.db.procedure

Examples of com.bleujin.framework.db.procedure.IQueryable

233
234
235
236
237
238
239
240
241
   
    public Rows getRows(IQueryable query) throws SQLException {
      return query.execQuery();
    }
    public Rows getRows(String strSQL, int listNum, int pageNo) throws SQLException {
      IQueryable query = createParameterQuery(strSQL) ;
      query.setPage(Page.create(listNum, pageNo)) ;
      return getRows(query);
    }
View Full Code Here
16
17
18
19
20
21
22
23
24
25
26
27
28
  }


    protected void handle(AfterTask atask)
    {
      IQueryable query = atask.getQueryable() ;
        final String procName = query.getProcSQL() ;
        final String procFullName = query.getProcFullSQL() ;
        final int misecond = Integer.parseInt(String.valueOf(atask.getEnd() - atask.getStart())) ;
        final DBController dc = new DBController(atask.getDBManager()) ;
        new Thread(){
            public void run(){
                try {
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
//            ( (showLevel / 4) % 2 == 1 && query instanceof UserProcedureBatch) ||
//            ( (showLevel / 2) % 2 == 1 && query instanceof UserCommand) ||
//            ( (showLevel / 1) % 2 == 1 && query instanceof UserProcedure)
//            );
//
      IQueryable query = atask.getQueryable() ;
        return  (this.showLevel == StdOutServant.All) || (
          ( (showLevel / 32) % 2 == 1 && query.getQueryType() == QueryType.CUSTOM_QUERY) ||
          ( (showLevel / 16) % 2 == 1 && query.getQueryType() == QueryType.USER_COMMAND_BATCH) ||
          ( (showLevel / 8) % 2 == 1 && query.getQueryType() ==  QueryType.USER_PROCEDURES) ||
          ( (showLevel / 4) % 2 == 1 && query.getQueryType() ==  QueryType.USER_PROCEDURE_BATCH) ||
          ( (showLevel / 2) % 2 == 1 && query.getQueryType() == QueryType.USER_COMMAND) ||
          ( (showLevel / 1) % 2 == 1 && query.getQueryType() == QueryType.USER_PROCEDURE)
          )  ;
    }
View Full Code Here
236
237
238
239
240
241
242
243
244
   
    public Rows getRows(IQueryable query) throws SQLException {
      return query.execQuery();
    }
    public Rows getRows(String strSQL, int listNum, int pageNo) throws SQLException {
      IQueryable query = createParameterQuery(strSQL) ;
      query.setPage(Page.create(listNum, pageNo)) ;
      return getRows(query);
    }
View Full Code Here
30
31
32
33
34
35
36
37
38
39
  public JSONParser(DBController dc){
    this.dc = dc ;
  }
 
  public QueryObj parseToQueryable(JSONObject jo) {
    IQueryable cmd = parse(jo) ;
   
    int ctype = parseCommandType(jo.getJSONObject(QUERY).get(CTYPE));
    return new QueryObj(cmd, ctype);
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
    return new QueryObj(cmd, ctype);
  }

 
  private IQueryable parse(JSONObject jo){
    IQueryable cmd = null ;
    Object type = jo.getJSONObject(QUERY).get(TYPE);
    if ("userprocedure".equalsIgnoreCase(String.valueOf(type))) {
      cmd = parseUserProcedure(jo);
    } else if ("userprocedures".equalsIgnoreCase(String.valueOf(type))){
      cmd = parseUserProcedures(jo) ;
View Full Code Here
17
18
19
20
21
22
23
24
import com.bleujin.framework.db.procedure.Queryable;

public class TestPlan extends DBTestCase{

  public void testExecute() throws Exception {
    IQueryable q1 = dc.createUserCommand("explain plan for select * from yyyymmdd_tblc") ;
    int result = q1.execUpdate() ;
  }
View Full Code Here
TOP

Related Classes of com.bleujin.framework.db.procedure.IQueryable

  • com.bleujin.dbfs.common.JSONParser
  • com.bleujin.framework.db.DBController
  • com.bleujin.framework.db.function.TestPlan
  • com.bleujin.framework.db.servant.StdOutServant
  • com.bleujin.framework.db.servant.TraceOfLateProcServant
    • 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.