Examples of queryForList()

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

52
53
54
55
56
57
58
59
60
61
62
        String groupNameField = getGroupInfo().getGroupNameField();
        String sqlText = getGroupInfo().getSqlText();
        SqlCommand sqlCommand = getSqlCommand();
        List<Object> objectParamWhere = new ArrayList<Object>();
        objectParamWhere.add(groupId);
        List<Map<String, Object>> dataObj = sqlCommand.queryForList("SELECT USERTABLE.* FROM (" + sqlText + ") USERTABLE where USERTABLE."
            + groupIdField + "=?", objectParamWhere);
        if (dataObj.size() == 0) {
          return null;
        }
        if (dataObj.get(0).get(groupIdField) == null) {
View Full Code Here

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

98
99
100
101
102
103
104
105
106
107
108
     
      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

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

138
139
140
141
142
143
144
145
146
147
148
        String userIdField = userInfo.getUserIdField();
        @SuppressWarnings("unused")
        String userNameField = userInfo.getUserNameField();
        String groupIdField = userInfo.getGroupIdField();
        String sqlText = userInfo.getSqlText();
        List<Map<String, Object>> dataObj = sqlCommand.queryForList("SELECT USERTABLE.* FROM (" + sqlText + ") USERTABLE where USERTABLE."
            + userIdField + "=? AND USERTABLE."+groupIdField+" IS NOT NULL", objectParamWhere);
        if(dataObj.size()==0){
          return groupTos;
        }
        for (Map<String, Object> roleTo : dataObj) {
View Full Code Here

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

201
202
203
204
205
206
207
208
209
210
211
      String supGroupIdField = getGroupInfo().getSupGroupIdField();
      String sqlText = getGroupInfo().getSqlText();
      SqlCommand sqlCommand = getSqlCommand();
      // 部门编号,父级编号，部门名称
      // 获取这个部门的所有子部门
      List<Map<String, Object>> listMap = sqlCommand.queryForList("SELECT USERTABLE.* FROM (" + sqlText + ") USERTABLE");
      for (Map<String, Object> map : listMap) {
        // 部门编号
        String groupDbId = StringUtil.getString(StringUtil.getString(map.get(groupIdField)));
        // 部门名称
        String groupDbName = StringUtil.getString(StringUtil.getString(map.get(groupNameField)));
View Full Code Here

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

291
292
293
294
295
296
297
298
299
300
301
        String userIdField = userInfo.getUserIdField();
        String userNameField = userInfo.getUserNameField();
        String groupIdField = userInfo.getGroupIdField();
        String sqlText = userInfo.getSqlText();
        // 这里可能会出现重复记录人名的问题
        List<Map<String, Object>> dataObj = sqlCommand.queryForList("select USERTABLE.* FROM (" + sqlText + ") USERTABLE WHERE USERTABLE."
            + groupIdField + " in (" + sqlInString + ")", objectParamWhere);
        List<UserTo> userTos = new ArrayList<UserTo>();
        for (Map<String, Object> map : dataObj) {
          UserTo userTo = new UserTo(StringUtil.getString(map.get(userIdField)), StringUtil.getString(map.get(userNameField)), map);
          userTos.add(userTo);
View Full Code Here

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

327
328
329
330
331
332
333
334
335
336
337
        UserInfo userInfo = getGroupInfo().getUserInfo();
        String userIdField = userInfo.getUserIdField();
        String userNameField = userInfo.getUserNameField();
        String groupIdField = userInfo.getGroupIdField();
        String sqlText = userInfo.getSqlText();
        List<Map<String, Object>> dataObj = sqlCommand.queryForList("SELECT USERTABLE.* FROM (" + sqlText + ") USERTABLE where USERTABLE."
            + groupIdField + "=?", objectParamWhere);
        List<UserTo> userTos = new ArrayList<UserTo>();
        for (Map<String, Object> map : dataObj) {
          UserTo userTo = new UserTo(StringUtil.getString(map.get(userIdField)), StringUtil.getString(map.get(userNameField)), map);
          userTos.add(userTo);
View Full Code Here

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

361
362
363
364
365
366
367
368
369
370
371
        String supGroupIdField = getGroupInfo().getSupGroupIdField();
        String sqlText = getGroupInfo().getSqlText();
        SqlCommand sqlCommand = getSqlCommand();
        List<Object> objectParamWhere = new ArrayList<Object>();
        objectParamWhere.add(groupId);
        List<Map<String, Object>> dataObj = sqlCommand.queryForList(" SELECT USERTABLENEW.* FROM (" + sqlText
            + ") USERTABLENEW WHERE USERTABLENEW." + groupIdField + " IN (SELECT USERTABLE." + supGroupIdField + " FROM (" + sqlText
            + ") USERTABLE where USERTABLE." + groupIdField + "=?)", objectParamWhere);
        if (dataObj.size() == 0) {
          return null;
        }
View Full Code Here

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

77
78
79
80
81
82
83
84
85
86
87
    }
   
    stringBuffer.append("'");
   
    SqlCommand sqlCommand=new SqlCommand(Context.getDbConnection());
    List<Map<String, Object>> productMapList= sqlCommand.queryForList(stringBuffer.toString());
   
    List<String> quehuoproductlist = new ArrayList<String>();
   
    //查看库存是否足够
    for(Map<String, Object> detailmap : detailMapList) {
View Full Code Here

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

65
66
67
68
69
70
71
72
73
74
75
      List<Object> objectParamWhere = new ArrayList<Object>();

      objectParamWhere.add(userId);

      List<Map<String, Object>> dataObj = sqlCommand.queryForList("SELECT USERTABLE.* FROM ("+sqlText+") USERTABLE where USERTABLE."+userIdField+"=?", objectParamWhere);

      if(dataObj.size()==0){
        return null;
      }
     
View Full Code Here

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

122
123
124
125
126
127
128
129
130
131
132
    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) {
        UserTo userTo = new UserTo(StringUtil.getString(dataObj.get(i).get(userIdField)), StringUtil.getString(dataObj.get(i).get(userNameField)), dataObj.get(i));
        resultList.add(userTo);
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.