Package com.founder.fix.fixflow.core.db.pagination

Examples of com.founder.fix.fixflow.core.db.pagination.Pagination

67
68
69
70
71
72
73
74
75
76
77
    this.connection = connection;
    pageination = initDialet(connection);
  }
 
  public static Pagination initDialet(Connection connection){
    Pagination pageination = null;
    try{
      String dbms = connection.getMetaData().getDatabaseProductName();
      if ( dbms == null || dbms.equals("") ){
        pageination = (Pagination)Class.forName("com.founder.fix.fixflow.expand.database.pagination.OraclePaginationImpl").newInstance();
      }else if ( dbms.equals("Oracle") ){
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
107
    return true;
  }
 
  private String getInsertSqlString(String tableId,String whereSql){
   
    Pagination pagination = Context.getProcessEngineConfiguration().getDbConfig().getPagination();
    String tableName = QueryTableUtil.getDefaultTableName(tableId);
    String archiveTableName = QueryTableUtil.getArchiveTableName(tableId);
    String columnString = QueryTableUtil.getColumnStringWithOutArchiveTime(tableId);
    String insertSqlString = "insert into "+archiveTableName+" (" + columnString+",ARCHIVE_TIME) select "+columnString+","+pagination.getCurrentDateSql()+" from "+tableName +" E where " + whereSql;
    return insertSqlString;
  }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
      }
    }
   
    if(page!=null)
    {
      Pagination pagination=Context.getProcessEngineConfiguration().getDbConfig().getPagination();
      sqlString=pagination.getPaginationSql(sqlString, page.getFirstResult(), page.getMaxResults(), "*",orderByString);
    }else{
      if (eventSubscriptionQuery.getOrderBy() != null) {
        sqlString = sqlString + " order by " + eventSubscriptionQuery.getOrderBy().toString();
      }
    }
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
93
        orderByString = orderByString + " order by " + tokenQuery.getOrderBy().toString().substring(2);
      }
    }
   
    if(page!=null){
      Pagination pagination=Context.getProcessEngineConfiguration().getDbConfig().getPagination();
      sqlString=pagination.getPaginationSql(sqlString, page.getFirstResult(), page.getMaxResults(), "*",orderByString);
    }else{
      if (tokenQuery.getOrderBy() != null) {
        sqlString = sqlString + " order by "+tokenQuery.getOrderBy().toString();
        }
    }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
    //pObjects.add(MailStatus.COMPLETE.toString());
    //pObjects.add(MailStatus.FAILURE.toString());
    pObjects.add(MailStatus.NOSEND.toString());
    SqlCommand sqlCommand = new SqlCommand(Context.getDbConnection());
   
    Pagination pagination = Context.getProcessEngineConfiguration().getDbConfig().getPagination();
   
   
   
   
    String sqlText=pagination.getPaginationSql("SELECT * FROM FIXFLOW_MAIL WHERE MAIL_STATUS=?", 1, 10, "*", null);
   
    List<Map<String, Object>> dataList = sqlCommand.queryForList(sqlText, pObjects);
   
    for (Map<String, Object> mapData : dataList) {

View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
      }
    }
   
   
    if (page != null) {
      Pagination pagination = Context.getProcessEngineConfiguration().getDbConfig().getPagination();
      sqlString = pagination.getPaginationSql(sqlString, page.getFirstResult(), page.getMaxResults(), "*",orderByString);
    }
    else{
      if (processInstanceQuery.getOrderBy() != null) {
        sqlString = sqlString + " order by " + processInstanceQuery.getOrderBy().toString();
        }
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
130
    sql += whereSql;
    countSql += whereSql;
   
    int count = Integer.parseInt(sqlCommand.queryForValue(countSql).toString());
    if (page != null) {
      Pagination pagination = Context.getProcessEngineConfiguration().getDbConfig().getPagination();
      sql = pagination.getPaginationSql(sql, page.getFirstResult(), page.getMaxResults(), "*",null);
    }
    List<Map<String, Object>> dataObj = sqlCommand.queryForList(sql, null);
   
    for(int i= 0;i<dataObj.size();i++){
      if (dataObj.get(i).get(userIdField) != null) {
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
      }
      sql += whereSql;
      countSql += whereSql;
     
      if (page != null) {
        Pagination pagination = Context.getProcessEngineConfiguration().getDbConfig().getPagination();
        sql = pagination.getPaginationSql(sql, page.getFirstResult(), page.getMaxResults(), "*",null);
      }
      List<Map<String, Object>> dataObj = sqlCommand.queryForList(sql, null);
      int count = Integer.parseInt(sqlCommand.queryForValue(countSql).toString());
      for(int i = 0;i<dataObj.size();i++){
        if (dataObj.get(0).get(groupIdField) != null) {
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
109
    return null;
  }
 
  private String getInsertSqlString(String tableId,String whereSql){
   
    Pagination pagination = Context.getProcessEngineConfiguration().getDbConfig().getPagination();
    String tableName = QueryTableUtil.getDefaultTableName(tableId);
    String archiveTableName = QueryTableUtil.getArchiveTableName(tableId);
    String columnString = QueryTableUtil.getColumnStringWithOutArchiveTime(tableId);
    String insertSqlString = "insert into "+archiveTableName+" (" + columnString+",ARCHIVE_TIME) select "+columnString+","+pagination.getCurrentDateSql()+" from "+tableName +"  where " + whereSql;
    return insertSqlString;
  }
View Full Code Here
898
899
900
901
902
903
904
905
906
907
908
  protected void initSqlServerDbConfig() {

    DataBase dataBase = this.selectedDatabase;

    // OraclePaginationImpl
    Pagination pagination = (Pagination) ReflectUtil.instantiate(dataBase.getPaginationImpl());
    DbConfig dbConfig = new DbConfig();
    dbConfig.setDbType(DbType.SQLSERVER);
    dbConfig.setPagination(pagination);
    dbConfig.setKeyword("?");
View Full Code Here
TOP

Related Classes of com.founder.fix.fixflow.core.db.pagination.Pagination

  • com.founder.fix.fixflow.core.impl.persistence.instance.EventSubscriptionPersistence
  • com.founder.fix.fixflow.core.impl.persistence.instance.HistoryPersistence
  • com.founder.fix.fixflow.core.impl.ProcessEngineConfigurationImpl
  • com.founder.fix.fixflow.expand.identity.GroupDefinitionImpl
  • com.founder.fix.fixflow.expand.identity.UserDefinitionImpl
  • com.founder.fix.fixflow.expand.mail.FixMailEngine
  • com.founder.fix.fixflow.expand.rulescript.entity.Archive
  • com.founder.fix.fixflow.expand.rulescript.select.ProcessInstanceQueryScript
  • com.founder.fix.fixflow.expand.rulescript.select.TokenQueryScript
  • com.founder.fix.fixflow.shell.DBConnection
    • 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.