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

Examples of com.founder.fix.fixflow.core.impl.db.SqlCommand.queryForValue()

99
100
101
102
103
104
105
106
107
108
109
      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) {
          GroupTo groupTo = new GroupTo(StringUtil.getString(dataObj.get(i).get(groupIdField)), StringUtil.getString(dataObj.get(i).get(groupNameField)), getId(), dataObj.get(i));
          resultList.add(groupTo);
        }
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
      whereSql += " AND "+userNameField+" LIKE '%"+queryMap.get("USERNAME")+"%' ";
    }
    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);
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
 
  public static Object getSequenceValue(String sequenceName){
   
   
    SqlCommand sqlCommand=new SqlCommand(Context.getDbConnection());
    Object returnValueObject=sqlCommand.queryForValue("SELECT "+sequenceName+".nextval FROM DUAL");
   
   
    return returnValueObject;
   
  }
View Full Code Here
255
256
257
258
259
260
261
262
263
264
265
  public Object selectOneObject(String sqlText) {
    // TODO Auto-generated method stub

    SqlCommand sqlCommand = new SqlCommand(Context.getDbConnection());
    return sqlCommand.queryForValue(ExpressionMgmt.execute(sqlText, this).toString());

  }

  public String getRollBackAssignee() {
    // TODO Auto-generated method stub
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.